I_TradingContractOverview

DDL: I_TRADINGCONTRACTOVERVIEW SQL: ITRDGCTROVW Type: view COMPOSITE
38 Fields 4 Data Sources 1 Associations

Interface Layer for Trading Ctr Overview

I_TradingContractOverview (Composite)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Sales

I_TradingContractOverview is a Composite CDS View that provides data about "Interface Layer for Trading Ctr Overview" in SAP S/4HANA. It reads from 4 data sources (P_GenericDomainVH, P_GenericDomainVH, P_TradingContractOverview, I_TrdgContractSnapshotData) and exposes 38 fields with key field TradingContractNumber. It has 1 association to related views.

SAP API Hub

StateC1
Line of BusinessSales
Application ComponentLO-AGR-CC
CapabilitiesData Source for Defining CDS Entities, Data Source in SQL Select
PackageSales for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (4)

SourceAliasJoin Type
P_GenericDomainVH P_GenericDomainVH left_outer
P_GenericDomainVH P_GenericDomainVH left_outer
P_TradingContractOverview TradgContrOvw from
I_TrdgContractSnapshotData TrdgContrSnapshot left_outer

Associations (1)

CardinalityTargetAliasCondition
[0..1] P_TradingContractCounterparty _Counterparty $projection.Counterparty = _Counterparty.Counterparty

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName ITRDGCTROVW 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 #COMPOSITE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Interface Layer for Trading Ctr Overview view

Fields (38)

KeyFieldSource TableSource FieldDescription
KEY TradingContractNumber TradingContractNumber Trading Contract
TradingContractType TradingContractType Trading Contract Type
TradingContractTypeName TradingContractTypeName Trading Contract Type Description
Side Side Side
DocumentSide DocumentSide Short Text for Fixed Values
ContractStatus P_TradingContractOverview ContractStatus Application Status of Trading Contract
TrdgContrApplStsName TrdgContrApplStsName Trading Contract: Name of Application Status
TradingContractCurrency TradingContractCurrency SD Document Currency
SalesOrganization SalesOrganization Sales Organization
SalesOrganizationText SalesOrgDescr Name
DistributionChannel DistributionChannel Distribution Channel
DistributionChannelText DistributionChannelDescr Distribution Channel Description
Division Division Internal Division ID
DivisionName SalesDivisionDescr Name
PurchasingOrganization PurchasingOrganization Purchasing Organization
PurchasingOrganizationName ekotx Description of purchasing organization
PurchasingGroup PurchasingGroup Purchasing Group
PurchasingGroupName eknam Purchasing Group Name
TradingContractExternalID TradingContractExternalID External Identifier in Trading Contract
TradingContrCreatedOnDate TradingContrCreatedOnDate Record Created On
DocumentDate DocumentDate Journal Entry Date
TrdgContrPersonResponsible PersonResponsible Trading Contract: Person Responsible
TrdgContrPersonResponsibleName PersonResponsibleName Full Name of Person
TradingContractCreatedBy TradingContractCreatedBy Name of Person Responsible for Creating the Object
TradingContractCreatedByName TradingContractCreatedByName Full Name of Person
TradingContractChangedBy TradingContractChangedBy Name of Person Who Changed Object
ACMTrdgContrIsStatusClosed ACMTrdgContrIsStatusClosed Contract Closure with CDOTE Indicator
Counterparty Counterparty Customer Number
CounterpartyFullName _Counterparty CounterpartyFullName
CustomerName _Counterparty CustomerName Name of Customer
Incoterms Incoterms Incoterms Part 1 Sales
IncotermsClassificationName IncotermsClassificationName Incoterms Classification Description
IncotermsLocation1 IncotermsLocation1 Incoterms Location 1
CompanyCode CompanyCode Receiver Company Code
ACMTrdgContractOutputProcess I_TrdgContractSnapshotData ACMTrdgContractOutputProcess Output Processing
ACMTrdgContrOutpProcText OutputProcess DomainText Short Text for Fixed Values
ACMTrdgContrSignatureStatus I_TrdgContractSnapshotData ACMTrdgContrSignatureStatus Signature Status
ACMTrdgContrSgntrStsText SignatureStatus DomainText Short Text for Fixed Values

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_TradingContractOverview.
-- 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: ITRDGCTROVW

CREATE VIEW I_TradingContractOverview AS
SELECT
  TradingContractNumber,
  TradingContractType,
  TradingContractTypeName,
  Side,
  DocumentSide,
  TradgContrOvw.ContractStatus AS ContractStatus,
  TrdgContrApplStsName,
  TradingContractCurrency,
  SalesOrganization,
  SalesOrgDescr AS SalesOrganizationText,
  DistributionChannel,
  DistributionChannelDescr AS DistributionChannelText,
  Division,
  SalesDivisionDescr AS DivisionName,
  PurchasingOrganization,
  ekotx AS PurchasingOrganizationName,
  PurchasingGroup,
  eknam AS PurchasingGroupName,
  TradingContractExternalID,
  TradingContrCreatedOnDate,
  DocumentDate,
  PersonResponsible AS TrdgContrPersonResponsible,
  PersonResponsibleName AS TrdgContrPersonResponsibleName,
  TradingContractCreatedBy,
  TradingContractCreatedByName,
  TradingContractChangedBy,
  ACMTrdgContrIsStatusClosed,
  Counterparty,
  _Counterparty.CounterpartyFullName AS CounterpartyFullName,
  _Counterparty.CustomerName AS CustomerName,
  Incoterms,
  IncotermsClassificationName,
  IncotermsLocation1,
  CompanyCode,
  TrdgContrSnapshot.ACMTrdgContractOutputProcess AS ACMTrdgContractOutputProcess,
  OutputProcess.DomainText AS ACMTrdgContrOutpProcText,
  TrdgContrSnapshot.ACMTrdgContrSignatureStatus AS ACMTrdgContrSignatureStatus,
  SignatureStatus.DomainText AS ACMTrdgContrSgntrStsText
FROM P_TradingContractOverview AS TradgContrOvw
LEFT OUTER JOIN I_TrdgContractSnapshotData AS TrdgContrSnapshot ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_GenericDomainVH ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_TradingContractCounterparty AS _Counterparty ON Counterparty = _Counterparty.Counterparty  -- association [0..1]
;

Learn More