I_AssldReltdSerialNumberBatch

DDL: I_ASSLDRELTDSERIALNUMBERBATCH SQL: IMPEASSRLTDSRNB Type: view COMPOSITE
23 Fields 1 Data Sources

Assembled Related Serial Number and/or Batch

I_AssldReltdSerialNumberBatch is a Composite CDS View that provides data about "Assembled Related Serial Number and/or Batch" in SAP S/4HANA. It reads from 1 data source (P_AssldReltdSerialNumberBatch) and exposes 23 fields with key fields Reservation, ReservationItem, RecordType, OpActyNtwkInstance, OpActyNtwkElement.

Data Sources (1)

SourceAliasJoin Type
P_AssldReltdSerialNumberBatch AssldReltdSerialNumberBatch from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IMPEASSRLTDSRNB view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
EndUserText.label Assembled Related Serial Number and/or Batch view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY Reservation P_AssldReltdSerialNumberBatch Reservation Reservation
KEY ReservationItem P_AssldReltdSerialNumberBatch ReservationItem Reservation Item
KEY RecordType P_AssldReltdSerialNumberBatch RecordType Reservation Record Type
KEY OpActyNtwkInstance P_AssldReltdSerialNumberBatch OpActyNtwkInstance Instance ID
KEY OpActyNtwkElement P_AssldReltdSerialNumberBatch OpActyNtwkElement Element Number
KEY AssemblyShopFloorItem P_AssldReltdSerialNumberBatch AssemblyShopFloorItem
KEY ShopFloorItem P_AssldReltdSerialNumberBatch ShopFloorItem Serial.Mat. ID
KEY Batch P_AssldReltdSerialNumberBatch Batch Lot No.
KEY Material P_AssldReltdSerialNumberBatch Material Vehicle Model
KEY Plant P_AssldReltdSerialNumberBatch Plant Valuation Area
SerialNumber
ManufacturerSerialNumber
BatchBySupplier
MaterialName
MaterialComponentQuantity P_AssldReltdSerialNumberBatch MaterialComponentQuantity
MaterialBaseUnit P_AssldReltdSerialNumberBatch MaterialBaseUnit Valuation Unit
_OpActyNtwkInstance P_AssldReltdSerialNumberBatch _OpActyNtwkInstance
_OperationActivityInstance P_AssldReltdSerialNumberBatch _OperationActivityInstance
_ReservationHeader P_AssldReltdSerialNumberBatch _ReservationHeader
_ShopFloorItem P_AssldReltdSerialNumberBatch _ShopFloorItem
_ParentShopFloorItem P_AssldReltdSerialNumberBatch _ParentShopFloorItem
_Material P_AssldReltdSerialNumberBatch _Material
_Plant P_AssldReltdSerialNumberBatch _Plant

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_AssldReltdSerialNumberBatch.
-- 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: IMPEASSRLTDSRNB

CREATE VIEW I_AssldReltdSerialNumberBatch AS
SELECT
  AssldReltdSerialNumberBatch.Reservation AS Reservation,
  AssldReltdSerialNumberBatch.ReservationItem AS ReservationItem,
  AssldReltdSerialNumberBatch.RecordType AS RecordType,
  AssldReltdSerialNumberBatch.OpActyNtwkInstance AS OpActyNtwkInstance,
  AssldReltdSerialNumberBatch.OpActyNtwkElement AS OpActyNtwkElement,
  AssldReltdSerialNumberBatch.AssemblyShopFloorItem AS AssemblyShopFloorItem,
  AssldReltdSerialNumberBatch.ShopFloorItem AS ShopFloorItem,
  AssldReltdSerialNumberBatch.Batch AS Batch,
  AssldReltdSerialNumberBatch.Material AS Material,
  AssldReltdSerialNumberBatch.Plant AS Plant,
  AssldReltdSerialNumberBatch._ShopFloorItem.SerialNumber AS SerialNumber,
  AssldReltdSerialNumberBatch._ShopFloorItem._Equipment.ManufacturerSerialNumber AS ManufacturerSerialNumber,
  AssldReltdSerialNumberBatch._BatchDistinct.BatchBySupplier AS BatchBySupplier,
  AssldReltdSerialNumberBatch._Material._Text[1: Language=$session.system_language].MaterialName AS MaterialName,
  AssldReltdSerialNumberBatch.MaterialComponentQuantity AS MaterialComponentQuantity,
  AssldReltdSerialNumberBatch.MaterialBaseUnit AS MaterialBaseUnit,
  AssldReltdSerialNumberBatch._OpActyNtwkInstance AS _OpActyNtwkInstance,
  AssldReltdSerialNumberBatch._OperationActivityInstance AS _OperationActivityInstance,
  AssldReltdSerialNumberBatch._ReservationHeader AS _ReservationHeader,
  AssldReltdSerialNumberBatch._ShopFloorItem AS _ShopFloorItem,
  AssldReltdSerialNumberBatch._ParentShopFloorItem AS _ParentShopFloorItem,
  AssldReltdSerialNumberBatch._Material AS _Material,
  AssldReltdSerialNumberBatch._Plant AS _Plant
FROM P_AssldReltdSerialNumberBatch AS AssldReltdSerialNumberBatch
;

Learn More