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_TrackToolUsageTP.
-- 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: CTTTUTRACKTOOLTP
CREATE VIEW C_TrackToolUsageTP AS
SELECT
TrackToolUsage.Equipment AS Equipment,
TrackToolUsage.Material AS Material,
TrackToolUsage._Equipment._EquipmentText[1: Language = $session.system_language ].EquipmentName AS EquipmentName,
TrackToolUsage._Material._Text[ 1: Language = $session.system_language ].MaterialName AS MaterialName,
TrackToolUsage.SerialNumber AS SerialNumber,
TrackToolUsage._Equipment.UniqueItemIdentifier AS UniqueItemIdentifier,
TrackToolUsage.Plant AS Plant,
_Plant.PlantName AS PlantName,
TrackToolUsage.MaintenancePlant AS MaintenancePlant,
_MaintenancePlant.PlantName AS MaintenancePlantName,
TrackToolUsage.StorageLocation AS StorageLocation,
_StorageLocation.StorageLocationName AS StorageLocationName,
case when EquipmentIsClaimed = 'X' then _TrackToolUsageHistory._ClaimUserDescription.UserDescription end as UserDescription AS UserDescriptionendasUserDescription,
EquipmentHistoryDocument,
cast('' as abap.char(100) ) AS EquipmentClaimedForText,
_BusinessUser.BusinessPartnerName AS BusinessPartnerName,
_BusinessUser.UserID AS UserID,
TrackToolUsage.OrderID AS OrderID,
TrackToolUsage.Operation AS Operation,
TrackToolUsage.OpActyNtwkElementExternalID AS OpActyNtwkElementExternalID,
TrackToolUsage.OperationActivityName AS OperationActivityName,
WorkCenter,
_WorkCenter._Text[1: Language = $session.system_language].WorkCenterText AS WorkCenterText,
TrackToolUsage.EquipClaimDurationInSeconds AS EquipClaimDurationInSeconds,
cast('' as text100) AS EquipmentClaimDurationText,
TrackToolUsage.WorkCenterInternalID AS WorkCenterInternalID,
TrackToolUsage.EquipmentCategory AS EquipmentCategory,
TrackToolUsage.MaintObjectInternalID AS MaintObjectInternalID,
cast('' as abap_boolean ) AS EquipmentClaimIsAvailable,
EquipmentIsClaimed,
EquipmentIsOnHold,
3 AS Criticality,
'X' AS TechObjIsEquipOrFuncnlLoc,
BusinessPartner,
_TechnicalObject[inner].TechnicalObject AS TechnicalObject,
_TechnicalObject[inner].TechnicalObjectCategory AS TechnicalObjectCategory,
_TechnicalObject[inner]._TechnicalObjectCategory._Text[1:Language = $session.system_language].TechnicalObjectCategoryDesc AS TechnicalObjectCategoryDesc,
_TechnicalObject[inner].AssetManufacturerName AS AssetManufacturerName,
_TechnicalObject[inner].ManufacturerPartTypeName AS ManufacturerPartTypeName,
_TechnicalObject[inner].ManufacturerPartNmbr AS ManufacturerPartNmbr,
_TechnicalObject[inner].ManufacturerSerialNumber AS ManufacturerSerialNumber,
_TechnicalObject[inner]._LocationAccountAssignment.PlantSection AS PlantSection,
_TechnicalObject[inner]._LocationAccountAssignment._PlantSection.PlantSectionPersonRespName AS PlantSectionPersonRespName,
_TechnicalObject[inner]._LocationAccountAssignment._PlantSection.PlantSectionPersonRespPhone AS PlantSectionPersonRespPhone,
_TechnicalObject[inner]._LocationAccountAssignment.AssetLocation AS AssetLocation,
_TechnicalObject[inner]._LocationAccountAssignment._Location.LocationName AS LocationName,
_TechnicalObject[inner]._LocationAccountAssignment.AssetRoom AS AssetRoom,
_TechnicalObject[inner]._LocationAccountAssignment.ABCIndicator AS ABCIndicator,
_TechnicalObject[inner]._LocationAccountAssignment._ABCIndicator._Text[1:Language=$session.system_language].ABCIndicatorDesc AS ABCIndicatorDesc,
_TechnicalObject[inner]._LocationAccountAssignment._Address.PostalCode AS PostalCode,
_TechnicalObject[inner]._LocationAccountAssignment._Address.CityName AS CityName,
_TechnicalObject[inner].SuperiorTechnicalObjectLabel AS SuperiorTechnicalObjectLabel,
_TechnicalObject[inner].SuperiorTechnicalObjectName AS SuperiorTechnicalObjectName,
_TechnicalObject[inner].SuperiorObjIsEquipOrFuncnlLoc AS SuperiorObjIsEquipOrFuncnlLoc,
_TechnicalObject[inner].TechnicalObjectSortCode AS TechnicalObjectSortCode,
_TechnicalObject[inner].MaintenancePlanningPlant AS MaintenancePlanningPlant,
_TechnicalObject[inner]._MaintenancePlanningPlant.PlantName AS MaintenancePlanningPlantName,
_TechnicalObject[inner].MaintenancePlannerGroup AS MaintenancePlannerGroup,
_TechnicalObject[inner]._MaintenancePlannerGroup.MaintenancePlannerGroupName AS MaintenancePlannerGroupName,
_TechnicalObject[inner]._WorkCenter.WorkCenter AS MainWorkCenter,
_TechnicalObject[inner]._WorkCenter._Text[ 1:Language = $session.system_language ].WorkCenterText AS MainWorkCenterDescription,
_TechnicalObject[inner]._WorkCenter.Plant AS MainWorkCenterPlant,
_TechnicalObject[inner]._WorkCenter._Plant.PlantName AS MainWorkCenterPlantName,
_TechnicalObject[inner]._LocationAccountAssignment.CompanyCode AS CompanyCode,
_TechnicalObject[inner]._LocationAccountAssignment._CompanyCode.CompanyCodeName AS CompanyCodeName,
_TechnicalObject[inner]._LocationAccountAssignment.BusinessArea AS BusinessArea,
_TechnicalObject[inner]._LocationAccountAssignment._BusinessArea._Text[1:Language=$session.system_language].BusinessAreaName AS BusinessAreaName,
_TechnicalObject[inner]._LocationAccountAssignment.MasterFixedAsset AS MasterFixedAsset,
_TechnicalObject[inner]._LocationAccountAssignment._MasterFixedAsset.MasterFixedAssetDescription AS MasterFixedAssetDescription,
_TechnicalObject[inner]._LocationAccountAssignment.FixedAsset AS FixedAsset,
_TechnicalObject[inner]._LocationAccountAssignment.CostCenter AS CostCenter,
_TechnicalObject[inner]._LocationAccountAssignment._CostCenter[1:ValidityEndDate>=$session.system_date and ValidityStartDate<=$session.system_date]._Text[1:Language=$session.system_language].CostCenterName AS CostCenterName,
_TechnicalObject[inner]._LocationAccountAssignment.ControllingArea AS ControllingArea,
_TechnicalObject[inner]._LocationAccountAssignment._ControllingArea.ControllingAreaName AS ControllingAreaName,
_TechnicalObject[inner]._LocationAccountAssignment._WBSElementBasicData.WBSElement AS WBSElement,
_TechnicalObject[inner]._LocationAccountAssignment._WBSElementBasicData.WBSDescription AS WBSDescription,
_TechnicalObject[inner]._LocationAccountAssignment.StandingOrderNumber AS StandingOrderNumber,
_TechnicalObject[inner]._LocationAccountAssignment._StandingOrderNumber.MaintenanceOrderDesc AS StandingOrderDesc,
_TechnicalObject[inner]._LocationAccountAssignment.SettlementOrder AS SettlementOrder,
_TechnicalObject[inner]._LocationAccountAssignment._SettlementOrder.OrderDescription AS SettlementOrderDesc,
_TechnicalObject[inner].CreatedByUser AS CreatedByUser,
_TechnicalObject[inner].CreationDate AS CreationDate,
_TechnicalObject[inner].LastChangedByUser AS LastChangedByUser,
_TechnicalObject[inner].LastChangeDate AS LastChangeDate,
_TechnicalObject[inner].TechnicalObjectHasLongText AS TechnicalObjectHasLongText,
_TechnicalObject[inner].InventoryNumber AS InventoryNumber,
_TechnicalObject[inner].GrossWeight AS GrossWeight,
_TechnicalObject[inner].GrossWeightUnit AS GrossWeightUnit,
_TechnicalObject[inner].SizeOrDimensionText AS SizeOrDimensionText,
_TechnicalObject[inner]._LocationAccountAssignment.MaintObjectFreeDefinedAttrib AS MaintObjectFreeDefinedAttrib,
_TechnicalObject[inner]._LocationAccountAssignment.SalesOrganization AS SalesOrganization,
_TechnicalObject[inner]._LocationAccountAssignment.DistributionChannel AS DistributionChannel,
_TechnicalObject[inner]._LocationAccountAssignment.OrganizationDivision AS Division,
_TechnicalObject[inner]._LocationAccountAssignment.SalesOffice AS SalesOffice,
_TechnicalObject[inner]._LocationAccountAssignment.SalesGroup AS SalesGroup,
TrackToolUsage.AuthorizationGroup AS AuthorizationGroup
FROM I_TrackToolUsageTP AS TrackToolUsage
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant -- association [0..1]
LEFT OUTER JOIN I_Plant AS _MaintenancePlant ON MaintenancePlant = _MaintenancePlant.Plant -- association [0..1]
LEFT OUTER JOIN I_TrackToolUsageHistory AS _TrackToolUsageHistory ON Equipment = _TrackToolUsageHistory.Equipment AND EquipmentHistoryDocument = _TrackToolUsageHistory.EquipmentHistoryDocument -- association [0..1]
LEFT OUTER JOIN I_StorageLocation AS _StorageLocation ON StorageLocation = _StorageLocation.StorageLocation AND Plant = _StorageLocation.Plant -- association [0..1]
LEFT OUTER JOIN C_TrackToolUsageHistoryData AS _UsageHistoryData ON Equipment = _UsageHistoryData.Equipment -- association [0..*]
LEFT OUTER JOIN I_TrackToolUsageHistoryData AS _UsageHistoryDataMax ON EquipmentHistoryDocument = _UsageHistoryDataMax.EquipmentHistoryDocument -- association [0..1]
LEFT OUTER JOIN C_TrackToolUsageOpActyEquip AS _TrackToolUsageOpActyEquip ON Equipment = _TrackToolUsageOpActyEquip.Equipment -- association [0..*]
LEFT OUTER JOIN I_EquipmentStdVH AS _EquipmentStdVH ON Equipment = _EquipmentStdVH.Equipment -- association [1..1]
LEFT OUTER JOIN C_TrackToolUsgeHistOpActyByDoc AS _UsgeHistOpActyByDoc ON EquipmentHistoryDocument = _UsgeHistOpActyByDoc.EquipmentHistoryDocument -- association [0..*]
LEFT OUTER JOIN C_MfgBusinessPartnerVH AS _BusinessUser ON BusinessPartner = _BusinessUser.MfgBusinessPartner -- association [0..*]
LEFT OUTER JOIN C_StsObjActiveStatusCodeText AS _ActiveSystemStatus ON _ActiveSystemStatus.StatusObject = MaintObjectInternalID AND _ActiveSystemStatus.IsUserStatus = '' -- association [0..*]
LEFT OUTER JOIN C_StsObjActiveStatusCodeText AS _ActiveUserStatus ON _ActiveUserStatus.StatusObject = MaintObjectInternalID AND _ActiveUserStatus.IsUserStatus = 'X' -- association [0..*]
LEFT OUTER JOIN C_OpActyInstceEquipRegnHistory AS _OpActyInstceEquipRegnHistory ON Equipment = _OpActyInstceEquipRegnHistory.Equipment -- association [0..*]
LEFT OUTER JOIN C_ObjPgTechnicalObject AS _TechnicalObject ON _TechnicalObject.TechnicalObject = Equipment AND _TechnicalObject.TechObjIsEquipOrFuncnlLoc = 'EAMS_EQUI' -- association [1..1]
LEFT OUTER JOIN I_SalesOrganizationText AS _SalesOrgText ON _SalesOrgText.SalesOrganization = SalesOrganization -- association [0..*]
LEFT OUTER JOIN I_DistributionChannelText AS _DistributionChannelText ON _DistributionChannelText.DistributionChannel = DistributionChannel -- association [0..*]
LEFT OUTER JOIN I_DivisionText AS _DivisionText ON _DivisionText.Division = Division -- association [0..*]
LEFT OUTER JOIN I_SalesOfficeText AS _SalesOfficeText ON _SalesOfficeText.SalesOffice = SalesOffice -- association [0..*]
LEFT OUTER JOIN I_SalesGroupText AS _SalesGroupText ON _SalesGroupText.SalesGroup = SalesGroup -- association [0..*]
LEFT OUTER JOIN I_Location AS _LocationText ON _LocationText.Location = assetlocation AND _LocationText.Plant = MaintenancePlant -- association [0..1]
LEFT OUTER JOIN I_MaintenancePlannerGroup AS _MaintenancePlannerGroupText ON _MaintenancePlannerGroupText.MaintenancePlanningPlant = maintenanceplanningplant AND _MaintenancePlannerGroupText.MaintenancePlannerGroup = maintenanceplannergroup -- association [0..1]
;