I_JP_InvcSummaryMchnLrngItem

DDL: I_JP_INVCSUMMARYMCHNLRNGITEM SQL: IJPISAMLITEM Type: view COMPOSITE Package: GLO_FIN_JP_BSML

Invoice Summary Machine Learning Item

I_JP_InvcSummaryMchnLrngItem is a Composite CDS View that provides data about "Invoice Summary Machine Learning Item" in SAP S/4HANA. It reads from 1 data source (I_JP_InvcSmmryItem) and exposes 27 fields with key fields CompanyCode, FiscalYear, AccountingDocument, AccountingDocumentItem. It has 4 associations to related views. Part of development package GLO_FIN_JP_BSML.

1 data source(s) 27 fields

Data Sources (1)

SourceAliasJoin Type
I_JP_InvcSmmryItem _InvcSmmryItm from

Associations (4)

CardinalityTargetAliasCondition
[0..1] I_Customer _InvcSmmryPayer $projection.InvcSmmryPayer = _InvcSmmryPayer.Customer
[0..1] I_Customer _InvcSmmryRecipient _InvcSmmryItm.InvcSmmryRecipient = _InvcSmmryRecipient.Customer
[0..1] I_JP_InvcSummaryAltvPayerName _InvcSmmryAltvName _InvcSmmryItm.CompanyCode = _InvcSmmryAltvName.CompanyCode and _InvcSmmryItm.InvcSmmryPayer = _InvcSmmryAltvName.InvcSmmryPayer
[0..1] I_JP_InvcSummaryPayerMonthly _InvcSmmryPayerMonthlyInvc _InvcSmmryItm.CompanyCode = _InvcSmmryPayerMonthlyInvc.CompanyCode and _InvcSmmryItm.InvcSmmryMonthlyInvc = _InvcSmmryPayerMonthlyInvc.InvcSmmryMonthlyInvc

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IJPISAMLITEM view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Invoice Summary Machine Learning Item view

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode
KEY FiscalYear FiscalYear
KEY AccountingDocument AccountingDocument
KEY AccountingDocumentItem AccountingDocumentItem
InvcSmmryPayer I_JP_InvcSmmryItem InvcSmmryPayer
InvcSmmryPayerName _InvcSmmryPayer BPCustomerName
InvcSmmryRecipient _InvcSmmryRecipient Customer
InvcSmmryRecipientName _InvcSmmryRecipient BPCustomerName
AlternativePayerName1 _InvcSmmryAltvName AlternativePayerName1
AlternativePayerName2 _InvcSmmryAltvName AlternativePayerName2
AlternativePayerName3 _InvcSmmryAltvName AlternativePayerName3
AlternativePayerName4 _InvcSmmryAltvName AlternativePayerName4
AlternativeBankName1 _InvcSmmryAltvName AlternativeBankName1
AlternativeBankName2 _InvcSmmryAltvName AlternativeBankName2
AlternativeBankName3 _InvcSmmryAltvName AlternativeBankName3
AlternativeBankName4 _InvcSmmryAltvName AlternativeBankName4
AlternativeBankBranchName1 _InvcSmmryAltvName AlternativeBankBranchName1
AlternativeBankBranchName2 _InvcSmmryAltvName AlternativeBankBranchName2
AlternativeBankBranchName3 _InvcSmmryAltvName AlternativeBankBranchName3
AlternativeBankBranchName4 _InvcSmmryAltvName AlternativeBankBranchName4
InvcSmmryVirtualAcctNo _InvcSmmryPayerMonthlyInvc InvcSmmryVirtualAcctNo
Bank _InvcSmmryPayerMonthlyInvc Bank
BankCountry _InvcSmmryPayerMonthlyInvc BankCountry
InvcSmmryMonthlyInvc _InvcSmmryPayerMonthlyInvc InvcSmmryMonthlyInvc
InvcSmmryPayerInvc _InvcSmmryPayerMonthlyInvc InvcSmmryPayerInvc
CustomerCompanyAuthznGroup _InvcSmmryRecipient AuthorizationGroup
SupplierCompanyAuthznGroup _InvcSmmryPayer AuthorizationGroup 
@AbapCatalog.sqlViewName: 'IJPISAMLITEM'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@VDM.viewType:#COMPOSITE
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #('TRANSACTIONAL_DATA') 
@ObjectModel.usageType.serviceQuality:'C'
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass:  #MIXED
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Invoice Summary Machine Learning Item'
define view I_JP_InvcSummaryMchnLrngItem as select from I_JP_InvcSmmryItem as _InvcSmmryItm
  association [0..1] to I_Customer  as _InvcSmmryPayer     
    on $projection.InvcSmmryPayer = _InvcSmmryPayer.Customer 
  association [0..1] to I_Customer  as _InvcSmmryRecipient 
    on _InvcSmmryItm.InvcSmmryRecipient = _InvcSmmryRecipient.Customer
  association [0..1] to I_JP_InvcSummaryAltvPayerName   as _InvcSmmryAltvName  
   on _InvcSmmryItm.CompanyCode = _InvcSmmryAltvName.CompanyCode
    and _InvcSmmryItm.InvcSmmryPayer = _InvcSmmryAltvName.InvcSmmryPayer
  association [0..1] to I_JP_InvcSummaryPayerMonthly  as _InvcSmmryPayerMonthlyInvc    
    on _InvcSmmryItm.CompanyCode = _InvcSmmryPayerMonthlyInvc.CompanyCode
    and _InvcSmmryItm.InvcSmmryMonthlyInvc = _InvcSmmryPayerMonthlyInvc.InvcSmmryMonthlyInvc 
{ key CompanyCode,
  key FiscalYear,
  key AccountingDocument,
  key AccountingDocumentItem,
  _InvcSmmryItm.InvcSmmryPayer,
  _InvcSmmryPayer.BPCustomerName as InvcSmmryPayerName,
  _InvcSmmryRecipient.Customer     as InvcSmmryRecipient,
  _InvcSmmryRecipient.BPCustomerName as InvcSmmryRecipientName,
  _InvcSmmryAltvName.AlternativePayerName1,
  _InvcSmmryAltvName.AlternativePayerName2,
  _InvcSmmryAltvName.AlternativePayerName3,
  _InvcSmmryAltvName.AlternativePayerName4,
  _InvcSmmryAltvName.AlternativeBankName1,
  _InvcSmmryAltvName.AlternativeBankName2,
  _InvcSmmryAltvName.AlternativeBankName3,
  _InvcSmmryAltvName.AlternativeBankName4,
  _InvcSmmryAltvName.AlternativeBankBranchName1,
  _InvcSmmryAltvName.AlternativeBankBranchName2,
  _InvcSmmryAltvName.AlternativeBankBranchName3,
  _InvcSmmryAltvName.AlternativeBankBranchName4,
  _InvcSmmryPayerMonthlyInvc.InvcSmmryVirtualAcctNo,
  _InvcSmmryPayerMonthlyInvc.Bank,
  _InvcSmmryPayerMonthlyInvc.BankCountry, 
  _InvcSmmryPayerMonthlyInvc.InvcSmmryMonthlyInvc,
  _InvcSmmryPayerMonthlyInvc.InvcSmmryPayerInvc,
  _InvcSmmryRecipient.AuthorizationGroup as CustomerCompanyAuthznGroup,
  _InvcSmmryPayer.AuthorizationGroup as SupplierCompanyAuthznGroup
}

Learn More