I_ACMTrdgContrHdrAddlDets

DDL: I_ACMTRDGCONTRHDRADDLDETS SQL: IACMCNTRHDRADDDT Type: view BASIC
12 Fields 1 Data Sources

Interface view for Trading Contract Header Addition Details

I_ACMTrdgContrHdrAddlDets is a Basic CDS View that provides data about "Interface view for Trading Contract Header Addition Details" in SAP S/4HANA. It reads from 1 data source (/accgo/t_cakhdr) and exposes 12 fields with key field TradingContractNumber.

Data Sources (1)

SourceAliasJoin Type
/accgo/t_cakhdr /accgo/t_cakhdr from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IACMCNTRHDRADDDT 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
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
EndUserText.label Interface view for Trading Contract Header Addition Details view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY TradingContractNumber tkonn Trading Contract
ACMOriginalTraderID orig_resp_trader_id Orig Trader
ACMOriginalTraderIDText _Text trader_id_text Trader ID Text
ACMAmendingTraderID resp_trader_id Resp Trader
ACMAmendingTraderIDText _AmedingText trader_id_text Trader ID Text
TradingContractTradeOffice trad_offc Trade Office
TradingContractCreditSales crdtsl Credit Sale
ACMSignedStatus sign_status Signed Status
ACMTargetTrdgContrType target_contract_type Contract Type
ACMTargetTrdgContrTypeName ContractTypeText TradingContractTypeName
ACMTrdgContrQuotesValidDate valid_till_date Valid Till
ACMTrdgContrIsStatusClosed closed_with_cdote CDOTE Closure

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_ACMTrdgContrHdrAddlDets.
-- 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: IACMCNTRHDRADDDT

CREATE VIEW I_ACMTrdgContrHdrAddlDets AS
SELECT
  tkonn AS TradingContractNumber,
  orig_resp_trader_id AS ACMOriginalTraderID,
  _Text.trader_id_text AS ACMOriginalTraderIDText,
  resp_trader_id AS ACMAmendingTraderID,
  _AmedingText.trader_id_text AS ACMAmendingTraderIDText,
  trad_offc AS TradingContractTradeOffice,
  crdtsl AS TradingContractCreditSales,
  sign_status AS ACMSignedStatus,
  target_contract_type AS ACMTargetTrdgContrType,
  ContractTypeText.TradingContractTypeName AS ACMTargetTrdgContrTypeName,
  valid_till_date AS ACMTrdgContrQuotesValidDate,
  closed_with_cdote AS ACMTrdgContrIsStatusClosed
FROM /accgo/t_cakhdr
;

Learn More