P_IBaseInstance

DDL: P_IBASEINSTANCE SQL: PIBASEINST Type: view BASIC Package: VCH_VDM_CBASE
28 Fields 1 Data Sources

Installed Base Instance

P_IBaseInstance is a Basic CDS View that provides data about "Installed Base Instance" in SAP S/4HANA. It reads from 1 data source (ibin) and exposes 28 fields with key field InstalledBaseComponentRecordNo. Part of development package VCH_VDM_CBASE.

Data Sources (1)

SourceAliasJoin Type
ibin ibin from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PIBASEINST 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 InstalledBaseComponentRecordNo in_recno Record number
ValidityStartDate Valid From
ValidityEndDate Valid To
aennr aennr Change Number
delflag delflag Yes/No (X/ )
InstalledBaseComponent instance TaskCount
mlang mlang Primary lang.
sortf sortf Sort string
objnr objnr Val. Obj. No.
InstalledBase ibase Installed Base
amount amount Value Amount
unit unit UoM
datuv datuv Valid-from date
techs techs Tech st from
in_objnr in_objnr Object number
in_guid in_guid GUID
IBaseInstanceObjectType objecttyp Object type
void void Void Komponente
cstatus cstatus ATINSTATUS
cucocnt cucocnt Int. counter
CUCOCNT_INT Int. counter
expert expert User as expert
mat_variant mat_variant Material
ataut ataut Justification
klart klart Class Type
crnam crnam Requester
upnam upnam Changed by
_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_IBaseInstance.
-- 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: PIBASEINST

CREATE VIEW P_IBaseInstance AS
SELECT
  in_recno AS InstalledBaseComponentRecordNo,
  cast( valfr as tzntstmps preserving type ) AS ValidityStartDate,
  cast( valto as tzntstmps preserving type ) AS ValidityEndDate,
  aennr,
  delflag,
  instance AS InstalledBaseComponent,
  mlang,
  sortf,
  objnr,
  ibase AS InstalledBase,
  amount,
  unit,
  datuv,
  techs,
  in_objnr,
  in_guid,
  objecttyp AS IBaseInstanceObjectType,
  void,
  cstatus,
  cucocnt,
  cast(cucocnt as abap.int4) AS CUCOCNT_INT,
  expert,
  mat_variant,
  ataut,
  klart,
  crnam,
  upnam
FROM ibin
;

Learn More