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. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_ACMTradingContractPricingOvw view inner COMPOSITE Intrface View for Trdg Cont Prcg Details
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 3
ACMContractStatusIsPosRelevant ACMContractStatusIsPosRelevant 3
ACMCustomerReference ACMCustomerReference 3
ACMPurgIncotermsPart1 ACMPurgIncotermsPart1 3
ACMSlsIncotermsPart1 ACMSlsIncotermsPart1 3
ACMTrdgContrStatusCategory ACMTrdgContrStatusCategory 3
ACMYourReference ACMYourReference 3
AlternatePaymentTerm AlternatePaymentTerm 3
CompanyCode CompanyCode 3
ContractStatus ContractStatus 3
DistributionChannel DistributionChannel 3
Division Division 3
DocumentDate DocumentDate 3
PersonResponsible PersonResponsible 3
PricingDocument PricingDocument 3
PurchaseOrderSupplier PurchaseOrderSupplier 3
PurchasingGroup PurchasingGroup 3
PurchasingOrganization PurchasingOrganization 3
SalesOrganization SalesOrganization 3
TradingContractChangedBy TradingContractChangedBy 3
TradingContractCreatedBy TradingContractCreatedBy 3
TradingContractExternalID TradingContractExternalID 3
TradingContractType TradingContractType 3
TradingContractTypeName TradingContractTypeName 3
TradingContrChangedOnDate TradingContrChangedOnDate 1
TradingContrCreatedOnDate TradingContrCreatedOnDate 3
TrdgContrApplStsName TrdgContrApplStsName 3
TrdgContrGoodsSupplier TrdgContrGoodsSupplier 3
TrdgContrPurgIncotermsLoc1Text TrdgContrPurgIncotermsLoc1Text 3
TrdgContrSlsIncotermsLoc1Text TrdgContrSlsIncotermsLoc1Text 3

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)
);