A_PRAMaintDOIHierNode

DDL: A_PRAMAINTDOIHIERNODE Type: view_entity CONSUMPTION
35 Fields 1 Data Sources 3 Associations

Division Of Interest

A_PRAMaintDOIHierNode is a Consumption CDS View that provides data about "Division Of Interest" in SAP S/4HANA. It reads from 1 data source (I_PRAMaintDOI) and exposes 35 fields with key fields CompanyCode, PRAJointVenture, DivisionOfInterest. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_PRAMaintDOI I_PRAMaintDOI from

Associations (3)

CardinalityTargetAliasCondition
[0..*] A_PRAMaintDOIOwnerHierNode _PRAMaintDOIOwnerHierNode
[0..*] A_PRAMaintBearerGroupHierNode _PRAMaintBearerGroupHierNode
[0..*] A_PRAMaintDOIHistoryHierNode _PRAMaintDOIHistoryHierNode

Annotations (10)

NameValueLevelField
EndUserText.label Division Of Interest view
AccessControl.authorizationCheck #CHECK view
Metadata.ignorePropagatedAnnotations true view
OData.entityType.name DOI_Type view
OData.entitySet.name DOI view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MIXED view

Fields (35)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode Receiver Company Code
KEY PRAJointVenture PRAJointVenture Ext vent name
KEY DivisionOfInterest DivisionOfInterest Venture/DOI
DivisionOfInterestName DivisionOfInterestName DOI Name
DivisionOfInterestDesc DivisionOfInterestDesc Unit
PRACombinedProductCode PRACombinedProductCode Comb. prd.cd
Country Country Venue: Ctry/Reg
PrimaryGeogrlLocation PrimaryGeogrlLocation Primary geo.loc
SecondaryGeogrlLocation SecondaryGeogrlLocation Secndry geo.loc
DivisionOfInterestHasLglDesc DivisionOfInterestHasLglDesc Legal Desc.
DivisionOfInterestStatus DivisionOfInterestStatus DOI Status
DivisionOfInterestStartDate DivisionOfInterestStartDate Valn start date
DivisionOfInterestEndDate DivisionOfInterestEndDate Valid To
DivisionOfInterestIsApproved DivisionOfInterestIsApproved Approval
DivisionOfInterestIsChkdOut DivisionOfInterestIsChkdOut Checked out
DOIPriorPeriodNotifProcDte
DOIPriorPeriodNotifIsProcd DOIPriorPeriodNotifIsProcd PPN Process Fl
DivisionOfInterestHasTransfer DivisionOfInterestHasTransfer Transfer Flag
DivisionOfInterestHasOwnrChgd DivisionOfInterestHasOwnrChgd Change Flag
DOICheckOutDteTme DOICheckOutDteTme Check Out Dt
DOICheckInDteTme DOICheckInDteTme Check In Date
CreatedByUser CreatedByUser User Name
CreationDateTime CreationDateTime Timestamp
DOIPrptnProdnIntrstIsIgnored DOIPrptnProdnIntrstIsIgnored Indicator
CompanyCodeName
CountryShortName
PrimaryGeogrlLocationName
SecondaryGeogrlLocationName
PRACombinedProductCodeName
DivisionOfInterestStatusText
DOIExchInfrstrucOilMktgChgDte
DOIExchInfrstrucGasMktgChgDte
_PRAMaintBearerGroupHierNode _PRAMaintBearerGroupHierNode
_PRAMaintDOIOwnerHierNode _PRAMaintDOIOwnerHierNode
_PRAMaintDOIHistoryHierNode _PRAMaintDOIHistoryHierNode

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 A_PRAMaintDOIHierNode.
-- 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 A_PRAMaintDOIHierNode AS
SELECT
  CompanyCode,
  PRAJointVenture,
  DivisionOfInterest,
  DivisionOfInterestName,
  DivisionOfInterestDesc,
  PRACombinedProductCode,
  Country,
  PrimaryGeogrlLocation,
  SecondaryGeogrlLocation,
  DivisionOfInterestHasLglDesc,
  DivisionOfInterestStatus,
  DivisionOfInterestStartDate,
  DivisionOfInterestEndDate,
  DivisionOfInterestIsApproved,
  DivisionOfInterestIsChkdOut,
  cast( '00000000' as abap.dats ) AS DOIPriorPeriodNotifProcDte,
  DOIPriorPeriodNotifIsProcd,
  DivisionOfInterestHasTransfer,
  DivisionOfInterestHasOwnrChgd,
  DOICheckOutDteTme,
  DOICheckInDteTme,
  CreatedByUser,
  CreationDateTime,
  DOIPrptnProdnIntrstIsIgnored,
  _CompanyCode[ 1: Language = $session.system_language ].CompanyCodeName AS CompanyCodeName,
  _GeoLoc._Country._Text[ 1: Language = $session.system_language ].CountryShortName AS CountryShortName,
  _GeoLoc._PrimaryGeogrlLocation._Text[ 1: Language = $session.system_language ].PrimaryGeogrlLocationName AS PrimaryGeogrlLocationName,
  _GeoLoc._Text[ 1: Language = $session.system_language ].SecondaryGeogrlLocationName AS SecondaryGeogrlLocationName,
  _PRAMaintCmbndProdCode._Text[ 1: Language = $session.system_language ].PRACombinedProductCodeName AS PRACombinedProductCodeName,
  _PRADivisionOfInterestSts._Text[ 1: Language = $session.system_language ].DivisionOfInterestStatusText AS DivisionOfInterestStatusText,
  cast( '00000000' as abap.dats ) AS DOIExchInfrstrucOilMktgChgDte,
  cast( '00000000' as abap.dats ) AS DOIExchInfrstrucGasMktgChgDte
FROM I_PRAMaintDOI
LEFT OUTER JOIN A_PRAMaintDOIOwnerHierNode AS _PRAMaintDOIOwnerHierNode ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN A_PRAMaintBearerGroupHierNode AS _PRAMaintBearerGroupHierNode ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN A_PRAMaintDOIHistoryHierNode AS _PRAMaintDOIHistoryHierNode ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More