P_StRpFxdAsstLocTransferAssgmt

DDL: P_STRPFXDASSTLOCTRANSFERASSGMT SQL: PSRFALTRASSGN Type: view CONSUMPTION Package: GLO_FIN_IS_AA_GEN
19 Fields 2 Data Sources

Fixed Asset Location Transfer Assignment

P_StRpFxdAsstLocTransferAssgmt is a Consumption CDS View that provides data about "Fixed Asset Location Transfer Assignment" in SAP S/4HANA. It reads from 2 data sources (I_FixedAssetAssgmt, I_FixedAssetAssgmt) and exposes 19 fields with key fields CompanyCode, MasterFixedAsset, FixedAsset, ValidityEndDate. Part of development package GLO_FIN_IS_AA_GEN.

Data Sources (2)

SourceAliasJoin Type
I_FixedAssetAssgmt FixedAssetAssgn inner
I_FixedAssetAssgmt FxdAsstAssgn from

Parameters (2)

NameTypeDefault
P_FromPostingDate fiaagen_frm_ltr_date_from
P_ToPostingDate fiaagen_frm_ltr_date_to

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PSRFALTRASSGN view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
VDM.private true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_FixedAssetAssgmt CompanyCode Receiver Company Code
KEY MasterFixedAsset I_FixedAssetAssgmt MasterFixedAsset Fixed Asset
KEY FixedAsset I_FixedAssetAssgmt FixedAsset Sub-number
KEY ValidityEndDate I_FixedAssetAssgmt ValidityEndDate ValidTo
ControllingArea I_FixedAssetAssgmt ControllingArea Controlling Area
ValidityStartDate I_FixedAssetAssgmt ValidityStartDate Validity Start Date
NewAssetCostCenter I_FixedAssetAssgmt CostCenter Cost Center
NewAssetPlant I_FixedAssetAssgmt Plant Valuation Area
NewAssetLocation I_FixedAssetAssgmt AssetLocation Location
OldAssetCostCenter I_FixedAssetAssgmt CostCenter Cost Center
OldAssetPlant I_FixedAssetAssgmt Plant Valuation Area
OldAssetLocation I_FixedAssetAssgmt AssetLocation Location
_AssetLocation I_FixedAssetAssgmt _AssetLocation
_CompanyCode I_FixedAssetAssgmt _CompanyCode
_ControllingArea I_FixedAssetAssgmt _ControllingArea
_CostCenter I_FixedAssetAssgmt _CostCenter
_FixedAsset I_FixedAssetAssgmt _FixedAsset
_MasterFixedAsset I_FixedAssetAssgmt _MasterFixedAsset
_Plant I_FixedAssetAssgmt _Plant

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 P_StRpFxdAsstLocTransferAssgmt.
-- 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: PSRFALTRASSGN
-- Parameters: P_FromPostingDate : fiaagen_frm_ltr_date_from, P_ToPostingDate : fiaagen_frm_ltr_date_to

CREATE VIEW P_StRpFxdAsstLocTransferAssgmt AS
SELECT
  FixedAssetAssgn.CompanyCode AS CompanyCode,
  FixedAssetAssgn.MasterFixedAsset AS MasterFixedAsset,
  FixedAssetAssgn.FixedAsset AS FixedAsset,
  FxdAsstAssgn.ValidityEndDate AS ValidityEndDate,
  FixedAssetAssgn.ControllingArea AS ControllingArea,
  FixedAssetAssgn.ValidityStartDate AS ValidityStartDate,
  FixedAssetAssgn.CostCenter AS NewAssetCostCenter,
  FixedAssetAssgn.Plant AS NewAssetPlant,
  FixedAssetAssgn.AssetLocation AS NewAssetLocation,
  FxdAsstAssgn.CostCenter AS OldAssetCostCenter,
  FxdAsstAssgn.Plant AS OldAssetPlant,
  FxdAsstAssgn.AssetLocation AS OldAssetLocation,
  FixedAssetAssgn._AssetLocation AS _AssetLocation,
  FixedAssetAssgn._CompanyCode AS _CompanyCode,
  FixedAssetAssgn._ControllingArea AS _ControllingArea,
  FixedAssetAssgn._CostCenter AS _CostCenter,
  FixedAssetAssgn._FixedAsset AS _FixedAsset,
  FixedAssetAssgn._MasterFixedAsset AS _MasterFixedAsset,
  FixedAssetAssgn._Plant AS _Plant
FROM I_FixedAssetAssgmt AS FxdAsstAssgn
INNER JOIN I_FixedAssetAssgmt AS FixedAssetAssgn ON /* join condition not captured in parsed metadata */
;

Learn More