P_IBaseInstance

DDL: P_IBASEINSTANCE SQL: PIBASEINST Type: view BASIC

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

1 data source(s) 28 fields

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
ValidityStartDate
ValidityEndDate
aennr aennr
delflag delflag
InstalledBaseComponent instance
mlang mlang
sortf sortf
objnr objnr
InstalledBase ibase
amount amount
unit unit
datuv datuv
techs techs
in_objnr in_objnr
in_guid in_guid
IBaseInstanceObjectType objecttyp
void void
cstatus cstatus
cucocnt cucocnt
CUCOCNT_INT
expert expert
mat_variant mat_variant
ataut ataut
klart klart
crnam crnam
upnam upnam
_dataaging _dataaging 
@AbapCatalog.sqlViewName: 'PIBASEINST'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #MASTER
@VDM.private:true
@VDM.viewType: #BASIC

define view P_IBaseInstance
  as select from ibin
{
  key 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,
      _dataaging
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"IBIN"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More