P_RequisitionTypeAnalysis2

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_RequisitionTypeAnalysis2.
-- 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: PMMREQTYPEANA0
-- Parameters: P_StartDate : budat, P_EndDate : budat

CREATE VIEW P_RequisitionTypeAnalysis2 AS
SELECT
  RequisitionItem.PurchaseRequisition AS PurchaseRequisition,
  RequisitionItem.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  PurchasingGroup,
  PurchasingOrganization,
  FixedSupplier,
  RequisitionItem.MaterialGroup AS MaterialGroup,
  BaseUnit,
  RequestedQuantity,
  PurReqnPriceQuantity,
  PurReqnItemCurrency,
  PurchaseRequisitionPrice,
  Material,
  Plant,
  PurchaseRequisitionType,
  CreatedByUser,
  PurReqnOrigin,
  CreationDate,
  cast ( '02' as mm_a_pur_reqn_item_classfctn ) AS PurReqnItemClassification,
  cast( 1 as abap.int4 ) AS PurReqnItemClassfctnCount,
  cast( 1 as nmbr_free_txt_via_fiori_appl ) AS NmbrOfFreeTxtItmCrtedFrmSSP,
  cast( 0 as nmbr_material_via_fiori_appl ) AS NmbrOfMaterialItmCrtedFrmSSP,
  cast( 0 as nmbr_catalog_via_fiori_appl ) AS NmbrOfCatalogItmCrtedFrmSSP,
  cast( 0 as nmbr_material_via_me51n ) AS NmbrOfMaterialItmCrtedManually,
  cast( 0 as nmbr_free_txt_via_me51n ) AS NmbrOfFreeTxtItmCrtedManually,
  cast( 0 as nmbr_material_via_extnl_source ) AS NmbrOfMatlItmCrtedFrmExtSrce
FROM I_PurchaseRequisitionItemBasic AS RequisitionItem
-- UNION ALL with additional select branch(es): I_PurchaseRequisitionItemBasic
;