P_SDControllingObjectStatus1

DDL: P_SDCONTROLLINGOBJECTSTATUS1 SQL: PSDCTRLGOSTS1 Type: view BASIC

P_SDControllingObjectStatus1 is a Basic CDS View in SAP S/4HANA. It reads from 2 data sources (jest, jsto) and exposes 5 fields with key fields objnr, stat.

2 data source(s) 5 fields

Data Sources (2)

SourceAliasJoin Type
jest jest inner
jsto jsto from

Annotations (8)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
VDM.private true view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName PSDCTRLGOSTS1 view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY objnr jsto objnr
KEY stat jest stat
stsma jsto stsma
obtyp jsto obtyp
inact jest inact 
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XL
@VDM.private: true
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck:#NOT_REQUIRED
@AbapCatalog.sqlViewName: 'PSDCTRLGOSTS1'

define view P_SDControllingObjectStatus1
as select from jsto
inner join jest
  on jsto.objnr = jest.objnr
{
    key jsto.objnr,
    key jest.stat,
    jsto.stsma,
    jsto.obtyp,
    jest.inact
}
where (jsto.obtyp = 'VBK' or jsto.obtyp = 'VBP');
  //and  not jest.inact = 'X';    

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"JEST",
"JSTO"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More