C_HU_ECSlsLstMatlDocCsgnmtC

DDL: C_HU_ECSLSLSTMATLDOCCSGNMTC Type: view_entity CONSUMPTION
16 Fields 2 Data Sources

Hungarian ECSL Consignment - Cube

C_HU_ECSlsLstMatlDocCsgnmtC is a Consumption CDS View (Cube) that provides data about "Hungarian ECSL Consignment - Cube" in SAP S/4HANA. It reads from 2 data sources (I_MaterialDocumentRecord, I_Supplier) and exposes 16 fields with key fields CompanyCode, MaterialDocumentYear, MaterialDocument, MaterialDocumentItem.

Data Sources (2)

SourceAliasJoin Type
I_MaterialDocumentRecord MatDoc from
I_Supplier Supplier inner

Annotations (11)

NameValueLevelField
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
EndUserText.label Hungarian ECSL Consignment - Cube view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
Analytics.internalName #LOCAL view
Analytics.dataCategory #CUBE view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_MaterialDocumentRecord CompanyCode Receiver Company Code
KEY MaterialDocumentYear I_MaterialDocumentRecord MaterialDocumentYear Material Document Year
KEY MaterialDocument I_MaterialDocumentRecord MaterialDocument Material Doc.
KEY MaterialDocumentItem I_MaterialDocumentRecord MaterialDocumentItem Material Document Item
Creditor
VATRegistrationendasVATRegistration
ReportingDate
PostingDate I_MaterialDocumentRecord PostingDate Posting Date for GR
DocumentDate I_MaterialDocumentRecord DocumentDate Journal Entry Date
BusinessPartner
BusinessPartnerName
GoodsMovementType I_MaterialDocumentRecord GoodsMovementType Movement Type
Material I_MaterialDocumentRecord Material Vehicle Model
ReversedMaterialDocumentYear I_MaterialDocumentRecord ReversedMaterialDocumentYear Reversed Doc Year
ReversedMaterialDocument I_MaterialDocumentRecord ReversedMaterialDocument Reversed Mat Doc
ReversedMaterialDocumentItem I_MaterialDocumentRecord ReversedMaterialDocumentItem Reversed Doc Item

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_HU_ECSlsLstMatlDocCsgnmtC.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW C_HU_ECSlsLstMatlDocCsgnmtC AS
SELECT
  MatDoc.CompanyCode AS CompanyCode,
  MatDoc.MaterialDocumentYear AS MaterialDocumentYear,
  MatDoc.MaterialDocument AS MaterialDocument,
  MatDoc.MaterialDocumentItem AS MaterialDocumentItem,
  cast(MatDoc.Supplier as fis_lifnr preserving type ) AS Creditor,
  case when MatDoc.Supplier <> '' and Supplier.VATRegistration = '' and Country.IsEuropeanUnionMember = 'X' and Supplier.Country <> 'HU' then concat(Country.CountryISOCode, '0') else Supplier.VATRegistration end as VATRegistration AS VATRegistrationendasVATRegistration,
  cast(MatDoc.PostingDate as glo_reporting_date ) AS ReportingDate,
  MatDoc.PostingDate AS PostingDate,
  MatDoc.DocumentDate AS DocumentDate,
  MatDoc._BusinessPartner.BusinessPartner AS BusinessPartner,
  MatDoc._BusinessPartner.BusinessPartnerName AS BusinessPartnerName,
  MatDoc.GoodsMovementType AS GoodsMovementType,
  MatDoc.Material AS Material,
  MatDoc.ReversedMaterialDocumentYear AS ReversedMaterialDocumentYear,
  MatDoc.ReversedMaterialDocument AS ReversedMaterialDocument,
  MatDoc.ReversedMaterialDocumentItem AS ReversedMaterialDocumentItem
FROM I_MaterialDocumentRecord AS MatDoc
INNER JOIN I_Supplier AS Supplier ON /* join condition not captured in parsed metadata */
;

Learn More