I_DFS_StatusObjectUserStatus

DDL: I_DFS_STATUSOBJECTUSERSTATUS SQL: CDFSSTATOBJUSER Type: view COMPOSITE

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.

1 data source(s) Exposed by 1 service(s) Used in 1 Fiori app(s) 10 fields

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
KEY StatusCode StatusCode External Status Code
UserStatusName User Ststus Description
UserStatusShortName User Status
StatusProfile StatusProfile
StatusIsActive StatusIsActive
_StatusCode _StatusCode
_StatusObject _StatusObject
_StatusProfile _StatusProfile
_UserStatusText _UserStatusText 
@AbapCatalog.sqlViewName: 'CDFSSTATOBJUSER'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@EndUserText.label: 'Status Object Single Active Status'

@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL

@VDM.viewType: #COMPOSITE

define view I_DFS_StatusObjectUserStatus
  as select from I_StatusObjectActiveStatus
  association [0..*] to I_UserStatusText as _UserStatusText on  $projection.StatusCode    = _UserStatusText.UserStatus
                                                            and $projection.StatusProfile = _UserStatusText.StatusProfile
{
       @UI.hidden: true
  key  StatusObject,
       @EndUserText.quickInfo: 'External Status Code'
       @EndUserText.label: 'External Status Code'
  key  StatusCode,
       @EndUserText.quickInfo:'User Status Description'
       @EndUserText.label: 'User Ststus Description'
       _UserStatusText[1:Language=$session.system_language].UserStatusName,
       @EndUserText.quickInfo:'User Status'
       @EndUserText.label: 'User Status'
       _UserStatusText[1:Language=$session.system_language].UserStatusShortName,
       @UI.hidden: true
       StatusProfile,
       @UI.hidden: true
       StatusIsActive,

       /* Associations */
       _StatusCode,
       _StatusObject,
       _StatusProfile,
       _UserStatusText
}
where
      IsUserStatus =    'X'
  and StatusObject like 'DF%'

Learn More