I_OIL_LocationTypeVH

DDL: I_OIL_LOCATIONTYPEVH Type: view_entity BASIC
19 Fields 1 Data Sources 1 Associations

Physical Business Location Type

I_OIL_LocationTypeVH is a Basic CDS View that provides data about "Physical Business Location Type" in SAP S/4HANA. It reads from 1 data source (oifspblt) and exposes 19 fields with key field BusinessLocationType. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
oifspblt oifspblt from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_OIL_LocationTypeText _Text _Text.BusinessLocationType = $projection.BusinessLocationType

Annotations (12)

NameValueLevelField
AbapCatalog.entityBuffer.definitionAllowed true view
AccessControl.authorizationCheck #NOT_REQUIRED view
Analytics.internalName #LOCAL view
EndUserText.label Physical Business Location Type view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey BusinessLocationType view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
Search.searchable true view
VDM.viewType #BASIC view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY BusinessLocationType pbltyp Location type
BusinessLocInternalNumberRange numri Int.no.rangeID
BusinessLocExternalNumberRange numre Ext.No.Range ID
BusinessLocationHasIndicator1 flag1 Text field length 1
BusinessLocationHasIndicator2 flag2 Tr. Evaluation
BusinessLocationHasIndicator3 flag3 Text field length 1
BusinessLocationHasIndicator4 flag4 Usage in the OWN Authorization Context
TSWCreationDate erdat Entered On
TSWCreationTime erzeit Time created
TSWCreatedByUser ernam User Name
TSWLastChangeDate aedat Obsolete
TSWLastChangeTime aezeit Time changed
TSWLastChangedByUser aenam User Name
BusinessLocationIsCompetitor flag_comp Competitor
BusinessLocIsPlanningRelevant planind Planning loc.
BusinessLocationIsRefinery refind Refinery ind.
BusinessLocationIsOrigin odindo Origin
BusinessLocationIsDestination odindd Destination
_Text _Text

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_OIL_LocationTypeVH.
-- 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_OIL_LocationTypeVH AS
SELECT
  pbltyp AS BusinessLocationType,
  numri AS BusinessLocInternalNumberRange,
  numre AS BusinessLocExternalNumberRange,
  flag1 AS BusinessLocationHasIndicator1,
  flag2 AS BusinessLocationHasIndicator2,
  flag3 AS BusinessLocationHasIndicator3,
  flag4 AS BusinessLocationHasIndicator4,
  erdat AS TSWCreationDate,
  erzeit AS TSWCreationTime,
  ernam AS TSWCreatedByUser,
  aedat AS TSWLastChangeDate,
  aezeit AS TSWLastChangeTime,
  aenam AS TSWLastChangedByUser,
  flag_comp AS BusinessLocationIsCompetitor,
  planind AS BusinessLocIsPlanningRelevant,
  refind AS BusinessLocationIsRefinery,
  odindo AS BusinessLocationIsOrigin,
  odindd AS BusinessLocationIsDestination
FROM oifspblt
LEFT OUTER JOIN I_OIL_LocationTypeText AS _Text ON _Text.BusinessLocationType = BusinessLocationType  -- association [0..*]
;

Learn More