P_SDDocControllingObjectStsT2

DDL: P_SDDOCCONTROLLINGOBJECTSTST2 SQL: PSDDOCCTRLGOT2 Type: view BASIC
4 Fields 2 Data Sources

P_SDDocControllingObjectStsT2 is a Basic CDS View in SAP S/4HANA. It reads from 2 data sources (I_SAPClient, tj02t) and exposes 4 fields with key fields stat, stsma, spras.

Data Sources (2)

SourceAliasJoin Type
I_SAPClient I_SAPClient inner
tj02t tj02t 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 PSDDOCCTRLGOT2 view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY stat istat System status
KEY stsma
KEY spras spras Off. Language
txt30 txt30 Text

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_SDDocControllingObjectStsT2.
-- 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: PSDDOCCTRLGOT2

CREATE VIEW P_SDDocControllingObjectStsT2 AS
SELECT
  istat AS stat,
  '' AS stsma,
  spras,
  txt30
FROM tj02t
INNER JOIN I_SAPClient ON /* join condition not captured in parsed metadata */
;

Learn More