C_BatchObjPageBatchHistory

DDL: C_BATCHOBJPAGEBATCHHISTORY SQL: CBATCHOBJPGHIST Type: view CONSUMPTION Package: LO_BM_BATCH_UI
34 Fields 1 Data Sources 6 Associations

Batch History for Batch Object Page

C_BatchObjPageBatchHistory is a Consumption CDS View that provides data about "Batch History for Batch Object Page" in SAP S/4HANA. It reads from 1 data source (P_BatchObjPageBatchHistory) and exposes 34 fields with key fields Plant, Material, Batch, MaterialDocumentYear, MaterialDocument. It has 6 associations to related views. Part of development package LO_BM_BATCH_UI.

Data Sources (1)

SourceAliasJoin Type
P_BatchObjPageBatchHistory P_BatchObjPageBatchHistory from

Parameters (1)

NameTypeDefault
P_Language sylangu

Associations (6)

CardinalityTargetAliasCondition
[1..1] I_Material _Material $projection.Material = _Material.Material
[0..1] I_Supplier _Supplier $projection.Supplier = _Supplier.Supplier
[0..1] I_SupplierCompany _SupplierCompany $projection.Supplier = _SupplierCompany.Supplier and $projection.CompanyCode = _SupplierCompany.CompanyCode
[0..1] I_Customer _Customer $projection.Customer = _Customer.Customer
[0..1] I_CustomerCompany _CustomerCompany $projection.Customer = _CustomerCompany.Customer and $projection.CompanyCode = _CustomerCompany.CompanyCode
[0..1] I_BatchUsageType _BatchUsageType $projection.BatchUsageType = _BatchUsageType.BatchUsageType

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName CBATCHOBJPGHIST view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Batch History for Batch Object Page view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private false view
VDM.viewType #CONSUMPTION view
UI.headerInfo.typeName Batch History Item view
UI.headerInfo.typeNamePlural Batch History Items view
UI.headerInfo.title.label Batch Usage Type view
UI.headerInfo.title.value BatchUsageTypeText view

Fields (34)

KeyFieldSource TableSource FieldDescription
KEY Plant Plant Valuation Area
KEY Material P_BatchObjPageBatchHistory Material Vehicle Model
KEY Batch Batch Lot No.
KEY MaterialDocumentYear MaterialDocumentYear Material Document Year
KEY MaterialDocument MaterialDocument Material Doc.
KEY MaterialDocumentItem MaterialDocumentItem Material Document Item
ManufacturingOrder ManufacturingOrder Order
ManufacturingOrderItem ManufacturingOrderItem Manufacturing Order Item
PurchaseOrder PurchaseOrder Purchasing Document
PurchaseOrderItem PurchaseOrderItem Purchasing Document Item
SalesOrder SalesOrder SD Document
SalesOrderItem SalesOrderItem Sales Order Item
IsReversalMovementType IsReversalMovementType
PostingDate PostingDate Posting Date for GR
QuantityInBaseUnit QuantityInBaseUnit Quantity
MaterialBaseUnit P_BatchObjPageBatchHistory MaterialBaseUnit Valuation Unit
Supplier Supplier Supplier
BatchBySupplier BatchBySupplier Supplier Batch
Customer Customer Sold-to Party
OutboundDelivery OutboundDelivery LE Delivery
OutboundDeliveryItem OutboundDeliveryItem Logistics Execution Delivery Item
IsGoodsIssueDocument IsGoodsIssueDocument
BatchUsageType BatchUsageType
BatchUsageTypeText
CompanyCode CompanyCode Receiver Company Code
_Plant _Plant
_Material _Material
_Batch _Batch
_Supplier _Supplier
_SupplierCompany _SupplierCompany
_Customer _Customer
_CustomerCompany _CustomerCompany
_MaterialBaseUnit _MaterialBaseUnit
_BatchUsageType _BatchUsageType

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 C_BatchObjPageBatchHistory.
-- 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: CBATCHOBJPGHIST
-- Parameters: P_Language : sylangu

CREATE VIEW C_BatchObjPageBatchHistory AS
SELECT
  Plant,
  P_BatchObjPageBatchHistory.Material AS Material,
  Batch,
  MaterialDocumentYear,
  MaterialDocument,
  MaterialDocumentItem,
  ManufacturingOrder,
  ManufacturingOrderItem,
  PurchaseOrder,
  PurchaseOrderItem,
  SalesOrder,
  SalesOrderItem,
  IsReversalMovementType,
  PostingDate,
  QuantityInBaseUnit,
  P_BatchObjPageBatchHistory.MaterialBaseUnit AS MaterialBaseUnit,
  Supplier,
  BatchBySupplier,
  Customer,
  OutboundDelivery,
  OutboundDeliveryItem,
  IsGoodsIssueDocument,
  BatchUsageType,
  _BatchUsageType._Text[1: Language=$parameters.P_Language].BatchUsageTypeText AS BatchUsageTypeText,
  CompanyCode
FROM P_BatchObjPageBatchHistory
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [1..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_SupplierCompany AS _SupplierCompany ON Supplier = _SupplierCompany.Supplier AND CompanyCode = _SupplierCompany.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_CustomerCompany AS _CustomerCompany ON Customer = _CustomerCompany.Customer AND CompanyCode = _CustomerCompany.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_BatchUsageType AS _BatchUsageType ON BatchUsageType = _BatchUsageType.BatchUsageType  -- association [0..1]
;

Learn More