I_FLDLOGSALLRESERVATION

CDS View

FL- Reservation with stock details

I_FLDLOGSALLRESERVATION is a CDS View in S/4HANA. FL- Reservation with stock details. It contains 11 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 11 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_FldLogsProdReservationDetail view from COMPOSITE Reservation details of products

Fields (11)

KeyField CDS FieldsUsed in Views
KEY FldLogsMaintenanceOrder FldLogsMaintenanceOrder 1
KEY FldLogsReferenceDocumentNumber FldLogsReferenceDocumentNumber 1
KEY FldLogsRemotePlant FldLogsRemotePlant 1
KEY Material Material 1
KEY ReferenceDocumentItem ReferenceDocumentItem 1
KEY RemoteStorageLocation RemoteStorageLocation 1
KEY Reservation Reservation 1
KEY ReservationItem ReservationItem 1
QuantityUnit QuantityUnit 1
ResvnItmRequiredQtyInBaseUnit ResvnItmRequiredQtyInBaseUnit 1
ResvnItmWithdrawnQtyInBaseUnit ResvnItmWithdrawnQtyInBaseUnit 1 
@AbapCatalog.sqlViewName: 'IFLRESBALL'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.serviceQuality: #C
@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'FL- Reservation with stock details'

define view I_FldLogsAllReservation

  as select from I_FldLogsReservationItem
{
  key   Material,
  key   FldLogsRemotePlant,
  key   FldLogsReferenceDocumentNumber,
  key   ReferenceDocumentItem,
  key   FldLogsMaintenanceOrder,
  key   RemoteStorageLocation,
  key   Reservation,
  key   ReservationItem,
        QuantityUnit,
        ResvnItmRequiredQtyInBaseUnit,
        ResvnItmWithdrawnQtyInBaseUnit
}

union all select from I_FldLogsReservationStock

{
  key   Material,
  key   FldLogsRemotePlant,
  key   FldLogsReferenceDocumentNumber,
  key   ReferenceDocumentItem,
  key   FldLogsMaintenanceOrder,
  key   RemoteStorageLocation,
  key   Reservation,
  key   ReservationItem,
        QuantityUnit,
        ResvnItmRequiredQtyInBaseUnit,
        ResvnItmWithdrawnQtyInBaseUnit
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_FLDLOGSRESERVATIONITEM",
"I_FLDLOGSRESERVATIONSTOCK"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More