P_SDPaymentPlanItemDetails

DDL: P_SDPAYMENTPLANITEMDETAILS Type: view COMPOSITE Package: VDM_SD_SLS_EPY
16 Fields 2 Data Sources

Payment Card item details

P_SDPaymentPlanItemDetails is a Composite CDS View that provides data about "Payment Card item details" in SAP S/4HANA. It reads from 2 data sources (I_PaymentPlan, I_PaymentPlanItemDetails) and exposes 16 fields with key fields PaymentPlan, PaymentPlanItem, SalesOrder. Part of development package VDM_SD_SLS_EPY.

Data Sources (2)

SourceAliasJoin Type
I_PaymentPlan header from
I_PaymentPlanItemDetails item inner

Annotations (6)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName PPAYTCARDITMDET view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY PaymentPlan I_PaymentPlan PaymentPlan Paym.Ca.Pl.No.
KEY PaymentPlanItem I_PaymentPlanItemDetails PaymentPlanItem Item
KEY SalesOrder I_PaymentPlan SalesDocument SD Document
ElectronicPaymentType I_PaymentPlanItemDetails ElectronicPaymentType
EPaytValidityEndDate I_PaymentPlanItemDetails EPaytValidityEndDate
AuthorizedAmountInAuthznCrcy I_PaymentPlanItemDetails AuthorizedAmountInAuthznCrcy
AuthorizationDate I_PaymentPlanItemDetails AuthorizationDate
PreauthorizationIsRequested I_PaymentPlanItemDetails PreauthorizationIsRequested
EPaytToBeAuthorizedAmount I_PaymentPlanItemDetails EPaytToBeAuthorizedAmount
EPaytAuthorizationIsExpired I_PaymentPlanItemDetails EPaytAuthorizationIsExpired
TransactionCurrency I_PaymentPlanItemDetails TransactionCurrency Transaction Currency
PaymentCardAuthznPeriodDays _PaymentCardType PaymentCardAuthznPeriodDays
PaytCardAuthznRqmtStatus I_PaymentPlan PaytCardAuthznRqmtStatus Requirement Sts
AuthorizationCurrency I_PaymentPlanItemDetails AuthorizationCurrency Transaction Currency
PaymentPlanRelatedBillgStatus I_PaymentPlanItemDetails PaymentPlanRelatedBillgStatus
_PaymentCardType I_PaymentPlanItemDetails _PaymentCardType

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_SDPaymentPlanItemDetails.
-- 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 P_SDPaymentPlanItemDetails AS
SELECT
  header.PaymentPlan AS PaymentPlan,
  item.PaymentPlanItem AS PaymentPlanItem,
  header.SalesDocument AS SalesOrder,
  item.ElectronicPaymentType AS ElectronicPaymentType,
  item.EPaytValidityEndDate AS EPaytValidityEndDate,
  item.AuthorizedAmountInAuthznCrcy AS AuthorizedAmountInAuthznCrcy,
  item.AuthorizationDate AS AuthorizationDate,
  item.PreauthorizationIsRequested AS PreauthorizationIsRequested,
  item.EPaytToBeAuthorizedAmount AS EPaytToBeAuthorizedAmount,
  item.EPaytAuthorizationIsExpired AS EPaytAuthorizationIsExpired,
  item.TransactionCurrency AS TransactionCurrency,
  _PaymentCardType.PaymentCardAuthznPeriodDays AS PaymentCardAuthznPeriodDays,
  header.PaytCardAuthznRqmtStatus AS PaytCardAuthznRqmtStatus,
  item.AuthorizationCurrency AS AuthorizationCurrency,
  item.PaymentPlanRelatedBillgStatus AS PaymentPlanRelatedBillgStatus,
  item._PaymentCardType AS _PaymentCardType
FROM I_PaymentPlan AS header
INNER JOIN I_PaymentPlanItemDetails AS item ON /* join condition not captured in parsed metadata */
;

Learn More