I_IN_INCGINVCACCTPYBLITEM
Incoming Invoice Account Payable Item
I_IN_INCGINVCACCTPYBLITEM is a CDS View in S/4HANA. Incoming Invoice Account Payable Item. It contains 6 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| P_IN_IncgInvcAcctgDocHlthChk | view_entity | from | COMPOSITE |
Fields (6)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | AccountingDocument | AccountingDocument | 1 |
| KEY | CompanyCode | CompanyCode | 1 |
| KEY | FiscalYear | FiscalYear | 1 |
| DocumentDate | DocumentDate | 1 | |
| IN_HSNOrSACCode | IN_HSNOrSACCode | 1 | |
| PostingDate | PostingDate | 1 |
@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';