I_SLSDOCPAYMENTPLANITEMDETAILS

CDS View

Sales Document Payment Plan Item Details

I_SLSDOCPAYMENTPLANITEMDETAILS is a CDS View in S/4HANA. Sales Document Payment Plan Item Details. It contains 15 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
A_SlsOrdPaymentPlanItemDetails view from COMPOSITE Header Payment Plan
C_SlsDocPaymentPlanItem view from CONSUMPTION Sales Document Payment Plan Item
C_SlsDocPaymentPlanItem view inner CONSUMPTION Sales Document Payment Plan Item

Fields (15)

KeyField CDS FieldsUsed in Views
KEY PaymentPlanItem PaymentPlanItem 1
KEY SalesDocument SalesDocument 1
AuthorizationCurrency AuthorizationCurrency 1
AuthorizedAmountInAuthznCrcy AuthorizedAmountInAuthznCrcy 1
BillingPlanRelatedBillgStsDesc BillingPlanRelatedBillgStsDesc 1
DistributionChannel DistributionChannel 1
ElectronicPayment ElectronicPayment 1
ElectronicPaymentHolderName ElectronicPaymentHolderName 1
ElectronicPaymentType ElectronicPaymentType 1
EPaytAuthorizationTypeDesc EPaytAuthorizationTypeDesc 1
OrganizationDivision OrganizationDivision 1
PaymentPlan PaymentPlan 2
SalesDocumentType SalesDocumentType 1
SalesOrganization SalesOrganization 1
TransactionCurrency TransactionCurrency 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Sales Document Payment Plan Item Details
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_SLSDOCPAYMENTPLANITEMDETAILS (
    PAYMENTPLANITEM,
    SALESDOCUMENT,
    AUTHORIZATIONCURRENCY,
    AUTHORIZEDAMOUNTINAUTHZNCRCY,
    BILLINGPLANRELATEDBILLGSTSDESC,
    DISTRIBUTIONCHANNEL,
    ELECTRONICPAYMENT,
    ELECTRONICPAYMENTHOLDERNAME,
    ELECTRONICPAYMENTTYPE,
    EPAYTAUTHORIZATIONTYPEDESC,
    ORGANIZATIONDIVISION,
    PAYMENTPLAN,
    SALESDOCUMENTTYPE,
    SALESORGANIZATION,
    TRANSACTIONCURRENCY,
    PRIMARY KEY (PAYMENTPLANITEM, SALESDOCUMENT)
);