FINOC_MOCK_RT_SOI_FILL

DDL: FINOC_MOCK_RT_SOI_FILL SQL: FINOC_MOCKRTSOI Type: view Package: FINS_ORGL_CHANGE_RUNTIME
13 Fields 2 Data Sources

Orgl Change: Mock for FINOC_RT_SOI_FILL

FINOC_MOCK_RT_SOI_FILL is a CDS View that provides data about "Orgl Change: Mock for FINOC_RT_SOI_FILL" in SAP S/4HANA. It reads from 2 data sources (FINOC_RT_WBS_FILL, vbap) and exposes 13 fields with key fields SalesDocument, SalesDocumentItem, OrganizationalChange. Part of development package FINS_ORGL_CHANGE_RUNTIME.

Data Sources (2)

SourceAliasJoin Type
FINOC_RT_WBS_FILL FINOC_RT_WBS_FILL from
vbap vbap inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName FINOC_MOCKRTSOI view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Orgl Change: Mock for FINOC_RT_SOI_FILL view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY SalesDocument vbap vbeln SD Sched. Agmt
KEY SalesDocumentItem vbap posnr WBS Element
KEY OrganizationalChange FINOC_RT_WBS_FILL OrganizationalChange Organizational Change
ControllingArea FINOC_RT_WBS_FILL ControllingArea Controlling Area
CompanyCode FINOC_RT_WBS_FILL CompanyCode Receiver Company Code
ProfitCenterBeforeOrglChange FINOC_RT_WBS_FILL ProfitCenterBeforeOrglChange Profit Center
ProfitCenterByOrglChange FINOC_RT_WBS_FILL ProfitCenterByOrglChange New Profit Center
ProfitCenterDerivationSrceType
SourceWBSElementInternalID FINOC_RT_WBS_FILL WBSElementInternalID WBS Internal ID
SourceProjectInternalID
SourceOrder
SourceProduct
SourcePlant

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 FINOC_MOCK_RT_SOI_FILL.
-- 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: FINOC_MOCKRTSOI

CREATE VIEW FINOC_MOCK_RT_SOI_FILL AS
SELECT
  vbap.vbeln AS SalesDocument,
  vbap.posnr AS SalesDocumentItem,
  FINOC_RT_WBS_FILL.OrganizationalChange AS OrganizationalChange,
  FINOC_RT_WBS_FILL.ControllingArea AS ControllingArea,
  FINOC_RT_WBS_FILL.CompanyCode AS CompanyCode,
  FINOC_RT_WBS_FILL.ProfitCenterBeforeOrglChange AS ProfitCenterBeforeOrglChange,
  FINOC_RT_WBS_FILL.ProfitCenterByOrglChange AS ProfitCenterByOrglChange,
  'PR' AS ProfitCenterDerivationSrceType,
  FINOC_RT_WBS_FILL.WBSElementInternalID AS SourceWBSElementInternalID,
  '00000000' AS SourceProjectInternalID,
  ' ' AS SourceOrder,
  ' ' AS SourceProduct,
  ' ' AS SourcePlant
FROM FINOC_RT_WBS_FILL
INNER JOIN vbap ON /* join condition not captured in parsed metadata */
;

Learn More