P_DGR_StorQtyHist_ApplData

DDL: P_DGR_STORQTYHIST_APPLDATA SQL: PDGRSQHAPPLDATA Type: view COMPOSITE
47 Fields 3 Data Sources

P_DGR_StorQtyHist_ApplData is a Composite CDS View in SAP S/4HANA. It reads from 3 data sources (I_ACMApplDocData, P_DGR_StorQtyHist_BPClassType, P_DGR_StorQtyHist_FillPhysCmdt) and exposes 47 fields with key fields ApplicationDocument, ApplicationDocumentItem, QuantityHistorySequenceNumber.

Data Sources (3)

SourceAliasJoin Type
I_ACMApplDocData ApplData left_outer
P_DGR_StorQtyHist_BPClassType BpClassType left_outer
P_DGR_StorQtyHist_FillPhysCmdt P_DGR_StorQtyHist_FillPhysCmdt from

Parameters (3)

NameTypeDefault
P_DisplayUnitOfMeasure cds_dgr_display_uom
P_DailyGrainReportType cds_dgr_report_type
P_DailyGrainReportDate cds_dgr_date

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PDGRSQHAPPLDATA view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ClientHandling.type #CLIENT_DEPENDENT view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (47)

KeyFieldSource TableSource FieldDescription
KEY ApplicationDocument StorageQH ApplicationDocument Appl. Document No.
KEY ApplicationDocumentItem
KEY QuantityHistorySequenceNumber StorageQH QuantityHistorySequenceNumber
QuantityHistoryParentItem StorageQH QuantityHistoryParentItem
QtyHistoryParentSequenceNumber StorageQH QtyHistoryParentSequenceNumber
QuantityHistoryChildItem StorageQH QuantityHistoryChildItem
Material StorageQH Material Vehicle Model
PhysicalCommodity StorageQH PhysicalCommodity
Creditor StorageQH Creditor Supplier
StorageQuantityInBaseUoM StorageQH StorageQuantityInBaseUoM
StorageQuantityBaseUnit StorageQH StorageQuantityBaseUnit
StorageQuantity StorageQH StorageQuantity
StorageQuantityUnit StorageQH StorageQuantityUnit
den_conv StorageQH den_conv Qty Conv.
num_conv StorageQH num_conv Qty Conv. Denomin.
StorageAgreement StorageQH StorageAgreement
StorageAgreementItem StorageQH StorageAgreementItem
QtyHistoryValidityStartDate StorageQH QtyHistoryValidityStartDate
QtyHistoryValidityStartTmstp StorageQH QtyHistoryValidityStartTmstp
QtyHistoryValidityEndDate StorageQH QtyHistoryValidityEndDate
QtyHistoryValidityEndTmstp StorageQH QtyHistoryValidityEndTmstp
TotalNumberOfStorageDays StorageQH TotalNumberOfStorageDays
WarehouseReceiptedQuantity StorageQH WarehouseReceiptedQuantity
WarehouseReceiptedQuantityUnit StorageQH WarehouseReceiptedQuantityUnit
QtyHistoryCreationDateTime StorageQH QtyHistoryCreationDateTime
QtyHistoryChangedDateTime StorageQH QtyHistoryChangedDateTime
EvaluationDate StorageQH EvaluationDate
ApplicationStatusObject I_ACMApplDocData ApplicationStatusObject Object number
StorageStartDate I_ACMApplDocData StorageStartDate Storage Start Date
StorageEndDate I_ACMApplDocData StorageEndDate Storage End Date
WarehouseReceiptType I_ACMApplDocData WarehouseReceiptType WHR Type
WarehouseReceiptNo I_ACMApplDocData WarehouseReceiptNo WHR Number
WarehouseStartDate I_ACMApplDocData WarehouseStartDate Warehouse Start Date
WarehouseEndDate I_ACMApplDocData WarehouseEndDate WHR End Date
ObligationType I_ACMApplDocData ObligationType Obligation Type
Plant I_ACMApplDocData Plant Valuation Area
StorageLocation I_ACMApplDocData StorageLocation StorageLocation
MaterialGroup I_ACMApplDocData MaterialGroup Product Group
LoadDataCaptureObjectID I_ACMApplDocData LoadDataCaptureObjectID LDC ID
LoadDataObjectUUID I_ACMApplDocData LoadDataObjectUUID LDC Key
LoadDataObjectType I_ACMApplDocData LoadDataObjectType LDC Type
CompanyCode I_ACMApplDocData CompanyCode Receiver Company Code
Vendor I_ACMApplDocData Supplier Supplier
LoadDataCaptureApplInstruction I_ACMApplDocData LDCApplInstructionValue Application Instr.
partner P_DGR_StorQtyHist_BPClassType partner With Partner
partner_guid P_DGR_StorQtyHist_BPClassType partner_guid Partner GUID
DailyGrainReportDisplayUnit

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_StorQtyHist_ApplData.
-- 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: PDGRSQHAPPLDATA
-- Parameters: P_DisplayUnitOfMeasure : cds_dgr_display_uom, P_DailyGrainReportType : cds_dgr_report_type, P_DailyGrainReportDate : cds_dgr_date

CREATE VIEW P_DGR_StorQtyHist_ApplData AS
SELECT
  StorageQH.ApplicationDocument AS ApplicationDocument,
  cast(right(StorageQH.ApplicationDocumentItem, 6) as abap.numc( 6) ) AS ApplicationDocumentItem,
  StorageQH.QuantityHistorySequenceNumber AS QuantityHistorySequenceNumber,
  StorageQH.QuantityHistoryParentItem AS QuantityHistoryParentItem,
  StorageQH.QtyHistoryParentSequenceNumber AS QtyHistoryParentSequenceNumber,
  StorageQH.QuantityHistoryChildItem AS QuantityHistoryChildItem,
  StorageQH.Material AS Material,
  StorageQH.PhysicalCommodity AS PhysicalCommodity,
  StorageQH.Creditor AS Creditor,
  StorageQH.StorageQuantityInBaseUoM AS StorageQuantityInBaseUoM,
  StorageQH.StorageQuantityBaseUnit AS StorageQuantityBaseUnit,
  StorageQH.StorageQuantity AS StorageQuantity,
  StorageQH.StorageQuantityUnit AS StorageQuantityUnit,
  StorageQH.den_conv AS den_conv,
  StorageQH.num_conv AS num_conv,
  StorageQH.StorageAgreement AS StorageAgreement,
  StorageQH.StorageAgreementItem AS StorageAgreementItem,
  StorageQH.QtyHistoryValidityStartDate AS QtyHistoryValidityStartDate,
  StorageQH.QtyHistoryValidityStartTmstp AS QtyHistoryValidityStartTmstp,
  StorageQH.QtyHistoryValidityEndDate AS QtyHistoryValidityEndDate,
  StorageQH.QtyHistoryValidityEndTmstp AS QtyHistoryValidityEndTmstp,
  StorageQH.TotalNumberOfStorageDays AS TotalNumberOfStorageDays,
  StorageQH.WarehouseReceiptedQuantity AS WarehouseReceiptedQuantity,
  StorageQH.WarehouseReceiptedQuantityUnit AS WarehouseReceiptedQuantityUnit,
  StorageQH.QtyHistoryCreationDateTime AS QtyHistoryCreationDateTime,
  StorageQH.QtyHistoryChangedDateTime AS QtyHistoryChangedDateTime,
  StorageQH.EvaluationDate AS EvaluationDate,
  ApplData.ApplicationStatusObject AS ApplicationStatusObject,
  ApplData.StorageStartDate AS StorageStartDate,
  ApplData.StorageEndDate AS StorageEndDate,
  ApplData.WarehouseReceiptType AS WarehouseReceiptType,
  ApplData.WarehouseReceiptNo AS WarehouseReceiptNo,
  ApplData.WarehouseStartDate AS WarehouseStartDate,
  ApplData.WarehouseEndDate AS WarehouseEndDate,
  ApplData.ObligationType AS ObligationType,
  ApplData.Plant AS Plant,
  ApplData.StorageLocation AS StorageLocation,
  ApplData.MaterialGroup AS MaterialGroup,
  ApplData.LoadDataCaptureObjectID AS LoadDataCaptureObjectID,
  ApplData.LoadDataObjectUUID AS LoadDataObjectUUID,
  ApplData.LoadDataObjectType AS LoadDataObjectType,
  ApplData.CompanyCode AS CompanyCode,
  ApplData.Supplier AS Vendor,
  ApplData.LDCApplInstructionValue AS LoadDataCaptureApplInstruction,
  BpClassType.partner AS partner,
  BpClassType.partner_guid AS partner_guid,
  $parameters.P_DisplayUnitOfMeasure AS DailyGrainReportDisplayUnit
FROM P_DGR_StorQtyHist_FillPhysCmdt
LEFT OUTER JOIN I_ACMApplDocData AS ApplData ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_DGR_StorQtyHist_BPClassType AS BpClassType ON /* join condition not captured in parsed metadata */
;

Learn More