I_ElectronicDocInterfaceTP

DDL: I_ELECTRONICDOCINTERFACETP Type: view_entity TRANSACTIONAL
8 Fields 1 Data Sources 5 Associations

eDocument Interface - TP

I_ElectronicDocInterfaceTP is a Transactional CDS View that provides data about "eDocument Interface - TP" in SAP S/4HANA. It reads from 1 data source (I_ElectronicDocInterface) and exposes 8 fields with key field ElectronicDocInterfaceID. It has 5 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_ElectronicDocInterface ElectronicDocInterface from

Associations (5)

CardinalityTargetAliasCondition
[1..*] I_EDocInterfaceVersionTextTP _ElectronicDocIntVersionText $projection.ElectronicDocInterfaceID = _ElectronicDocIntVersionText.ElectronicDocInterfaceID
[0..1] I_EDocInterfaceDrctnVH _EDocInterfaceDrctn $projection.ElectronicDocInterfaceDir = _EDocInterfaceDrctn.DomainValue
[1..*] I_ElectronicDocInterfaceTextTP _ElectronicDocInterfaceText
[1..*] I_EDocInterfaceVersionDefTP _ElectronicDocIntVersionDef
[1..1] I_EDocInterfaceCommScenarioTP _EDocInterfaceCommScenario

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label eDocument Interface - TP view
Metadata.ignorePropagatedAnnotations true view
VDM.lifecycle.contract.type #NONE view
VDM.viewType #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY ElectronicDocInterfaceID ElectronicDocInterfaceID Interface ID
ElectronicDocInterfaceDir ElectronicDocInterfaceDir Direction
ElectronicDocInterfaceDrctnTxt _EDocInterfaceDrctn ElectronicDocInterfaceDrctnTxt
_ElectronicDocInterfaceText _ElectronicDocInterfaceText
_ElectronicDocIntVersionDef _ElectronicDocIntVersionDef
_EDocInterfaceCommScenario _EDocInterfaceCommScenario
_ElectronicDocIntVersionText _ElectronicDocIntVersionText
_EDocInterfaceDrctn _EDocInterfaceDrctn

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_ElectronicDocInterfaceTP.
-- 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_ElectronicDocInterfaceTP AS
SELECT
  ElectronicDocInterfaceID,
  ElectronicDocInterfaceDir,
  _EDocInterfaceDrctn.ElectronicDocInterfaceDrctnTxt AS ElectronicDocInterfaceDrctnTxt
FROM I_ElectronicDocInterface AS ElectronicDocInterface
LEFT OUTER JOIN I_EDocInterfaceVersionTextTP AS _ElectronicDocIntVersionText ON ElectronicDocInterfaceID = _ElectronicDocIntVersionText.ElectronicDocInterfaceID  -- association [1..*]
LEFT OUTER JOIN I_EDocInterfaceDrctnVH AS _EDocInterfaceDrctn ON ElectronicDocInterfaceDir = _EDocInterfaceDrctn.DomainValue  -- association [0..1]
LEFT OUTER JOIN I_ElectronicDocInterfaceTextTP AS _ElectronicDocInterfaceText ON /* condition not available in parsed metadata */  -- association [1..*]
LEFT OUTER JOIN I_EDocInterfaceVersionDefTP AS _ElectronicDocIntVersionDef ON /* condition not available in parsed metadata */  -- association [1..*]
LEFT OUTER JOIN I_EDocInterfaceCommScenarioTP AS _EDocInterfaceCommScenario ON /* condition not available in parsed metadata */  -- association [1..1]
;

Learn More