I_BOPFormItemRule

DDL: I_BOPFORMITEMRULE SQL: IBOPRULE Type: view BASIC
14 Fields 1 Data Sources 4 Associations

Balance of Payments Form Item Rule

I_BOPFormItemRule (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Country or Region-Specific Functions for Finance

I_BOPFormItemRule is a Basic CDS View (Dimension) that provides data about "Balance of Payments Form Item Rule" in SAP S/4HANA. It reads from 1 data source (glo_t_boprule) and exposes 14 fields with key fields BOPRptgCntry, BOPForm, BOPFormItem, BOPFormItemRule. It has 4 associations to related views.

SAP Help Documentation

CategoryCDS Views for Balance of Payments
Data CategoryCustomizing
StatusReleased
Purpose
This CDS view reads the different settings for the balance of payment item that is used. For example, it reads the accounts used for that rule.

Structure
Object types This view relates to the following SAP object types: not applicable

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessCountry or Region-Specific Functions for Finance
Application ComponentFI-LOC-FI
CapabilitiesData Source in SQL Select, Data Source for Defining CDS Entities, Association Target for Defining CDS Entities
PackageCountry or Region-Specific Functions for Finance for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
glo_t_boprule glo_t_boprule from

Associations (4)

CardinalityTargetAliasCondition
[0..1] I_Country _BOPRptgCntry $projection.BOPRptgCntry = _BOPRptgCntry.Country
[0..1] I_BOPForm _BOPForm $projection.BOPRptgCntry = _BOPForm.BOPRptgCntry and $projection.BOPForm = _BOPForm.BOPForm
[0..1] I_BOPFormItem _BOPFormItem $projection.BOPRptgCntry = _BOPFormItem.BOPRptgCntry and $projection.BOPForm = _BOPFormItem.BOPForm and $projection.BOPFormItem = _BOPFormItem.BOPFormItem
[0..1] I_BOPTriangularDealRelevancy _BOPTriangularDealRelevancy $projection.BOPTriangularDealRelevancy = _BOPTriangularDealRelevancy.BOPTriangularDealRelevancy

Annotations (16)

NameValueLevelField
EndUserText.label Balance of Payments Form Item Rule view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName IBOPRULE view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
Analytics.dataCategory #DIMENSION view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.type #CLIENT_DEPENDENT view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.representativeKey BOPFormItemRule view
AccessControl.personalData.blocking #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY BOPRptgCntry country Reporting Country/Region
KEY BOPForm form Title
KEY BOPFormItem item Form Item
KEY BOPFormItemRule rule_id Form Item Rule
BOPChtAccts chartofaccounts Chart of Accounts
BOPLowrBndryGLAcct account_from Account Interval Lower Limit
BOPUprBndryGLAcct account_to Account Interval Upper Limit
BOPTaxCode taxcode Tax on Sales/Purchases Code
BOPAcctgDocType doctype Journal Entry Type
BOPTriangularDealRelevancy boptriangulardealrelevancy BOP Triangular Deal Relevancy
_BOPRptgCntry _BOPRptgCntry
_BOPForm _BOPForm
_BOPFormItem _BOPFormItem
_BOPTriangularDealRelevancy _BOPTriangularDealRelevancy

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_BOPFormItemRule.
-- 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: IBOPRULE

CREATE VIEW I_BOPFormItemRule AS
SELECT
  country AS BOPRptgCntry,
  form AS BOPForm,
  item AS BOPFormItem,
  rule_id AS BOPFormItemRule,
  chartofaccounts AS BOPChtAccts,
  account_from AS BOPLowrBndryGLAcct,
  account_to AS BOPUprBndryGLAcct,
  taxcode AS BOPTaxCode,
  doctype AS BOPAcctgDocType,
  BOPTriangularDealRelevancy
FROM glo_t_boprule
LEFT OUTER JOIN I_Country AS _BOPRptgCntry ON BOPRptgCntry = _BOPRptgCntry.Country  -- association [0..1]
LEFT OUTER JOIN I_BOPForm AS _BOPForm ON BOPRptgCntry = _BOPForm.BOPRptgCntry AND BOPForm = _BOPForm.BOPForm  -- association [0..1]
LEFT OUTER JOIN I_BOPFormItem AS _BOPFormItem ON BOPRptgCntry = _BOPFormItem.BOPRptgCntry AND BOPForm = _BOPFormItem.BOPForm AND BOPFormItem = _BOPFormItem.BOPFormItem  -- association [0..1]
LEFT OUTER JOIN I_BOPTriangularDealRelevancy AS _BOPTriangularDealRelevancy ON BOPTriangularDealRelevancy = _BOPTriangularDealRelevancy.BOPTriangularDealRelevancy  -- association [0..1]
;

Learn More