I_BOPFORMITEMRULE

CDS View

Balance of Payments Form Item Rule

I_BOPFORMITEMRULE is a CDS View in S/4HANA. Balance of Payments Form Item Rule. It contains 1 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
P_BOPRblsPyblsItemToFormItemR view_entity inner COMPOSITE
P_BOPRevnCostItemToFormItem10 view_entity inner COMPOSITE
P_BOPRevnCostItemToFormItem25 view_entity inner COMPOSITE
P_JrnlEntrItmToBOPFormItm21 view left_outer COMPOSITE
P_JrnlEntrItmToBOPFormItm31 view left_outer COMPOSITE

Fields (1)

KeyField CDS FieldsUsed in Views
KEY BOPFormItem BOPFormItem 4
@EndUserText.label: 'Balance of Payments Form Item Rule'
@AbapCatalog.preserveKey: true
@AbapCatalog.compiler.compareFilter: true 
@AbapCatalog.sqlViewName: 'IBOPRULE' 
@VDM.viewType: #BASIC
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@Analytics.dataCategory: #DIMENSION
@AccessControl.authorizationCheck: #NOT_REQUIRED 
@ClientHandling: { type: #CLIENT_DEPENDENT, algorithm: #SESSION_VARIABLE }
@ObjectModel.usageType: { dataClass: #CUSTOMIZING, sizeCategory: #S, serviceQuality: #B }
@ObjectModel.representativeKey: 'BOPFormItemRule'
@AccessControl.personalData.blocking: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.supportedCapabilities: [#SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE,
                                     #CDS_MODELING_ASSOCIATION_TARGET]

define view I_BOPFormItemRule as

select from glo_t_boprule

association [0..1] to I_Country as _BOPRptgCntry    on $projection.BOPRptgCntry = _BOPRptgCntry.Country  
association [0..1] to I_BOPForm as _BOPForm         on $projection.BOPRptgCntry = _BOPForm.BOPRptgCntry and 
                                                       $projection.BOPForm      = _BOPForm.BOPForm 
association [0..1] to I_BOPFormItem as _BOPFormItem on $projection.BOPRptgCntry = _BOPFormItem.BOPRptgCntry and 
                                                       $projection.BOPForm      = _BOPFormItem.BOPForm and
                                                       $projection.BOPFormItem  = _BOPFormItem.BOPFormItem
association [0..1] to I_BOPTriangularDealRelevancy as _BOPTriangularDealRelevancy
                                                    on $projection.BOPTriangularDealRelevancy = _BOPTriangularDealRelevancy.BOPTriangularDealRelevancy                                                       
{
 
  @ObjectModel.foreignKey.association: '_BOPRptgCntry'  
  key country     as BOPRptgCntry,
  @ObjectModel.foreignKey.association: '_BOPForm'     
  key form        as BOPForm,
  @ObjectModel.foreignKey.association: '_BOPFormItem'     
  key item        as BOPFormItem,
  key rule_id     as BOPFormItemRule,

  chartofaccounts as BOPChtAccts,
  account_from    as BOPLowrBndryGLAcct,
  account_to      as BOPUprBndryGLAcct,
  taxcode         as BOPTaxCode,
  doctype         as BOPAcctgDocType,
  @ObjectModel.foreignKey.association: '_BOPTriangularDealRelevancy'  
  boptriangulardealrelevancy as BOPTriangularDealRelevancy,
      
  _BOPRptgCntry,
  _BOPForm,
  _BOPFormItem,
  _BOPTriangularDealRelevancy
      
}