I_IN_OutgInvcAcctRblItm
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)
| Source | Alias | Join Type |
|---|---|---|
| I_IN_AcctDocTypeClassfctn | I_IN_AcctDocTypeClassfctn | inner |
| I_OperationalAcctgDocItem | OutInvcAcctPyblItem | from |
Associations (3)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [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)
| Name | Value | Level | Field |
|---|---|---|---|
| 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)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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":""
}
}*/
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA