P_RU_GlobAssetAssignment

DDL: P_RU_GLOBASSETASSIGNMENT SQL: PRUGFASSETASSGMT Type: view COMPOSITE Package: GLO_FIN_IS_RU
21 Fields 1 Data Sources

Russia: Country Specific Fixed Asset Assignment

P_RU_GlobAssetAssignment is a Composite CDS View that provides data about "Russia: Country Specific Fixed Asset Assignment" in SAP S/4HANA. It reads from 1 data source (I_GlobAssetAssignment) and exposes 21 fields with key fields CompanyCode, MasterFixedAsset, FixedAsset, ValidityEndDate. Part of development package GLO_FIN_IS_RU.

Data Sources (1)

SourceAliasJoin Type
I_GlobAssetAssignment I_GlobAssetAssignment from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PRUGFASSETASSGMT view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #COMPOSITE view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey MasterFixedAsset view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode Receiver Company Code
KEY MasterFixedAsset MasterFixedAsset Fixed Asset
KEY FixedAsset FixedAsset Sub-number
KEY ValidityEndDate ValidityEndDate ValidTo
ValidityStartDate ValidityStartDate Validity Start Date
RU_AssetPropertyType RU_AssetPropertyType Property Type
RU_PropertyTaxOKTMO RU_PropertyTaxOKTMO
RU_PropertyTaxSpecialCategory RU_PropertyTaxSpecialCategory Special Tax Category
RU_PropertyTaxRateReduction RU_PropertyTaxRateReduction Tax Reduction Code
RU_PropertyTaxAmtReduction RU_PropertyTaxAmtReduction Tax Amount Red.Code
RU_PropertyTaxExemption RU_PropertyTaxExemption Tax Exemption Code
RU_PropertyCadastrValInLocCrcy RU_PrptyCadastrAmtInLoclCrcy
RU_PropertyTaxObjectNumberType RU_PropertyTaxObjectNumberType
RU_PropertyTaxObjectNumber RU_PropertyTaxObjectNumber
RU_AssetOKOF RU_AssetOKOF
RU_AssetSZPKIsApplied RU_AssetSZPKIsApplied SZPK Applies
RU_AssetCommonPropertyShare RU_AssetCommonPropertyShare Property Share
RU_RoomFloorAreaInSquareMeter RU_RoomFloorAreaInSquareMeter Room Area
RU_RoomBuildFloorAreaInSqMtr RU_RoomBuildFloorAreaInSqMtr Area
RU_AssetTaxOfficeCode RU_AssetTaxOfficeCode Tax Office
RU_AssetIsRealEstate RU_AssetIsRealEstate Is Real Estate

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 P_RU_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: PRUGFASSETASSGMT

CREATE VIEW P_RU_GlobAssetAssignment AS
SELECT
  CompanyCode,
  MasterFixedAsset,
  FixedAsset,
  ValidityEndDate,
  ValidityStartDate,
  RU_AssetPropertyType,
  RU_PropertyTaxOKTMO,
  RU_PropertyTaxSpecialCategory,
  RU_PropertyTaxRateReduction,
  RU_PropertyTaxAmtReduction,
  RU_PropertyTaxExemption,
  RU_PrptyCadastrAmtInLoclCrcy AS RU_PropertyCadastrValInLocCrcy,
  RU_PropertyTaxObjectNumberType,
  RU_PropertyTaxObjectNumber,
  RU_AssetOKOF,
  RU_AssetSZPKIsApplied,
  RU_AssetCommonPropertyShare,
  RU_RoomFloorAreaInSquareMeter,
  RU_RoomBuildFloorAreaInSqMtr,
  RU_AssetTaxOfficeCode,
  RU_AssetIsRealEstate
FROM I_GlobAssetAssignment
;

Learn More