PURCHASEDOC

PURCHASEDOC is an SAP database table in S/4HANA. It contains 6 fields.

Fields (6)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 5
KEY PurchasingGroup PurchasingGroup 5
KEY PurchasingOrganization PurchasingOrganization 5
KEY Supplier Supplier 5
PurchasingDocumentCategory PurchasingDocumentCategory 5
PurchasingDocumentStatus PurchasingDocumentStatus 5

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 PURCHASEDOC (
    COMPANYCODE,
    PURCHASINGGROUP,
    PURCHASINGORGANIZATION,
    SUPPLIER,
    PURCHASINGDOCUMENTCATEGORY,
    PURCHASINGDOCUMENTSTATUS,
    PRIMARY KEY (COMPANYCODE, PURCHASINGGROUP, PURCHASINGORGANIZATION, SUPPLIER)
);