A_PRAMaintDOI

DDL: A_PRAMAINTDOI Type: view_entity CONSUMPTION
30 Fields 1 Data Sources

Division Of Interest

A_PRAMaintDOI is a Consumption CDS View that provides data about "Division Of Interest" in SAP S/4HANA. It reads from 1 data source (A_PRAMaintDOIHierNode) and exposes 30 fields with key fields CompanyCode, PRAJointVenture, DivisionOfInterest.

Data Sources (1)

SourceAliasJoin Type
A_PRAMaintDOIHierNode A_PRAMaintDOIHierNode projection

Annotations (10)

NameValueLevelField
EndUserText.label Division Of Interest view
AccessControl.authorizationCheck #CHECK view
OData.entityType.name DOI_Type view
OData.entitySet.name DOI view
Metadata.ignorePropagatedAnnotations true 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 (30)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode Receiver Company Code
KEY PRAJointVenture PRAJointVenture Ext vent name
KEY DivisionOfInterest DivisionOfInterest Venture/DOI
DivisionOfInterestName DivisionOfInterestName
DivisionOfInterestDesc DivisionOfInterestDesc
PRACombinedProductCode PRACombinedProductCode
Country Country Venue: Ctry/Reg
PrimaryGeogrlLocation PrimaryGeogrlLocation
SecondaryGeogrlLocation SecondaryGeogrlLocation
DivisionOfInterestHasLglDesc DivisionOfInterestHasLglDesc
DivisionOfInterestStatus DivisionOfInterestStatus
DivisionOfInterestStartDate DivisionOfInterestStartDate
DivisionOfInterestEndDate DivisionOfInterestEndDate
DivisionOfInterestIsApproved DivisionOfInterestIsApproved
DivisionOfInterestIsChkdOut DivisionOfInterestIsChkdOut
DOIPriorPeriodNotifProcDte DOIPriorPeriodNotifProcDte
DOIPriorPeriodNotifIsProcd DOIPriorPeriodNotifIsProcd
DivisionOfInterestHasTransfer DivisionOfInterestHasTransfer
DivisionOfInterestHasOwnrChgd DivisionOfInterestHasOwnrChgd
DOICheckOutDteTme DOICheckOutDteTme
DOICheckInDteTme DOICheckInDteTme
DOIPrptnProdnIntrstIsIgnored DOIPrptnProdnIntrstIsIgnored
CompanyCodeName CompanyCodeName Company Name
CountryShortName CountryShortName
PrimaryGeogrlLocationName PrimaryGeogrlLocationName
SecondaryGeogrlLocationName SecondaryGeogrlLocationName
PRACombinedProductCodeName PRACombinedProductCodeName
DivisionOfInterestStatusText DivisionOfInterestStatusText
DOIExchInfrstrucOilMktgChgDte DOIExchInfrstrucOilMktgChgDte
DOIExchInfrstrucGasMktgChgDte DOIExchInfrstrucGasMktgChgDte

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_PRAMaintDOI.
-- 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_PRAMaintDOI AS
SELECT
  CompanyCode,
  PRAJointVenture,
  DivisionOfInterest,
  DivisionOfInterestName,
  DivisionOfInterestDesc,
  PRACombinedProductCode,
  Country,
  PrimaryGeogrlLocation,
  SecondaryGeogrlLocation,
  DivisionOfInterestHasLglDesc,
  DivisionOfInterestStatus,
  DivisionOfInterestStartDate,
  DivisionOfInterestEndDate,
  DivisionOfInterestIsApproved,
  DivisionOfInterestIsChkdOut,
  DOIPriorPeriodNotifProcDte,
  DOIPriorPeriodNotifIsProcd,
  DivisionOfInterestHasTransfer,
  DivisionOfInterestHasOwnrChgd,
  DOICheckOutDteTme,
  DOICheckInDteTme,
  DOIPrptnProdnIntrstIsIgnored,
  CompanyCodeName,
  CountryShortName,
  PrimaryGeogrlLocationName,
  SecondaryGeogrlLocationName,
  PRACombinedProductCodeName,
  DivisionOfInterestStatusText,
  DOIExchInfrstrucOilMktgChgDte,
  DOIExchInfrstrucGasMktgChgDte
FROM A_PRAMaintDOIHierNode
;

Learn More