PURCHASECONTRACTITEM

18 Fields

PURCHASECONTRACTITEM is an SAP database table in S/4HANA. It contains 18 fields.

Fields (18)

KeyField CDS FieldsUsed in Views
KEY PurchaseContract PurchaseContract 3
KEY PurchaseContractItem PurchaseContractItem 3
CompanyCode CompanyCode 2
ContractNetPriceAmount ContractNetPriceAmount 1
ContractPlant ContractPlant 1
CreationDate CreationDate 1
DisplayCurrency DisplayCurrency 1
Material Material 3
MaterialGroup MaterialGroup 3
OrderQuantityUnit OrderQuantityUnit 2
Plant Plant 2
PurchaseContractType PurchaseContractType 1
PurchasingGroup PurchasingGroup 2
PurchasingOrganization PurchasingOrganization 2
Supplier Supplier 1
TargetQuantity TargetQuantity 1
ValidityEndDate ValidityEndDate 1
ValidityStartDate ValidityStartDate 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 PURCHASECONTRACTITEM (
    PURCHASECONTRACT,
    PURCHASECONTRACTITEM,
    COMPANYCODE,
    CONTRACTNETPRICEAMOUNT,
    CONTRACTPLANT,
    CREATIONDATE,
    DISPLAYCURRENCY,
    MATERIAL,
    MATERIALGROUP,
    ORDERQUANTITYUNIT,
    PLANT,
    PURCHASECONTRACTTYPE,
    PURCHASINGGROUP,
    PURCHASINGORGANIZATION,
    SUPPLIER,
    TARGETQUANTITY,
    VALIDITYENDDATE,
    VALIDITYSTARTDATE,
    PRIMARY KEY (PURCHASECONTRACT, PURCHASECONTRACTITEM)
);

Learn More