I_FSItemMappingHeaderDef

DDL: I_FSITEMMAPPINGHEADERDEF Type: view COMPOSITE Package: FIN_CS_MD_FSITEMMAPPING
25 Fields 1 Data Sources 7 Associations

Financial Statement Item Mapping Header

I_FSItemMappingHeaderDef is a Composite CDS View that provides data about "Financial Statement Item Mapping Header" in SAP S/4HANA. It reads from 1 data source (P_FSITEMMAPPINGHEADERDEF) and exposes 25 fields with key field FSItemMappingUUID. It has 7 associations to related views. Part of development package FIN_CS_MD_FSITEMMAPPING.

Data Sources (1)

SourceAliasJoin Type
P_FSITEMMAPPINGHEADERDEF P_FSITEMMAPPINGHEADERDEF from

Associations (7)

CardinalityTargetAliasCondition
[0..1] I_CnsldtnChartOfAccounts _ConsChartOfAccounts $projection.ConsolidationChartOfAccounts = _ConsChartOfAccounts.ConsolidationChartOfAccounts
[0..1] I_ChartOfAccounts _GLChartOfAccounts $projection.ChartOfAccounts = _GLChartOfAccounts.ChartOfAccounts
[1..1] I_FSItemMapping _Mapping $projection.FSItemMappingID = _Mapping.FSItemMappingID
[1..1] I_FSItemMappingRevision _Revision $projection.ConsolidationChartOfAccounts = _Revision.ConsolidationChartOfAccounts and $projection.FSItemMappingID = _Revision.FSItemMappingID and $projection.ChartOfAccounts = _Revision.ChartOfAccounts and $projection.FSItemMappingRevision = _Revision.FSItemMappingRevision
[1..*] I_FSItemMappingAssignment _Assignment $projection.ConsolidationChartOfAccounts = _Assignment.ConsolidationChartOfAccounts and $projection.FSItemMappingID = _Assignment.FSItemMappingID and $projection.ChartOfAccounts = _Assignment.ChartOfAccounts and $projection.FSItemMappingRevision = _Assignment.FSItemMappingRevision
[0..1] I_UserContactCard _CreatedByUser $projection.CreatedByUser = _CreatedByUser.ContactCardID
[0..1] I_UserContactCard _LastChangeByUser $projection.LastChangeByUser = _LastChangeByUser.ContactCardID

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IFSITEMMAPHDRDEF view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
EndUserText.label Financial Statement Item Mapping Header view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY FSItemMappingUUID FSItemMappingUUID
ConsolidationChartOfAccounts ConsolidationChartOfAccounts Cons. COA
ChartOfAccounts ChartOfAccounts Node Class
FSItemMappingID FSItemMappingID Mapping ID
FSItemMappingRevision FSItemMappingRevision Revision
TotalNmbrOfMappedGLAccounts TotalNmbrOfMappedGLAccounts Mapped G/L Accounts
TotalNmbrOfNotMappedGLAccounts TotalNmbrOfNotMappedGLAccounts Unmapped G/L Accounts
TotalNmbrOfFinStmntItems TotalNmbrOfFinStmntItems FS Items
HasError HasError TRUE
SystemMessageText SystemMessageText Message Text
IsActiveEntity IsActiveEntity Status
HasActiveEntity HasActiveEntity With Active Version
HasDraftEntity HasDraftEntity With Draft Version
CreatedByUser CreatedByUser Created By
CreationDateTime CreationDateTime Created At
LastChangeByUser LastChangeByUser Last Changed By
LastChangeDateTime LastChangeDateTime Last Changed At
QueueTimeInSeconds
_ConsChartOfAccounts _ConsChartOfAccounts
_GLChartOfAccounts _GLChartOfAccounts
_Mapping _Mapping
_Revision _Revision
_Assignment _Assignment
_CreatedByUser _CreatedByUser
_LastChangeByUser _LastChangeByUser

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_FSItemMappingHeaderDef.
-- 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.

CREATE VIEW I_FSItemMappingHeaderDef AS
SELECT
  FSItemMappingUUID,
  ConsolidationChartOfAccounts,
  ChartOfAccounts,
  FSItemMappingID,
  FSItemMappingRevision,
  TotalNmbrOfMappedGLAccounts,
  TotalNmbrOfNotMappedGLAccounts,
  TotalNmbrOfFinStmntItems,
  HasError,
  SystemMessageText,
  IsActiveEntity,
  HasActiveEntity,
  HasDraftEntity,
  CreatedByUser,
  CreationDateTime,
  LastChangeByUser,
  LastChangeDateTime,
  TSTMP_SECONDS_BETWEEN(CreationDateTime, TSTMP_CURRENT_UTCTIMESTAMP(), 'INITIAL') AS QueueTimeInSeconds
FROM P_FSITEMMAPPINGHEADERDEF
LEFT OUTER JOIN I_CnsldtnChartOfAccounts AS _ConsChartOfAccounts ON ConsolidationChartOfAccounts = _ConsChartOfAccounts.ConsolidationChartOfAccounts  -- association [0..1]
LEFT OUTER JOIN I_ChartOfAccounts AS _GLChartOfAccounts ON ChartOfAccounts = _GLChartOfAccounts.ChartOfAccounts  -- association [0..1]
LEFT OUTER JOIN I_FSItemMapping AS _Mapping ON FSItemMappingID = _Mapping.FSItemMappingID  -- association [1..1]
LEFT OUTER JOIN I_FSItemMappingRevision AS _Revision ON ConsolidationChartOfAccounts = _Revision.ConsolidationChartOfAccounts AND FSItemMappingID = _Revision.FSItemMappingID AND ChartOfAccounts = _Revision.ChartOfAccounts AND FSItemMappingRevision = _Revision.FSItemMappingRevision  -- association [1..1]
LEFT OUTER JOIN I_FSItemMappingAssignment AS _Assignment ON ConsolidationChartOfAccounts = _Assignment.ConsolidationChartOfAccounts AND FSItemMappingID = _Assignment.FSItemMappingID AND ChartOfAccounts = _Assignment.ChartOfAccounts AND FSItemMappingRevision = _Assignment.FSItemMappingRevision  -- association [1..*]
LEFT OUTER JOIN I_UserContactCard AS _CreatedByUser ON CreatedByUser = _CreatedByUser.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _LastChangeByUser ON LastChangeByUser = _LastChangeByUser.ContactCardID  -- association [0..1]
;

Learn More