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
  _ProdBufPositioningTP.Material AS Material,
  _ProdBufPositioningTP.Plant AS Plant,
  _ProdBufPositioningTP.MRPArea AS MRPArea,
  _ProdBufPositioningTP.IsYesNoValueSelected AS IsYesNoValueSelected,
  _ProdBufPositioningTP.MaterialBaseUnit AS MaterialBaseUnit,
  _ProdBufPositioningTP.CreatedByUser AS CreatedByUser,
  _ProdBufPositioningTP.CreationTime AS CreationTime,
  _ProdBufPositioningTP.DecoupledLeadTmeChgdByUsr AS DecoupledLeadTmeChgdByUsr,
  _ProdBufPositioningTP.DecoupledLeadTmeChgdOn AS DecoupledLeadTmeChgdOn,
  _UnitOfMeasure.UnitOfMeasure AS LeadTimeUnit,
  _UnitOfMeasure.UnitOfMeasureName AS BaseUnitText,
  _ProdText.ProductName AS MaterialName,
  _Plant.PlantName AS PlantName,
  _MRPArea.MRPAreaText AS MRPAreaText,
  _ProdBufPositioningTP.MRPController AS MRPController,
  _MRPController.MRPControllerName AS MRPControllerName,
  _ProdBufPositioningTP.MRPGroup AS MRPGroup,
  _ProdBufPositioningTP.MRPType AS MRPType,
  _MRPText.MRPTypeName AS MRPTypeName,
  _ProdBufPositioningTP.MRPProcedure AS MRPProcedure,
  _ProdBufPositioningTP.BOMUsageCode AS BOMUsageCode,
  _DomainText[SAPDataDictionaryDomain = 'PPH_PQR_IND' and DomainValue = BOMUsageCode].DomainText as BOMUsageDescription AS DomainTextasBOMUsageDescription,
  _ProdBufPositioningTP.ConsumptionCode AS ConsumptionCode,
  _DomainText[SAPDataDictionaryDomain = 'PPH_ABC_IND' and DomainValue = ConsumptionCode].DomainText as ConsumptionDescription AS DomainTextasConsumptionDescription,
  _ProdBufPositioningTP.ReplenishmentLeadTimeCode AS ReplenishmentLeadTimeCode,
  _DomainText[SAPDataDictionaryDomain = 'PPH_EFG_IND' and DomainValue = ReplenishmentLeadTimeCode].DomainText as ReplenishmentLeadTimeDesc AS DomainTextasReplenishmentLeadTimeDesc,
  _ProdBufPositioningTP.VariabilityCode AS VariabilityCode,
  _DomainText[SAPDataDictionaryDomain = 'PPH_XYZ_IND' and DomainValue = VariabilityCode].DomainText as VariabilityDescription AS DomainTextasVariabilityDescription,
  _ProdBufPositioningTP.ProcurementType AS ProcurementType,
  _DomainText[SAPDataDictionaryDomain = 'PPH_PROC_TYPE' and DomainValue = ProcurementType].DomainText as ProcurementTypeDescription AS DomainTextasProcurementTypeDescription,
  _ProdBufPositioningTP.PlanningTimeFence AS PlanningTimeFence,
  _ProdBufPositioningTP.LotSizingProcedure AS LotSizingProcedure,
  _ProdBufPositioningTP.MaterialMaxStockLevelQuantity AS MaterialMaxStockLevelQuantity,
  _ProdBufPositioningTP.MinimumLotSizeQuantity AS MinimumLotSizeQuantity,
  _ProdBufPositioningTP.ReorderThresholdQuantity AS ReorderThresholdQuantity,
  _ProdBufPositioningTP.SafetyStockQuantity AS SafetyStockQuantity,
  _ProdBufPositioningTP.IsMRPAreaExisting AS IsMRPAreaExisting,
  _ProdBufPositioningTP.ProductIsBuffered AS ProductIsBuffered,
  _DomainText[SAPDataDictionaryDomain = 'PPH_DD_BUFFER_STATUS' and DomainValue = ProductIsBuffered].DomainText as BufferStatusText AS DomainTextasBufferStatusText,
  _ProdBufPositioningTP.ProductAuthorizationGroup AS ProductAuthorizationGroup,
  _ProdBufPositioningTP.ProductTypeAuthorizationGroup AS ProductTypeAuthorizationGroup,
  _ProdBufPositioningTP.ProductGroupAuthorizationGroup AS ProductGroupAuthorizationGroup,
  _ProdBufPositioningTP.BufferedMRPType AS BufferedMRPType,
  _ProdBufPositioningTP.NonBufferedMRPType AS NonBufferedMRPType,
  _ProdBufPositioningTP.MaterialType AS MaterialType,
  _MaterialTypeText.MaterialTypeName AS MaterialTypeName,
  _ProdBufPositioningTP.MaterialGroup AS MaterialGroup,
  _MaterialGroupText.MaterialGroupName AS MaterialGroupName,
  _ProdBufPositioningTP.ProductIsClassified AS ProductIsClassified,
  case when _ProdBufPositioningTP.ProductIsClassified = 'X' then _DomainText[SAPDataDictionaryDomain = 'PPH_DD_PRODUCTISCLASSIFEDTXT' and DomainValue = 'X'].DomainText else _DomainText[SAPDataDictionaryDomain = 'PPH_DD_PRODUCTISCLASSIFEDTXT' and DomainValue = ' '].DomainText end as MaterialStatusText AS DomainTextendasMaterialStatusText,
  _ProdBufPositioningTP.IndividualLeadTime AS IndividualLeadTime,
  _ProdBufPositioningTP.SimulatedDecoupledLeadTime AS SimulatedDecoupledLeadTime,
  _ProdBufPositioningTP.DecoupledLeadTime AS DecoupledLeadTime,
  _SupplierInfo.DDBufPosSupplierInfoTxt AS DDBufPosSupplierInfoTxt,
  _SupplierInfo.SupplierName AS SupplierName,
  _PurOrgInfo.DDBufPosPurgOrgInfoTxt AS DDBufPosPurgOrgInfoTxt,
  _PurOrgInfo.PurchasingOrganizationName AS PurchasingOrganizationName,
  _SalesOrgInfo.DDBufPosSalesOrgInfoTxt AS DDBufPosSalesOrgInfoTxt,
  _SalesOrgInfo.SalesOrganizationName AS SalesOrganizationName,
  _WrkCtrInfo.DDBufPosWrkCtrInfoTxt AS DDBufPosWrkCtrInfoTxt,
  _WrkCtrInfo.WorkCenterText AS WorkCenterText,
  case when _ProdBufPositioningTP.Plant = MRPArea then concat_with_space(concat(_ProdText.ProductName,','), concat(concat(concat(_Plant.PlantName,'('), _ProdBufPositioningTP.Plant),')'), 1) else concat_with_space(concat(_ProdText.ProductName,','), concat_with_space(concat(concat(concat(concat(_Plant.PlantName,'('), _ProdBufPositioningTP.Plant),')'),','), concat(concat(concat(_MRPArea.MRPAreaText,'('), _ProdBufPositioningTP.MRPArea),')'),1), 1) end as PlantName2 AS MRPArea11endasPlantName2,
  concat( concat(concat(concat(_ProdBufPositioningTP.ProcurementType, '-'),_ProdBufPositioningTP.ReplenishmentLeadTimeCode),'-'),_ProdBufPositioningTP.VariabilityCode ) AS ProposedMaterialBufferProfile,
  _ProdBufPositioningTP.ProductIsClassified AS UxFcProductIsClassified,
  _ProdBufPositioningTP.ProductIsClassified AS UxFcVariabilityCode,
  case when _ProdBufPositioningTP.SimulatedDecoupledLeadTime >= 0 then cast(1 as abap.int1) else cast(0 as abap.int1) end as UxFcDecoupledLeadTime AS int1endasUxFcDecoupledLeadTime,
  case when _ProdBufPositioningTP.SimulatedDecoupledLeadTime < 0 or _ProdBufPositioningTP.IsYesNoValueSelected = '' then cast(1 as abap.int1) else cast(0 as abap.int1) end as UxFcDecoupledLeadTmeCalcStsTxt AS int1endasUxFcDecoupledLeadTmeCalcStsTxt,
  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 I_ProductText AS _ProdText ON _ProdText.Product = Material AND _ProdText.Language = $session.system_language  -- 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..*]
LEFT OUTER JOIN I_DDBufPosSupplierInformation AS _SupplierInfo ON Material = _SupplierInfo.Material AND Plant = _SupplierInfo.Plant  -- association [0..1]
LEFT OUTER JOIN I_DDBufPosPurgOrgInformation AS _PurOrgInfo ON _PurOrgInfo.Plant = Plant  -- association [0..1]
LEFT OUTER JOIN I_DDBufPosSalesOrgInformation AS _SalesOrgInfo ON _SalesOrgInfo.Material = Material  -- association [0..1]
LEFT OUTER JOIN I_DDBufPosWorkCenterInfo AS _WrkCtrInfo ON _WrkCtrInfo.Material = Material AND _WrkCtrInfo.Plant = Plant  -- association [0..1]
LEFT OUTER JOIN I_DDHistlBufDomainFxdValTxt AS _DomainText ON _DomainText.SAPDataDictionaryDomain = 'PPH_DD_BUFFER_STATUS' OR _DomainText.SAPDataDictionaryDomain = 'PPH_PROC_TYPE' OR _DomainText.SAPDataDictionaryDomain = 'PPH_XYZ_IND' OR _DomainText.SAPDataDictionaryDomain = 'PPH_EFG_IND' OR _DomainText.SAPDataDictionaryDomain = 'PPH_ABC_IND' OR _DomainText.SAPDataDictionaryDomain = 'PPH_PQR_IND' OR _DomainText.SAPDataDictionaryDomain = 'PPH_DD_CALCULATIONSTATUSTEXT' OR _DomainText.SAPDataDictionaryDomain = 'PPH_DD_PRODUCTISCLASSIFEDTXT' OR _DomainText.SAPDataDictionaryDomain = 'PPH_EFG_LONGTEXT' OR _DomainText.SAPDataDictionaryDomain = 'PPH_XYZ_LONGTEXT'  -- association [0..*]
LEFT OUTER JOIN I_MRPTypeText AS _MRPText ON MRPType = _MRPText.MRPType AND _MRPText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_MaterialTypeText AS _MaterialTypeText ON _MaterialTypeText.MaterialType = MaterialType AND _MaterialTypeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_MaterialGroupText AS _MaterialGroupText ON _MaterialGroupText.MaterialGroup = MaterialGroup AND _MaterialGroupText.Language = $session.system_language  -- association [0..1]
;