I_GlobAssetAssignment

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_GlobAssetAssignment.
-- 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: IGFASSETASSGMT

CREATE VIEW I_GlobAssetAssignment AS
SELECT
  CompanyCode,
  MasterFixedAsset,
  FixedAsset,
  ValidityEndDate,
  ValidityStartDate,
  RU_AssetShutdownReason,
  RU_AssetShutdownDocument,
  RU_AssetIsPledged,
  RU_AssetPledgeAmountInLocCrcy,
  RU_AssetPledgee,
  RU_AssetPledgeDocumentNumber,
  RU_AssetInventoryCardNumber,
  RU_AssetOKOF,
  RU_AssetDepreciationGroup,
  RU_AssetTaxOfficeCode,
  RU_AssetSZPKIsApplied,
  RU_AssetPropertyType,
  RU_PropertyTaxOKTMO,
  RU_PropertyTaxSpecialCategory,
  RU_PropertyTaxRateReduction,
  RU_PropertyTaxAmtReduction,
  RU_PropertyTaxExemption,
  RU_PropertyTaxObjectNumber,
  RU_PropertyTaxObjectNumberType,
  RU_PrptyCadastrAmtInLoclCrcy,
  RU_AssetCommonPropertyShare,
  RU_RoomFloorAreaInSquareMeter,
  RU_RoomBuildFloorAreaInSqMtr,
  RU_AssetIsRealEstate,
  RU_TransportTaxPowerUnit,
  RU_TranspTaxBaseQtyInBaseUnit,
  RU_TransportTaxExemption,
  RU_TransportTaxReduction,
  RU_VehicleStolenDate,
  RU_VehicleReturnDate,
  RU_VehicleRegistrationDate,
  RU_VehicleCancellationDate,
  RU_TransportTaxOKTMO,
  RU_VehicleLicensePlateNumber,
  RU_TranspTxAmtReduction,
  RU_VehTranspTxPriceCategory,
  RU_VehicleIsRegisteredInPlaton,
  RU_TransptCommonOwnershipShare,
  CN_CADEFixedAssetUsage,
  Currency,
  Country
FROM P_GlobAssetAssignment
LEFT OUTER JOIN I_FixedAsset AS _FixedAsset ON CompanyCode = _FixedAsset.CompanyCode AND MasterFixedAsset = _FixedAsset.MasterFixedAsset AND FixedAsset = _FixedAsset.FixedAsset  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON Currency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Country AS _Country ON Country = _Country.Country  -- association [0..1]
LEFT OUTER JOIN I_MasterFixedAsset AS _MasterFixedAsset ON CompanyCode = _MasterFixedAsset.CompanyCode AND MasterFixedAsset = _MasterFixedAsset.MasterFixedAsset  -- association [0..1]
;