P_SDDocControllingObjectSts2

DDL: P_SDDOCCONTROLLINGOBJECTSTS2 SQL: PSDDOCCTRLGOSTS2 Type: view BASIC

P_SDDocControllingObjectSts2 is a Basic CDS View in SAP S/4HANA. It reads from 4 data sources (P_SDDocControllingObjectSts1, P_SDDocControllingObjectSts1, tj07, tj31) and exposes 13 fields with key fields objnr, stsma, stat, vrgng, stsma.

4 data source(s) 13 fields

Data Sources (4)

SourceAliasJoin Type
P_SDDocControllingObjectSts1 p1 from
P_SDDocControllingObjectSts1 p2 union_all
tj07 tj07 inner
tj31 tj31 inner

Annotations (8)

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

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY objnr P_SDDocControllingObjectSts1 objnr
KEY stsma P_SDDocControllingObjectSts1 stsma
KEY stat P_SDDocControllingObjectSts1 stat
KEY vrgng tj31 vrgng
obtyp P_SDDocControllingObjectSts1 obtyp
modkz tj31 modkz
objnr
KEY stsma P_SDDocControllingObjectSts1 stsma
KEY stat P_SDDocControllingObjectSts1 stat
KEY vrgng tj07 vrgng
obtyp P_SDDocControllingObjectSts1 obtyp
modkz tj07 modkz
inact inact 
@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: 'PSDDOCCTRLGOSTS2'

define view P_SDDocControllingObjectSts2
as
//User Status

select from P_SDDocControllingObjectSts1 as p1
inner join tj31
  on p1.stsma = tj31.stsma and p1.stat = tj31.estat
{
  key p1.objnr,
  key p1.stsma,
  key p1.stat,
  key tj31.vrgng,
  p1.obtyp,
  tj31.modkz,
  inact
}
where (tj31.vrgng = 'SDDN' or tj31.vrgng = 'SDIN')

union all

//System Status

select from P_SDDocControllingObjectSts1 as p2
inner join tj07
  on p2.stat = tj07.istat

{
  key p2.objnr,
  key p2.stsma,
  key p2.stat,
  key tj07.vrgng,
  p2.obtyp,
  tj07.modkz,
  inact
}
where (tj07.vrgng = 'SDDN' or tj07.vrgng = 'SDIN');   
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_SDDOCCONTROLLINGOBJECTSTS1",
"TJ07",
"TJ31"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More