C_FldLogsReceiptsByStatusTP

DDL: C_FLDLOGSRECEIPTSBYSTATUSTP Type: view_entity CONSUMPTION Package: FLOG_DASHBOARD

Projection View for Receipts By Status

C_FldLogsReceiptsByStatusTP is a Consumption CDS View that provides data about "Projection View for Receipts By Status" in SAP S/4HANA. It reads from 1 data source (I_FldLogsDateFuncVH) and exposes 15 fields with key field FldLogsSuplrItemUUID. It has 1 association to related views. It is exposed through 1 OData service (UI_RCPTSRETSOVERVIEW). It is used in 1 Fiori application: Receipts and Returns Overview. Part of development package FLOG_DASHBOARD.

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

Data Sources (1)

SourceAliasJoin Type
I_FldLogsDateFuncVH I_FldLogsDateFuncVH from

Parameters (1)

NameTypeDefault
P_DateFunction datefunctionid

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_FldLogsReceiptsByStatus _ReceiptByStatus ( _ReceiptByStatus.DeliveryDate >= _DateFunVH.StartDate and _ReceiptByStatus.DeliveryDate <= _DateFunVH.EndDate )

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Projection View for Receipts By Status view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view

OData Services (1)

ServiceBindingVersionContractRelease
UI_RCPTSRETSOVERVIEW UI_RCPTSRETSOVERVIEW V2 C1 NOT_TO_BE_RELEASED_STABLE

Fiori Apps (1)

App IDApp NameTypeDescription
F5479 Receipts and Returns Overview Transactional, Analytical This application is to have an overview of KPIs for items to be received at the base and remote location and aggregated information of item type (rentals, non-stock, stock and supplier owned items, Overdue items and Failed receipts, Delayed Receipts, items initiated at the remote location.

Receipts and Returns Overview

Business Role: Receiving Specialist (Oil & Gas)

This feature enables you to view the logistics items to be received for a certain date range in a consolidated chart view. You can view them by item type (stock, rental, or supplier items) as well as by status (to be received, received, or failed receipts). You can view items that are delayed, by item value or duration. For failed receipts, you can view the reason for failure re-initiate a new receipt. You can view the number of items for which returns action has been initiated, or dispatched items. You can also navigate from the cards of the overview pages to the underlaying apps: Process Receipts and Process Returns.

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY FldLogsSuplrItemUUID
CalendarDate CalendarDate
FirstDayOfWeekDate FirstDayOfWeekDate
StartDate StartDate
EndDate EndDate
FldLogsProcRecRcvgStatus
_FldLogsProcRcptRcvgStatus
FldLogsNumberOfRcptsByStatus
DeliveryDate
Plant
Supplier
Material
FldLogsPurOrdItem
FldLogsItemType
_ItemTypeText _ItemTypeText 
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@EndUserText.label: 'Projection View for Receipts By Status'
@Metadata.allowExtensions: true
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
    serviceQuality: #X,
    sizeCategory: #M,
    dataClass: #MIXED
}
@VDM.viewType: #CONSUMPTION
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]
define view entity C_FldLogsReceiptsByStatusTP

  with parameters

    P_DateFunction : datefunctionid

  as select from I_FldLogsDateFuncVH ( P_DateFunction :$parameters.P_DateFunction ) as _DateFunVH

  association [0..1] to I_FldLogsReceiptsByStatus as _ReceiptByStatus on  (
      _ReceiptByStatus.DeliveryDate     >= _DateFunVH.StartDate
      and _ReceiptByStatus.DeliveryDate <= _DateFunVH.EndDate
    )
  association        to I_FldLogsItemTypeVH       as _ItemTypeText    on  $projection.fldlogsitemtype = _ItemTypeText.FldLogsItemType
                                                                      and _ItemTypeText.Language      = $session.system_language
{

  key _ReceiptByStatus( P_DateFunction : $parameters.P_DateFunction ).FldLogsSuplrItemUUID,
      CalendarDate,
      FirstDayOfWeekDate,
      StartDate,
      EndDate,
      @ObjectModel.text.association: '_FldLogsProcRcptRcvgStatus'
      _ReceiptByStatus( P_DateFunction : $parameters.P_DateFunction ).FldLogsProcRecRcvgStatus,
      _ReceiptByStatus( P_DateFunction : $parameters.P_DateFunction )._FldLogsProcRcptRcvgStatus,
      @DefaultAggregation: #SUM
      _ReceiptByStatus(P_DateFunction : $parameters.P_DateFunction ).FldLogsNumberOfRcptsByStatus,
      _ReceiptByStatus( P_DateFunction : $parameters.P_DateFunction ).DeliveryDate,
      _ReceiptByStatus( P_DateFunction : $parameters.P_DateFunction ).Plant,
      _ReceiptByStatus( P_DateFunction : $parameters.P_DateFunction ).Supplier,
      _ReceiptByStatus( P_DateFunction : $parameters.P_DateFunction ).Material,
      _ReceiptByStatus( P_DateFunction : $parameters.P_DateFunction ).FldLogsPurOrdItem,
      @ObjectModel.text.association: '_ItemTypeText'
      _ReceiptByStatus( P_DateFunction : $parameters.P_DateFunction ).FldLogsItemType,
      _ItemTypeText


}

Learn More