I_IN_OutgInvcAcctRblItm

DDL: I_IN_OUTGINVCACCTRBLITM Type: view_entity COMPOSITE

Outgoing Invoice Account Receivable Item

I_IN_OutgInvcAcctRblItm is a Composite CDS View that provides data about "Outgoing Invoice Account Receivable Item" in SAP S/4HANA. It reads from 2 data sources (I_IN_AcctDocTypeClassfctn, I_OperationalAcctgDocItem) and exposes 61 fields with key fields CompanyCode, AccountingDocument, FiscalYear, AccountingDocumentItem. It has 3 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_IN_AcctDocTypeClassfctn I_IN_AcctDocTypeClassfctn inner
I_OperationalAcctgDocItem OutInvcAcctPyblItem from

Associations (3)

CardinalityTargetAliasCondition
[0..*] I_OperationalAcctgDocItem _OutgInvcRevenueItem $projection.CompanyCode = _OutgInvcRevenueItem.CompanyCode and $projection.AccountingDocument = _OutgInvcRevenueItem.AccountingDocument and $projection.FiscalYear = _OutgInvcRevenueItem.FiscalYear and _OutgInvcRevenueItem.FinancialAccountType = 'S' and _OutgInvcRevenueItem.AccountingDocumentItemType = '' and _OutgInvcRevenueItem.TransactionTypeDetermination = '' and _OutgInvcRevenueItem.IsAutomaticallyCreated = ''
[0..*] I_OperationalAcctgDocItem _OutgInvcTaxItem $projection.CompanyCode = _OutgInvcTaxItem.CompanyCode and $projection.AccountingDocument = _OutgInvcTaxItem.AccountingDocument and $projection.FiscalYear = _OutgInvcTaxItem.FiscalYear and _OutgInvcTaxItem.FinancialAccountType = 'S' and _OutgInvcTaxItem.AccountingDocumentItemType = 'T' and _OutgInvcTaxItem.TransactionTypeDetermination <> '' and _OutgInvcTaxItem.IsAutomaticallyCreated = 'X'
[0..1] I_BusinessPlace _BusinessPlace $projection.CompanyCode = _BusinessPlace.CompanyCode and $projection.BusinessPlace = _BusinessPlace.BusinessPlace

Annotations (7)

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

Fields (61)

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
BillingDocument I_OperationalAcctgDocItem BillingDocument
SalesDocument I_OperationalAcctgDocItem SalesDocument
SalesDocumentItem I_OperationalAcctgDocItem SalesDocumentItem
IsSalesRelated I_OperationalAcctgDocItem IsSalesRelated
IsAutomaticallyCreated I_OperationalAcctgDocItem IsAutomaticallyCreated
IsUsedInPaymentTransaction I_OperationalAcctgDocItem IsUsedInPaymentTransaction
Customer I_OperationalAcctgDocItem Customer
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
_Customer I_OperationalAcctgDocItem _Customer
_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
_SalesDoc I_OperationalAcctgDocItem _SalesDoc
_SalesDocItem I_OperationalAcctgDocItem _SalesDocItem
_SalesDocument I_OperationalAcctgDocItem _SalesDocument
_SalesDocumentItem I_OperationalAcctgDocItem _SalesDocumentItem
_OutgInvcRevenueItem _OutgInvcRevenueItem
_OutgInvcTaxItem _OutgInvcTaxItem
_BusinessPlace _BusinessPlace
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Outgoing Invoice Account Receivable Item'
@Metadata.ignorePropagatedAnnotations: false
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #XXL,
  dataClass: #MIXED
}
@VDM.viewType: #COMPOSITE
define view entity I_IN_OutgInvcAcctRblItm
  as select from I_OperationalAcctgDocItem as OutInvcAcctPyblItem
  inner join   I_IN_AcctDocTypeClassfctn on  ( I_IN_AcctDocTypeClassfctn.CompanyCode = OutInvcAcctPyblItem.CompanyCode
                                            or I_IN_AcctDocTypeClassfctn.CompanyCode = '' )
                                           and I_IN_AcctDocTypeClassfctn.AccountingDocumentType = OutInvcAcctPyblItem.AccountingDocumentType

  association [0..*] to I_OperationalAcctgDocItem as _OutgInvcRevenueItem on  $projection.CompanyCode                           = _OutgInvcRevenueItem.CompanyCode
                                                                          and $projection.AccountingDocument                    = _OutgInvcRevenueItem.AccountingDocument
                                                                          and $projection.FiscalYear                            = _OutgInvcRevenueItem.FiscalYear
                                                                          and _OutgInvcRevenueItem.FinancialAccountType         = 'S'
                                                                          and _OutgInvcRevenueItem.AccountingDocumentItemType   = ''
                                                                          and _OutgInvcRevenueItem.TransactionTypeDetermination = ''
                                                                          and _OutgInvcRevenueItem.IsAutomaticallyCreated       = ''

  association [0..*] to I_OperationalAcctgDocItem as _OutgInvcTaxItem     on  $projection.CompanyCode                       =  _OutgInvcTaxItem.CompanyCode
                                                                          and $projection.AccountingDocument                =  _OutgInvcTaxItem.AccountingDocument
                                                                          and $projection.FiscalYear                        =  _OutgInvcTaxItem.FiscalYear
                                                                          and _OutgInvcTaxItem.FinancialAccountType         =  'S'
                                                                          and _OutgInvcTaxItem.AccountingDocumentItemType   =  'T'
                                                                          and _OutgInvcTaxItem.TransactionTypeDetermination <> ''
                                                                          and _OutgInvcTaxItem.IsAutomaticallyCreated       =  'X'
                                           
  association [0..1] to I_BusinessPlace           as _BusinessPlace       on  $projection.CompanyCode   = _BusinessPlace.CompanyCode
                                                                          and $projection.BusinessPlace = _BusinessPlace.BusinessPlace
{
  key OutInvcAcctPyblItem.CompanyCode,
  key OutInvcAcctPyblItem.AccountingDocument,
  key OutInvcAcctPyblItem.FiscalYear,
  key OutInvcAcctPyblItem.AccountingDocumentItem,
      OutInvcAcctPyblItem.FinancialAccountType,
      OutInvcAcctPyblItem.SpecialGLCode,
      OutInvcAcctPyblItem.SpecialGLTransactionType,
      OutInvcAcctPyblItem.DebitCreditCode,
      OutInvcAcctPyblItem.BillingDocument,
      OutInvcAcctPyblItem.SalesDocument,
      OutInvcAcctPyblItem.SalesDocumentItem,
      OutInvcAcctPyblItem.IsSalesRelated,
      OutInvcAcctPyblItem.IsAutomaticallyCreated,
      OutInvcAcctPyblItem.IsUsedInPaymentTransaction,
      OutInvcAcctPyblItem.Customer,
      OutInvcAcctPyblItem.InvoiceReference,
      OutInvcAcctPyblItem.InvoiceReferenceFiscalYear,
      OutInvcAcctPyblItem.InvoiceItemReference,
      OutInvcAcctPyblItem.FollowOnDocumentType,
      OutInvcAcctPyblItem.Material,
      OutInvcAcctPyblItem.Product,
      OutInvcAcctPyblItem.Plant,
      OutInvcAcctPyblItem.PurchasingDocument,
      OutInvcAcctPyblItem.PurchasingDocumentItem,
      OutInvcAcctPyblItem.IsNegativePosting,
      OutInvcAcctPyblItem.BusinessPlace,
      OutInvcAcctPyblItem.TaxSection,
      OutInvcAcctPyblItem.ReferenceDocumentType,
      OutInvcAcctPyblItem.OriginalReferenceDocument,
      OutInvcAcctPyblItem.ReferenceDocumentLogicalSystem,
      OutInvcAcctPyblItem.AccountingDocumentItemRef,
      OutInvcAcctPyblItem.FiscalPeriod,
      OutInvcAcctPyblItem.AccountingDocumentCategory,
      OutInvcAcctPyblItem.PostingDate,
      OutInvcAcctPyblItem.DocumentDate,
      OutInvcAcctPyblItem.AccountingDocumentType,
      OutInvcAcctPyblItem.BaseUnit,
      @Semantics: { quantity : {unitOfMeasure: 'BaseUnit'} }
      OutInvcAcctPyblItem.Quantity,
      OutInvcAcctPyblItem.IN_GSTPartner,
      OutInvcAcctPyblItem.IN_GSTPlaceOfSupply,
      OutInvcAcctPyblItem.IN_HSNOrSACCode,
      //      /* Associations */

      OutInvcAcctPyblItem._CompanyCode,
      OutInvcAcctPyblItem._Customer,
      OutInvcAcctPyblItem._DebitCreditCode,
      OutInvcAcctPyblItem._FinancialAccountType,
      OutInvcAcctPyblItem._FiscalYear,
      OutInvcAcctPyblItem._JournalEntry,
      OutInvcAcctPyblItem._Material,
      OutInvcAcctPyblItem._Plant,
      OutInvcAcctPyblItem._Product,
      OutInvcAcctPyblItem._ProductText,
      OutInvcAcctPyblItem._PurchasingDocument,
      OutInvcAcctPyblItem._PurchasingDocumentItem,
      OutInvcAcctPyblItem._ReferenceDocumentType,
      OutInvcAcctPyblItem._SalesDoc,
      OutInvcAcctPyblItem._SalesDocItem,
      OutInvcAcctPyblItem._SalesDocument,
      OutInvcAcctPyblItem._SalesDocumentItem,
      _OutgInvcRevenueItem,
      _OutgInvcTaxItem,
      _BusinessPlace
}
where
      OutInvcAcctPyblItem.FinancialAccountType          = 'D'
  and OutInvcAcctPyblItem.AccountingDocumentItemType    = ''
  and OutInvcAcctPyblItem.SpecialGLTransactionType      = ''
  and OutInvcAcctPyblItem.SpecialGLCode                 = ''
  and OutInvcAcctPyblItem.IsUsedInPaymentTransaction    = ''
  and OutInvcAcctPyblItem._JournalEntry.IsReversal      = ''
  and OutInvcAcctPyblItem._CompanyCode.Country          = 'IN'
  and I_IN_AcctDocTypeClassfctn.IN_AcctDocTypeClassfctn = 'GSTOI';
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_COMPANYCODE",
"I_IN_ACCTDOCTYPECLASSFCTN",
"I_JOURNALENTRY",
"I_OPERATIONALACCTGDOCITEM"
],
"ASSOCIATED":
[
"I_BUSINESSPLACE",
"I_COMPANYCODE",
"I_CUSTOMER",
"I_DEBITCREDITCODE",
"I_FINANCIALACCOUNTTYPE",
"I_FISCALYEARFORCOMPANYCODE",
"I_JOURNALENTRY",
"I_MATERIAL",
"I_OPERATIONALACCTGDOCITEM",
"I_PLANT",
"I_PRODUCT",
"I_PRODUCTDESCRIPTION",
"I_PURCHASINGDOCUMENT",
"I_PURCHASINGDOCUMENTITEM",
"I_REFERENCEDOCUMENTTYPE",
"I_SALESDOCUMENT",
"I_SALESDOCUMENTITEM",
"I_SALESORDER",
"I_SALESORDERITEM"
],
"BASE":
[
"I_OPERATIONALACCTGDOCITEM"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/