I_ACMTrdgContractPartnerDets

DDL: I_ACMTRDGCONTRACTPARTNERDETS SQL: ITRDGCONTRPART Type: view COMPOSITE
15 Fields 1 Data Sources 3 Associations

Interface view for Trading Contract Partner details

I_ACMTrdgContractPartnerDets is a Composite CDS View that provides data about "Interface view for Trading Contract Partner details" in SAP S/4HANA. It reads from 1 data source (I_TradingContractPartnerDets) and exposes 15 fields with key fields TradingContractNumber, TradingContractItem, PartnerFunction. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_TradingContractPartnerDets PartnerDets from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_TrdgContrPartAddressDets _Address $projection.ActiveAddressID = _Address.ActiveAddressID
[1..1] I_PartnerFunctionText _PartnerFunctions $projection.PartnerFunction = _PartnerFunctions.PartnerFunction and _PartnerFunctions.Language = $session.system_language
[1..1] I_ACMTransCtptyPrFixations _CounterParty $projection.PartnerFunction = _CounterParty.ACMTransCtpty

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName ITRDGCONTRPART view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
EndUserText.label Interface view for Trading Contract Partner details view
AccessControl.personalData.blocking #REQUIRED view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY TradingContractNumber I_TradingContractPartnerDets TradingContractNumber Trading Contract
KEY TradingContractItem I_TradingContractPartnerDets TradingContractItem Item Number
KEY PartnerFunction I_TradingContractPartnerDets PartnerFunction Partner Functn
NumberOfContactPersons I_TradingContractPartnerDets NumberOfContactPersons Responsible
PersonnelNumber I_TradingContractPartnerDets PersonnelNumber Personnel No.
ActiveAddressID I_TradingContractPartnerDets ActiveAddressID Sold-To Address
PartnerFunctionName _PartnerFunctions PartnerFunctionName Name
Partner I_TradingContractPartnerDets Partner With Partner
BusinessPartnerName1 _Address BusinessPartnerName1 Name
CustomerSupplierCityName _Address CustomerSupplierCityName
CustomerSupplierPostalCode _Address CustomerSupplierPostalCode
CustomerSupplierStreetName _Address CustomerSupplierStreetName
AuthorizationGroup CountPart AuthorizationGroup AuthorizGroup
IsBusinessPurposeCompleted CountPart IsBusinessPurposeCompleted Purpose Completed
PartnerelseendasTransactingCtpty

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_ACMTrdgContractPartnerDets.
-- 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: ITRDGCONTRPART

CREATE VIEW I_ACMTrdgContractPartnerDets AS
SELECT
  PartnerDets.TradingContractNumber AS TradingContractNumber,
  PartnerDets.TradingContractItem AS TradingContractItem,
  PartnerDets.PartnerFunction AS PartnerFunction,
  PartnerDets.NumberOfContactPersons AS NumberOfContactPersons,
  PartnerDets.PersonnelNumber AS PersonnelNumber,
  PartnerDets.ActiveAddressID AS ActiveAddressID,
  _PartnerFunctions.PartnerFunctionName AS PartnerFunctionName,
  PartnerDets.Partner AS Partner,
  _Address.BusinessPartnerName1 AS BusinessPartnerName1,
  _Address.CustomerSupplierCityName AS CustomerSupplierCityName,
  _Address.CustomerSupplierPostalCode AS CustomerSupplierPostalCode,
  _Address.CustomerSupplierStreetName AS CustomerSupplierStreetName,
  CountPart.AuthorizationGroup AS AuthorizationGroup,
  CountPart.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  case when PartnerDets.PartnerFunction = _CounterParty.ACMTransCtpty then PartnerDets.Partner else '' end as TransactingCtpty AS PartnerelseendasTransactingCtpty
FROM I_TradingContractPartnerDets AS PartnerDets
LEFT OUTER JOIN I_TrdgContrPartAddressDets AS _Address ON ActiveAddressID = _Address.ActiveAddressID  -- association [0..1]
LEFT OUTER JOIN I_PartnerFunctionText AS _PartnerFunctions ON PartnerFunction = _PartnerFunctions.PartnerFunction AND _PartnerFunctions.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_ACMTransCtptyPrFixations AS _CounterParty ON PartnerFunction = _CounterParty.ACMTransCtpty  -- association [1..1]
;

Learn More