C_FldLogsReceiptsByStatusTP

DDL: C_FLDLOGSRECEIPTSBYSTATUSTP Type: view_entity CONSUMPTION
15 Fields 1 Data Sources 1 Associations

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.

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

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