P_PL_SAFTDownPaymentItem

DDL: P_PL_SAFTDOWNPAYMENTITEM SQL: PPLSAFTDWPAYITM Type: view CONSUMPTION
16 Fields 3 Data Sources

P_PL_SAFTDownPaymentItem is a Consumption CDS View in SAP S/4HANA. It reads from 3 data sources (I_PL_SAFTDownPaymentSlsOrdItm, P_PL_SAFTInvoiceHeaderBasic, I_SalesDocumentItem) and exposes 16 fields with key fields CompanyCode, BillingDocument, SalesDocument, SalesDocumentItem, ConditionRateValue.

Data Sources (3)

SourceAliasJoin Type
I_PL_SAFTDownPaymentSlsOrdItm DPSalesOrderItem inner
P_PL_SAFTInvoiceHeaderBasic P_PL_SAFTInvoiceHeaderBasic from
I_SalesDocumentItem SalesDocumentItem inner

Parameters (2)

NameTypeDefault
P_StartDate datum
P_EndDate datum

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PPLSAFTDWPAYITM view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
VDM.private true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #P view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode InvoiceHeader CompanyCode Receiver Company Code
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
AmountInTransactionCurrency InvoiceHeader AmountInTransactionCurrency Pt Crcy Amt
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
_SalesDocument I_PL_SAFTDownPaymentSlsOrdItm _SalesDocument
_CompanyCode InvoiceHeader _CompanyCode
_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 P_PL_SAFTDownPaymentItem.
-- 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: PPLSAFTDWPAYITM
-- Parameters: P_StartDate : datum, P_EndDate : datum

CREATE VIEW P_PL_SAFTDownPaymentItem AS
SELECT
  InvoiceHeader.CompanyCode AS CompanyCode,
  DPSalesOrderItem.BillingDocument AS BillingDocument,
  DPSalesOrderItem.SalesDocument AS SalesDocument,
  DPSalesOrderItem.SalesDocumentItem AS SalesDocumentItem,
  DPSalesOrderItem.ConditionRateValue AS ConditionRateValue,
  InvoiceHeader.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  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,
  DPSalesOrderItem._SalesDocument AS _SalesDocument,
  InvoiceHeader._CompanyCode AS _CompanyCode,
  SalesDocumentItem._OrderQuantityUnit AS _OrderQuantityUnit
FROM P_PL_SAFTInvoiceHeaderBasic
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 */
;

Learn More