C_FldLogsReceiptsByStatusTP

DDL: C_FLDLOGSRECEIPTSBYSTATUSTP Type: view_entity CONSUMPTION

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.

1 data source(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

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
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


}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_FLDLOGSDATEFUNCVH",
"I_FLDLOGSRECEIPTSBYSTATUS"
],
"ASSOCIATED":
[
"I_FLDLOGSITEMTYPEVH",
"I_FLDLOGSPROCRCPTRCVGSTATUS"
],
"BASE":
[
"I_FLDLOGSRECEIPTSBYSTATUS"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More