I_TrdgContrDocumentFlow

DDL: I_TRDGCONTRDOCUMENTFLOW Type: view_entity COMPOSITE
19 Fields 1 Data Sources

Document Flow for a Trading Contract

I_TrdgContrDocumentFlow is a Composite CDS View that provides data about "Document Flow for a Trading Contract" in SAP S/4HANA. It reads from 1 data source (R_TrdgContrDocumentFlow) and exposes 19 fields with key field TrdgReltdDocumentUUID.

Data Sources (1)

SourceAliasJoin Type
R_TrdgContrDocumentFlow R_TrdgContrDocumentFlow from

Annotations (12)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Document Flow for a Trading Contract view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.compositionRoot false view
ObjectModel.modelingPattern #NONE view
ObjectModel.representativeKey TrdgReltdDocumentUUID view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.viewType #COMPOSITE view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY TrdgReltdDocumentUUID TrdgReltdDocumentUUID
TradingContract TradingContract
TradingContractItem TradingContractItem Item Number
TrdgContrSubsqntDocument TrdgContrSubsqntDocument
TrdgContrSubsqntDocItem TrdgContrSubsqntDocItem
TrdgContrSubsqntDocCategory TrdgContrSubsqntDocCategory
CreatedByUser CreatedByUser User Name
CreationDate CreationDate Time Stamp
CreationTime CreationTime Time of Change
TrdgContrSalesQuantity TrdgContrSalesQuantity
TrdgContrPurgQuantity TrdgContrPurgQuantity
BaseUnit BaseUnit Unit of Measure
TrdgContrFlfmtCalculationRule TrdgContrFlfmtCalculationRule
FinancialYear FinancialYear Fiscal Year
TrdgContrDocFlowOrigin TrdgContrDocFlowOrigin
TrdgContrBusProcessCategory TrdgContrBusProcessCategory
TrdgContrSlsQtyInBaseUnit TrdgContrSlsQtyInBaseUnit
TrdgContrPurgQtyInBaseUnit TrdgContrPurgQtyInBaseUnit
_TrdgContr _TrdgContr

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_TrdgContrDocumentFlow.
-- 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 I_TrdgContrDocumentFlow AS
SELECT
  TrdgReltdDocumentUUID,
  TradingContract,
  TradingContractItem,
  TrdgContrSubsqntDocument,
  TrdgContrSubsqntDocItem,
  TrdgContrSubsqntDocCategory,
  CreatedByUser,
  CreationDate,
  CreationTime,
  TrdgContrSalesQuantity,
  TrdgContrPurgQuantity,
  BaseUnit,
  TrdgContrFlfmtCalculationRule,
  FinancialYear,
  TrdgContrDocFlowOrigin,
  TrdgContrBusProcessCategory,
  TrdgContrSlsQtyInBaseUnit,
  TrdgContrPurgQtyInBaseUnit
FROM R_TrdgContrDocumentFlow
;

Learn More