What is C_PL_SAFTDownPaytCnsldtnItem in SAP S/4HANA?

C_PL_SAFTDownPaytCnsldtnItem is a consumption CDS view in SAP S/4HANA. SAF-T PL: Down Payment Consolidation Item It contains 13 fields.

What VDM layer is C_PL_SAFTDownPaytCnsldtnItem?

C_PL_SAFTDownPaytCnsldtnItem is classified as a Consumption view optimized for specific business scenarios and reporting.

C_PL_SAFTDownPaytCnsldtnItem

Q: Which tables does C_PL_SAFTDownPaytCnsldtnItem read from?

C_PL_SAFTDownPaytCnsldtnItem reads data from: I_SAFTConsolidationKey, I_PL_SAFTDownPaymentSlsOrdItm, I_PL_SAFTInvoiceHeader, I_SalesDocumentItem.

DDL: C_PL_SAFTDOWNPAYTCNSLDTNITEM SQL: CPLSAFTDPCI Type: view CONSUMPTION

13 Fields 4 Data Sources

SAF-T PL: Down Payment Consolidation Item

C_PL_SAFTDownPaytCnsldtnItem is a Consumption CDS View that provides data about "SAF-T PL: Down Payment Consolidation Item" in SAP S/4HANA. It reads from 4 data sources (I_SAFTConsolidationKey, I_PL_SAFTDownPaymentSlsOrdItm, I_PL_SAFTInvoiceHeader, I_SalesDocumentItem) and exposes 13 fields with key fields SAFTConsolidationUUID, BillingDocument, SalesDocument, SalesDocumentItem, ConditionRateValue.

Data Sources (4)

Source	Alias	Join Type
I_SAFTConsolidationKey	Consolidation	from
I_PL_SAFTDownPaymentSlsOrdItm	DPSalesOrderItem	inner
I_PL_SAFTInvoiceHeader	InvoiceHeader	inner
I_SalesDocumentItem	SalesDocumentItem	inner

Annotations (12)

Name	Value	Level
AbapCatalog.sqlViewName	CPLSAFTDPCI	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
AccessControl.authorizationCheck	#CHECK	view
EndUserText.label	SAF-T PL: Down Payment Consolidation Item	view
VDM.viewType	#CONSUMPTION	view
AccessControl.personalData.blocking	#NOT_REQUIRED	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.dataClass	#MIXED	view
VDM.lifecycle.status	#DEPRECATED	view

Fields (13)

Key	Field	Source Table	Source Field	Description
KEY	SAFTConsolidationUUID	I_SAFTConsolidationKey	SAFTConsolidationUUID	Consolidation ID
KEY	BillingDocument	I_PL_SAFTDownPaymentSlsOrdItm	BillingDocument	SD Document
KEY	SalesDocument	I_PL_SAFTDownPaymentSlsOrdItm	SalesDocument	SD Document
KEY	SalesDocumentItem	I_PL_SAFTDownPaymentSlsOrdItm	SalesDocumentItem	Sales Document Item
KEY	ConditionRateValue	I_PL_SAFTDownPaymentSlsOrdItm	ConditionRateValue	Condition Rate Value
	SalesDocumentItemText	I_SalesDocumentItem	SalesDocumentItemText	Item Descr.
	OrderQuantity	I_SalesDocumentItem	OrderQuantity	Quantity
	OrderQuantityUnit	I_SalesDocumentItem	OrderQuantityUnit	Sales Unit
	NetPriceAmount	I_SalesDocumentItem	NetPriceAmount	Net Price
	NetAmount	I_SalesDocumentItem	NetAmount	Stated Amount
	TransactionCurrency	I_PL_SAFTDownPaymentSlsOrdItm	TransactionCurrency	Transaction Currency
	TaxAmount	I_PL_SAFTDownPaymentSlsOrdItm	TaxAmount	Tax Amt in Rptg Crcy
	_OrderQuantityUnit	I_SalesDocumentItem	_OrderQuantityUnit

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_PL_SAFTDownPaytCnsldtnItem.
-- 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: CPLSAFTDPCI

CREATE VIEW C_PL_SAFTDownPaytCnsldtnItem AS
SELECT
  Consolidation.SAFTConsolidationUUID AS SAFTConsolidationUUID,
  DPSalesOrderItem.BillingDocument AS BillingDocument,
  DPSalesOrderItem.SalesDocument AS SalesDocument,
  DPSalesOrderItem.SalesDocumentItem AS SalesDocumentItem,
  DPSalesOrderItem.ConditionRateValue AS ConditionRateValue,
  SalesDocumentItem.SalesDocumentItemText AS SalesDocumentItemText,
  SalesDocumentItem.OrderQuantity AS OrderQuantity,
  SalesDocumentItem.OrderQuantityUnit AS OrderQuantityUnit,
  SalesDocumentItem.NetPriceAmount AS NetPriceAmount,
  SalesDocumentItem.NetAmount AS NetAmount,
  DPSalesOrderItem.TransactionCurrency AS TransactionCurrency,
  DPSalesOrderItem.TaxAmount AS TaxAmount,
  SalesDocumentItem._OrderQuantityUnit AS _OrderQuantityUnit
FROM I_SAFTConsolidationKey AS Consolidation
INNER JOIN I_PL_SAFTInvoiceHeader AS InvoiceHeader ON /* join condition not captured in parsed metadata */
INNER JOIN I_PL_SAFTDownPaymentSlsOrdItm AS DPSalesOrderItem ON /* join condition not captured in parsed metadata */
INNER JOIN I_SalesDocumentItem AS SalesDocumentItem ON /* join condition not captured in parsed metadata */
;

Depth:

C_PL_SAFTDownPaytCnsldtnItem view