A_PRAMaintBearerHierNode

DDL: A_PRAMAINTBEARERHIERNODE Type: view_entity CONSUMPTION
15 Fields 1 Data Sources

Bearer Maintain

A_PRAMaintBearerHierNode is a Consumption CDS View that provides data about "Bearer Maintain" in SAP S/4HANA. It reads from 1 data source (I_PRAMaintBearer) and exposes 15 fields with key fields CompanyCode, PRAJointVenture, DivisionOfInterest, PRABearerGroup, PRABearerGroupEffctvFrmDte.

Data Sources (1)

SourceAliasJoin Type
I_PRAMaintBearer I_PRAMaintBearer from

Annotations (10)

NameValueLevelField
EndUserText.label Bearer Maintain view
AccessControl.authorizationCheck #CHECK view
OData.entityType.name Bearer_Type view
OData.entitySet.name Bearer view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MIXED view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode Receiver Company Code
KEY PRAJointVenture PRAJointVenture Ext vent name
KEY DivisionOfInterest DivisionOfInterest Venture/DOI
KEY PRABearerGroup PRABearerGroup Bearer Group
KEY PRABearerGroupEffctvFrmDte PRABearerGroupEffctvFrmDte Effective From Date
KEY PRABearerGroupUseControlNmbr PRABearerGroupUseControlNmbr BGUC No
KEY PRAOwner PRAOwner Owner Number
KEY OwnerInterestType OwnerInterestType Opart int type
KEY OwnerInterestSequence OwnerInterestSequence Own. ISQ
OwnerBearerPercent OwnerBearerPercent Bearer Percent
CreatedByUser CreatedByUser User Name
CreationDateTime CreationDateTime Timestamp
OwnerName _PRAOwner PRAOwnerName
_PRAMaintBearerGroupHierNode _PRAMaintBearerGroupHierNode
_PRAMaintDOIHierNode _PRAMaintDOIHierNode

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_PRAMaintBearerHierNode.
-- 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_PRAMaintBearerHierNode AS
SELECT
  CompanyCode,
  PRAJointVenture,
  DivisionOfInterest,
  PRABearerGroup,
  PRABearerGroupEffctvFrmDte,
  PRABearerGroupUseControlNmbr,
  PRAOwner,
  OwnerInterestType,
  OwnerInterestSequence,
  OwnerBearerPercent,
  CreatedByUser,
  CreationDateTime,
  _PRAOwner.PRAOwnerName AS OwnerName
FROM I_PRAMaintBearer
;

Learn More