I_PAYMENTADVICETP

CDS View
56 Fields 2 CDS Views

Payment Advice Header

I_PAYMENTADVICETP is a CDS View in S/4HANA. Payment Advice Header. It contains 56 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
C_PaymentAdvice view from CONSUMPTION Payment Advice Header
P_PaymentAdviceForSituation view from COMPOSITE

Fields (56)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 2
KEY PaymentAdvice PaymentAdvice 2
KEY PaymentAdviceAccount PaymentAdviceAccount 2
KEY PaymentAdviceAccountType PaymentAdviceAccountType 2
_BusinessPartner _BusinessPartner 1
_CompanyCode _CompanyCode 1
_CompanyCodeForEdit _CompanyCodeForEdit 1
_Currency _Currency 1
_Customer _Customer 1
_CustomerCompany _CustomerCompany 1
_CustomerForEdit _CustomerForEdit 1
_PaymentAdviceType _PaymentAdviceType 1
_PaytAdvcDiffDeterminationRule _PaytAdvcDiffDeterminationRule 1
_PaytAdviceSelRules _PaytAdviceSelRules 1
_Supplier _Supplier 1
_SupplierCompany _SupplierCompany 1
_UserContactCard _UserContactCard 1
AccountByShipper AccountByShipper 1
AccountingClerk AccountingClerk 1
AccountingClerkName AccountingClerkName 1
CashDiscountAmountInPaytCrcy CashDiscountAmountInPaytCrcy 1
CompanyCodeForEdit CompanyCodeForEdit 1
CreatedByUser CreatedByUser 2
CreationDate CreationDate 1
CreationDateTime CreationDateTime 1
CreationTime CreationTime 1
Customer Customer 1
CustomerName CustomerName 1
FullName FullName 1
LastChangeDate LastChangeDate 1
LastChangedByUser LastChangedByUser 1
OrganizationBPName1 OrganizationBPName1 1
OrganizationBPName2 OrganizationBPName2 1
PaidAmountInPaytCurrency PaidAmountInPaytCurrency 1
PaymentAdviceAccountForEdit PaymentAdviceAccountForEdit 1
PaymentAdviceExtractionStatus PaymentAdviceExtractionStatus 1
PaymentAdviceExtractorUUID PaymentAdviceExtractorUUID 1
PaymentAdviceForEdit PaymentAdviceForEdit 1
PaymentAdviceHeaderText PaymentAdviceHeaderText 1
PaymentAdviceIsExtracted PaymentAdviceIsExtracted 1
PaymentAdviceIsHeld PaymentAdviceIsHeld 1
PaymentAdviceSelectionRule PaymentAdviceSelectionRule 1
PaymentAdviceStatus PaymentAdviceStatus 1
PaymentAdviceType PaymentAdviceType 1
PaymentAdviceTypeName PaymentAdviceTypeName 1
PaymentAdviceUUID PaymentAdviceUUID 1
PaymentCurrency PaymentCurrency 1
PaymentDate PaymentDate 1
PaymentDocument PaymentDocument 1
PaytAdvcDiffDeterminationRule PaytAdvcDiffDeterminationRule 1
PaytAdvcDiffDetnRuleDesc PaytAdvcDiffDetnRuleDesc 1
PaytAdviceAccountTypeForEdit PaytAdviceAccountTypeForEdit 1
PaytAdviceExtractorConfidence PaytAdviceExtractorConfidence 1
PaytAdviceSelectionRuleDesc PaytAdviceSelectionRuleDesc 1
PaytAdviceTotalNumberOfPages PaytAdviceTotalNumberOfPages 1
UxFcPaymentAdviceAccount UxFcPaymentAdviceAccount 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.

-- Payment Advice Header
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PAYMENTADVICETP (
    COMPANYCODE,
    PAYMENTADVICE,
    PAYMENTADVICEACCOUNT,
    PAYMENTADVICEACCOUNTTYPE,
    _BUSINESSPARTNER,
    _COMPANYCODE,
    _COMPANYCODEFOREDIT,
    _CURRENCY,
    _CUSTOMER,
    _CUSTOMERCOMPANY,
    _CUSTOMERFOREDIT,
    _PAYMENTADVICETYPE,
    _PAYTADVCDIFFDETERMINATIONRULE,
    _PAYTADVICESELRULES,
    _SUPPLIER,
    _SUPPLIERCOMPANY,
    _USERCONTACTCARD,
    ACCOUNTBYSHIPPER,
    ACCOUNTINGCLERK,
    ACCOUNTINGCLERKNAME,
    CASHDISCOUNTAMOUNTINPAYTCRCY,
    COMPANYCODEFOREDIT,
    CREATEDBYUSER,
    CREATIONDATE,
    CREATIONDATETIME,
    CREATIONTIME,
    CUSTOMER,
    CUSTOMERNAME,
    FULLNAME,
    LASTCHANGEDATE,
    LASTCHANGEDBYUSER,
    ORGANIZATIONBPNAME1,
    ORGANIZATIONBPNAME2,
    PAIDAMOUNTINPAYTCURRENCY,
    PAYMENTADVICEACCOUNTFOREDIT,
    PAYMENTADVICEEXTRACTIONSTATUS,
    PAYMENTADVICEEXTRACTORUUID,
    PAYMENTADVICEFOREDIT,
    PAYMENTADVICEHEADERTEXT,
    PAYMENTADVICEISEXTRACTED,
    PAYMENTADVICEISHELD,
    PAYMENTADVICESELECTIONRULE,
    PAYMENTADVICESTATUS,
    PAYMENTADVICETYPE,
    PAYMENTADVICETYPENAME,
    PAYMENTADVICEUUID,
    PAYMENTCURRENCY,
    PAYMENTDATE,
    PAYMENTDOCUMENT,
    PAYTADVCDIFFDETERMINATIONRULE,
    PAYTADVCDIFFDETNRULEDESC,
    PAYTADVICEACCOUNTTYPEFOREDIT,
    PAYTADVICEEXTRACTORCONFIDENCE,
    PAYTADVICESELECTIONRULEDESC,
    PAYTADVICETOTALNUMBEROFPAGES,
    UXFCPAYMENTADVICEACCOUNT,
    PRIMARY KEY (COMPANYCODE, PAYMENTADVICE, PAYMENTADVICEACCOUNT, PAYMENTADVICEACCOUNTTYPE)
);

Learn More