CONTRACTSTATUS

8 Fields

CONTRACTSTATUS is an SAP database table in S/4HANA. It contains 8 fields.

Fields (8)

KeyField CDS FieldsUsed in Views
KEY PurchaseContract PurchaseContract 2
KEY PurchaseContractItem PurchaseContractItem 1
PurchaseContractType PurchaseContractType 1
PurchasingGroup PurchasingGroup 1
PurchasingOrganization PurchasingOrganization 1
PurContrValidityStatusName Name 1
ValidityEndDate ValidityEndDate 2
ValidityStartDate ValidityStartDate 2

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 CONTRACTSTATUS (
    PURCHASECONTRACT,
    PURCHASECONTRACTITEM,
    PURCHASECONTRACTTYPE,
    PURCHASINGGROUP,
    PURCHASINGORGANIZATION,
    PURCONTRVALIDITYSTATUSNAME,
    VALIDITYENDDATE,
    VALIDITYSTARTDATE,
    PRIMARY KEY (PURCHASECONTRACT, PURCHASECONTRACTITEM)
);

Learn More