I_IN_IncgInvcAcctPyblItem

DDL: I_IN_INCGINVCACCTPYBLITEM Type: view_entity COMPOSITE

Incoming Invoice Account Payable Item

I_IN_IncgInvcAcctPyblItem is a Composite CDS View that provides data about "Incoming Invoice Account Payable Item" in SAP S/4HANA. It reads from 1 data source (I_OperationalAcctgDocItem) and exposes 53 fields with key fields CompanyCode, AccountingDocument, FiscalYear, AccountingDocumentItem. It has 1 association to related views.

1 data source(s) 53 fields

Data Sources (1)

SourceAliasJoin Type
I_OperationalAcctgDocItem IncgInvcAcctPyblItem from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_BusinessPlace _BusinessPlace $projection.CompanyCode = _BusinessPlace.CompanyCode and $projection.BusinessPlace = _BusinessPlace.BusinessPlace

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Incoming Invoice Account Payable Item view
Metadata.ignorePropagatedAnnotations false view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view

Fields (53)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_OperationalAcctgDocItem CompanyCode
KEY AccountingDocument I_OperationalAcctgDocItem AccountingDocument
KEY FiscalYear I_OperationalAcctgDocItem FiscalYear
KEY AccountingDocumentItem I_OperationalAcctgDocItem AccountingDocumentItem
FinancialAccountType I_OperationalAcctgDocItem FinancialAccountType
SpecialGLCode I_OperationalAcctgDocItem SpecialGLCode
SpecialGLTransactionType I_OperationalAcctgDocItem SpecialGLTransactionType
DebitCreditCode I_OperationalAcctgDocItem DebitCreditCode
IsSalesRelated I_OperationalAcctgDocItem IsSalesRelated
IsAutomaticallyCreated I_OperationalAcctgDocItem IsAutomaticallyCreated
IsUsedInPaymentTransaction I_OperationalAcctgDocItem IsUsedInPaymentTransaction
Supplier I_OperationalAcctgDocItem Supplier
InvoiceReference I_OperationalAcctgDocItem InvoiceReference
InvoiceReferenceFiscalYear I_OperationalAcctgDocItem InvoiceReferenceFiscalYear
InvoiceItemReference I_OperationalAcctgDocItem InvoiceItemReference
FollowOnDocumentType I_OperationalAcctgDocItem FollowOnDocumentType
Material I_OperationalAcctgDocItem Material
Product I_OperationalAcctgDocItem Product
Plant I_OperationalAcctgDocItem Plant
PurchasingDocument I_OperationalAcctgDocItem PurchasingDocument
PurchasingDocumentItem I_OperationalAcctgDocItem PurchasingDocumentItem
IsNegativePosting I_OperationalAcctgDocItem IsNegativePosting
BusinessPlace I_OperationalAcctgDocItem BusinessPlace
TaxSection I_OperationalAcctgDocItem TaxSection
ReferenceDocumentType I_OperationalAcctgDocItem ReferenceDocumentType
OriginalReferenceDocument I_OperationalAcctgDocItem OriginalReferenceDocument
ReferenceDocumentLogicalSystem I_OperationalAcctgDocItem ReferenceDocumentLogicalSystem
AccountingDocumentItemRef I_OperationalAcctgDocItem AccountingDocumentItemRef
FiscalPeriod I_OperationalAcctgDocItem FiscalPeriod
AccountingDocumentCategory I_OperationalAcctgDocItem AccountingDocumentCategory
PostingDate I_OperationalAcctgDocItem PostingDate
DocumentDate I_OperationalAcctgDocItem DocumentDate
AccountingDocumentType I_OperationalAcctgDocItem AccountingDocumentType
BaseUnit I_OperationalAcctgDocItem BaseUnit
Quantity I_OperationalAcctgDocItem Quantity
IN_GSTPartner I_OperationalAcctgDocItem IN_GSTPartner
IN_GSTPlaceOfSupply I_OperationalAcctgDocItem IN_GSTPlaceOfSupply
IN_HSNOrSACCode I_OperationalAcctgDocItem IN_HSNOrSACCode
_CompanyCode I_OperationalAcctgDocItem _CompanyCode
_DebitCreditCode I_OperationalAcctgDocItem _DebitCreditCode
_FinancialAccountType I_OperationalAcctgDocItem _FinancialAccountType
_FiscalYear I_OperationalAcctgDocItem _FiscalYear
_JournalEntry I_OperationalAcctgDocItem _JournalEntry
_Material I_OperationalAcctgDocItem _Material
_Plant I_OperationalAcctgDocItem _Plant
_Product I_OperationalAcctgDocItem _Product
_ProductText I_OperationalAcctgDocItem _ProductText
_PurchasingDocument I_OperationalAcctgDocItem _PurchasingDocument
_PurchasingDocumentItem I_OperationalAcctgDocItem _PurchasingDocumentItem
_ReferenceDocumentType I_OperationalAcctgDocItem _ReferenceDocumentType
_SpecialGLCode I_OperationalAcctgDocItem _SpecialGLCode
_Supplier I_OperationalAcctgDocItem _Supplier
_BusinessPlace _BusinessPlace 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Incoming Invoice Account Payable Item'
@Metadata.ignorePropagatedAnnotations: false
@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #XXL,
  dataClass: #MIXED
}
@VDM.viewType: #COMPOSITE
define view entity I_IN_IncgInvcAcctPyblItem
  as select from I_OperationalAcctgDocItem as IncgInvcAcctPyblItem

//  association [0..*] to I_OperationalAcctgDocItem as _IncgInvcRevnItem on  $projection.CompanyCode                        =  _IncgInvcRevnItem.CompanyCode

//                                                                       and $projection.AccountingDocument                 =  _IncgInvcRevnItem.AccountingDocument

//                                                                       and $projection.FiscalYear                         =  _IncgInvcRevnItem.FiscalYear

//                                                                       and _IncgInvcRevnItem.FinancialAccountType         =  'S'

//                                                                       and _IncgInvcRevnItem.TransactionTypeDetermination <> 'UPF'

//                                                                       and _IncgInvcRevnItem.IsAutomaticallyCreated       =  ''

//

//  association [0..*] to I_OperationalAcctgDocItem as _IncgInvcTaxItem  on  $projection.CompanyCode                       =  _IncgInvcTaxItem.CompanyCode

//                                                                       and $projection.AccountingDocument                =  _IncgInvcTaxItem.AccountingDocument

//                                                                       and $projection.FiscalYear                        =  _IncgInvcTaxItem.FiscalYear

//                                                                       and _IncgInvcTaxItem.FinancialAccountType         =  'S'

//                                                                       and _IncgInvcTaxItem.AccountingDocumentItemType   =  'T'

//                                                                       and _IncgInvcTaxItem.TransactionTypeDetermination <> ''

//                                                                       and _IncgInvcTaxItem.IsAutomaticallyCreated       =  'X'


  association [0..1] to I_BusinessPlace           as _BusinessPlace    on  $projection.CompanyCode   = _BusinessPlace.CompanyCode
                                                                       and $projection.BusinessPlace = _BusinessPlace.BusinessPlace

{
  key IncgInvcAcctPyblItem.CompanyCode,
  key IncgInvcAcctPyblItem.AccountingDocument,
  key IncgInvcAcctPyblItem.FiscalYear,
  key IncgInvcAcctPyblItem.AccountingDocumentItem,
      IncgInvcAcctPyblItem.FinancialAccountType,
      IncgInvcAcctPyblItem.SpecialGLCode,
      IncgInvcAcctPyblItem.SpecialGLTransactionType,
      IncgInvcAcctPyblItem.DebitCreditCode,
      IncgInvcAcctPyblItem.IsSalesRelated,
      IncgInvcAcctPyblItem.IsAutomaticallyCreated,
      IncgInvcAcctPyblItem.IsUsedInPaymentTransaction,
      IncgInvcAcctPyblItem.Supplier,
      IncgInvcAcctPyblItem.InvoiceReference,
      IncgInvcAcctPyblItem.InvoiceReferenceFiscalYear,
      IncgInvcAcctPyblItem.InvoiceItemReference,
      IncgInvcAcctPyblItem.FollowOnDocumentType,
      IncgInvcAcctPyblItem.Material,
      IncgInvcAcctPyblItem.Product,
      IncgInvcAcctPyblItem.Plant,
      IncgInvcAcctPyblItem.PurchasingDocument,
      IncgInvcAcctPyblItem.PurchasingDocumentItem,
      IncgInvcAcctPyblItem.IsNegativePosting,
      IncgInvcAcctPyblItem.BusinessPlace,
      IncgInvcAcctPyblItem.TaxSection,
      IncgInvcAcctPyblItem.ReferenceDocumentType,
      IncgInvcAcctPyblItem.OriginalReferenceDocument,
      IncgInvcAcctPyblItem.ReferenceDocumentLogicalSystem,
      IncgInvcAcctPyblItem.AccountingDocumentItemRef,
      IncgInvcAcctPyblItem.FiscalPeriod,
      IncgInvcAcctPyblItem.AccountingDocumentCategory,
      IncgInvcAcctPyblItem.PostingDate,
      IncgInvcAcctPyblItem.DocumentDate,
      IncgInvcAcctPyblItem.AccountingDocumentType,
      IncgInvcAcctPyblItem.BaseUnit,
      IncgInvcAcctPyblItem.Quantity,
      IncgInvcAcctPyblItem.IN_GSTPartner,
      IncgInvcAcctPyblItem.IN_GSTPlaceOfSupply,
      IncgInvcAcctPyblItem.IN_HSNOrSACCode,
      /* Associations */
      IncgInvcAcctPyblItem._CompanyCode,
      IncgInvcAcctPyblItem._DebitCreditCode,
      IncgInvcAcctPyblItem._FinancialAccountType,
      IncgInvcAcctPyblItem._FiscalYear,
      IncgInvcAcctPyblItem._JournalEntry,
      IncgInvcAcctPyblItem._Material,
      IncgInvcAcctPyblItem._Plant,
      IncgInvcAcctPyblItem._Product,
      IncgInvcAcctPyblItem._ProductText,
      IncgInvcAcctPyblItem._PurchasingDocument,
      IncgInvcAcctPyblItem._PurchasingDocumentItem,
      IncgInvcAcctPyblItem._ReferenceDocumentType,
      IncgInvcAcctPyblItem._SpecialGLCode,
      IncgInvcAcctPyblItem._Supplier,
//      _IncgInvcRevnItem,

//      _IncgInvcTaxItem,

      _BusinessPlace

}
where
      IncgInvcAcctPyblItem.FinancialAccountType         = 'K'
  and IncgInvcAcctPyblItem.AccountingDocumentItemType   = ''
  and IncgInvcAcctPyblItem.SpecialGLTransactionType     = ''
  and IncgInvcAcctPyblItem.SpecialGLCode                = ''
  and IncgInvcAcctPyblItem.IsUsedInPaymentTransaction   = ''
  and ( IncgInvcAcctPyblItem.AccountingDocumentType     = 'KR' or IncgInvcAcctPyblItem.AccountingDocumentType = 'KG' or IncgInvcAcctPyblItem.AccountingDocumentType = 'RE' )
  and ( IncgInvcAcctPyblItem._JournalEntry.AccountingDocumentType  = 'KR' or IncgInvcAcctPyblItem._JournalEntry.AccountingDocumentType = 'KG' or IncgInvcAcctPyblItem._JournalEntry.AccountingDocumentType = 'RE' )
  and IncgInvcAcctPyblItem._JournalEntry.IsReversal     = ''
  and IncgInvcAcctPyblItem._CompanyCode.Country         = 'IN';

Learn More