FINOC_RULE_POI_EXAMPLE

DDL: FINOC_RULE_POI_EXAMPLE SQL: FINOCV_RULE_POIE Type: view Package: FINS_ORGL_CHANGE_RULE
21 Fields 1 Data Sources

Organizational Change: Custom Rule POI

FINOC_RULE_POI_EXAMPLE is a CDS View that provides data about "Organizational Change: Custom Rule POI" in SAP S/4HANA. It reads from 1 data source (FINOC_RULE_POI_BASE) and exposes 21 fields with key fields PurchasingDocument, PurchasingDocumentItem, AccountAssignmentNumber, OrganizationalChange. Part of development package FINS_ORGL_CHANGE_RULE.

Data Sources (1)

SourceAliasJoin Type
FINOC_RULE_POI_BASE base_view from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName FINOCV_RULE_POIE 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 Organizational Change: Custom Rule POI view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY PurchasingDocument PurchasingDocument Purchasing Document
KEY PurchasingDocumentItem PurchasingDocumentItem Purchasing Doc. Item
KEY AccountAssignmentNumber AccountAssignmentNumber Account Assgmt No.
KEY OrganizationalChange OrganizationalChange Organizational Change
ControllingArea ControllingArea Controlling Area
CompanyCode CompanyCode Receiver Company Code
ProfitCenterBeforeOrglChange ProfitCenterBeforeOrglChange
ProfitCenterByOrglChange ProfitCenterByOrglChange New Profit Center
ProfitCenterDerivationSrceType ProfitCenterDerivationSrceType
SourceWBSElementInternalID SourceWBSElementInternalID
SourceProjectInternalID SourceProjectInternalID
SourceProduct SourceProduct Product Sold
SourcePlant SourcePlant Valuation Area
SourceSalesDocument SourceSalesDocument
SourceSalesDocumentItem SourceSalesDocumentItem
SourceCostCenter SourceCostCenter Cost Center
SourceMasterFixedAsset SourceMasterFixedAsset
SourceFixedAsset SourceFixedAsset
SourceOrder SourceOrder
SourceOperation SourceOperation
SemanticObject SemanticObject Semantic Object

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_RULE_POI_EXAMPLE.
-- 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_RULE_POIE

CREATE VIEW FINOC_RULE_POI_EXAMPLE AS
SELECT
  PurchasingDocument,
  PurchasingDocumentItem,
  AccountAssignmentNumber,
  OrganizationalChange,
  ControllingArea,
  CompanyCode,
  ProfitCenterBeforeOrglChange,
  ProfitCenterByOrglChange,
  ProfitCenterDerivationSrceType,
  SourceWBSElementInternalID,
  SourceProjectInternalID,
  SourceProduct,
  SourcePlant,
  SourceSalesDocument,
  SourceSalesDocumentItem,
  SourceCostCenter,
  SourceMasterFixedAsset,
  SourceFixedAsset,
  SourceOrder,
  SourceOperation,
  SemanticObject
FROM FINOC_RULE_POI_BASE AS base_view
;

Learn More