P_SDDocControllingObjectSts1

DDL: P_SDDOCCONTROLLINGOBJECTSTS1 SQL: PSDDOCCTRLGOSTS1 Type: view BASIC
5 Fields 2 Data Sources

P_SDDocControllingObjectSts1 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.

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 #C view
ObjectModel.usageType.sizeCategory #XL view
VDM.private true view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName PSDDOCCTRLGOSTS1 view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY objnr jsto objnr Val. Obj. No.
KEY stat jest stat Status of Time-Dependent Document Linkage
stsma jsto stsma Status Profile
obtyp jsto obtyp Picking area
inact jest inact TRUE

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_SDDocControllingObjectSts1.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: PSDDOCCTRLGOSTS1

CREATE VIEW P_SDDocControllingObjectSts1 AS
SELECT
  jsto.objnr AS objnr,
  jest.stat AS stat,
  jsto.stsma AS stsma,
  jsto.obtyp AS obtyp,
  jest.inact AS inact
FROM jsto
INNER JOIN jest ON /* join condition not captured in parsed metadata */
;

Learn More