P_APFLEXIBLEAGING0

CDS View

Accounts Payables Flexible Aging 0

P_APFLEXIBLEAGING0 is a CDS View in S/4HANA. Accounts Payables Flexible Aging 0. It contains 18 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_APFlexibleAging1 view left_outer COMPOSITE Accounts Payables Flexible Aging 1
P_APFlexibleAging1 view union_all COMPOSITE Accounts Payables Flexible Aging 1

Fields (18)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 1
KEY AccountingDocumentItem AccountingDocumentItem 1
KEY FiscalYear FiscalYear 1
AccountingDocumentCategory AccountingDocumentCategory 1
BusinessArea BusinessArea 1
CompanyCodeCurrency CompanyCodeCurrency 1
DocumentDate RefInvcDocumentDate 1
FollowOnDocumentType FollowOnDocumentType 1
InvoiceItemReference InvoiceItemReference 1
InvoiceReference InvoiceReference 1
InvoiceReferenceFiscalYear InvoiceReferenceFiscalYear 1
NetDueDate NetDueDate,RefInvcNetDueDate 1
PaymentMethod PaymentMethod 1
PaymentTerms PaymentTerms 1
ReconciliationAccount ReconciliationAccount 1
SpecialGLCode SpecialGLCode 1
Supplier Supplier 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.

-- Accounts Payables Flexible Aging 0
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_APFLEXIBLEAGING0 (
    ACCOUNTINGDOCUMENT,
    ACCOUNTINGDOCUMENTITEM,
    FISCALYEAR,
    ACCOUNTINGDOCUMENTCATEGORY,
    BUSINESSAREA,
    COMPANYCODECURRENCY,
    DOCUMENTDATE,
    FOLLOWONDOCUMENTTYPE,
    INVOICEITEMREFERENCE,
    INVOICEREFERENCE,
    INVOICEREFERENCEFISCALYEAR,
    NETDUEDATE,
    PAYMENTMETHOD,
    PAYMENTTERMS,
    RECONCILIATIONACCOUNT,
    SPECIALGLCODE,
    SUPPLIER,
    TRANSACTIONCURRENCY,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, ACCOUNTINGDOCUMENTITEM, FISCALYEAR)
);