C_FldLogsReceiptsByStatusTP

DDL: C_FLDLOGSRECEIPTSBYSTATUSTP Type: view_entity CONSUMPTION
15 Fields 1 Data Sources 1 Associations 1 OData Services 1 Fiori Apps

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.

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_RELEASED

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 Calendar Date
FirstDayOfWeekDate FirstDayOfWeekDate First day of week date
StartDate StartDate Valid From
EndDate EndDate Term to
FldLogsProcRecRcvgStatus
_FldLogsProcRcptRcvgStatus
FldLogsNumberOfRcptsByStatus
DeliveryDate
Plant
Supplier
Material
FldLogsPurOrdItem
FldLogsItemType
_ItemTypeText _ItemTypeText

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 C_FldLogsReceiptsByStatusTP.
-- 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.
-- Parameters: P_DateFunction : datefunctionid

CREATE VIEW C_FldLogsReceiptsByStatusTP AS
SELECT
  _ReceiptByStatus( P_DateFunction : $parameters.P_DateFunction ).FldLogsSuplrItemUUID AS FldLogsSuplrItemUUID,
  CalendarDate,
  FirstDayOfWeekDate,
  StartDate,
  EndDate,
  _ReceiptByStatus( P_DateFunction : $parameters.P_DateFunction ).FldLogsProcRecRcvgStatus AS FldLogsProcRecRcvgStatus,
  _ReceiptByStatus( P_DateFunction : $parameters.P_DateFunction )._FldLogsProcRcptRcvgStatus AS _FldLogsProcRcptRcvgStatus,
  _ReceiptByStatus(P_DateFunction : $parameters.P_DateFunction ).FldLogsNumberOfRcptsByStatus AS FldLogsNumberOfRcptsByStatus,
  _ReceiptByStatus( P_DateFunction : $parameters.P_DateFunction ).DeliveryDate AS DeliveryDate,
  _ReceiptByStatus( P_DateFunction : $parameters.P_DateFunction ).Plant AS Plant,
  _ReceiptByStatus( P_DateFunction : $parameters.P_DateFunction ).Supplier AS Supplier,
  _ReceiptByStatus( P_DateFunction : $parameters.P_DateFunction ).Material AS Material,
  _ReceiptByStatus( P_DateFunction : $parameters.P_DateFunction ).FldLogsPurOrdItem AS FldLogsPurOrdItem,
  _ReceiptByStatus( P_DateFunction : $parameters.P_DateFunction ).FldLogsItemType AS FldLogsItemType
FROM I_FldLogsDateFuncVH
LEFT OUTER JOIN I_FldLogsReceiptsByStatus AS _ReceiptByStatus ON ( _ReceiptByStatus.DeliveryDate >= _DateFunVH.StartDate AND _ReceiptByStatus.DeliveryDate <= _DateFunVH.EndDate )  -- association [0..1]
;

Learn More