FINOC_RT_POI_FILL

DDL: FINOC_RT_POI_FILL SQL: FINOCV_RTPOIFILL Type: view Package: FINS_ORGL_CHANGE_RUNTIME
21 Fields 1 Data Sources

Orgl Change: Fill Runtime for Purg Doc

FINOC_RT_POI_FILL is a CDS View that provides data about "Orgl Change: Fill Runtime for Purg Doc" in SAP S/4HANA. It reads from 1 data source (finoc_rule_t_poi) and exposes 21 fields with key fields PurchasingDocument, PurchasingDocumentItem, AccountAssignmentNumber, OrganizationalChange. Part of development package FINS_ORGL_CHANGE_RUNTIME.

Data Sources (1)

SourceAliasJoin Type
finoc_rule_t_poi finoc_rule_t_poi from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName FINOCV_RTPOIFILL view
AbapCatalog.compiler.compareFilter 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: Fill Runtime for Purg Doc view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY PurchasingDocument ebeln Source PurchDoc
KEY PurchasingDocumentItem ebelp Item pur. doc.
KEY AccountAssignmentNumber zekkn Account Assgmt No.
KEY OrganizationalChange orgl_change Organizational Change
ControllingArea kokrs Org. Value
CompanyCode bukrs Value
ProfitCenterBeforeOrglChange prctr_old Old Profit Center
ProfitCenterByOrglChange prctr Profit Centers
ProfitCenterDerivationSrceType prctr_drvtn_source_type Profit Center Source
SourceWBSElementInternalID srce_ps_psp_pnr Source WBS Element
SourceProjectInternalID srce_ps_prj_pnr Source Project
SourceProduct srce_matnr Source Product
SourcePlant srce_werks Source Plant
SourceSalesDocument srce_kdauf Source Sales Order
SourceSalesDocumentItem srce_kdpos Source Sales Order Item
SourceCostCenter srce_kostl Source Cost Center
SourceMasterFixedAsset srce_anln1 Source Main Asset Number
SourceFixedAsset srce_anln2 Source Asset Subnumber
SourceOrder srce_aufnr Source Order
SourceOperation srce_vornr Source Activity / Operation
SemanticObject

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_RT_POI_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: FINOCV_RTPOIFILL

CREATE VIEW FINOC_RT_POI_FILL AS
SELECT
  ebeln AS PurchasingDocument,
  ebelp AS PurchasingDocumentItem,
  zekkn AS AccountAssignmentNumber,
  orgl_change AS OrganizationalChange,
  kokrs AS ControllingArea,
  bukrs AS CompanyCode,
  prctr_old AS ProfitCenterBeforeOrglChange,
  prctr AS ProfitCenterByOrglChange,
  prctr_drvtn_source_type AS ProfitCenterDerivationSrceType,
  srce_ps_psp_pnr AS SourceWBSElementInternalID,
  srce_ps_prj_pnr AS SourceProjectInternalID,
  srce_matnr AS SourceProduct,
  srce_werks AS SourcePlant,
  srce_kdauf AS SourceSalesDocument,
  srce_kdpos AS SourceSalesDocumentItem,
  srce_kostl AS SourceCostCenter,
  srce_anln1 AS SourceMasterFixedAsset,
  srce_anln2 AS SourceFixedAsset,
  srce_aufnr AS SourceOrder,
  srce_vornr AS SourceOperation,
  'RULE' AS SemanticObject
FROM finoc_rule_t_poi
;

Learn More