OPENPAYABLES

28 Fields

OPENPAYABLES is an SAP database table in S/4HANA. It contains 28 fields.

Fields (28)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 1
KEY CompanyCode CompanyCode 1
KEY FiscalYear FiscalYear 1
KEY LedgerGLLineItem LedgerGLLineItem 2
AccountingDocumentCategory AccountingDocumentCategory 2
AccountingDocumentItem AccountingDocumentItem 2
AccountingDocumentType AccountingDocumentType 2
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency 1
AssignmentReference AssignmentReference 1
BusinessArea BusinessArea 1
ClearingDate ClearingDate 2
CompanyCodeCurrency CompanyCodeCurrency 1
CostCenter CostCenter 1
DocumentDate DocumentDate 2
FinancialAccountType FinancialAccountType 2
FollowOnDocumentType FollowOnDocumentType 1
FunctionalArea FunctionalArea 1
GLAccount GLAccount 1
InvoiceItemReference InvoiceItemReference 1
InvoiceReference InvoiceReference 1
InvoiceReferenceFiscalYear InvoiceReferenceFiscalYear 1
NetDueDate NetDueDate 1
PostingDate PostingDate 2
ProfitCenter ProfitCenter 1
PurchasingDocument PurchasingDocument 1
Segment Segment 1
SpecialGLCode SpecialGLCode 1
Supplier Supplier 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 OPENPAYABLES (
    ACCOUNTINGDOCUMENT,
    COMPANYCODE,
    FISCALYEAR,
    LEDGERGLLINEITEM,
    ACCOUNTINGDOCUMENTCATEGORY,
    ACCOUNTINGDOCUMENTITEM,
    ACCOUNTINGDOCUMENTTYPE,
    AMOUNTINCOMPANYCODECURRENCY,
    ASSIGNMENTREFERENCE,
    BUSINESSAREA,
    CLEARINGDATE,
    COMPANYCODECURRENCY,
    COSTCENTER,
    DOCUMENTDATE,
    FINANCIALACCOUNTTYPE,
    FOLLOWONDOCUMENTTYPE,
    FUNCTIONALAREA,
    GLACCOUNT,
    INVOICEITEMREFERENCE,
    INVOICEREFERENCE,
    INVOICEREFERENCEFISCALYEAR,
    NETDUEDATE,
    POSTINGDATE,
    PROFITCENTER,
    PURCHASINGDOCUMENT,
    SEGMENT,
    SPECIALGLCODE,
    SUPPLIER,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, COMPANYCODE, FISCALYEAR, LEDGERGLLINEITEM)
);

Learn More