I_ACMContractHeader

DDL: I_ACMCONTRACTHEADER SQL: ITRDGCTRHEAD Type: view BASIC
17 Fields 1 Data Sources

Contract Header

I_ACMContractHeader is a Basic CDS View that provides data about "Contract Header" in SAP S/4HANA. It reads from 1 data source (P_ACMContractHeader) and exposes 17 fields.

Data Sources (1)

SourceAliasJoin Type
P_ACMContractHeader wbhk from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName ITRDGCTRHEAD view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
EndUserText.label Contract Header view

Fields (17)

KeyFieldSource TableSource FieldDescription
TradingContractNumber P_ACMContractHeader tkonn Trading Contract
TradingContractType P_ACMContractHeader tctyp Contract Type
ContractStatus P_ACMContractHeader btbsta Only Copy Appr.TC
SalesOrganization P_ACMContractHeader vkorg SD Sales Org.
DistributionChannel P_ACMContractHeader vtweg RefDistCh-Cust/Mat.
TradingContractExternalID P_ACMContractHeader tkonn_ex Ext. Identifier
TradingContrCreatedOnDate P_ACMContractHeader erdat Entered On
DocumentDate P_ACMContractHeader budat Posting Date
PersonResponsible P_ACMContractHeader tksachb Pers. Respons.
TradingContractCreatedBy P_ACMContractHeader ernam User Name
TradingContractChangedBy P_ACMContractHeader aenam User Name
TradingContractChangedOnDate P_ACMContractHeader aedat Obsolete
TrdgContrGoodsSupplier P_ACMContractHeader kunnr Stock customer
Division P_ACMContractHeader spart Source supplier
TradingContractSalesCurrency P_ACMContractHeader sdwrs Doc. Currency
CompanyCode P_ACMContractHeader company_code Company Code
PricingDocument P_ACMContractHeader knumv_sd Doc. Condition

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_ACMContractHeader.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: ITRDGCTRHEAD

CREATE VIEW I_ACMContractHeader AS
SELECT
  wbhk.tkonn AS TradingContractNumber,
  wbhk.tctyp AS TradingContractType,
  wbhk.btbsta AS ContractStatus,
  wbhk.vkorg AS SalesOrganization,
  wbhk.vtweg AS DistributionChannel,
  wbhk.tkonn_ex AS TradingContractExternalID,
  wbhk.erdat AS TradingContrCreatedOnDate,
  wbhk.budat AS DocumentDate,
  wbhk.tksachb AS PersonResponsible,
  wbhk.ernam AS TradingContractCreatedBy,
  wbhk.aenam AS TradingContractChangedBy,
  wbhk.aedat AS TradingContractChangedOnDate,
  wbhk.kunnr AS TrdgContrGoodsSupplier,
  wbhk.spart AS Division,
  wbhk.sdwrs AS TradingContractSalesCurrency,
  wbhk.company_code AS CompanyCode,
  wbhk.knumv_sd AS PricingDocument
FROM P_ACMContractHeader AS wbhk
;

Learn More