I_FldLogsReceiptsByStatus

DDL: I_FLDLOGSRECEIPTSBYSTATUS Type: view_entity COMPOSITE

Field Logistics Receipts by Status

I_FldLogsReceiptsByStatus is a Composite CDS View that provides data about "Field Logistics Receipts by Status" in SAP S/4HANA. It reads from 1 data source (I_FldLogsDateFuncVH) and exposes 9 fields with key field FldLogsSuplrItemUUID. It has 1 association to related views.

1 data source(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
I_FldLogsDateFuncVH I_FldLogsDateFuncVH from

Parameters (1)

NameTypeDefault
P_DateFunction datefunctionid

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_FldLogsProcRcptRcvgStatus _FldLogsProcRcptRcvgStatus _FldLogsProcRcptRcvgStatus.FldLogsProcRecRcvgStatus = $projection.FldLogsProcRecRcvgStatus and _FldLogsProcRcptRcvgStatus.Language = $session.system_language

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
EndUserText.label Field Logistics Receipts by Status view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY FldLogsSuplrItemUUID _ProcRcptItms FldLogsSuplrItemUUID
DeliveryDate _ProcRcptItms DeliveryDate
_FldLogsProcRcptRcvgStatus _FldLogsProcRcptRcvgStatus
FldLogsNumberOfRcptsByStatus
Plant _ProcRcptItms Plant
FldLogsItemType _ProcRcptItms FldLogsItemType
Supplier _ProcRcptItms Supplier
Material _ProcRcptItms Material
FldLogsPurOrdItem _ProcRcptItms FldLogsPurOrdItem 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #XL,
  dataClass: #MIXED
}
@VDM.viewType: #COMPOSITE
@EndUserText.label: 'Field Logistics Receipts by Status'

define view entity I_FldLogsReceiptsByStatus

with parameters

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

  association [0..1] to I_FldLogsProcRcptSrchEnbld as _ProcRcptItms on(
    _ProcRcptItms.DeliveryDate     >= _DateFunVH.StartDate
    and _ProcRcptItms.DeliveryDate <= _DateFunVH.EndDate
  )

  association [0..1] to I_FldLogsProcRcptRcvgStatus as _FldLogsProcRcptRcvgStatus on  _FldLogsProcRcptRcvgStatus.FldLogsProcRecRcvgStatus = $projection.FldLogsProcRecRcvgStatus
                                                                                  and _FldLogsProcRcptRcvgStatus.Language                 = $session.system_language
  
  { 
   key _ProcRcptItms.FldLogsSuplrItemUUID,
      @ObjectModel.text.association: '_FldLogsProcRcptRcvgStatus'
       case
                 when cast(_ProcRcptItms.FldLogsItmIsToBeReceived as  boole_d) = 'X' then cast('01' as flog_procrcpt_gr_status )
                 when cast(_ProcRcptItms.FldLogsItmIsReceived as  boole_d) = 'X'     then cast('02' as flog_procrcpt_gr_status )
                 when cast(_ProcRcptItms.FldLogsItmIsFailed as boole_d) = 'X'        then cast('03' as flog_procrcpt_gr_status )
        end      as FldLogsProcRecRcvgStatus,
      _ProcRcptItms.DeliveryDate as DeliveryDate,

      @ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
      _FldLogsProcRcptRcvgStatus, //text association in projection list    

       cast(1 as abap.int4) as FldLogsNumberOfRcptsByStatus,
       _ProcRcptItms.Plant,
       _ProcRcptItms.FldLogsItemType,
       _ProcRcptItms.Supplier,
       _ProcRcptItms.Material,
       _ProcRcptItms.FldLogsPurOrdItem  
      
}

where 
  (  _ProcRcptItms.FldLogsItmIsToBeReceived = 'X'
  or _ProcRcptItms.FldLogsItmIsReceived     = 'X'
  or _ProcRcptItms.FldLogsItmIsFailed       = 'X' )
  and _ProcRcptItms.DeliveryDate is not initial 
  and  _ProcRcptItms.FldLogsItemType <> 'NA'
 
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_FLDLOGSDATEFUNCVH",
"I_FLDLOGSPROCRCPTSRCHENBLD"
],
"ASSOCIATED":
[
"I_FLDLOGSPROCRCPTRCVGSTATUS"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More