P_OrderOpCompStatusBasic

DDL: P_ORDEROPCOMPSTATUSBASIC SQL: PORDOPCOMPSTSBAS Type: view COMPOSITE
7 Fields 1 Data Sources 5 Associations

P_OrderOpCompStatusBasic is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_StatusObjectStatusBasic) and exposes 7 fields with key field ObjectInternalID. It has 5 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_StatusObjectStatusBasic jest from

Associations (5)

CardinalityTargetAliasCondition
[0..1] I_StatusCode _ComponentIsCreatedCode _ComponentIsCreatedCode.StatusCode = 'I0001' and _ComponentIsCreatedCode.StatusProfile = ''
[0..1] I_StatusCode _ComponentIsReleasedCode _ComponentIsReleasedCode.StatusCode = 'I0002' and _ComponentIsReleasedCode.StatusProfile = ''
[0..1] I_StatusCode _ComponentIsPrintedCode _ComponentIsPrintedCode.StatusCode = 'I0007' and _ComponentIsPrintedCode.StatusProfile = ''
[0..1] I_StatusCode _ComponentIsDeletedCode _ComponentIsDeletedCode.StatusCode = 'I0013' and _ComponentIsDeletedCode.StatusProfile = ''
[0..1] I_StatusCode _CompIsCreatedByOrderSplitCode _CompIsCreatedByOrderSplitCode.StatusCode = 'I0487' and _CompIsCreatedByOrderSplitCode.StatusProfile = ''

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PORDOPCOMPSTSBAS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY ObjectInternalID I_StatusObjectStatusBasic StatusObject Status Object
_StatusObject _StatusObject
_ComponentIsCreatedCode _ComponentIsCreatedCode
_ComponentIsReleasedCode _ComponentIsReleasedCode
_ComponentIsPrintedCode _ComponentIsPrintedCode
_ComponentIsDeletedCode _ComponentIsDeletedCode
_CompIsCreatedByOrderSplitCode _CompIsCreatedByOrderSplitCode

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_OrderOpCompStatusBasic.
-- 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: PORDOPCOMPSTSBAS

CREATE VIEW P_OrderOpCompStatusBasic AS
SELECT
  jest.StatusObject AS ObjectInternalID
FROM I_StatusObjectStatusBasic AS jest
LEFT OUTER JOIN I_StatusCode AS _ComponentIsCreatedCode ON _ComponentIsCreatedCode.StatusCode = 'I0001' AND _ComponentIsCreatedCode.StatusProfile = ''  -- association [0..1]
LEFT OUTER JOIN I_StatusCode AS _ComponentIsReleasedCode ON _ComponentIsReleasedCode.StatusCode = 'I0002' AND _ComponentIsReleasedCode.StatusProfile = ''  -- association [0..1]
LEFT OUTER JOIN I_StatusCode AS _ComponentIsPrintedCode ON _ComponentIsPrintedCode.StatusCode = 'I0007' AND _ComponentIsPrintedCode.StatusProfile = ''  -- association [0..1]
LEFT OUTER JOIN I_StatusCode AS _ComponentIsDeletedCode ON _ComponentIsDeletedCode.StatusCode = 'I0013' AND _ComponentIsDeletedCode.StatusProfile = ''  -- association [0..1]
LEFT OUTER JOIN I_StatusCode AS _CompIsCreatedByOrderSplitCode ON _CompIsCreatedByOrderSplitCode.StatusCode = 'I0487' AND _CompIsCreatedByOrderSplitCode.StatusProfile = ''  -- association [0..1]
;

Learn More