C_FrcElmntOrgLogisticsDataTP

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_FrcElmntOrgLogisticsDataTP.
-- 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: CFEORGLOGSTP

CREATE VIEW C_FrcElmntOrgLogisticsDataTP AS
SELECT
  _FrcElmntOrgLogisticsDataTP.ForceElementOrgID AS ForceElementOrgID,
  _FrcElmntOrgLogisticsDataTP.ForceElementOrgUUID AS ForceElementOrgUUID,
  _FrcElmntOrgLogisticsDataTP.NumberOfForceElementOrg AS NumberOfForceElementOrg,
  _FrcElmntOrgLogisticsDataTP.FrcElmntOrgPlanVersion AS FrcElmntOrgPlanVersion,
  _FrcElmntOrgLogisticsDataTP.FrcElmntOrgType AS FrcElmntOrgType,
  _FrcElmntOrgLogisticsDataTP.FrcElmntOrgWBSElement AS FrcElmntOrgWBSElement,
  _FrcElmntOrgLogisticsDataTP.FrcElmntOrgStockPlant AS FrcElmntOrgStockPlant,
  _PlantVH.PlantName AS FrcElmntOrgStockPlantName,
  _FrcElmntOrgLogisticsDataTP.FrcElmntOrgMRPStockArea AS FrcElmntOrgMRPStockArea,
  _FrcElmntOrgMRPAreaVH.MRPAreaText AS FrcElmntOrgMRPStockAreaName,
  _FrcElmntOrgLogisticsDataTP.FrcElmntOrgIsAccountableFoEd AS FrcElmntOrgIsAccountable,
  _FrcElmntOrgLogisticsDataTP.FrcElmntOrgProvisionsPlant AS FrcElmntOrgProvisionsPlant,
  _Plant.PlantName AS FrcElmntOrgProvisionsPlantName,
  _FrcElmntOrgLogisticsDataTP.FrcElmntOrgProvisionStorageLoc AS FrcElmntOrgProvisionStorageLoc,
  _FrcElmntOrgLogisticsDataTP.FrcElmntOrgPrvsnMRPArea AS FrcElmntOrgPrvsnMRPArea,
  _MRPAreaStorageLocation.MRPAreaText AS FrcElmntOrgPrvsnMRPAreaName,
  _FrcElmntOrgLogisticsDataTP.FrcElmntOrgIsStockHoldingFoEd AS FrcElmntOrgIsStockHolding,
  _FrcElmntOrgLogisticsDataTP.FrcElmntOrgInitSupSts AS FrcElmntOrgInitSupSts,
  _FrcElmntOrgLogisticsDataTP.FrcElmntOrgPurgOrg AS FrcElmntOrgPurgOrg,
  _FrcElmntOrgLogisticsDataTP.FrcElmntOrgPurgGroup AS FrcElmntOrgPurgGroup,
  _FrcElmntOrgLogisticsDataTP.FrcElmntOrgStockStorageLoc AS FrcElmntOrgStockStorageLoc,
  _FrcElmntOrgLogisticsDataTP.FrcElmntOrgMatlRdnssPct AS FrcElmntOrgMatlRdnssPct,
  _FrcElmntOrgLogisticsDataTP.FrcElmntOrgPrsnlRdnssPct AS FrcElmntOrgPrsnlRdnssPct,
  _FrcElmntOrgLogisticsDataTP.FrcElmntOrgTrngRdnssPct AS FrcElmntOrgTrngRdnssPct,
  _FrcElmntOrgLogisticsDataTP.FrcElmntOrgPriority AS FrcElmntOrgPriority,
  _FrcElmntOrgLogisticsDataTP.FrcElmntOrgLastChgdDteTme AS FrcElmntOrgLastChgdDteTme,
  _FrcElmntOrgLogisticsDataTP.FrcElmntOrgLogsLevel AS FrcElmntOrgLogsLevel,
  _FrcElmntOrgLogisticsDataTP.FrcElmntOrgInfrstrucPlant AS FrcElmntOrgInfrstrucPlant,
  _MRPAreaPlant.PlantName AS FrcElmntOrgInfrstrucPlantName,
  _FrcElmntOrgLogisticsDataTP.FrcElmOrgInfrMRPArea AS FrcElmOrgInfrMRPArea,
  _MRPAreaVH.MRPAreaText AS FrcElmOrgInfrMRPAreaName,
  _FrcElmntOrgLogisticsDataTP.FrcElmOrgInfrStorLoc AS FrcElmOrgInfrStorLoc,
  _FrcElmntOrgLogisticsDataTP.FrcElmntOrgIsInfrstrucMaterial AS FrcElmntOrgIsInfrstrucMaterial,
  _FrcElmntOrgLogisticsDataTP.FrcElmntOrgLastChgdByUser AS FrcElmntOrgLastChgdByUser,
  _FrcElmntOrgLogisticsDataTP.FrcElmntOrgLastChgdDate AS FrcElmntOrgLastChgdDate,
  _FrcElmntOrgLogisticsDataTP.FrcElmntOrgCreatedByUser AS FrcElmntOrgCreatedByUser,
  _FrcElmntOrgLogisticsDataTP.FrcElmntOrgCreationDate AS FrcElmntOrgCreationDate,
  _FrcElmntOrgLogisticsDataTP.FrcElmntOrgLogicalSystem AS FrcElmntOrgLogicalSystem,
  _FrcElmntOrgLogisticsDataTP.FrcElmntOrgMaterialSuplrUUID AS FrcElmntOrgMaterialSuplrUUID,
  _FrcElmntOrgLogisticsDataTP.DfsFrcElmntIsChangeable AS DfsFrcElmntIsChangeable,
  _FrcElmntOrgLogisticsDataTP.FrcElmntOrgIsRefFrcElmntOrg AS FrcElmntOrgIsRefFrcElmntOrg,
  _FrcElmntOrgLogisticsDataTP.FrcElmntOrgReferenceID AS FrcElmntOrgReferenceID,
  _FrcElmntOrgLogisticsDataTP._FrcElmntOrgNtwkGraphNodes AS _FrcElmntOrgNtwkGraphNodes
FROM I_FrcElmntOrgLogisticsDataTP AS _FrcElmntOrgLogisticsDataTP
LEFT OUTER JOIN C_PurchasingGroup AS _PurchasingGroup ON FrcElmntOrgPurgGroup = _PurchasingGroup.PurchasingGroup  -- association [1..1]
LEFT OUTER JOIN C_PurchasingOrgValueHelp AS _PurchasingOrgValueHelp ON FrcElmntOrgPurgOrg = _PurchasingOrgValueHelp.PurchasingOrganization  -- association [0..1]
LEFT OUTER JOIN C_FrcElmntOrgPriorityVH AS _FrcElmntOrgPriorityVH ON FrcElmntOrgPriority = _FrcElmntOrgPriorityVH.FrcElmntOrgPriority AND _FrcElmntOrgPriorityVH.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN C_FrcElmntOrgLogisticsLevelVH AS _FrcElmntOrgLogisticsLevelVH ON FrcElmntOrgLogsLevel = _FrcElmntOrgLogisticsLevelVH.FrcElmntOrgLogsLevel AND _FrcElmntOrgLogisticsLevelVH.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN C_FrcElmntOrgMRPAreaVH AS _FrcElmntOrgMRPAreaVH ON FrcElmntOrgMRPStockArea = _FrcElmntOrgMRPAreaVH.MRPArea AND FrcElmntOrgStockPlant = _FrcElmntOrgMRPAreaVH.MRPAreaPlant  -- association [1..1]
LEFT OUTER JOIN C_FrcElmntOrgStorageLocationVH AS _FrcElmntOrgStorageLocationVH ON FrcElmntOrgStockStorageLoc = _FrcElmntOrgStorageLocationVH.FrcElmntOrgStockStorageLoc  -- association [0..*]
LEFT OUTER JOIN C_Plantvaluehelp AS _PlantVH ON FrcElmntOrgStockPlant = _PlantVH.Plant  -- association [0..1]
LEFT OUTER JOIN C_FrcElmntOrgMRPAreaVH AS _MRPAreaStorageLocation ON FrcElmntOrgPrvsnMRPArea = _MRPAreaStorageLocation.MRPArea AND FrcElmntOrgProvisionsPlant = _MRPAreaStorageLocation.MRPAreaPlant  -- association [1..1]
LEFT OUTER JOIN C_FrcElmntOrgStorageLocationVH AS _FrcElmntOrgStorageLocation ON FrcElmntOrgProvisionStorageLoc = _FrcElmntOrgStorageLocation.FrcElmntOrgProvisionStorageLoc  -- association [0..*]
LEFT OUTER JOIN C_Plantvaluehelp AS _Plant ON FrcElmntOrgProvisionsPlant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN C_FrcElmntOrgMRPAreaVH AS _MRPAreaVH ON FrcElmOrgInfrMRPArea = _MRPAreaVH.MRPArea AND FrcElmntOrgInfrstrucPlant = _MRPAreaVH.MRPAreaPlant  -- association [1..1]
LEFT OUTER JOIN C_FrcElmntOrgStorageLocationVH AS _StorageLocation ON FrcElmOrgInfrStorLoc = _StorageLocation.FrcElmOrgInfrStorLoc  -- association [0..*]
LEFT OUTER JOIN C_FrcElmntPlantToStorLocVH AS _PlantStorLoc ON FrcElmOrgInfrStorLoc = _PlantStorLoc.StorageLocation  -- association [0..*]
LEFT OUTER JOIN C_Plantvaluehelp AS _MRPAreaPlant ON FrcElmntOrgInfrstrucPlant = _MRPAreaPlant.Plant  -- association [0..1]
LEFT OUTER JOIN C_FrcElmntOrgTP AS _FrcElmntOrgTP ON ForceElementOrgID = _FrcElmntOrgTP.ForceElementOrgID  -- association [1..1]
LEFT OUTER JOIN C_FrcElmntOrgVH AS _FrcElmntOrgVH ON ForceElementOrgID = _FrcElmntOrgVH.ForceElementOrgID  -- association [1..*]
LEFT OUTER JOIN C_FrcElmntOrgNodeInfo AS _FrcElmntOrgRefElementVH ON ForceElementOrgID = _FrcElmntOrgRefElementVH.ForceElementOrgID  -- association [1..1]
;