P_PAYMENTADVICESUBITEM

CDS View
22 Fields 1 CDS Views

P_PAYMENTADVICESUBITEM is a CDS View in S/4HANA. It contains 22 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PaymentAdviceSubItemTP view from TRANSACTIONAL Payment Advice Subitem

Fields (22)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode,CompanyCodeForEdit 1
KEY PaymentAdvice PaymentAdvice,PaymentAdviceForEdit 1
KEY PaymentAdviceAccount PaymentAdviceAccount,PaymentAdviceAccountForEdit 1
KEY PaymentAdviceAccountType PaymentAdviceAccountType,PaytAdviceAccountTypeForEdit 1
KEY PaymentAdviceItem PaymentAdviceItem,PaymentAdviceItemForEdit 1
KEY PaymentAdviceSubItem PaymentAdviceSubItem,PaymentAdviceSubItemForEdit 1
_CompanyCode _CompanyCode 1
_Currency _Currency 1
_Customer _Customer 1
_CustomerCompany _CustomerCompany 1
_PaymentDifferenceReason _PaymentDifferenceReason 1
_Supplier _Supplier 1
_SupplierCompany _SupplierCompany 1
Currency Currency 1
GrossDeductionAmountInPaytCrcy GrossDeductionAmountInPaytCrcy 1
NetDeductionAmountInPaytCrcy NetDeductionAmountInPaytCrcy 1
PaymentDifferenceReason PaymentDifferenceReason 1
PaymentDifferenceReasonDesc PaymentDifferenceReasonDesc 1
PaymentDifferenceReasonName PaymentDifferenceReasonName 1
PaytDifferenceReasonExtCode PaytDifferenceReasonExtCode 1
Reference1IDByBusinessPartner Reference1IDByBusinessPartner 1
Reference2IDByBusinessPartner Reference2IDByBusinessPartner 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_PAYMENTADVICESUBITEM (
    COMPANYCODE,
    PAYMENTADVICE,
    PAYMENTADVICEACCOUNT,
    PAYMENTADVICEACCOUNTTYPE,
    PAYMENTADVICEITEM,
    PAYMENTADVICESUBITEM,
    _COMPANYCODE,
    _CURRENCY,
    _CUSTOMER,
    _CUSTOMERCOMPANY,
    _PAYMENTDIFFERENCEREASON,
    _SUPPLIER,
    _SUPPLIERCOMPANY,
    CURRENCY,
    GROSSDEDUCTIONAMOUNTINPAYTCRCY,
    NETDEDUCTIONAMOUNTINPAYTCRCY,
    PAYMENTDIFFERENCEREASON,
    PAYMENTDIFFERENCEREASONDESC,
    PAYMENTDIFFERENCEREASONNAME,
    PAYTDIFFERENCEREASONEXTCODE,
    REFERENCE1IDBYBUSINESSPARTNER,
    REFERENCE2IDBYBUSINESSPARTNER,
    PRIMARY KEY (COMPANYCODE, PAYMENTADVICE, PAYMENTADVICEACCOUNT, PAYMENTADVICEACCOUNTTYPE, PAYMENTADVICEITEM, PAYMENTADVICESUBITEM)
);

Learn More