I_FldLogsTotReturnBatchStock

DDL: I_FLDLOGSTOTRETURNBATCHSTOCK SQL: IFLDTOTBATCHSTK Type: view COMPOSITE Package: FLOG_RETURN
7 Fields 1 Data Sources

Total returnable batch stock

I_FldLogsTotReturnBatchStock is a Composite CDS View that provides data about "Total returnable batch stock" in SAP S/4HANA. It reads from 1 data source (I_FldLogsReturnItem) and exposes 7 fields with key fields Material, FldLogsRemotePlant, RemoteStorageLocation, SerialNumber, WBSElementInternalID. Part of development package FLOG_RETURN.

Data Sources (1)

SourceAliasJoin Type
I_FldLogsReturnItem I_FldLogsReturnItem from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IFLDTOTBATCHSTK view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Total returnable batch stock view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY Material Material Vehicle Model
KEY FldLogsRemotePlant FldLogsRemotePlant Plant
KEY RemoteStorageLocation RemoteStorageLocation
KEY SerialNumber SerialNumber Serial Number
KEY WBSElementInternalID WBSElementInternalID WBS Internal ID
TotRetblQtyInBaseUnit RetblQtyInBaseUnit
RetblQtyBaseUnit RetblQtyBaseUnit

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 I_FldLogsTotReturnBatchStock.
-- 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.
-- SQL view name: IFLDTOTBATCHSTK

CREATE VIEW I_FldLogsTotReturnBatchStock AS
SELECT
  Material,
  FldLogsRemotePlant,
  RemoteStorageLocation,
  SerialNumber,
  WBSElementInternalID,
  RetblQtyInBaseUnit AS TotRetblQtyInBaseUnit,
  RetblQtyBaseUnit
FROM I_FldLogsReturnItem
;

Learn More