P_OIL_BusinessLocation

DDL: P_OIL_BUSINESSLOCATION Type: view_entity BASIC
15 Fields 1 Data Sources

P_OIL_BusinessLocation is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (oifspbl) and exposes 15 fields with key field BusinessLocationIdentifier.

Data Sources (1)

SourceAliasJoin Type
oifspbl oifspbl from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #BASIC view
VDM.private true view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY BusinessLocationIdentifier pblnr Location ID
BusinessLocationIdentifierName name1 PA text
BusinessLocationType pbltyp Location type
BusinessLocationAddressNumber addrnum Address Number
CreationDate erdat Entered On
CreationTime erzeit Time created
CreatedByUser ernam User Name
LastChangeDate aedat Obsolete
LastChangeTime aezeit Time changed
LastChangedByUser aenam User Name
EntityIsBlocked bloind Single-Character Flag
EntityIsMarkedForDeletion delind Will be Deleted
BusinessLocationBlockingCode blcode Closed
MaintObjectInternalID objnr Val. Obj. No.
LocationAreaAssignment locaa Loc.a.assign.

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 P_OIL_BusinessLocation.
-- 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 P_OIL_BusinessLocation AS
SELECT
  pblnr AS BusinessLocationIdentifier,
  name1 AS BusinessLocationIdentifierName,
  pbltyp AS BusinessLocationType,
  addrnum AS BusinessLocationAddressNumber,
  erdat AS CreationDate,
  erzeit AS CreationTime,
  ernam AS CreatedByUser,
  aedat AS LastChangeDate,
  aezeit AS LastChangeTime,
  aenam AS LastChangedByUser,
  bloind AS EntityIsBlocked,
  delind AS EntityIsMarkedForDeletion,
  blcode AS BusinessLocationBlockingCode,
  objnr AS MaintObjectInternalID,
  locaa AS LocationAreaAssignment
FROM oifspbl
;

Learn More