I_AssetAssignmentTP

DDL: I_ASSETASSIGNMENTTP SQL: IASSETASSGMTTP Type: view TRANSACTIONAL Package: FINS_FAA_MD_BOPF
63 Fields 1 Data Sources 2 Associations

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. Part of development package FINS_FAA_MD_BOPF.

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 Receiver Company Code
KEY MasterFixedAsset P_AssetAssignment MasterFixedAsset Fixed Asset
KEY FixedAsset P_AssetAssignment FixedAsset Sub-number
KEY ValidityEndDate P_AssetAssignment ValidityEndDate ValidTo
ValidityStartDate P_AssetAssignment ValidityStartDate Validity Start Date
ValidityEndDateForEdit P_AssetAssignment ValidityEndDate ValidTo
ControllingArea P_AssetAssignment ControllingArea Controlling Area
FinancialManagementArea P_AssetAssignment FinancialManagementArea FM Area
BusinessArea P_AssetAssignment BusinessArea Business Area
CostCenter P_AssetAssignment CostCenter Cost Center
CostCenterName P_AssetAssignment CostCenterName Name
CostCtrActivityType P_AssetAssignment CostCtrActivityType Activity Type
CostCtrActivityTypeName P_AssetAssignment CostCtrActivityTypeName
InternalOrder P_AssetAssignment InternalOrder Order
Fund P_AssetAssignment Fund Sender Fund
GrantID P_AssetAssignment GrantID Sender Grant
FunctionalArea P_AssetAssignment FunctionalArea Sendr Fctl Area
FundsCenter P_AssetAssignment FundsCenter Funds Center
FundsCenterName P_AssetAssignment FundsCenterName
WBSElementInternalID P_AssetAssignment WBSElementInternalID WBS Internal ID
WBSElementExternalID P_AssetAssignment WBSElementExternalID WBS Element External ID
WBSElementDescription P_AssetAssignment WBSElementDescription Description
TaxJurisdiction P_AssetAssignment TaxJurisdiction Tax Jurisdiction
RealEstateObject P_AssetAssignment RealEstateObject Real Estate Key
Segment P_AssetAssignment Segment Segment number
ProfitCenter P_AssetAssignment ProfitCenter Profit Center
ProfitCenterName P_AssetAssignment ProfitCenterName Profit Center Name
BudgetPeriod P_AssetAssignment BudgetPeriod Budget Period
ResponsibleCostCenter P_AssetAssignment ResponsibleCostCenter Responsible Cost Center
ResponsibleCostCenterName P_AssetAssignment ResponsibleCostCenterName
Room P_AssetAssignment Room Room Number
Plant P_AssetAssignment Plant Valuation Area
AssetLocation P_AssetAssignment AssetLocation Location
VehicleLicensePlateNumber P_AssetAssignment VehicleLicensePlateNumber
PersonnelNumber P_AssetAssignment PersonnelNumber Personnel No.
BusinessPlace P_AssetAssignment BusinessPlace Business place
LongText P_AssetAssignment LongText Text Name
AssetAuthorizationContext P_AssetAssignment AssetAuthorizationContext
ReferenceDocumentType P_AssetAssignment ReferenceDocumentType Reference Document Type
LogicalSystem P_AssetAssignment LogicalSystem Logical System
ReferenceDocumentContext P_AssetAssignment ReferenceDocumentContext Reference Document Context
ReferenceDocument P_AssetAssignment ReferenceDocument Reference Document
_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

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_AssetAssignmentTP.
-- 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: IASSETASSGMTTP

CREATE VIEW I_AssetAssignmentTP AS
SELECT
  P_AssetAssignment.CompanyCode AS CompanyCode,
  P_AssetAssignment.MasterFixedAsset AS MasterFixedAsset,
  P_AssetAssignment.FixedAsset AS FixedAsset,
  P_AssetAssignment.ValidityEndDate AS ValidityEndDate,
  P_AssetAssignment.ValidityStartDate AS ValidityStartDate,
  P_AssetAssignment.ValidityEndDate AS ValidityEndDateForEdit,
  P_AssetAssignment.ControllingArea AS ControllingArea,
  P_AssetAssignment.FinancialManagementArea AS FinancialManagementArea,
  P_AssetAssignment.BusinessArea AS BusinessArea,
  P_AssetAssignment.CostCenter AS CostCenter,
  P_AssetAssignment.CostCenterName AS CostCenterName,
  P_AssetAssignment.CostCtrActivityType AS CostCtrActivityType,
  P_AssetAssignment.CostCtrActivityTypeName AS CostCtrActivityTypeName,
  P_AssetAssignment.InternalOrder AS InternalOrder,
  P_AssetAssignment.Fund AS Fund,
  P_AssetAssignment.GrantID AS GrantID,
  P_AssetAssignment.FunctionalArea AS FunctionalArea,
  P_AssetAssignment.FundsCenter AS FundsCenter,
  P_AssetAssignment.FundsCenterName AS FundsCenterName,
  P_AssetAssignment.WBSElementInternalID AS WBSElementInternalID,
  P_AssetAssignment.WBSElementExternalID AS WBSElementExternalID,
  P_AssetAssignment.WBSElementDescription AS WBSElementDescription,
  P_AssetAssignment.TaxJurisdiction AS TaxJurisdiction,
  P_AssetAssignment.RealEstateObject AS RealEstateObject,
  P_AssetAssignment.Segment AS Segment,
  P_AssetAssignment.ProfitCenter AS ProfitCenter,
  P_AssetAssignment.ProfitCenterName AS ProfitCenterName,
  P_AssetAssignment.BudgetPeriod AS BudgetPeriod,
  P_AssetAssignment.ResponsibleCostCenter AS ResponsibleCostCenter,
  P_AssetAssignment.ResponsibleCostCenterName AS ResponsibleCostCenterName,
  P_AssetAssignment.Room AS Room,
  P_AssetAssignment.Plant AS Plant,
  P_AssetAssignment.AssetLocation AS AssetLocation,
  P_AssetAssignment.VehicleLicensePlateNumber AS VehicleLicensePlateNumber,
  P_AssetAssignment.PersonnelNumber AS PersonnelNumber,
  P_AssetAssignment.BusinessPlace AS BusinessPlace,
  P_AssetAssignment.LongText AS LongText,
  P_AssetAssignment.AssetAuthorizationContext AS AssetAuthorizationContext,
  P_AssetAssignment.ReferenceDocumentType AS ReferenceDocumentType,
  P_AssetAssignment.LogicalSystem AS LogicalSystem,
  P_AssetAssignment.ReferenceDocumentContext AS ReferenceDocumentContext,
  P_AssetAssignment.ReferenceDocument AS ReferenceDocument
FROM P_AssetAssignment
LEFT OUTER JOIN I_AssetTP AS _AssetTP ON CompanyCode = _AssetTP.CompanyCode AND MasterFixedAsset = _AssetTP.MasterFixedAsset AND FixedAsset = _AssetTP.FixedAsset  -- association [1..1]
LEFT OUTER JOIN E_FixedAssetAssgmt AS _Extension ON CompanyCode = _Extension.CompanyCode AND MasterFixedAsset = _Extension.MasterFixedAsset AND FixedAsset = _Extension.FixedAsset AND ValidityEndDate = _Extension.ValidityEndDate  -- association [1..1]
;

Learn More