P_SDCONTROLLINGOBJECTSTATUS1
SD Controlling Object Status
P_SDCONTROLLINGOBJECTSTATUS1 is a CDS View in S/4HANA. SD Controlling Object Status. It contains 4 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| P_SDControllingObjectStatus2 | view | from | BASIC | SD Controlling Object Status |
| P_SDControllingObjectStatus2 | view | union_all | BASIC | SD Controlling Object Status |
Fields (4)
| Key | Field | CDS Fields | Used 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: #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';