I_SDDocControllingObjectSts

DDL: I_SDDOCCONTROLLINGOBJECTSTS SQL: ISDDOCCTRLGOSTS Type: view BASIC
7 Fields 1 Data Sources

SD Document Controlling Object Status

I_SDDocControllingObjectSts is a Basic CDS View that provides data about "SD Document Controlling Object Status" in SAP S/4HANA. It reads from 1 data source (P_SDDocControllingObjectSts2) and exposes 7 fields with key fields ControllingObject, ControllingObjectStatus, StatusProfile, BusinessTransactionType.

Data Sources (1)

SourceAliasJoin Type
P_SDDocControllingObjectSts2 P_SDDocControllingObjectSts2 from

Annotations (8)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
EndUserText.label SD Document Controlling Object Status view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName ISDDOCCTRLGOSTS view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY ControllingObject objnr Val. Obj. No.
KEY ControllingObjectStatus stat Status of Time-Dependent Document Linkage
KEY StatusProfile stsma Status Profile
KEY BusinessTransactionType vrgng Bus.Transaction
ControllingObjectCategory obtyp Picking area
BusTransacExecutionAllowance modkz Modif. Indic.
StatusIsInactive 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 I_SDDocControllingObjectSts.
-- 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: ISDDOCCTRLGOSTS

CREATE VIEW I_SDDocControllingObjectSts AS
SELECT
  objnr AS ControllingObject,
  stat AS ControllingObjectStatus,
  stsma AS StatusProfile,
  vrgng AS BusinessTransactionType,
  obtyp AS ControllingObjectCategory,
  modkz AS BusTransacExecutionAllowance,
  inact AS StatusIsInactive
FROM P_SDDocControllingObjectSts2
;

Learn More