P_SDDOCCONTROLLINGOBJECTSTS1

CDS View

P_SDDOCCONTROLLINGOBJECTSTS1 is a CDS View in S/4HANA. It contains 4 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 4 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_SDDocControllingObjectSts2 view from BASIC
P_SDDocControllingObjectSts2 view union_all BASIC

Fields (4)

KeyField CDS FieldsUsed in Views
KEY objnr objnr 1
KEY stat stat 1
KEY stsma stsma 1
obtyp obtyp 1 
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@VDM.private: true
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck:#NOT_REQUIRED
@AbapCatalog.sqlViewName: 'PSDDOCCTRLGOSTS1'

define view P_SDDocControllingObjectSts1
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