P_DGR_BeginBookBal_ValidQtyRec

DDL: P_DGR_BEGINBOOKBAL_VALIDQTYREC SQL: PDGRBBBVALIDREC Type: view COMPOSITE
7 Fields 2 Data Sources

P_DGR_BeginBookBal_ValidQtyRec is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_DailyGrainRepBeginBookBal, P_DGR_BeginBookBal_ValidDate) and exposes 7 fields with key fields Plant, Material, StorageLocation, BeginingBookBalanceDate.

Data Sources (2)

SourceAliasJoin Type
I_DailyGrainRepBeginBookBal BBB from
P_DGR_BeginBookBal_ValidDate P_DGR_BeginBookBal_ValidDate left_outer

Parameters (1)

NameTypeDefault
P_DailyGrainReportDate cds_dgr_date

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PDGRBBBVALIDREC view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
VDM.private true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY Plant I_DailyGrainRepBeginBookBal Plant Valuation Area
KEY Material I_DailyGrainRepBeginBookBal Material Vehicle Model
KEY StorageLocation I_DailyGrainRepBeginBookBal StorageLocation StorageLocation
KEY BeginingBookBalanceDate BeginningBookBalanceDate
BeginingBookBalanceQuantity BeginningBookBalanceQuantity
BeginingBookBalanceUnit BeginningBookBalanceUnit
ValidBeginingBookBalanceDate ValidBeginingBookBalanceDate

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 P_DGR_BeginBookBal_ValidQtyRec.
-- 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: PDGRBBBVALIDREC
-- Parameters: P_DailyGrainReportDate : cds_dgr_date

CREATE VIEW P_DGR_BeginBookBal_ValidQtyRec AS
SELECT
  BBB.Plant AS Plant,
  BBB.Material AS Material,
  BBB.StorageLocation AS StorageLocation,
  BeginningBookBalanceDate AS BeginingBookBalanceDate,
  BeginningBookBalanceQuantity AS BeginingBookBalanceQuantity,
  BeginningBookBalanceUnit AS BeginingBookBalanceUnit,
  ValidBeginingBookBalanceDate
FROM I_DailyGrainRepBeginBookBal AS BBB
LEFT OUTER JOIN P_DGR_BeginBookBal_ValidDate ON /* join condition not captured in parsed metadata */
;

Learn More