C_ProdBufPositioningTP

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_ProdBufPositioningTP.
-- 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: CPRODBUFPOSTP

CREATE VIEW C_ProdBufPositioningTP AS
SELECT
  Material,
  _ProdBufPositioningTP.Plant AS Plant,
  MRPArea,
  MaterialBaseUnit,
  CreatedByUser,
  AvgDailyUsgeChgdByUsr,
  CreationTime,
  AvgDailyUsgeChgdOn,
  DecoupledLeadTmeChgdByUsr,
  DecoupledLeadTmeChgdOn,
  _UnitOfMeasure.UnitOfMeasure AS LeadTimeUnit,
  _UnitOfMeasure.UnitOfMeasureName AS BaseUnitText,
  _ProdBufPositioningTP._Material._Text[1:Language = $session.system_language].ProductName AS MaterialName,
  _Plant.PlantName AS PlantName,
  _MRPArea.MRPAreaText AS MRPAreaText,
  _ProdBufPositioningTP.MRPController AS MRPController,
  _MRPController.MRPControllerName AS MRPControllerName,
  MRPGroup,
  MRPType,
  cast('' as dibez) AS MRPTypeName,
  MRPProcedure,
  BOMUsageCode,
  cast('' as val_text) AS BOMUsageDescription,
  ConsumptionCode,
  cast('' as val_text) AS ConsumptionDescription,
  ReplenishmentLeadTimeCode,
  cast('' as val_text) AS ReplenishmentLeadTimeDesc,
  VariabilityCode,
  cast('' as val_text) AS VariabilityDescription,
  ProcurementType,
  cast('' as val_text) AS ProcurementTypeDescription,
  PlanningTimeFence,
  LotSizingProcedure,
  MaterialMaxStockLevelQuantity,
  MinimumLotSizeQuantity,
  ReorderThresholdQuantity,
  SafetyStockQuantity,
  DDScopeProduct,
  _DDScopeValueHelp.DDScopeProductDescription AS DDScopeProductDescription,
  IsMRPAreaExisting,
  ProductIsBuffered,
  cast('' as val_text) AS BufferStatusText,
  ProductAuthorizationGroup,
  ProductTypeAuthorizationGroup,
  ProductGroupAuthorizationGroup,
  BufferedMRPType,
  NonBufferedMRPType,
  MaterialType,
  cast('' as producttypename) AS MaterialTypeName,
  MaterialGroup,
  cast('' as productgroupdescription) AS MaterialGroupName,
  cast('' as xfeld) AS ProductIsClassified,
  cast('' as val_text) AS MaterialStatusText,
  IndividualLeadTime,
  AverageDailyUsage,
  SimulatedDecoupledLeadTime,
  DecoupledLeadTime,
  cast('' as pph_dd_dltcalcstatus ) AS DecoupledLeadTimeCalcStsTxt,
  cast( '' as lifnr ) AS Supplier,
  cast('' as md_supplier_name ) AS SupplierName,
  cast('' as ekorg_ll ) AS PurchasingOrganization,
  cast('' as vkorg ) AS SalesOrganization,
  cast('' as pph_arbpl ) AS WorkCenter,
  cast('' as workcentertext ) AS WorkCenterText,
  cast('' as salesorganizationname ) AS SalesOrganizationName,
  cast(' ' as mm_a_purg_org_name ) AS PurchasingOrganizationName,
  cast('' as abap.sstring(1333)) AS PlantName2,
  cast('' as pph_materialbufferprofiletxt ) AS ProposedMaterialBufferProfile,
  cast('' as abap.char(200)) AS ProposedMatlBufferProfileText,
  cast(0 as abap.int1) AS UxFcProductIsClassified,
  cast(0 as abap.int1) AS UxFcVariabilityCode,
  cast(0 as abap.int1) AS UxFcDecoupledLeadTime,
  cast(0 as abap.int1) AS UxFcDecoupledLeadTmeCalcStsTxt,
  cast( ' ' as pph_dd_extbufhndlgisenabled ) AS ExtBufHndlgIsEnabled,
  IsBulkMaterial,
  IsPhantomItem
FROM I_ProdBufPositioningTP AS _ProdBufPositioningTP
INNER JOIN C_SDMAreaOfResponsibility AS _SDMAreaOfResponsibility ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Plant AS _Plant ON _ProdBufPositioningTP.Plant = _Plant.Plant  -- association [1..1]
LEFT OUTER JOIN I_MRPArea AS _MRPArea ON MRPArea = _MRPArea.MRPArea  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasureText AS _UnitOfMeasure ON _UnitOfMeasure.UnitOfMeasure = 'TAG' AND _UnitOfMeasure.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_MRPController AS _MRPController ON Plant = _MRPController.Plant AND _ProdBufPositioningTP.MRPController = _MRPController.MRPController  -- association [1..1]
LEFT OUTER JOIN C_DDScopeProductVH AS _DDScopeValueHelp ON DDScopeProduct = _DDScopeValueHelp.DDScopeProduct  -- association [1..1]
LEFT OUTER JOIN C_ProductBufferSalesData AS _ProductSales ON Material = _ProductSales.Material  -- association [0..*]
LEFT OUTER JOIN C_PlantPurchasingOrganization AS _PurchasingOrg ON Plant = _PurchasingOrg.Plant  -- association [0..*]
LEFT OUTER JOIN C_ProductSupplierBySourceDoc AS _Supplier ON Material = _Supplier.Material AND Plant = _Supplier.Plant  -- association [0..*]
LEFT OUTER JOIN C_ProductsByWorkCenter AS _WorkCenter ON Material = _WorkCenter.Material AND Plant = _WorkCenter.Plant  -- association [1..*]
LEFT OUTER JOIN C_ProductBOMUpstream AS _BOMUpstream ON Material = _BOMUpstream.Material AND Plant = _BOMUpstream.Plant AND MRPArea = _BOMUpstream.MRPArea  -- association [1..*]
LEFT OUTER JOIN C_BOMUpstreamAndDownstream AS _BOMNetwork ON Material = _BOMNetwork.Material AND Plant = _BOMNetwork.Plant AND MRPArea = _BOMNetwork.MRPArea  -- association [1..*]
LEFT OUTER JOIN C_BOMDwnStreamDirectParent AS _BOMDownStreamDP ON Material = _BOMDownStreamDP.BillOfMaterialComponent AND Plant = _BOMDownStreamDP.Plant  -- association [1..*]
LEFT OUTER JOIN C_BOMDwnStreamNextBuffered AS _BOMDownStreamNxtBuff ON Material = _BOMDownStreamNxtBuff.Material AND Plant = _BOMDownStreamNxtBuff.Plant  -- association [1..*]
LEFT OUTER JOIN C_BOMDwnStreamFinishedProd AS _BOMDownStreamFP ON Material = _BOMDownStreamFP.Material AND Plant = _BOMDownStreamFP.Plant  -- association [1..*]
;