P_IBaseHeader

DDL: P_IBASEHEADER SQL: PIBASEHEADER Type: view BASIC
28 Fields 1 Data Sources

P_IBaseHeader is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (ibib) and exposes 28 fields with key field InstalledBase.

Data Sources (1)

SourceAliasJoin Type
ibib ibib from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PIBASEHEADER view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MASTER view
VDM.private true view
VDM.viewType #BASIC view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY InstalledBase ibase Installed Base
crnam crnam Requester
upnam upnam Changed by
ibtyp ibtyp Int. Conf. Cat.
compind compind Comp.Store
confind confind Config.Store
filid filid Reference to File
valtyp valtyp Validity type
intst intst Process Status
sttyp sttyp Status Type
ib_guid ib_guid Record number
ib_guid_16 ib_guid_16 GUID 16
objnr objnr Val. Obj. No.
extid extid External Key
mlang mlang Primary lang.
authg authg Authoriz. group
vbeln vbeln SD Sched. Agmt
posnr posnr WBS Element
mstone mstone Milestone
counter counter Version
cuobj cuobj Object Number
plant plant Valuation Area
matnr matnr Vehicle Model
kalnr kalnr ProdCostEst.No.
kbid kbid ATKBID
clang clang Config. Lang.
cstatus cstatus ATINSTATUS
_dataaging _dataaging Data Aging

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_IBaseHeader.
-- 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.
-- SQL view name: PIBASEHEADER

CREATE VIEW P_IBaseHeader AS
SELECT
  ibase AS InstalledBase,
  crnam,
  upnam,
  ibtyp,
  compind,
  confind,
  filid,
  valtyp,
  intst,
  sttyp,
  ib_guid,
  ib_guid_16,
  objnr,
  extid,
  mlang,
  authg,
  vbeln,
  posnr,
  mstone,
  counter,
  cuobj,
  plant,
  matnr,
  kalnr,
  kbid,
  clang,
  cstatus
FROM ibib
;

Learn More