I_ACMTRDGCONTRHDRFORPRCGOVW

CDS View

Trading Contract Header Details

I_ACMTRDGCONTRHDRFORPRCGOVW is a CDS View in S/4HANA. Trading Contract Header Details. It contains 30 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_ACMTradingContractPricingOvw view inner COMPOSITE Intrface View for Trdg Cont Prcg Details
I_ACMTrdgContrPrcFxtnOvw view_entity inner COMPOSITE Interface Layer for Trdg Contr Prc Ovw
I_ACMTrdgContrPrcLotDet view inner COMPOSITE Interface Layer for Trdg Contr Prc lot det
I_ACMTrdgContrPrcOvw view inner COMPOSITE Interface Layer for Trdg Contr Prc Ovw

Fields (30)

KeyField CDS FieldsUsed in Views
KEY TradingContractNumber TradingContractNumber 4
ACMContractStatusIsPosRelevant ACMContractStatusIsPosRelevant 4
ACMCustomerReference ACMCustomerReference 4
ACMPurgIncotermsPart1 ACMPurgIncotermsPart1 4
ACMSlsIncotermsPart1 ACMSlsIncotermsPart1 4
ACMTrdgContrStatusCategory ACMTrdgContrStatusCategory 4
ACMYourReference ACMYourReference 4
AlternatePaymentTerm AlternatePaymentTerm 4
CompanyCode CompanyCode 4
ContractStatus ContractStatus 4
DistributionChannel DistributionChannel 4
Division Division 4
DocumentDate DocumentDate 4
PersonResponsible PersonResponsible 3
PricingDocument PricingDocument 4
PurchaseOrderSupplier PurchaseOrderSupplier 4
PurchasingGroup PurchasingGroup 4
PurchasingOrganization PurchasingOrganization 4
SalesOrganization SalesOrganization 4
TradingContractChangedBy TradingContractChangedBy 4
TradingContractCreatedBy TradingContractCreatedBy 4
TradingContractExternalID TradingContractExternalID 4
TradingContractType TradingContractType 4
TradingContractTypeName ACMTradingContractTypeName,TradingContractTypeName 4
TradingContrChangedOnDate TradingContrChangedOnDate 1
TradingContrCreatedOnDate TradingContrCreatedOnDate 4
TrdgContrApplStsName TrdgContrApplStsName 4
TrdgContrGoodsSupplier TrdgContrGoodsSupplier 4
TrdgContrPurgIncotermsLoc1Text TrdgContrPurgIncotermsLoc1Text 4
TrdgContrSlsIncotermsLoc1Text TrdgContrSlsIncotermsLoc1Text 4

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 Contract Header Details
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_ACMTRDGCONTRHDRFORPRCGOVW (
    TRADINGCONTRACTNUMBER,
    ACMCONTRACTSTATUSISPOSRELEVANT,
    ACMCUSTOMERREFERENCE,
    ACMPURGINCOTERMSPART1,
    ACMSLSINCOTERMSPART1,
    ACMTRDGCONTRSTATUSCATEGORY,
    ACMYOURREFERENCE,
    ALTERNATEPAYMENTTERM,
    COMPANYCODE,
    CONTRACTSTATUS,
    DISTRIBUTIONCHANNEL,
    DIVISION,
    DOCUMENTDATE,
    PERSONRESPONSIBLE,
    PRICINGDOCUMENT,
    PURCHASEORDERSUPPLIER,
    PURCHASINGGROUP,
    PURCHASINGORGANIZATION,
    SALESORGANIZATION,
    TRADINGCONTRACTCHANGEDBY,
    TRADINGCONTRACTCREATEDBY,
    TRADINGCONTRACTEXTERNALID,
    TRADINGCONTRACTTYPE,
    TRADINGCONTRACTTYPENAME,
    TRADINGCONTRCHANGEDONDATE,
    TRADINGCONTRCREATEDONDATE,
    TRDGCONTRAPPLSTSNAME,
    TRDGCONTRGOODSSUPPLIER,
    TRDGCONTRPURGINCOTERMSLOC1TEXT,
    TRDGCONTRSLSINCOTERMSLOC1TEXT,
    PRIMARY KEY (TRADINGCONTRACTNUMBER)
);