R_DebitCreditReferenceQuantity

DDL: R_DEBITCREDITREFERENCEQUANTITY Type: view_entity BASIC Package: ODATA_ML_DSPMATLDBCRDOCS
7 Fields 1 Data Sources

Debit Credit Reference Quantity

R_DebitCreditReferenceQuantity is a Basic CDS View that provides data about "Debit Credit Reference Quantity" in SAP S/4HANA. It reads from 1 data source (mlppf) and exposes 7 fields with key fields MaterialLedgerDocument, MaterialLedgerDocumentYear, DocumentItemNumber, FiscalYear, FiscalPeriod. Part of development package ODATA_ML_DSPMATLDBCRDOCS.

Data Sources (1)

SourceAliasJoin Type
mlppf mlppf from

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Debit Credit Reference Quantity view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY MaterialLedgerDocument mlppf belnr SD Document
KEY MaterialLedgerDocumentYear mlppf kjahr Year
KEY DocumentItemNumber mlppf posnr WBS Element
KEY FiscalYear
KEY FiscalPeriod mlppf poper Posting periods
MaterialBaseUnit Dimension MaterialBaseUnit Valuation Unit
ReferenceQuantity mlppf menge WarrCountValue

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 R_DebitCreditReferenceQuantity.
-- 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 R_DebitCreditReferenceQuantity AS
SELECT
  mlppf.belnr AS MaterialLedgerDocument,
  mlppf.kjahr AS MaterialLedgerDocumentYear,
  mlppf.posnr AS DocumentItemNumber,
  cast(mlppf.bdatj as fis_gjahr_no_conv preserving type ) AS FiscalYear,
  mlppf.poper AS FiscalPeriod,
  Dimension.MaterialBaseUnit AS MaterialBaseUnit,
  mlppf.menge AS ReferenceQuantity
FROM mlppf
;

Learn More