I_ACMCONTRACTSUBITEMDET

CDS View
22 Fields 3 CDS Views

Trading Contrct Sub item details

I_ACMCONTRACTSUBITEMDET is a CDS View in S/4HANA. Trading Contrct Sub item details. It contains 22 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_ACMTrdgContrBusDataDet view from COMPOSITE Trading Contract Business Data Details
P_ACMTradingContractOverview view inner COMPOSITE
P_ACMTrdgContrHdrDetsMntnContr view inner COMPOSITE

Fields (22)

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

-- Trading Contrct Sub item details
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_ACMCONTRACTSUBITEMDET (
    TRADINGCONTRACTNUMBER,
    ACMCUSTOMERREFERENCE,
    ACMPURGINCOTERMSPART1,
    ACMSLSINCOTERMSPART1,
    ACMSUPPLYINGPLANT,
    ACMYOURREFERENCE,
    ALTERNATEPAYMENTTERM,
    DOCUMENTSIDE,
    INCOTERMSLOCATION1,
    PRICINGDOCUMENT,
    PURCHASEORDERSUPPLIER,
    PURCHASINGGROUP,
    PURCHASINGORGANIZATION,
    TRADINGCONTRACTCURRENCY,
    TRADINGCONTRACTITEM,
    TRDGCONTRCOMMODITYSUBITEM,
    TRDGCONTRPURGINCOTERMSLOC1TEXT,
    TRDGCONTRPURGINCOTERMSVERSION,
    TRDGCONTRSALESINCOTERMSVERSION,
    TRDGCONTRSALESPAYMENTTERMS,
    TRDGCONTRSLSINCOTERMSLOC1TEXT,
    TRDGCONTRSLSINCOTERMSLOC2TEXT,
    PRIMARY KEY (TRADINGCONTRACTNUMBER)
);

Learn More