I_ACMCONTRITMDATA

CDS View
8 Fields 16 CDS Views

Contract Item data

I_ACMCONTRITMDATA is a CDS View in S/4HANA. Contract Item data. It contains 8 fields. 16 CDS views read from this table.

CDS Views using this table (16)

ViewTypeJoinVDMDescription
I_ACMMntnContrItem view_entity from COMPOSITE Basic Contract Item
I_TrdgContrItemOverfillData view from COMPOSITE Overfill Quantity Data
P_ACMAppliAssgmtQtyDistr view_entity inner COMPOSITE
P_ACMApplicationAssgmtQtyDistr view inner COMPOSITE
P_ACMAppliedApplicationData view inner COMPOSITE
P_ACMAppliedApplicationsData view_entity inner COMPOSITE
P_ACMCanceledQtyTotalOnContr view from COMPOSITE
P_ACMCancelledQtyTotalOnContr view_entity from COMPOSITE
P_ACMTotalCancelledQty view_entity from COMPOSITE
P_ACMTotalCancelledQty view_entity union_all COMPOSITE
P_ACMTotalCancelledQuantity view from COMPOSITE
P_ACMTrdgContractAssgmtData view_entity inner COMPOSITE
P_ACMTrdgContrAssgmtData view inner COMPOSITE
P_DGR_Appl_FillContrPlntMat view left_outer COMPOSITE
P_NetPosition_DerivativeUpdD view left_outer COMPOSITE
P_TrdgContrItmQtyLinkTypeInd view from COMPOSITE

Fields (8)

KeyField CDS FieldsUsed in Views
KEY ContractItem TradingContractItem 1
KEY ContractNum TradingContractNumber 2
ContractMaterial ContractMaterial 2
ContractPlant ContractPlant 1
RelatedDocumentItemNumber RelatedDocumentItemNumber 1
RelatedDocumentNumber RelatedDocumentNumber 1
TradingContractItemQuantity TradingContractItemQuantity 1
TrdgContractItemUnitOfMeasure TrdgContractItemUnitOfMeasure 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.

-- Contract Item data
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_ACMCONTRITMDATA (
    CONTRACTITEM,
    CONTRACTNUM,
    CONTRACTMATERIAL,
    CONTRACTPLANT,
    RELATEDDOCUMENTITEMNUMBER,
    RELATEDDOCUMENTNUMBER,
    TRADINGCONTRACTITEMQUANTITY,
    TRDGCONTRACTITEMUNITOFMEASURE,
    PRIMARY KEY (CONTRACTITEM, CONTRACTNUM)
);

Learn More