I_AssetAssignmentTP

DDL: I_ASSETASSIGNMENTTP SQL: IASSETASSGMTTP Type: view TRANSACTIONAL

Asset Assignment

I_AssetAssignmentTP is a Transactional CDS View that provides data about "Asset Assignment" in SAP S/4HANA. It reads from 1 data source (P_AssetAssignment) and exposes 63 fields with key fields CompanyCode, MasterFixedAsset, FixedAsset, ValidityEndDate. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
P_AssetAssignment P_AssetAssignment from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_AssetTP _AssetTP $projection.CompanyCode = _AssetTP.CompanyCode and $projection.MasterFixedAsset = _AssetTP.MasterFixedAsset and $projection.FixedAsset = _AssetTP.FixedAsset
[1..1] E_FixedAssetAssgmt _Extension $projection.CompanyCode = _Extension.CompanyCode and $projection.MasterFixedAsset = _Extension.MasterFixedAsset and $projection.FixedAsset = _Extension.FixedAsset and $projection.ValidityEndDate = _Extension.ValidityEndDate

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName IASSETASSGMTTP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Asset Assignment view
VDM.viewType #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.allowExtensions false view
ObjectModel.writeActivePersistence FAAV_MD_TDD view
ObjectModel.writeDraftPersistence FAAD_MD_TDD view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (63)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode P_AssetAssignment CompanyCode
KEY MasterFixedAsset P_AssetAssignment MasterFixedAsset
KEY FixedAsset P_AssetAssignment FixedAsset
KEY ValidityEndDate P_AssetAssignment ValidityEndDate
ValidityStartDate P_AssetAssignment ValidityStartDate
ValidityEndDateForEdit P_AssetAssignment ValidityEndDate
ControllingArea P_AssetAssignment ControllingArea
FinancialManagementArea P_AssetAssignment FinancialManagementArea
BusinessArea P_AssetAssignment BusinessArea
CostCenter P_AssetAssignment CostCenter
CostCenterName P_AssetAssignment CostCenterName
CostCtrActivityType P_AssetAssignment CostCtrActivityType
CostCtrActivityTypeName P_AssetAssignment CostCtrActivityTypeName
InternalOrder P_AssetAssignment InternalOrder
Fund P_AssetAssignment Fund
GrantID P_AssetAssignment GrantID
FunctionalArea P_AssetAssignment FunctionalArea
FundsCenter P_AssetAssignment FundsCenter
FundsCenterName P_AssetAssignment FundsCenterName
WBSElementInternalID P_AssetAssignment WBSElementInternalID
WBSElementExternalID P_AssetAssignment WBSElementExternalID
WBSElementDescription P_AssetAssignment WBSElementDescription
TaxJurisdiction P_AssetAssignment TaxJurisdiction
RealEstateObject P_AssetAssignment RealEstateObject
Segment P_AssetAssignment Segment
ProfitCenter P_AssetAssignment ProfitCenter
ProfitCenterName P_AssetAssignment ProfitCenterName
BudgetPeriod P_AssetAssignment BudgetPeriod
ResponsibleCostCenter P_AssetAssignment ResponsibleCostCenter
ResponsibleCostCenterName P_AssetAssignment ResponsibleCostCenterName
Room P_AssetAssignment Room
Plant P_AssetAssignment Plant
AssetLocation P_AssetAssignment AssetLocation
VehicleLicensePlateNumber P_AssetAssignment VehicleLicensePlateNumber
PersonnelNumber P_AssetAssignment PersonnelNumber
BusinessPlace P_AssetAssignment BusinessPlace
LongText P_AssetAssignment LongText
AssetAuthorizationContext P_AssetAssignment AssetAuthorizationContext
ReferenceDocumentType P_AssetAssignment ReferenceDocumentType
LogicalSystem P_AssetAssignment LogicalSystem
ReferenceDocumentContext P_AssetAssignment ReferenceDocumentContext
ReferenceDocument P_AssetAssignment ReferenceDocument
_AssetTP _AssetTP
_MasterFixedAsset _MasterFixedAsset
_FixedAsset _FixedAsset
_CompanyCode _CompanyCode
_ControllingArea _ControllingArea
_Fund _Fund
_FundsCenter _FundsCenter
_CostCenter _CostCenter
_ResponsibleCostCenter _ResponsibleCostCenter
_BusinessArea _BusinessArea
_Segment _Segment
_InternalOrder _InternalOrder
_ProfitCenter _ProfitCenter
_FunctionalArea _FunctionalArea
_CostCenterActivityType _CostCenterActivityType
_WBSElementBasicData _WBSElementBasicData
_Plant _Plant
_AssetLocation _AssetLocation
_BudgetPeriod _BudgetPeriod
_Employment _Employment
_Grant _Grant
@AbapCatalog.sqlViewName: 'IASSETASSGMTTP'
@AbapCatalog.compiler.compareFilter: true
//@AbapCatalog.preserveKey: true

@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Asset Assignment'
@VDM.viewType: #TRANSACTIONAL
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.allowExtensions: false
@ObjectModel: {
    writeActivePersistence:         'FAAV_MD_TDD',
    writeDraftPersistence:          'FAAD_MD_TDD',
    semanticKey:                    ['ValidityEndDate','CompanyCode','MasterFixedAsset','FixedAsset'],
    createEnabled:                  true,
    updateEnabled:                  true,
    deleteEnabled:                  true,
    usageType: {
        serviceQuality: #B,
        sizeCategory: #XXL,
        dataClass: #TRANSACTIONAL
        }
}
define view I_AssetAssignmentTP
  as select from P_AssetAssignment
  association [1..1] to I_AssetTP          as _AssetTP   on  $projection.CompanyCode      = _AssetTP.CompanyCode
                                                         and $projection.MasterFixedAsset = _AssetTP.MasterFixedAsset
                                                         and $projection.FixedAsset       = _AssetTP.FixedAsset
  association [1..1] to E_FixedAssetAssgmt as _Extension on  $projection.CompanyCode      = _Extension.CompanyCode
                                                         and $projection.MasterFixedAsset = _Extension.MasterFixedAsset
                                                         and $projection.FixedAsset       = _Extension.FixedAsset
                                                         and $projection.ValidityEndDate  = _Extension.ValidityEndDate

{
  key    P_AssetAssignment.CompanyCode     as CompanyCode,

  key    P_AssetAssignment.MasterFixedAsset,

  key    P_AssetAssignment.FixedAsset,
         @Semantics.businessDate.to: null
         @ObjectModel:{ readOnly:true}
  key    P_AssetAssignment.ValidityEndDate,

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

         P_AssetAssignment.ControllingArea,

         P_AssetAssignment.FinancialManagementArea,

         //@ObjectModel.text.element: ['BusinessAreaName']

         @ObjectModel:{ mandatory:'EXTERNAL_CALCULATION', readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
         P_AssetAssignment.BusinessArea,

         //@ObjectModel:{ mandatory:'EXTERNAL_CALCULATION', readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}

         //_BusinessArea._Text[1:Language=$session.system_language].BusinessAreaName,

         //@ObjectModel.readOnly:true

         //P_AssetAssignment.BusinessAreaName,


         //@ObjectModel.text.element: ['CostCenterName']

         @ObjectModel:{ mandatory:'EXTERNAL_CALCULATION', readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
         P_AssetAssignment.CostCenter,
         //@ObjectModel:{ mandatory:'EXTERNAL_CALCULATION', readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}

         //_CostCenter._Text[1:Language=$session.system_language].CostCenterName,

         @ObjectModel.readOnly:true
         P_AssetAssignment.CostCenterName,



         //@ObjectModel.text.element: ['CostCtrActivityTypeName']

         @ObjectModel:{ mandatory:'EXTERNAL_CALCULATION', readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
         P_AssetAssignment.CostCtrActivityType,
         //@ObjectModel:{ mandatory:'EXTERNAL_CALCULATION', readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}

         //_CostCenterActivityType._Text[1:Language=$session.system_language].CostCtrActivityTypeName,

         @ObjectModel.readOnly:true
         P_AssetAssignment.CostCtrActivityTypeName,

         //@ObjectModel.text.element: ['InternalOrderDescription']

         @ObjectModel:{ mandatory:'EXTERNAL_CALCULATION', readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
         P_AssetAssignment.InternalOrder,
         //@ObjectModel:{ mandatory:'EXTERNAL_CALCULATION', readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}

         //@ObjectModel.readOnly:true

         //P_AssetAssignment.InternalOrderDescription,

         //@ObjectModel:0000000000000{ mandatory:'EXTERNAL_CALCULATION', readOnly:'true', enabled:'EXTERNAL_CALCULATION'}

         //_InternalOrder.InternalOrderDescription,

         //InternalOrderDescription,


         //@ObjectModel.text.element: ['FundName']

         @ObjectModel:{ mandatory:'EXTERNAL_CALCULATION', readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
         P_AssetAssignment.Fund,
         //@ObjectModel:{ mandatory:'EXTERNAL_CALCULATION', readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}

         //P_AssetAssignment._Fund._Text[1:Language=$session.system_language].FundName,

         //@ObjectModel.readOnly:true

         //P_AssetAssignment.FundName,


         @ObjectModel:{ mandatory:'EXTERNAL_CALCULATION', readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
         P_AssetAssignment.GrantID,

         //@ObjectModel.text.element: ['FunctionalAreaName']

         @ObjectModel:{ mandatory:'EXTERNAL_CALCULATION', readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
         P_AssetAssignment.FunctionalArea,
         //@ObjectModel:{ mandatory:'EXTERNAL_CALCULATION', readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}

         //_FunctionalArea._Text[1:Language=$session.system_language].FunctionalAreaName,

         //@ObjectModel.readOnly:true

         //P_AssetAssignment.FunctionalAreaName,


         //@ObjectModel.text.element: ['FundsCenterName']

         @ObjectModel:{ mandatory:'EXTERNAL_CALCULATION', readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
         P_AssetAssignment.FundsCenter,
         //@ObjectModel:{ mandatory:'EXTERNAL_CALCULATION', readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}

         //P_AssetAssignment._FundsCenter._Text[1:Language=$session.system_language].FundsCenterName,

         @ObjectModel.readOnly:true
         P_AssetAssignment.FundsCenterName,

         @ObjectModel.text.element: ['WBSElementDescription']
         @ObjectModel:{ mandatory:'EXTERNAL_CALCULATION', readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
         P_AssetAssignment.WBSElementInternalID,

         @ObjectModel.text.element: ['WBSElementDescription']
         @ObjectModel:{ mandatory:'EXTERNAL_CALCULATION', readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
         P_AssetAssignment.WBSElementExternalID,

         //@ObjectModel:{ mandatory:'EXTERNAL_CALCULATION', readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}

         @ObjectModel.readOnly:true
         P_AssetAssignment.WBSElementDescription,


         @ObjectModel:{ mandatory:'EXTERNAL_CALCULATION', readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
         P_AssetAssignment.TaxJurisdiction,

         @ObjectModel:{ mandatory:'EXTERNAL_CALCULATION', readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
         P_AssetAssignment.RealEstateObject,

         //@ObjectModel.text.element: ['SegmentName']

         @ObjectModel:{ mandatory:'EXTERNAL_CALCULATION', readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
         P_AssetAssignment.Segment,
         //@ObjectModel:{ mandatory:'EXTERNAL_CALCULATION', readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}

         //P_AssetAssignment._Segment._Text[1:Language=$session.system_language].SegmentName,

         //@ObjectModel.readOnly:true

         //P_AssetAssignment.SegmentName,


         //@ObjectModel.text.element: ['ProfitCenterName']

         @ObjectModel:{ mandatory:'EXTERNAL_CALCULATION', readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
         P_AssetAssignment.ProfitCenter,
         //@ObjectModel:{ mandatory:'EXTERNAL_CALCULATION', readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}

         //P_AssetAssignment._ProfitCenter._Text[1:Language=$session.system_language].ProfitCenterName,

         @ObjectModel.readOnly:true
         P_AssetAssignment.ProfitCenterName,

         @ObjectModel:{ mandatory:'EXTERNAL_CALCULATION', readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
         P_AssetAssignment.BudgetPeriod,

         //@ObjectModel.text.element: ['ResponsibleCostCenterName']

         @ObjectModel:{ mandatory:'EXTERNAL_CALCULATION', readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
         P_AssetAssignment.ResponsibleCostCenter,
         //@ObjectModel:{ mandatory:'EXTERNAL_CALCULATION', readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}

         //P_AssetAssignment._ResponsibleCostCenter._Text[1:Language=$session.system_language].CostCenterName                      as ResponsibleCostCenterName,

         @ObjectModel.readOnly:true
         P_AssetAssignment.ResponsibleCostCenterName,

         @ObjectModel:{ mandatory:'EXTERNAL_CALCULATION', readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
         P_AssetAssignment.Room,

         @ObjectModel:{ mandatory:'EXTERNAL_CALCULATION', readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
         P_AssetAssignment.Plant,
         //@ObjectModel:{ mandatory:'EXTERNAL_CALCULATION', readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}

         //@ObjectModel.readOnly:true

         //P_AssetAssignment.PlantName,


         @ObjectModel:{ mandatory:'EXTERNAL_CALCULATION', readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
         P_AssetAssignment.AssetLocation,
         //@ObjectModel:{ mandatory:'EXTERNAL_CALCULATION', readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}

         //@ObjectModel.readOnly:true

         //P_AssetAssignment.AssetLocationName,

         //         AssetLocationName,


         @ObjectModel:{ mandatory:'EXTERNAL_CALCULATION', readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
         P_AssetAssignment.VehicleLicensePlateNumber,

         @ObjectModel:{ mandatory:'EXTERNAL_CALCULATION', readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
         P_AssetAssignment.PersonnelNumber,

         @ObjectModel:{ mandatory:'EXTERNAL_CALCULATION', readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
         P_AssetAssignment.BusinessPlace,

         //Helping fields

         P_AssetAssignment.LongText,

         //auth

         @Consumption.hidden: true
         P_AssetAssignment.AssetAuthorizationContext,

         //Technical fields for document

         @ObjectModel:{readOnly:'true'}
         P_AssetAssignment.ReferenceDocumentType,
         @ObjectModel:{readOnly:'true'}
         P_AssetAssignment.LogicalSystem,
         @ObjectModel:{readOnly:'true'}
         P_AssetAssignment.ReferenceDocumentContext,
         @ObjectModel:{readOnly:'true'}
         P_AssetAssignment.ReferenceDocument,


         // Associations

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

         _MasterFixedAsset,

         @ObjectModel.association.type:null
         _FixedAsset, // For inheritence use in access control


         _CompanyCode,

         _ControllingArea,

         _Fund,

         _FundsCenter,

         _CostCenter,

         _ResponsibleCostCenter,

         _BusinessArea,

         _Segment,

         _InternalOrder,

         _ProfitCenter,

         _FunctionalArea,

         _CostCenterActivityType,

         _WBSElementBasicData,

         _Plant,

         _AssetLocation,

         _BudgetPeriod,

         _Employment,

         _Grant

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_ASSETASSIGNMENT"
],
"ASSOCIATED":
[
"E_FIXEDASSETASSGMT",
"I_ASSETTP",
"I_BUDGETPERIOD",
"I_BUSINESSAREA",
"I_COMPANYCODE",
"I_CONTROLLINGAREA",
"I_COSTCENTER",
"I_COSTCENTERACTIVITYTYPE",
"I_EMPLOYMENT",
"I_FIXEDASSET",
"I_FUNCTIONALAREA",
"I_FUND",
"I_FUNDSCENTER",
"I_GRANT",
"I_INTERNALORDER",
"I_LOCATION",
"I_MASTERFIXEDASSET",
"I_PLANT",
"I_PROFITCENTER",
"I_SEGMENT",
"I_WBSELEMENTBASICDATA"
],
"BASE":
[
"P_ASSETASSIGNMENT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/