A_ProjNtwkActyMatlCompStatus

DDL: A_PROJNTWKACTYMATLCOMPSTATUS Type: view_entity COMPOSITE
11 Fields 1 Data Sources 2 Associations 1 OData Services

Proj Ntwk Acty Material Component Status

A_ProjNtwkActyMatlCompStatus is a Composite CDS View that provides data about "Proj Ntwk Acty Material Component Status" in SAP S/4HANA. It reads from 1 data source (I_ProjectMaterialCompBasicData) and exposes 11 fields with key fields Reservation, ReservationItem, RecordType, StatusCode. It has 2 associations to related views. It is exposed through 1 OData service (API_PROJECTNETWORK).

Data Sources (1)

SourceAliasJoin Type
I_ProjectMaterialCompBasicData _ProjectMaterialCompBasicData inner

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_UserStatusText _UserStatusText _StatusObject.StatusProfile = _UserStatusText.StatusProfile and _StatusObject.StatusCode = _UserStatusText.UserStatus
[1..1] A_ProjNtwkActyMatlComp _ProjNtwkActyMatlComp $projection.Reservation = _ProjNtwkActyMatlComp.Reservation and $projection.ReservationItem = _ProjNtwkActyMatlComp.ReservationItem and $projection.RecordType = _ProjNtwkActyMatlComp.RecordType

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Proj Ntwk Acty Material Component Status view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
OData.entitySet.name ProjNtwkActyMatlCompStatus view
OData.entityType.name ProjNtwkActyMatlCompStatus_Type view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view

OData Services (1)

ServiceBindingVersionContractRelease
API_PROJECTNETWORK API_PROJECTNETWORK V4 C2 C1

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY Reservation I_ProjectMaterialCompBasicData Reservation Reservation
KEY ReservationItem I_ProjectMaterialCompBasicData ReservationItem Reservation Item
KEY RecordType I_ProjectMaterialCompBasicData RecordType Reservation Record Type
KEY StatusCode _StatusObject StatusCode Statuscode
StatusObject _StatusObject StatusObject Status Object
StatusProfile _StatusObject StatusProfile Status Profile
StatusIsActive _StatusObject StatusIsActive
IsUserStatus _StatusObject IsUserStatus
StatusShortNameendasStatusShortName
StatusNameendasStatusName
_ProjNtwkActyMatlComp _ProjNtwkActyMatlComp

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

CREATE VIEW A_ProjNtwkActyMatlCompStatus AS
SELECT
  _ProjectMaterialCompBasicData.Reservation AS Reservation,
  _ProjectMaterialCompBasicData.ReservationItem AS ReservationItem,
  _ProjectMaterialCompBasicData.RecordType AS RecordType,
  _StatusObject.StatusCode AS StatusCode,
  _StatusObject.StatusObject AS StatusObject,
  _StatusObject.StatusProfile AS StatusProfile,
  _StatusObject.StatusIsActive AS StatusIsActive,
  _StatusObject.IsUserStatus AS IsUserStatus,
  case _StatusObject.IsUserStatus when 'X' then case when _UserStatusText[Language = $session.system_language].UserStatusShortName is not initial and _UserStatusText[Language = $session.system_language].UserStatusShortName <> '' then _UserStatusText[Language = $session.system_language].UserStatusShortName else _UserStatusText[Language = _StatusProfile.MasterLanguage].UserStatusShortName end else _StatusCodeText.StatusShortName end as StatusShortName AS StatusShortNameendasStatusShortName,
  case _StatusObject.IsUserStatus when 'X' then case when _UserStatusText[Language = $session.system_language].UserStatusShortName is not initial and _UserStatusText[Language = $session.system_language].UserStatusShortName <> '' then _UserStatusText[Language = $session.system_language].UserStatusName else _UserStatusText[Language = _StatusProfile.MasterLanguage].UserStatusName end else _StatusCodeText.StatusName end as StatusName AS StatusNameendasStatusName
INNER JOIN I_ProjectMaterialCompBasicData AS _ProjectMaterialCompBasicData ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_UserStatusText AS _UserStatusText ON _StatusObject.StatusProfile = _UserStatusText.StatusProfile AND _StatusObject.StatusCode = _UserStatusText.UserStatus  -- association [0..*]
LEFT OUTER JOIN A_ProjNtwkActyMatlComp AS _ProjNtwkActyMatlComp ON Reservation = _ProjNtwkActyMatlComp.Reservation AND ReservationItem = _ProjNtwkActyMatlComp.ReservationItem AND RecordType = _ProjNtwkActyMatlComp.RecordType  -- association [1..1]
;

Learn More