C_RO_SAFTMatlDocLineItemC

DDL: C_RO_SAFTMATLDOCLINEITEMC Type: view_entity CONSUMPTION
19 Fields 1 Data Sources

RO SAFT Matl Doc Lines - Cube

C_RO_SAFTMatlDocLineItemC is a Consumption CDS View (Cube) that provides data about "RO SAFT Matl Doc Lines - Cube" in SAP S/4HANA. It reads from 1 data source (C_RO_SAFTMatlDocLineItem) and exposes 19 fields with key fields MaterialDocument, MaterialDocumentYear, MaterialDocumentItem, CompanyCode.

Data Sources (1)

SourceAliasJoin Type
C_RO_SAFTMatlDocLineItem C_RO_SAFTMatlDocLineItem from

Parameters (1)

NameTypeDefault
P_AlternativeGLAccountIsUsed saft_ro_alt_gl_account_flag

Annotations (10)

NameValueLevelField
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label RO SAFT Matl Doc Lines - Cube view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
Analytics.dataCategory #CUBE view
Analytics.internalName #LOCAL view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY MaterialDocument MaterialDocument Material Doc.
KEY MaterialDocumentYear MaterialDocumentYear Material Document Year
KEY MaterialDocumentItem MaterialDocumentItem Material Document Item
KEY CompanyCode CompanyCode Receiver Company Code
BusinessTransactionTypeName BusinessTransactionTypeName
RO_SAFTStandardAccount RO_SAFTStandardAccount
CustomerVATRegistration CustomerVATRegistration VAT Registration No.
SupplierVATRegistration SupplierVATRegistration VAT Registration No.
Product Product Product Sold
Batch Batch Lot No.
MaterialBaseUnit MaterialBaseUnit Valuation Unit
MatlStkChangeQtyInBaseUnit MatlStkChangeQtyInBaseUnit
PostingDate PostingDate Posting Date for GR
SourceUnitOfMeasureFactor SourceUnitOfMeasureFactor
ConversionFactor ConversionFactor
CompanyCodeCurrency CompanyCodeCurrency Local Currency
GoodsMovementStkAmtInCCCrcy GoodsMovementStkAmtInCCCrcy
MaterialDocumentItemText MaterialDocumentItemText Text
RO_SAFTMovementType RO_SAFTMovementType

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_RO_SAFTMatlDocLineItemC.
-- 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.
-- Parameters: P_AlternativeGLAccountIsUsed : saft_ro_alt_gl_account_flag

CREATE VIEW C_RO_SAFTMatlDocLineItemC AS
SELECT
  MaterialDocument,
  MaterialDocumentYear,
  MaterialDocumentItem,
  CompanyCode,
  BusinessTransactionTypeName,
  RO_SAFTStandardAccount,
  CustomerVATRegistration,
  SupplierVATRegistration,
  Product,
  Batch,
  MaterialBaseUnit,
  MatlStkChangeQtyInBaseUnit,
  PostingDate,
  SourceUnitOfMeasureFactor,
  ConversionFactor,
  CompanyCodeCurrency,
  GoodsMovementStkAmtInCCCrcy,
  MaterialDocumentItemText,
  RO_SAFTMovementType
FROM C_RO_SAFTMatlDocLineItem
;

Learn More