I_GLOBASSETASSIGNMENT

CDS View

Country/Region Specific Fixed Asset Assignment

I_GLOBASSETASSIGNMENT is a CDS View in S/4HANA. Country/Region Specific Fixed Asset Assignment. It contains 14 fields. 6 CDS views read from this table.

Used by 6 CDS view(s) 14 fields

CDS Views using this table (6)

ViewTypeJoinVDMDescription
I_CN_CADEFixedAssetValueCube view left_outer COMPOSITE Fixed Asset Balance Cube for CADE
I_GlobAssetAssignmentTP view from TRANSACTIONAL CSMD Asset Assignments Data(TDD)
I_RU_LandPlotCadastrNumberVH view_entity from COMPOSITE Land Plot by Russian Cadastral Number
I_RU_TransportTaxItemCube view inner COMPOSITE Russia Transport Tax: Cube
I_RU_VehicleLicPlateNumberVH view_entity from COMPOSITE Vehicle by Russian License Plate number
P_RU_GlobAssetAssignment view from COMPOSITE

Fields (14)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 2
KEY FixedAsset FixedAsset 2
KEY MasterFixedAsset MasterFixedAsset 2
KEY RU_VehicleLicensePlateNumber RU_VehicleLicensePlateNumber 2
KEY ValidityStartDate ValidityStartDate 2
RU_TransportTaxExemption RU_TransportTaxExemption 1
RU_TransportTaxOKTMO RU_TransportTaxOKTMO 1
RU_TransportTaxReduction RU_TransportTaxReduction 1
RU_TranspTxAmtReduction RU_TranspTxAmtReduction 1
RU_VehicleCancellationDate RU_VehicleCancellationDate 1
RU_VehicleRegistrationDate RU_VehicleRegistrationDate 1
RU_VehicleReturnDate RU_VehicleReturnDate 1
RU_VehicleStolenDate RU_VehicleStolenDate 1
RU_VehTranspTxPriceCategory RU_VehTranspTxPriceCategory 1 
@AbapCatalog.sqlViewName: 'IGFASSETASSGMT'
//@Analytics: { dataCategory: #DIMENSION, dataExtraction.enabled: true }

@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Country/Region Specific Fixed Asset Assignment'
@VDM.viewType: #BASIC
@ObjectModel: { representativeKey: 'FixedAsset',
                usageType.serviceQuality: #C,
                usageType.sizeCategory: #XXL,
                usageType.dataClass: #MIXED }
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata: {ignorePropagatedAnnotations: true, allowExtensions: true}

define view I_GlobAssetAssignment
  as select from P_GlobAssetAssignment
  //Association with Asset Master Reference

  association [1..1] to I_FixedAsset       as _FixedAsset       on  $projection.CompanyCode      = _FixedAsset.CompanyCode
                                                                and $projection.MasterFixedAsset = _FixedAsset.MasterFixedAsset
                                                                and $projection.FixedAsset       = _FixedAsset.FixedAsset

  association [0..1] to I_CompanyCode      as _CompanyCode      on  $projection.CompanyCode = _CompanyCode.CompanyCode
  association [0..1] to I_Currency         as _Currency         on  $projection.Currency = _Currency.Currency
  association [0..1] to I_Country          as _Country          on  $projection.Country = _Country.Country
  association [0..1] to I_MasterFixedAsset as _MasterFixedAsset on  $projection.CompanyCode      = _MasterFixedAsset.CompanyCode
                                                                and $projection.MasterFixedAsset = _MasterFixedAsset.MasterFixedAsset
{
      //Key Fields

      @ObjectModel.foreignKey.association: '_CompanyCode'
      @Consumption.valueHelpDefinition: [ { entity: { name: 'I_CompanyCodeStdVH', element: 'CompanyCode' } } ]
  key CompanyCode,
      @ObjectModel.foreignKey.association: '_MasterFixedAsset'
      @Consumption.valueHelpDefinition: [ { entity: { name: 'I_MasterFixedAssetStdVH', element: 'MasterFixedAsset' },
                                            additionalBinding:  [ { localElement: 'CompanyCode', element:'CompanyCode' } ]
                                        } ]
  key MasterFixedAsset,
  key FixedAsset,
      @Semantics.businessDate.to: true
  key ValidityEndDate,
      //Relevant Fields

      @Semantics.businessDate.from: true
      ValidityStartDate,

      //RU General Data

      RU_AssetShutdownReason,
      RU_AssetShutdownDocument,
      RU_AssetIsPledged,
      @Semantics.amount.currencyCode: 'Currency'
      @DefaultAggregation:#NONE
      RU_AssetPledgeAmountInLocCrcy,
      RU_AssetPledgee,
      RU_AssetPledgeDocumentNumber,
      RU_AssetInventoryCardNumber,
      RU_AssetOKOF,
      RU_AssetDepreciationGroup,
      RU_AssetTaxOfficeCode,
      RU_AssetSZPKIsApplied,

      //RU Property Tax

      RU_AssetPropertyType,
      RU_PropertyTaxOKTMO,
      RU_PropertyTaxSpecialCategory,
      RU_PropertyTaxRateReduction,
      RU_PropertyTaxAmtReduction,
      RU_PropertyTaxExemption,
      RU_PropertyTaxObjectNumber,
      RU_PropertyTaxObjectNumberType,

      @Semantics.amount.currencyCode: 'Currency'
      @DefaultAggregation:#NONE
      RU_PrptyCadastrAmtInLoclCrcy,
      RU_AssetCommonPropertyShare,
      RU_RoomFloorAreaInSquareMeter,
      RU_RoomBuildFloorAreaInSqMtr,
      RU_AssetIsRealEstate,

      //RU Transport Tax

      RU_TransportTaxPowerUnit,
      @Semantics.quantity.unitOfMeasure: 'RU_TransportTaxPowerUnit'
      @DefaultAggregation:#NONE
      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 CADE

      CN_CADEFixedAssetUsage,

      @Semantics.currencyCode: true
      @ObjectModel.foreignKey.association: '_Currency'
      Currency,

      @ObjectModel.foreignKey.association: '_Country'
      Country,

      // Define association to parent

      @ObjectModel.association.type: [ #TO_COMPOSITION_PARENT, #TO_COMPOSITION_ROOT ]
      _FixedAsset,
      _CompanyCode,
      _Country,
      _MasterFixedAsset,
      _Currency
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_GLOBASSETASSIGNMENT"
],
"ASSOCIATED":
[
"I_COMPANYCODE",
"I_COUNTRY",
"I_CURRENCY",
"I_FIXEDASSET",
"I_MASTERFIXEDASSET"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More