C_RO_SAFTMatlDocLineItemQ

DDL: C_RO_SAFTMATLDOCLINEITEMQ SQL: CROSAFTMATDOITQ Type: view CONSUMPTION
19 Fields 1 Data Sources

RO SAFT Matl Doc Lines - Query

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

Data Sources (1)

SourceAliasJoin Type
C_RO_SAFTMatlDocLineItemC C_RO_SAFTMatlDocLineItemC from

Parameters (1)

NameTypeDefault
P_AlternativeGLAccountIsUsed saft_ro_alt_gl_account_flag

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CROSAFTMATDOITQ view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #CONSUMPTION view
Analytics.query true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label RO SAFT Matl Doc Lines - Query 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
RO_SAFTStandardAccount RO_SAFTStandardAccount
BusinessTransactionTypeName BusinessTransactionTypeName
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_SAFTMatlDocLineItemQ.
-- 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.
-- SQL view name: CROSAFTMATDOITQ
-- Parameters: P_AlternativeGLAccountIsUsed : saft_ro_alt_gl_account_flag

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

Learn More