I_AssetMultipleCreationTP

DDL: I_ASSETMULTIPLECREATIONTP SQL: IASTMULTICRTETP Type: view TRANSACTIONAL
106 Fields 1 Data Sources 1 Associations

Asset Multiple Creation - TP

I_AssetMultipleCreationTP is a Transactional CDS View that provides data about "Asset Multiple Creation - TP" in SAP S/4HANA. It reads from 1 data source (I_AssetMultipleCreation) and exposes 106 fields with key fields CompanyCode, MasterFixedAsset, FixedAsset, RowIndex. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_AssetMultipleCreation Multi from

Associations (1)

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

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName IASTMULTICRTETP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Asset Multiple Creation - TP view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #TRANSACTIONAL view
Metadata.allowExtensions false view
ObjectModel.writeActivePersistence IASTMULTICRTETP view
ObjectModel.writeDraftPersistence FAAD_MD_MULTI view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view

Fields (106)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode Receiver Company Code
KEY MasterFixedAsset MasterFixedAsset Fixed Asset
KEY FixedAsset FixedAsset Sub-number
KEY RowIndex RowIndex Row index
AssetClass AssetClass Asset Class
AssetAccountDetermination AssetAccountDetermination Account Determ.
FixedAssetDescription FixedAssetDescription Description
AssetAdditionalDescription AssetAdditionalDescription Description (2)
AssetSerialNumber AssetSerialNumber Serial Number of Proposal Descriptions
Inventory Inventory Ci Inventory
Supplier Supplier Supplier
AssetCountryOfOrigin AssetCountryOfOrigin Origin C/R
AssetManufacturerName AssetManufacturerName Manufacturer
OriginalMasterFixedAsset OriginalMasterFixedAsset Original Asset
OriginalFixedAsset OriginalFixedAsset Asset Sub-No. AuC
OriginalFixedAssetValueDate OriginalFixedAssetValueDate Acq.Orig.Ast.On
OriginalAcquisitionFiscalYear OriginalAcquisitionFiscalYear Org. Acq. Year
OriginalAcquisitionAmount OriginalAcquisitionAmount Original Value
OriginalAcquisitionCurrency OriginalAcquisitionCurrency Orig Acq Crcy
InHouseProdnPercent InHouseProdnPercent In-H.Prod.Perc.
AssetTypeName AssetTypeName Type Name
PartnerCompany PartnerCompany Trading Partner
AssetIsAcquiredUsed AssetIsAcquiredUsed Used indicator
InvestmentProjectWBSElement InvestmentProjectWBSElement
InvestmentOrder InvestmentOrder Inv. Order
LastInventoryDate LastInventoryDate Last Inventory
InventoryNote InventoryNote Inventory Note
InventoryIsCounted InventoryIsCounted Inventory Ind.
InvestmentReason InvestmentReason Invest. Reason
EnvrnmtlInvestmentReason EnvrnmtlInvestmentReason Envir. Invest.
FixedAssetGroup FixedAssetGroup Asset Super No.
PropertyClass PropertyClass Prop.classif.
FixedAssetPropertyType FixedAssetPropertyType Property Indic.
LocalTaxOffice LocalTaxOffice Tax Office
NoticeOfAssessmentTaxID NoticeOfAssessmentTaxID Assmt Tax No.
LastAssessmentNoticeDate LastAssessmentNoticeDate Notice on
Municipality Municipality Venue Municplty
LandRegisterDate LandRegisterDate Land Regist. of
LandRegisterEntrySequence LandRegisterEntrySequence LandRegEntSeqNo
LandRegisterEntryDate LandRegisterEntryDate Entry by
LandRegisterVolume LandRegisterVolume Lnd Reg. Volume
LandRegisterPage LandRegisterPage Land Reg. Page
LandRegisterMap LandRegisterMap Ld.Reg.Map.No
LandPlot LandPlot Plot No.
ConveyanceDate ConveyanceDate Conveyance
AreaSize AreaSize Area
AreaSizeUnit AreaSizeUnit Area Unit
AssetIsRealEstate AssetIsRealEstate Connection to SAP Real Estate Management
LeaseSupplier LeaseSupplier Lessor
LeaseAgreement LeaseAgreement Agreement no.
LeaseAgreementDate LeaseAgreementDate Agreement Date
LeaseTermEndDate LeaseTermEndDate Notice date
LeaseTermStartDate LeaseTermStartDate Leas.start date
LeaseDurationInFiscalYears LeaseDurationInFiscalYears Lease Length
LeaseDurationInFiscalPeriods LeaseDurationInFiscalPeriods Periods
LeaseType LeaseType Type
LeasedAssetNote LeasedAssetNote Suppl. text
BaseUnit BaseUnit Unit of Measure
FixedAssetOrderDate FixedAssetOrderDate Ordered On
LastReorganizationDate LastReorganizationDate Reorganization Date
ObjectInternalID ObjectInternalID Object number
BusinessArea BusinessArea Business Area
CostCenter CostCenter Cost Center
CostCtrActivityType CostCtrActivityType Activity Type
InternalOrder InternalOrder Order
Fund Fund Sender Fund
GrantID GrantID Sender Grant
FunctionalArea FunctionalArea Sendr Fctl Area
FundsCenter FundsCenter Funds Center
WBSElementInternalID WBSElementInternalID WBS Internal ID
WBSElementExternalID
TaxJurisdiction TaxJurisdiction Tax Jurisdiction
RealEstateObject RealEstateObject Real Estate Key
Segment Segment Segment number
ProfitCenter ProfitCenter Profit Center
BudgetPeriod BudgetPeriod Budget Period
ResponsibleCostCenter ResponsibleCostCenter Responsible Cost Center
Room Room Room Number
Plant Plant Valuation Area
AssetLocation AssetLocation Location
VehicleLicensePlateNumber VehicleLicensePlateNumber License Plate Number
PersonnelNumber PersonnelNumber Personnel No.
BusinessPlace BusinessPlace Business place
_AssetTP _AssetTP
_CompanyCode _CompanyCode
_MasterFixedAsset _MasterFixedAsset
_FixedAsset _FixedAsset
_AssetClass _AssetClass
_AssetAccountDetermination _AssetAccountDetermination
_Supplier _Supplier
_AssetCountryOfOrigin _AssetCountryOfOrigin
_OriginalAcquisitionCurrency _OriginalAcquisitionCurrency
_PartnerCompany _PartnerCompany
_InvestmentOrder _InvestmentOrder
_InvestmentReason _InvestmentReason
_EnvrnmtlInvestmentReason _EnvrnmtlInvestmentReason
_FixedAssetGroup _FixedAssetGroup
_FixedAssetPropertyType _FixedAssetPropertyType
_UnitOfMeasure _UnitOfMeasure
_BusinessArea _BusinessArea
_InternalOrder _InternalOrder
_FunctionalArea _FunctionalArea
_Segment _Segment
_Plant _Plant
_AssetLocation _AssetLocation
_Employment _Employment

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_AssetMultipleCreationTP.
-- 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: IASTMULTICRTETP

CREATE VIEW I_AssetMultipleCreationTP AS
SELECT
  CompanyCode,
  MasterFixedAsset,
  FixedAsset,
  RowIndex,
  AssetClass,
  AssetAccountDetermination,
  FixedAssetDescription,
  AssetAdditionalDescription,
  AssetSerialNumber,
  Inventory,
  Supplier,
  AssetCountryOfOrigin,
  AssetManufacturerName,
  OriginalMasterFixedAsset,
  OriginalFixedAsset,
  OriginalFixedAssetValueDate,
  OriginalAcquisitionFiscalYear,
  OriginalAcquisitionAmount,
  OriginalAcquisitionCurrency,
  InHouseProdnPercent,
  AssetTypeName,
  PartnerCompany,
  AssetIsAcquiredUsed,
  InvestmentProjectWBSElement,
  InvestmentOrder,
  LastInventoryDate,
  InventoryNote,
  InventoryIsCounted,
  InvestmentReason,
  EnvrnmtlInvestmentReason,
  FixedAssetGroup,
  PropertyClass,
  FixedAssetPropertyType,
  LocalTaxOffice,
  NoticeOfAssessmentTaxID,
  LastAssessmentNoticeDate,
  Municipality,
  LandRegisterDate,
  LandRegisterEntrySequence,
  LandRegisterEntryDate,
  LandRegisterVolume,
  LandRegisterPage,
  LandRegisterMap,
  LandPlot,
  ConveyanceDate,
  AreaSize,
  AreaSizeUnit,
  AssetIsRealEstate,
  LeaseSupplier,
  LeaseAgreement,
  LeaseAgreementDate,
  LeaseTermEndDate,
  LeaseTermStartDate,
  LeaseDurationInFiscalYears,
  LeaseDurationInFiscalPeriods,
  LeaseType,
  LeasedAssetNote,
  BaseUnit,
  FixedAssetOrderDate,
  LastReorganizationDate,
  ObjectInternalID,
  BusinessArea,
  CostCenter,
  CostCtrActivityType,
  InternalOrder,
  Fund,
  GrantID,
  FunctionalArea,
  FundsCenter,
  WBSElementInternalID,
  cast (cast('' as abap.char(24)) as ps_posid_edit preserving type) AS WBSElementExternalID,
  TaxJurisdiction,
  RealEstateObject,
  Segment,
  ProfitCenter,
  BudgetPeriod,
  ResponsibleCostCenter,
  Room,
  Plant,
  AssetLocation,
  VehicleLicensePlateNumber,
  PersonnelNumber,
  BusinessPlace
FROM I_AssetMultipleCreation AS Multi
LEFT OUTER JOIN I_AssetTP AS _AssetTP ON CompanyCode = _AssetTP.CompanyCode AND MasterFixedAsset = _AssetTP.MasterFixedAsset AND FixedAsset = _AssetTP.FixedAsset  -- association [1..1]
;

Learn More