I_ASSIGNMENTDATA

CDS View

ACM Qty: Assignment Data

I_ASSIGNMENTDATA is a CDS View in S/4HANA. ACM Qty: Assignment Data. It contains 9 fields. 9 CDS views read from this table.

CDS Views using this table (9)

ViewTypeJoinVDMDescription
I_ACMContractPricing view_entity inner COMPOSITE Interface for ACM contract pricing
I_ACMPpaytAgrmtAssgdDoc view_entity inner COMPOSITE Interface for Prepay Agmt Asgd Docs
I_ACMPrepaymentAssignedDoc view_entity inner COMPOSITE Interface for Prepay Agmt Asgd Docs
I_QuantityAssignmentData view from COMPOSITE ACM Quantity: Assignment Data
P_ACMLgclAdjdCanclnQts view inner COMPOSITE
P_ASSIGNMENTDATA view from COMPOSITE
P_CancelledQuantity view inner COMPOSITE
P_LogisticallyAdjustedQty view inner COMPOSITE
P_WashoutQuantity view inner COMPOSITE

Fields (9)

KeyField CDS FieldsUsed in Views
KEY ACMFromDocumentItemNumber ACMFromDocumentItemNumber 2
KEY ACMFromDocumentNumber ACMFromDocumentNumber 2
KEY ContractCommodityItem ContractCommodityItem 2
KEY ContractItem TradingContractItem 2
KEY ContractNum TradingContractNumber 2
KEY DocumentFrom DocumentFrom 2
AssignmentQuantity AssignmentQuantity 1
ContractItemAssignmentUUID ContractItemAssignmentUUID 2
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.

-- ACM Qty: Assignment Data
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_ASSIGNMENTDATA (
    ACMFROMDOCUMENTITEMNUMBER,
    ACMFROMDOCUMENTNUMBER,
    CONTRACTCOMMODITYITEM,
    CONTRACTITEM,
    CONTRACTNUM,
    DOCUMENTFROM,
    ASSIGNMENTQUANTITY,
    CONTRACTITEMASSIGNMENTUUID,
    TRDGCONTRACTITEMUNITOFMEASURE,
    PRIMARY KEY (ACMFROMDOCUMENTITEMNUMBER, ACMFROMDOCUMENTNUMBER, CONTRACTCOMMODITYITEM, CONTRACTITEM, CONTRACTNUM, DOCUMENTFROM)
);