I_LocationAccountAssignment

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 I_LocationAccountAssignment.
-- 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.

CREATE VIEW I_LocationAccountAssignment AS
SELECT
  iloa.iloan AS MaintObjectLocAcctAssgmtNmbr,
  iloa.ppsid AS WorkCenterInternalID,
  iloa.cr_objty AS WorkCenterTypeCode,
  iloa.tplnr AS FunctionalLocation,
  iloa.swerk AS MaintenancePlant,
  iloa.beber AS PlantSection,
  iloa.stort AS AssetLocation,
  iloa.eqfnr AS MaintObjectFreeDefinedAttrib,
  iloa.gsber AS BusinessArea,
  iloa.kokrs AS ControllingArea,
  iloa.kostl AS CostCenter,
  iloa.bukrs AS CompanyCode,
  iloa.spart AS Division,
  iloa.stort AS MaintenanceObjectLocation,
  iloa.msgrp AS AssetRoom,
  iloa.abckz AS ABCIndicator,
  iloa.adrnr AS AddressID,
  iloa.proid AS WBSElementInternalID,
  iloa.anlnr AS MasterFixedAsset,
  iloa.anlun AS FixedAsset,
  iloa.aufnr AS SettlementOrder,
  iloa.daufn AS StandingOrderNumber,
  iloa.vkorg AS SalesOrganization,
  iloa.vtweg AS DistributionChannel,
  iloa.vkbur AS SalesOffice,
  iloa.spart AS OrganizationDivision,
  iloa.vkgrp AS SalesGroup
FROM iloa
LEFT OUTER JOIN I_WorkCenterType AS _WorkCenterType ON WorkCenterTypeCode = _WorkCenterType.WorkCenterTypeCode  -- association [0..1]
LEFT OUTER JOIN I_WorkCenter AS _WorkCenter ON WorkCenterInternalID = _WorkCenter.WorkCenterInternalID AND WorkCenterTypeCode = _WorkCenter.WorkCenterTypeCode  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _MaintenancePlant ON MaintenancePlant = _MaintenancePlant.Plant  -- association [0..1]
LEFT OUTER JOIN I_FunctionalLocation AS _FunctionalLocation ON FunctionalLocation = _FunctionalLocation.FunctionalLocation  -- association [0..1]
LEFT OUTER JOIN I_PlantSection AS _PlantSection ON PlantSection = _PlantSection.PlantSection AND MaintenancePlant = _PlantSection.Plant  -- association [0..1]
LEFT OUTER JOIN I_CostCenter AS _CostCenter ON CostCenter = _CostCenter.CostCenter AND ControllingArea = _CostCenter.ControllingArea  -- association [0..*]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_BusinessArea AS _BusinessArea ON BusinessArea = _BusinessArea.BusinessArea  -- association [0..1]
LEFT OUTER JOIN I_Division AS _Division ON Division = _Division.Division  -- association [0..1]
LEFT OUTER JOIN I_ABCIndicator AS _ABCIndicator ON ABCIndicator = _ABCIndicator.ABCIndicator  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementBasicData ON WBSElementInternalID = _WBSElementBasicData.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_PMNotifMaintenanceData AS _PMNotifMaintenanceData ON MaintObjectLocAcctAssgmtNmbr = _PMNotifMaintenanceData.MaintObjectLocAcctAssgmtNmbr  -- association [0..1]
LEFT OUTER JOIN I_Location AS _Location ON MaintenancePlant = _Location.Plant AND AssetLocation = _Location.Location  -- association [0..1]
LEFT OUTER JOIN I_MasterFixedAsset AS _MasterFixedAsset ON CompanyCode = _MasterFixedAsset.CompanyCode AND MasterFixedAsset = _MasterFixedAsset.MasterFixedAsset  -- association [0..1]
LEFT OUTER JOIN I_FixedAsset AS _FixedAsset ON CompanyCode = _FixedAsset.CompanyCode AND MasterFixedAsset = _FixedAsset.MasterFixedAsset AND FixedAsset = _FixedAsset.FixedAsset  -- association [0..1]
LEFT OUTER JOIN I_Order AS _SettlementOrder ON SettlementOrder = _SettlementOrder.OrderID  -- association [0..1]
LEFT OUTER JOIN I_MaintenanceOrder AS _StandingOrderNumber ON StandingOrderNumber = _StandingOrderNumber.MaintenanceOrder  -- association [0..1]
LEFT OUTER JOIN I_Address AS _Address ON AddressID = _Address.AddressID  -- association [0..1]
LEFT OUTER JOIN I_SalesOrganization AS _SalesOrganization ON SalesOrganization = _SalesOrganization.SalesOrganization  -- association [0..1]
LEFT OUTER JOIN I_SlsOrganizationDistrChnl AS _SlsOrganizationDistrChnl ON SalesOrganization = _SlsOrganizationDistrChnl.SalesOrganization AND DistributionChannel = _SlsOrganizationDistrChnl.DistributionChannel  -- association [0..1]
LEFT OUTER JOIN I_SalesAreaSalesOffice AS _SalesAreaSalesOffice ON SalesOffice = _SalesAreaSalesOffice.SalesOffice AND SalesOrganization = _SalesAreaSalesOffice.SalesOrganization AND DistributionChannel = _SalesAreaSalesOffice.DistributionChannel AND OrganizationDivision = _SalesAreaSalesOffice.OrganizationDivision  -- association [0..1]
LEFT OUTER JOIN I_SalesOfficeSalesGroup AS _SalesOfficeSalesGroup ON SalesOffice = _SalesOfficeSalesGroup.SalesOffice AND SalesGroup = _SalesOfficeSalesGroup.SalesGroup  -- association [0..1]
LEFT OUTER JOIN I_CostCenterText AS _CostCenterText ON ControllingArea = _CostCenterText.ControllingArea AND CostCenter = _CostCenterText.CostCenter AND _CostCenterText.ValidityStartDate <= $session.system_date AND _CostCenterText.ValidityEndDate >= $session.system_date  -- association [0..*]
LEFT OUTER JOIN I_AddressDefaultRepresentation AS _Address2 ON AddressID = _Address2.AddressID  -- association [0..1]
LEFT OUTER JOIN I_AddressPhoneNumber_2 AS _PhoneNumber ON AddressID = _PhoneNumber.AddressID AND _PhoneNumber.PhNmbrIsCurrentOverallDefault = 'X' AND _PhoneNumber.AddressID <> '' AND _PhoneNumber.AddressPersonID = ''  -- association [0..*]
LEFT OUTER JOIN I_AddressFaxNumber_2 AS _FaxNumber ON AddressID = _FaxNumber.AddressID AND _FaxNumber.FaxNumberIsCurrentDefault = 'X' AND _FaxNumber.AddressID <> '' AND _FaxNumber.AddressPersonID = ''  -- association [0..*]
;