CONTRACTITEMDATA

17 Fields

CONTRACTITEMDATA is an SAP database table in S/4HANA. It contains 17 fields.

Fields (17)

KeyField CDS FieldsUsed in Views
ContractMaterial ContractMaterial 3
ContractPlant ContractPlant 1
ContractStorageLocation ContractStorageLocation 1
MaterialBaseUnit MaterialBaseUnit 1
PricingDocument PricingDocument 2
PricingProcedure PricingProcedure 2
RelatedDocumentItemNumber RelatedDocumentItemNumber 2
RelatedDocumentNumber RelatedDocumentNumber 2
TradingContractChangedOnDate TradingContrChangedOnDate 2
TradingContractChangedOnTime TradingContrChangedOnTime 2
TradingContractItemQuantity TradingContractItemQuantity 2
TradingContractType TradingContractType 2
TradingContrChangedOnDateTime TradingContrChangedOnDateTime 2
TradingContrCreatedOnDate TradingContrCreatedOnDate 2
TradingContrCreatedOnDateTime TradingContrCreatedOnDateTime 2
TradingContrCreatedOnTime TradingContrCreatedOnTime 2
TrdgContractItemUnitOfMeasure TrdgContractItemUnitOfMeasure 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 CONTRACTITEMDATA (
    CONTRACTMATERIAL,
    CONTRACTPLANT,
    CONTRACTSTORAGELOCATION,
    MATERIALBASEUNIT,
    PRICINGDOCUMENT,
    PRICINGPROCEDURE,
    RELATEDDOCUMENTITEMNUMBER,
    RELATEDDOCUMENTNUMBER,
    TRADINGCONTRACTCHANGEDONDATE,
    TRADINGCONTRACTCHANGEDONTIME,
    TRADINGCONTRACTITEMQUANTITY,
    TRADINGCONTRACTTYPE,
    TRADINGCONTRCHANGEDONDATETIME,
    TRADINGCONTRCREATEDONDATE,
    TRADINGCONTRCREATEDONDATETIME,
    TRADINGCONTRCREATEDONTIME,
    TRDGCONTRACTITEMUNITOFMEASURE
);

Learn More