PURCHASECONTRACT

11 Fields

PURCHASECONTRACT is an SAP database table in S/4HANA. It contains 11 fields.

Fields (11)

KeyField CDS FieldsUsed in Views
KEY PurchaseContract PurchaseContract 3
CompanyCode CompanyCode 3
CreatedByUser CreatedByUser 3
CreationDate CreationDate 3
DocumentCurrency DocumentCurrency 1
PurchaseContractType PurchaseContractType 3
PurchasingGroup PurchasingGroup 3
PurchasingOrganization PurchasingOrganization 3
Supplier Supplier 3
ValidityEndDate ValidityEndDate 3
ValidityStartDate ValidityStartDate 3

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 PURCHASECONTRACT (
    PURCHASECONTRACT,
    COMPANYCODE,
    CREATEDBYUSER,
    CREATIONDATE,
    DOCUMENTCURRENCY,
    PURCHASECONTRACTTYPE,
    PURCHASINGGROUP,
    PURCHASINGORGANIZATION,
    SUPPLIER,
    VALIDITYENDDATE,
    VALIDITYSTARTDATE,
    PRIMARY KEY (PURCHASECONTRACT)
);

Learn More