I_CONTSUBITEM

CDS View

CONSUMPTION VIEW for wbhd

I_CONTSUBITEM is a CDS View in S/4HANA. CONSUMPTION VIEW for wbhd. It contains 20 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
I_ACMTrdgContrItmInfo view inner COMPOSITE Interface view for Tradg Cont Item Info
I_ContItem view inner COMPOSITE Contract Item
P_ACMTrdgContrHdr view inner COMPOSITE Trading Contract Header
P_ACMTrdgContrHdrDet view inner COMPOSITE Trading Contract Header
P_TradingContractBusinessDets view from COMPOSITE

Fields (20)

KeyField CDS FieldsUsed in Views
KEY TradingContractNumber TradingContractNumber 1
ACMCustomerReference ACMCustomerReference 3
ACMPurgIncotermsPart1 ACMPurgIncotermsPart1,Incoterms 4
ACMSlsIncotermsPart1 ACMSlsIncotermsPart1,Incoterms 4
ACMSupplyingPlant ACMSupplyingPlant 1
ACMYourReference ACMYourReference 3
PricingDocument PricingDocument 2
PurchaseOrderSupplier PurchaseOrderSupplier 1
PurchasingGroup PurchasingGroup 3
PurchasingOrganization PurchasingOrganization 3
TradingContractCurrency TradingContractCurrency 3
TradingContractItem TradingContractItem 1
TrdgContrCommoditySubitem TrdgContrCommoditySubitem 1
TrdgContrPurgIncotermsLoc1Text IncotermsLocation1,TrdgContrPurgIncotermsLoc1Text 3
TrdgContrPurgIncotermsVersion TrdgContrPurgIncotermsVersion 1
TrdgContrPurgPaymentTerms PaymentTerms,TrdgContrPurgPaymentTerms 3
TrdgContrSalesIncotermsVersion TrdgContrSalesIncotermsVersion 1
TrdgContrSalesPaymentTerms PaymentTerms,TrdgContrSalesPaymentTerms 3
TrdgContrSlsIncotermsLoc1Text IncotermsLocation1,TrdgContrSlsIncotermsLoc1Text 3
TrdgContrSlsIncotermsLoc2Text TrdgContrSlsIncotermsLoc2Text 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.

-- CONSUMPTION VIEW for wbhd
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CONTSUBITEM (
    TRADINGCONTRACTNUMBER,
    ACMCUSTOMERREFERENCE,
    ACMPURGINCOTERMSPART1,
    ACMSLSINCOTERMSPART1,
    ACMSUPPLYINGPLANT,
    ACMYOURREFERENCE,
    PRICINGDOCUMENT,
    PURCHASEORDERSUPPLIER,
    PURCHASINGGROUP,
    PURCHASINGORGANIZATION,
    TRADINGCONTRACTCURRENCY,
    TRADINGCONTRACTITEM,
    TRDGCONTRCOMMODITYSUBITEM,
    TRDGCONTRPURGINCOTERMSLOC1TEXT,
    TRDGCONTRPURGINCOTERMSVERSION,
    TRDGCONTRPURGPAYMENTTERMS,
    TRDGCONTRSALESINCOTERMSVERSION,
    TRDGCONTRSALESPAYMENTTERMS,
    TRDGCONTRSLSINCOTERMSLOC1TEXT,
    TRDGCONTRSLSINCOTERMSLOC2TEXT,
    PRIMARY KEY (TRADINGCONTRACTNUMBER)
);