I_GlobAssetAssignmentTP

DDL: I_GLOBASSETASSIGNMENTTP SQL: IGASSETASSGMTTP Type: view TRANSACTIONAL Package: GLO_FIN_FAA_GEN

CSMD Asset Assignments Data(TDD)

I_GlobAssetAssignmentTP is a Transactional CDS View that provides data about "CSMD Asset Assignments Data(TDD)" in SAP S/4HANA. It reads from 1 data source (I_GlobAssetAssignment) and exposes 51 fields with key fields CompanyCode, MasterFixedAsset, FixedAsset, ValidityEndDate. It has 2 associations to related views. Part of development package GLO_FIN_FAA_GEN.

1 data source(s) 51 fields

Data Sources (1)

SourceAliasJoin Type
I_GlobAssetAssignment I_GlobAssetAssignment from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode
[1..1] I_AssetTP _AssetTP $projection.CompanyCode = _AssetTP.CompanyCode and $projection.MasterFixedAsset = _AssetTP.MasterFixedAsset and $projection.FixedAsset = _AssetTP.FixedAsset

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName IGASSETASSGMTTP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label CSMD Asset Assignments Data(TDD) view
VDM.viewType #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.allowExtensions false view
ObjectModel.writeActivePersistence GLO_FAAV_MD_TDD view
ObjectModel.writeDraftPersistence GLO_FAAD_MD_TDD view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (51)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode
KEY MasterFixedAsset MasterFixedAsset
KEY FixedAsset FixedAsset
KEY ValidityEndDate ValidityEndDate
ValidityStartDate ValidityStartDate
ValidityEndDateForEdit ValidityEndDate
Country Country
RU_AssetShutdownReason RU_AssetShutdownReason
RU_AssetShutdownDocument RU_AssetShutdownDocument
RU_AssetIsPledged RU_AssetIsPledged
RU_AssetPledgeAmountInLocCrcy RU_AssetPledgeAmountInLocCrcy
RU_AssetPledgee RU_AssetPledgee
RU_AssetPledgeDocumentNumber RU_AssetPledgeDocumentNumber
RU_AssetInventoryCardNumber RU_AssetInventoryCardNumber
RU_AssetOKOF RU_AssetOKOF
RU_AssetDepreciationGroup RU_AssetDepreciationGroup
RU_AssetTaxOfficeCode RU_AssetTaxOfficeCode
RU_AssetSZPKIsApplied RU_AssetSZPKIsApplied
RU_AssetPropertyType RU_AssetPropertyType
RU_PropertyTaxOKTMO RU_PropertyTaxOKTMO
RU_PropertyTaxSpecialCategory RU_PropertyTaxSpecialCategory
RU_PropertyTaxRateReduction RU_PropertyTaxRateReduction
RU_PropertyTaxAmtReduction RU_PropertyTaxAmtReduction
RU_PropertyTaxExemption RU_PropertyTaxExemption
RU_PropertyTaxObjectNumber RU_PropertyTaxObjectNumber
RU_PropertyTaxObjectNumberType RU_PropertyTaxObjectNumberType
RU_PrptyCadastrAmtInLoclCrcy RU_PrptyCadastrAmtInLoclCrcy
RU_AssetCommonPropertyShare RU_AssetCommonPropertyShare
RU_RoomFloorAreaInSquareMeter RU_RoomFloorAreaInSquareMeter
RU_RoomBuildFloorAreaInSqMtr RU_RoomBuildFloorAreaInSqMtr
RU_AssetIsRealEstate RU_AssetIsRealEstate
RU_TransportTaxPowerUnit RU_TransportTaxPowerUnit
RU_TranspTaxBaseQtyInBaseUnit RU_TranspTaxBaseQtyInBaseUnit
RU_TransportTaxExemption RU_TransportTaxExemption
RU_TransportTaxReduction RU_TransportTaxReduction
RU_VehicleStolenDate RU_VehicleStolenDate
RU_VehicleReturnDate RU_VehicleReturnDate
RU_VehicleRegistrationDate RU_VehicleRegistrationDate
RU_VehicleCancellationDate RU_VehicleCancellationDate
RU_TransportTaxOKTMO RU_TransportTaxOKTMO
RU_VehicleLicensePlateNumber RU_VehicleLicensePlateNumber
RU_TranspTxAmtReduction RU_TranspTxAmtReduction
RU_VehTranspTxPriceCategory RU_VehTranspTxPriceCategory
RU_VehicleIsRegisteredInPlaton RU_VehicleIsRegisteredInPlaton
RU_TransptCommonOwnershipShare RU_TransptCommonOwnershipShare
CN_CADEFixedAssetUsage CN_CADEFixedAssetUsage
PL_CustInvcAccountingDocument PL_CustInvcAccountingDocument
PL_CustomerInvoiceFiscalYear PL_CustomerInvoiceFiscalYear
Currency Currency
_AssetTP _AssetTP
_CompanyCode _CompanyCode 
@AbapCatalog.sqlViewName: 'IGASSETASSGMTTP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'CSMD Asset Assignments Data(TDD)'
@VDM.viewType: #TRANSACTIONAL
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.allowExtensions: false
@ObjectModel: {
    writeActivePersistence:         'GLO_FAAV_MD_TDD',
    writeDraftPersistence:          'GLO_FAAD_MD_TDD',
    semanticKey:                    ['ValidityEndDateForEdit','CompanyCode','MasterFixedAsset','FixedAsset'],
    createEnabled:                  true,
    updateEnabled:                  true,
    deleteEnabled:                  true,
//    draftEnabled:                   true,

    usageType: {
        serviceQuality: #B,
        sizeCategory: #XL,
        dataClass: #TRANSACTIONAL
        }
}
define view I_GlobAssetAssignmentTP
  as select from I_GlobAssetAssignment

  association [0..1] to I_CompanyCode as _CompanyCode on  $projection.CompanyCode = _CompanyCode.CompanyCode
  association [1..1] to I_AssetTP     as _AssetTP     on  $projection.CompanyCode      = _AssetTP.CompanyCode
                                                      and $projection.MasterFixedAsset = _AssetTP.MasterFixedAsset
                                                      and $projection.FixedAsset       = _AssetTP.FixedAsset
{
  key    CompanyCode,

  key    MasterFixedAsset,

  key    FixedAsset,
         @Semantics.businessDate.to: null
  key    ValidityEndDate,

         @ObjectModel:{ mandatory:true}
         ValidityStartDate,
         @Semantics.businessDate.to: true
         ValidityEndDate                                      as ValidityEndDateForEdit,

         @ObjectModel.foreignKey.association: null
         Country,

         //RU General Data

         @Consumption.valueHelpDefinition: [ { entity: { name: 'I_RU_AssetShutdownReason', element: 'RU_AssetShutdownReason' } } ]
         @ObjectModel:{ mandatory:'EXTERNAL_CALCULATION', readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
         RU_AssetShutdownReason,
         @ObjectModel:{ mandatory:'EXTERNAL_CALCULATION', readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
         RU_AssetShutdownDocument,
         @ObjectModel:{ mandatory:'EXTERNAL_CALCULATION', readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
         RU_AssetIsPledged,
         @Semantics.amount.currencyCode: 'Currency'
//         @DefaultAggregation: #NONE

         @ObjectModel:{ mandatory:'EXTERNAL_CALCULATION', readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
         RU_AssetPledgeAmountInLocCrcy,
         @ObjectModel:{ mandatory:'EXTERNAL_CALCULATION', readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
         RU_AssetPledgee,
         @ObjectModel:{ mandatory:'EXTERNAL_CALCULATION', readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
         RU_AssetPledgeDocumentNumber,
         @ObjectModel:{ mandatory:'EXTERNAL_CALCULATION', readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
         RU_AssetInventoryCardNumber,
         @Consumption.valueHelpDefinition: [ { entity: { name: 'I_RU_AssetOKOF', element: 'RU_AssetOKOF' },
                                           additionalBinding  : [{ localElement : 'Country', element : 'Country', usage: #FILTER }]
                                          } ]
         @ObjectModel:{ mandatory:'EXTERNAL_CALCULATION', readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
         RU_AssetOKOF,
         @Consumption.valueHelpDefinition: [ { entity: { name: 'I_RU_AssetDepreciationGroup', element: 'RU_AssetDepreciationGroup' },
                                               additionalBinding: [{ localElement : 'RU_AssetOKOF', element : 'RU_AssetOKOF' }]
                                               } ]
         @ObjectModel:{ mandatory:'EXTERNAL_CALCULATION', readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
         RU_AssetDepreciationGroup,
         @Consumption.valueHelpDefinition: [ { entity: { name: 'I_RU_TaxOfficeCode', element: 'RU_TaxOfficeCode' } } ]
         @ObjectModel:{ mandatory:'EXTERNAL_CALCULATION', readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
         RU_AssetTaxOfficeCode,
         @ObjectModel:{ mandatory:'EXTERNAL_CALCULATION', readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
         RU_AssetSZPKIsApplied,

         //RU Property Tax

         @Consumption.valueHelpDefinition: [ { entity: { name: 'I_RU_AssetPropertyType', element: 'RU_AssetPropertyType' } } ]
         @ObjectModel:{ mandatory:'EXTERNAL_CALCULATION', readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
         RU_AssetPropertyType,
         @Consumption.valueHelpDefinition: [ { entity: { name: 'I_RU_TerritoryClassfctnOKTMO', element: 'RU_TerritoryClassfctnOKTMO' } } ]
         @ObjectModel:{ mandatory:'EXTERNAL_CALCULATION', readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
         RU_PropertyTaxOKTMO,
         @Consumption.valueHelpDefinition: [ { entity: { name: 'I_RU_PropertyTaxSpecialCat', element: 'RU_PropertyTaxSpecialCategory' } } ]
         @ObjectModel:{ mandatory:'EXTERNAL_CALCULATION', readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
         RU_PropertyTaxSpecialCategory,
         @Consumption.valueHelpDefinition: [ { entity: { name: 'I_RU_PropertyTaxRateReducnVH', element: 'RU_PropertyTaxConcession' } } ]
         @ObjectModel:{ mandatory:'EXTERNAL_CALCULATION', readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
         RU_PropertyTaxRateReduction,
         @Consumption.valueHelpDefinition: [ { entity: { name: 'I_RU_PropertyTaxAmtReductionVH', element: 'RU_PropertyTaxConcession' } } ]
         @ObjectModel:{ mandatory:'EXTERNAL_CALCULATION', readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
         RU_PropertyTaxAmtReduction,
         @Consumption.valueHelpDefinition: [ { entity: { name: 'I_RU_PropertyTaxExemptionVH', element: 'RU_PropertyTaxConcession' } } ]
         @ObjectModel:{ mandatory:'EXTERNAL_CALCULATION', readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
         RU_PropertyTaxExemption,
         @ObjectModel:{ mandatory:'EXTERNAL_CALCULATION', readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
         RU_PropertyTaxObjectNumber,
         @Consumption.valueHelpDefinition: [ { entity: { name: 'I_RU_PropertyTaxObjNumberType', element: 'RU_PropertyTaxObjectNumberType' } } ]
         @ObjectModel:{ mandatory:'EXTERNAL_CALCULATION', readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
         RU_PropertyTaxObjectNumberType,
         @Semantics.amount.currencyCode: 'Currency'
//         @DefaultAggregation: #NONE

         @ObjectModel:{ mandatory:'EXTERNAL_CALCULATION', readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
         RU_PrptyCadastrAmtInLoclCrcy,
         @ObjectModel:{ mandatory:'EXTERNAL_CALCULATION', readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
         RU_AssetCommonPropertyShare,
         @ObjectModel:{ mandatory:'EXTERNAL_CALCULATION', readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
         RU_RoomFloorAreaInSquareMeter,
         @ObjectModel:{ mandatory:'EXTERNAL_CALCULATION', readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
         RU_RoomBuildFloorAreaInSqMtr,
         @ObjectModel:{ mandatory:'EXTERNAL_CALCULATION', readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
         RU_AssetIsRealEstate,

         //RU Transport Tax

         @Consumption.valueHelpDefinition: [ { entity: { name: 'I_UnitOfMeasure', element: 'UnitOfMeasure' } } ]
         @ObjectModel:{ mandatory:'EXTERNAL_CALCULATION', readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
         RU_TransportTaxPowerUnit,
         @Semantics.quantity.unitOfMeasure: 'RU_TransportTaxPowerUnit'
//         @DefaultAggregation:#NONE

         @ObjectModel:{ mandatory:'EXTERNAL_CALCULATION', readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
         RU_TranspTaxBaseQtyInBaseUnit,
         @Consumption.valueHelpDefinition: [ { entity: { name: 'I_RU_TransportTaxExemptionVH', element: 'RU_TransportTaxConcession' } } ]
         @ObjectModel:{ mandatory:'EXTERNAL_CALCULATION', readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
         RU_TransportTaxExemption,
         @Consumption.valueHelpDefinition: [ { entity: { name: 'I_RU_TransportTaxReductionVH', element: 'RU_TransportTaxConcession' } } ]
         @ObjectModel:{ mandatory:'EXTERNAL_CALCULATION', readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
         RU_TransportTaxReduction,
         @ObjectModel:{ mandatory:'EXTERNAL_CALCULATION', readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
         RU_VehicleStolenDate,
         @ObjectModel:{ mandatory:'EXTERNAL_CALCULATION', readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
         RU_VehicleReturnDate,
         @ObjectModel:{ mandatory:'EXTERNAL_CALCULATION', readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
         RU_VehicleRegistrationDate,
         @ObjectModel:{ mandatory:'EXTERNAL_CALCULATION', readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
         RU_VehicleCancellationDate,
         @Consumption.valueHelpDefinition: [ { entity: { name: 'I_RU_TerritoryClassfctnOKTMO', element: 'RU_TerritoryClassfctnOKTMO' } } ]
         @ObjectModel:{ mandatory:'EXTERNAL_CALCULATION', readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
         RU_TransportTaxOKTMO,
         @ObjectModel:{ mandatory:'EXTERNAL_CALCULATION', readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
         RU_VehicleLicensePlateNumber,
         @Consumption.valueHelpDefinition: [ { entity: { name: 'I_RU_TranspTxAmtReductionVH', element: 'RU_TransportTaxConcession' } } ]
         @ObjectModel:{ mandatory:'EXTERNAL_CALCULATION', readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
         RU_TranspTxAmtReduction,
         @Consumption.valueHelpDefinition: [ { entity: { name: 'I_RU_VehTranspTxPriceCategory', element: 'RU_VehTranspTxPriceCategory' } } ]
         @ObjectModel:{ mandatory:'EXTERNAL_CALCULATION', readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
         RU_VehTranspTxPriceCategory,
         @ObjectModel:{ mandatory:'EXTERNAL_CALCULATION', readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
         RU_VehicleIsRegisteredInPlaton,
         @ObjectModel:{ mandatory:'EXTERNAL_CALCULATION', readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
         RU_TransptCommonOwnershipShare,

         // CN CADE

         @Consumption.valueHelpDefinition: [ { entity: { name: 'I_CN_CADEAssetUsageVH', element: 'CN_CADEFixedAssetUsage' } } ]
         @ObjectModel:{ mandatory:'EXTERNAL_CALCULATION', readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
         CN_CADEFixedAssetUsage,

         //PL SAF-T

         @ObjectModel:{ mandatory:'EXTERNAL_CALCULATION', readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
         PL_CustInvcAccountingDocument,
         @ObjectModel:{ mandatory:'EXTERNAL_CALCULATION', readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
         PL_CustomerInvoiceFiscalYear,      

         Currency,

         // Associations

         @ObjectModel.association.type: [ #TO_COMPOSITION_ROOT, #TO_COMPOSITION_PARENT ]
         _AssetTP,
         _CompanyCode
}

Learn More