I_OrderCategory

DDL: I_ORDERCATEGORY SQL: IPPORDERCAT Type: view BASIC

Order Category

I_OrderCategory is a Basic CDS View (Dimension) that provides data about "Order Category" in SAP S/4HANA. It reads from 1 data source (dd07l) and exposes 3 fields with key field OrderCategory. It has 1 association to related views. It is exposed through 5 OData services (UI_HCMAPPROVETIMESHEET, UI_HCMCOMPLIANCE, UI_HCMCOMPLIANCE_EMP, ...). It is used in 2 Fiori applications: Approve Timesheets (S/4HANA / Version 4), My Timesheet (S/4HANA / Version 4).

1 data source(s) Exposed by 5 service(s) Used in 2 Fiori app(s) 3 fields

Data Sources (1)

SourceAliasJoin Type
dd07l l from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_OrderCategoryText _Text $projection.OrderCategory = _Text.OrderCategory

Annotations (22)

NameValueLevelField
AbapCatalog.sqlViewName IPPORDERCAT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
Analytics.dataCategory #DIMENSION view
Analytics.internalName #LOCAL view
ClientHandling.algorithm #SESSION_VARIABLE view
Consumption.ranked true view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.compositionRoot true view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
ObjectModel.representativeKey OrderCategory view
ObjectModel.resultSet.sizeCategory #XS view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #META view
Search.searchable true view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.viewType #BASIC view
EndUserText.label Order Category view

OData Services (5)

ServiceBindingVersionContractRelease
UI_HCMAPPROVETIMESHEET UI_HCMAPPROVETIMESHEET V2 C1 NOT_RELEASED
UI_HCMCOMPLIANCE UI_HCMCOMPLIANCE_V2 V2 C1 NOT_RELEASED
UI_HCMCOMPLIANCE_EMP UI_HCMCOMPLIANCE_EMP_V2 V2 C1 NOT_RELEASED
UI_HCMMYTIMESHEET API_HCMMYTIMESHEET V2 C2 NOT_RELEASED
UI_HCMMYTIMESHEET UI_HCMMYTIMESHEET V2 C1 NOT_RELEASED

Fiori Apps (2)

App IDApp NameTypeDescription
F2585A Approve Timesheets (S/4HANA / Version 4) Analytical With this app, you as a manager can quickly view all pending approvals of your direct reports and approve timesheets using desktop or mobile devices.
F3074A My Timesheet (S/4HANA / Version 4) Transactional You, as an employee, can use this app to manage your time entries quickly and efficiently using a desktop or a mobile device.

Approve Timesheets (S/4HANA / Version 4)

Business Role: Manager - HR Info

With this app, you as a manager can quickly view all pending approvals of your direct reports and approve timesheets using desktop, tablet or mobile devices. This app provides the following key features: Review timesheets for all your employees and view time entry compliance at a glance. View all time entries pending approval or that have already been approved. Filter time entries based on a date range, on specific attributes, or per employee. View designation and contact information of each employee. Approve or reject records by week.

My Timesheet (S/4HANA / Version 4)

Business Role: Employee - HR Info

You, as an employee, can use this app to manage your time entries quickly and efficiently using a desktop or a mobile device. You can use this app to do the following: enter time records for the chosen personnel assignment using form entry or assignments. create or import assignments and manage them. create and manage assignment groups. use horizontal or grid view for time entries. view the calendar for a chosen month on a desktop device, and for a given week on a mobile device. copy and paste time records. access the to-do list. switch between the allowed data entry profiles for a given time entry.

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY OrderCategory
DomainValue dd07l domvalue_l
_Text _Text 
@AbapCatalog.sqlViewName: 'IPPORDERCAT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@Analytics.dataCategory: #DIMENSION
@Analytics.internalName: #LOCAL
@ClientHandling.algorithm: #SESSION_VARIABLE
@Consumption.ranked: true
@Metadata.allowExtensions: true
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.compositionRoot: true
@ObjectModel.dataCategory: #VALUE_HELP
@ObjectModel.modelingPattern: #ANALYTICAL_DIMENSION
@ObjectModel.supportedCapabilities: [#ANALYTICAL_DIMENSION, #CDS_MODELING_ASSOCIATION_TARGET, #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #SEARCHABLE_ENTITY, #VALUE_HELP_PROVIDER]
@ObjectModel.representativeKey: 'OrderCategory'
@ObjectModel.semanticKey: ['OrderCategory']
@ObjectModel.resultSet.sizeCategory: #XS
@ObjectModel.usageType: {serviceQuality: #A, sizeCategory: #L, dataClass: #META}
@Search.searchable: true
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@VDM.viewType: #BASIC
@EndUserText.label: 'Order Category'

/*+[hideWarning] { "IDS" : [ "CALCULATED_FIELD_CHECK", "KEY_CHECK" ]  } */
define view I_OrderCategory
  as select from dd07l as l
  association [0..*] to I_OrderCategoryText as _Text on $projection.OrderCategory = _Text.OrderCategory
  {
      @ObjectModel.text.association: '_Text'
  key cast( cast(substring(l.domvalue_l, 1, 2) as abap.numc(2) ) as auftyp preserving type) as OrderCategory,
      @Analytics.hidden: true
      @Consumption.hidden: true
      @Search: {defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 0.8}
      l.domvalue_l                                                                          as DomainValue,

      // Association

      @ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
      _Text
  }
  where l.domname = 'AUFTYP'
    and l.as4local = 'A'
    and l.as4vers  = '0000';

Learn More