I_DFS_StatusObjectUserStatus

DDL: I_DFS_STATUSOBJECTUSERSTATUS SQL: CDFSSTATOBJUSER Type: view COMPOSITE
10 Fields 1 Data Sources 1 Associations 1 OData Services 1 Fiori Apps

Status Object Single Active Status

I_DFS_StatusObjectUserStatus is a Composite CDS View that provides data about "Status Object Single Active Status" in SAP S/4HANA. It reads from 1 data source (I_StatusObjectActiveStatus) and exposes 10 fields with key fields StatusObject, StatusCode. It has 1 association to related views. It is exposed through 1 OData service (UI_C_DFS_ALLWNCPLAN). It is used in 1 Fiori application: Manage Allowance Plans.

Data Sources (1)

SourceAliasJoin Type
I_StatusObjectActiveStatus I_StatusObjectActiveStatus from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_UserStatusText _UserStatusText $projection.StatusCode = _UserStatusText.UserStatus and $projection.StatusProfile = _UserStatusText.StatusProfile

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CDFSSTATOBJUSER view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Status Object Single Active Status view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #COMPOSITE view

OData Services (1)

ServiceBindingVersionContractRelease
UI_C_DFS_ALLWNCPLAN UI_C_DFS_ALLWNCPLAN V2 C1 NOT_RELEASED

Fiori Apps (1)

App IDApp NameTypeDescription
F4662 Manage Allowance Plans Transactional The allowance enables force element structures to request authorized materials or products over a time period without influencing the current force planning.

Manage Allowance Plans

Business Role: Material Planner - Authorized Materials

The allowance enables force element structures to request authorized materials or products over a time period without influencing the current force planning. An allowance is divided up into a request and a plan. The request is used to place enquiries for quantities and the plan is a preliminary planning process in which quantities are limited for force element structures over a time period. The result is available in the force planning process.

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY StatusObject StatusObject Status Object
KEY StatusCode StatusCode External Status Code
UserStatusName User Ststus Description
UserStatusShortName User Status
StatusProfile StatusProfile Status Profile
StatusIsActive StatusIsActive
_StatusCode _StatusCode
_StatusObject _StatusObject
_StatusProfile _StatusProfile
_UserStatusText _UserStatusText

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_DFS_StatusObjectUserStatus.
-- 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: CDFSSTATOBJUSER

CREATE VIEW I_DFS_StatusObjectUserStatus AS
SELECT
  StatusObject,
  StatusCode,
  _UserStatusText[1:Language=$session.system_language].UserStatusName AS UserStatusName,
  _UserStatusText[1:Language=$session.system_language].UserStatusShortName AS UserStatusShortName,
  StatusProfile,
  StatusIsActive
FROM I_StatusObjectActiveStatus
LEFT OUTER JOIN I_UserStatusText AS _UserStatusText ON StatusCode = _UserStatusText.UserStatus AND StatusProfile = _UserStatusText.StatusProfile  -- association [0..*]
;

Learn More