I_ACMCONTRACTHEADER

CDS View

Contract Header

I_ACMCONTRACTHEADER is a CDS View in S/4HANA. Contract Header. It contains 17 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_ACMContrValueHelp view from BASIC
I_ACMTrdgContrItmInfo view from COMPOSITE Interface view for Tradg Cont Item Info
I_ACMTrdgContrStatusOvw view from COMPOSITE ACM Trading Contract Status Overview
P_ACMTradingContractHeader view from COMPOSITE

Fields (17)

KeyField CDS FieldsUsed in Views
KEY TradingContractNumber TradingContractNumber 2
CompanyCode CompanyCode 1
ContractStatus ContractStatus 2
DistributionChannel DistributionChannel 1
Division Division 1
DocumentDate DocumentDate 1
PersonResponsible PersonResponsible 1
PricingDocument PricingDocument,SalesDocumentCondition 2
SalesOrganization SalesOrganization 1
TradingContractChangedBy TradingContractChangedBy 1
TradingContractChangedOnDate TradingContractChangedOnDate 1
TradingContractCreatedBy TradingContractCreatedBy 1
TradingContractExternalID TradingContractExternalID 1
TradingContractSalesCurrency TradingContractSalesCurrency 1
TradingContractType TradingContractType 2
TradingContrCreatedOnDate TradingContrCreatedOnDate 1
TrdgContrGoodsSupplier kunnr 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 Header
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_ACMCONTRACTHEADER (
    TRADINGCONTRACTNUMBER,
    COMPANYCODE,
    CONTRACTSTATUS,
    DISTRIBUTIONCHANNEL,
    DIVISION,
    DOCUMENTDATE,
    PERSONRESPONSIBLE,
    PRICINGDOCUMENT,
    SALESORGANIZATION,
    TRADINGCONTRACTCHANGEDBY,
    TRADINGCONTRACTCHANGEDONDATE,
    TRADINGCONTRACTCREATEDBY,
    TRADINGCONTRACTEXTERNALID,
    TRADINGCONTRACTSALESCURRENCY,
    TRADINGCONTRACTTYPE,
    TRADINGCONTRCREATEDONDATE,
    TRDGCONTRGOODSSUPPLIER,
    PRIMARY KEY (TRADINGCONTRACTNUMBER)
);