R_TrdgDocReltdDocInfo

DDL: R_TRDGDOCRELTDDOCINFO Type: view_entity COMPOSITE Package: VDM_LO_GT
23 Fields 1 Data Sources 1 Associations

Information of a Trading Document

R_TrdgDocReltdDocInfo is a Composite CDS View that provides data about "Information of a Trading Document" in SAP S/4HANA. It reads from 1 data source (R_TrdgDocReltdDocInfoBasic) and exposes 23 fields with key field TrdgReltdDocumentUUID. It has 1 association to related views. Part of development package VDM_LO_GT.

Data Sources (1)

SourceAliasJoin Type
R_TrdgDocReltdDocInfoBasic TrdgDocReltdDocInfoBasic from

Associations (1)

CardinalityTargetAliasCondition
[1..1] R_TrdgDoc _TrdgDoc $projection.TradingDocument = _TrdgDoc.TradingDocument

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Information of a Trading Document view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.compositionRoot false view
ObjectModel.representativeKey TrdgReltdDocumentUUID view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
Analytics.dataExtraction.enabled false view
Analytics.internalName #LOCAL view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY TrdgReltdDocumentUUID R_TrdgDocReltdDocInfoBasic TrdgReltdDocumentUUID SM Doc Rel UUID
TrdgReltdDocCategory R_TrdgDocReltdDocInfoBasic TrdgReltdDocCategory
TrdgDocRelatedDocument R_TrdgDocReltdDocInfoBasic TrdgDocRelatedDocument SD Sched. Agmt
TrdgDocReltdDocumentYear R_TrdgDocReltdDocInfoBasic TrdgDocReltdDocumentYear Settlement Year
TrdgDocReltdSideCat R_TrdgDocReltdDocInfoBasic TrdgDocReltdSideCat
TradingDocument R_TrdgDocReltdDocInfoBasic TradingDocument Trading Contract
TrdgDocBusinessScenario R_TrdgDocReltdDocInfoBasic TrdgDocBusinessScenario VAT Scenario
TradingProcessVariantType R_TrdgDocReltdDocInfoBasic TradingProcessVariantType TEW Type
TradingProcessMasterStep R_TrdgDocReltdDocInfoBasic TradingProcessMasterStep
TradingProcessBusinessStep R_TrdgDocReltdDocInfoBasic TradingProcessBusinessStep Step
TradingProcessPreviousStep R_TrdgDocReltdDocInfoBasic TradingProcessPreviousStep
TradingProcessSourceStep R_TrdgDocReltdDocInfoBasic TradingProcessSourceStep
TrdgDocExternalIdentifier R_TrdgDocReltdDocInfoBasic TrdgDocExternalIdentifier Ext. Identifier
TrdgDocReltdDocDeltnCat R_TrdgDocReltdDocInfoBasic TrdgDocReltdDocDeltnCat Deletion Ind.
TrdgDocDeltnIsRlvt R_TrdgDocReltdDocInfoBasic TrdgDocDeltnIsRlvt Deletion
TrdgDocPrcgPaytEvtGrpValue R_TrdgDocReltdDocInfoBasic TrdgDocPrcgPaytEvtGrpValue PPE Group
TrdgDocHasShdwContr R_TrdgDocReltdDocInfoBasic TrdgDocHasShdwContr has shadow TC
TrdgDocReltdDocumentDate R_TrdgDocReltdDocInfoBasic TrdgDocReltdDocumentDate Date
_TrdgDoc _TrdgDoc
_TrdgDocDeltnIsRlvt R_TrdgDocReltdDocInfoBasic _TrdgDocDeltnIsRlvt
_TrdgDocReltdDocDeltnCat R_TrdgDocReltdDocInfoBasic _TrdgDocReltdDocDeltnCat
_TrdgDocReltdSideCat R_TrdgDocReltdDocInfoBasic _TrdgDocReltdSideCat
_TrdgReltdDocCategory R_TrdgDocReltdDocInfoBasic _TrdgReltdDocCategory

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 R_TrdgDocReltdDocInfo.
-- 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.

CREATE VIEW R_TrdgDocReltdDocInfo AS
SELECT
  TrdgDocReltdDocInfoBasic.TrdgReltdDocumentUUID AS TrdgReltdDocumentUUID,
  TrdgDocReltdDocInfoBasic.TrdgReltdDocCategory AS TrdgReltdDocCategory,
  TrdgDocReltdDocInfoBasic.TrdgDocRelatedDocument AS TrdgDocRelatedDocument,
  TrdgDocReltdDocInfoBasic.TrdgDocReltdDocumentYear AS TrdgDocReltdDocumentYear,
  TrdgDocReltdDocInfoBasic.TrdgDocReltdSideCat AS TrdgDocReltdSideCat,
  TrdgDocReltdDocInfoBasic.TradingDocument AS TradingDocument,
  TrdgDocReltdDocInfoBasic.TrdgDocBusinessScenario AS TrdgDocBusinessScenario,
  TrdgDocReltdDocInfoBasic.TradingProcessVariantType AS TradingProcessVariantType,
  TrdgDocReltdDocInfoBasic.TradingProcessMasterStep AS TradingProcessMasterStep,
  TrdgDocReltdDocInfoBasic.TradingProcessBusinessStep AS TradingProcessBusinessStep,
  TrdgDocReltdDocInfoBasic.TradingProcessPreviousStep AS TradingProcessPreviousStep,
  TrdgDocReltdDocInfoBasic.TradingProcessSourceStep AS TradingProcessSourceStep,
  TrdgDocReltdDocInfoBasic.TrdgDocExternalIdentifier AS TrdgDocExternalIdentifier,
  TrdgDocReltdDocInfoBasic.TrdgDocReltdDocDeltnCat AS TrdgDocReltdDocDeltnCat,
  TrdgDocReltdDocInfoBasic.TrdgDocDeltnIsRlvt AS TrdgDocDeltnIsRlvt,
  TrdgDocReltdDocInfoBasic.TrdgDocPrcgPaytEvtGrpValue AS TrdgDocPrcgPaytEvtGrpValue,
  TrdgDocReltdDocInfoBasic.TrdgDocHasShdwContr AS TrdgDocHasShdwContr,
  TrdgDocReltdDocInfoBasic.TrdgDocReltdDocumentDate AS TrdgDocReltdDocumentDate,
  TrdgDocReltdDocInfoBasic._TrdgDocDeltnIsRlvt AS _TrdgDocDeltnIsRlvt,
  TrdgDocReltdDocInfoBasic._TrdgDocReltdDocDeltnCat AS _TrdgDocReltdDocDeltnCat,
  TrdgDocReltdDocInfoBasic._TrdgDocReltdSideCat AS _TrdgDocReltdSideCat,
  TrdgDocReltdDocInfoBasic._TrdgReltdDocCategory AS _TrdgReltdDocCategory
FROM R_TrdgDocReltdDocInfoBasic AS TrdgDocReltdDocInfoBasic
LEFT OUTER JOIN R_TrdgDoc AS _TrdgDoc ON TradingDocument = _TrdgDoc.TradingDocument  -- association [1..1]
;

Learn More