I_IN_OutgInvcAcctRblItm

DDL: I_IN_OUTGINVCACCTRBLITM Type: view_entity COMPOSITE
61 Fields 2 Data Sources 3 Associations

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 (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED 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 Receiver Company Code
KEY AccountingDocument I_OperationalAcctgDocItem AccountingDocument Journal Entry
KEY FiscalYear I_OperationalAcctgDocItem FiscalYear G/L Fiscal Year
KEY AccountingDocumentItem I_OperationalAcctgDocItem AccountingDocumentItem Posting View Item
FinancialAccountType I_OperationalAcctgDocItem FinancialAccountType Fin. Account Type
SpecialGLCode I_OperationalAcctgDocItem SpecialGLCode Special G/L Ind
SpecialGLTransactionType I_OperationalAcctgDocItem SpecialGLTransactionType Transact.Type
DebitCreditCode I_OperationalAcctgDocItem DebitCreditCode Single-Character Flag
BillingDocument I_OperationalAcctgDocItem BillingDocument SD Document
SalesDocument I_OperationalAcctgDocItem SalesDocument SD Document
SalesDocumentItem I_OperationalAcctgDocItem SalesDocumentItem Sales Document Item
IsSalesRelated I_OperationalAcctgDocItem IsSalesRelated Is Sales Related
IsAutomaticallyCreated I_OperationalAcctgDocItem IsAutomaticallyCreated Is Automatically Created
IsUsedInPaymentTransaction I_OperationalAcctgDocItem IsUsedInPaymentTransaction Is Used In Payment Transaction
Customer I_OperationalAcctgDocItem Customer Sold-to Party
InvoiceReference I_OperationalAcctgDocItem InvoiceReference Invoice Reference
InvoiceReferenceFiscalYear I_OperationalAcctgDocItem InvoiceReferenceFiscalYear Invoice Reference Fiscal Year
InvoiceItemReference I_OperationalAcctgDocItem InvoiceItemReference Item
FollowOnDocumentType I_OperationalAcctgDocItem FollowOnDocumentType Follow-On Document Type
Material I_OperationalAcctgDocItem Material Vehicle Model
Product I_OperationalAcctgDocItem Product Product Sold
Plant I_OperationalAcctgDocItem Plant Valuation Area
PurchasingDocument I_OperationalAcctgDocItem PurchasingDocument Purchasing Document
PurchasingDocumentItem I_OperationalAcctgDocItem PurchasingDocumentItem Purchasing Doc. Item
IsNegativePosting I_OperationalAcctgDocItem IsNegativePosting Negative Posting
BusinessPlace I_OperationalAcctgDocItem BusinessPlace Business place
TaxSection I_OperationalAcctgDocItem TaxSection Tax Section
ReferenceDocumentType I_OperationalAcctgDocItem ReferenceDocumentType Reference Document Type
OriginalReferenceDocument I_OperationalAcctgDocItem OriginalReferenceDocument Reference Key
ReferenceDocumentLogicalSystem I_OperationalAcctgDocItem ReferenceDocumentLogicalSystem Ref. Doc. Lgcl Syst.
AccountingDocumentItemRef I_OperationalAcctgDocItem AccountingDocumentItemRef Position
FiscalPeriod I_OperationalAcctgDocItem FiscalPeriod Tax period
AccountingDocumentCategory I_OperationalAcctgDocItem AccountingDocumentCategory Journal Entry Category
PostingDate I_OperationalAcctgDocItem PostingDate Posting Date for GR
DocumentDate I_OperationalAcctgDocItem DocumentDate Journal Entry Date
AccountingDocumentType I_OperationalAcctgDocItem AccountingDocumentType Journal Entry Type
BaseUnit I_OperationalAcctgDocItem BaseUnit Unit of Measure
Quantity I_OperationalAcctgDocItem Quantity Value
IN_GSTPartner I_OperationalAcctgDocItem IN_GSTPartner GST Partner
IN_GSTPlaceOfSupply I_OperationalAcctgDocItem IN_GSTPlaceOfSupply Place of Supply
IN_HSNOrSACCode I_OperationalAcctgDocItem IN_HSNOrSACCode HSN/SAC Code
_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

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_IN_OutgInvcAcctRblItm.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_IN_OutgInvcAcctRblItm AS
SELECT
  OutInvcAcctPyblItem.CompanyCode AS CompanyCode,
  OutInvcAcctPyblItem.AccountingDocument AS AccountingDocument,
  OutInvcAcctPyblItem.FiscalYear AS FiscalYear,
  OutInvcAcctPyblItem.AccountingDocumentItem AS AccountingDocumentItem,
  OutInvcAcctPyblItem.FinancialAccountType AS FinancialAccountType,
  OutInvcAcctPyblItem.SpecialGLCode AS SpecialGLCode,
  OutInvcAcctPyblItem.SpecialGLTransactionType AS SpecialGLTransactionType,
  OutInvcAcctPyblItem.DebitCreditCode AS DebitCreditCode,
  OutInvcAcctPyblItem.BillingDocument AS BillingDocument,
  OutInvcAcctPyblItem.SalesDocument AS SalesDocument,
  OutInvcAcctPyblItem.SalesDocumentItem AS SalesDocumentItem,
  OutInvcAcctPyblItem.IsSalesRelated AS IsSalesRelated,
  OutInvcAcctPyblItem.IsAutomaticallyCreated AS IsAutomaticallyCreated,
  OutInvcAcctPyblItem.IsUsedInPaymentTransaction AS IsUsedInPaymentTransaction,
  OutInvcAcctPyblItem.Customer AS Customer,
  OutInvcAcctPyblItem.InvoiceReference AS InvoiceReference,
  OutInvcAcctPyblItem.InvoiceReferenceFiscalYear AS InvoiceReferenceFiscalYear,
  OutInvcAcctPyblItem.InvoiceItemReference AS InvoiceItemReference,
  OutInvcAcctPyblItem.FollowOnDocumentType AS FollowOnDocumentType,
  OutInvcAcctPyblItem.Material AS Material,
  OutInvcAcctPyblItem.Product AS Product,
  OutInvcAcctPyblItem.Plant AS Plant,
  OutInvcAcctPyblItem.PurchasingDocument AS PurchasingDocument,
  OutInvcAcctPyblItem.PurchasingDocumentItem AS PurchasingDocumentItem,
  OutInvcAcctPyblItem.IsNegativePosting AS IsNegativePosting,
  OutInvcAcctPyblItem.BusinessPlace AS BusinessPlace,
  OutInvcAcctPyblItem.TaxSection AS TaxSection,
  OutInvcAcctPyblItem.ReferenceDocumentType AS ReferenceDocumentType,
  OutInvcAcctPyblItem.OriginalReferenceDocument AS OriginalReferenceDocument,
  OutInvcAcctPyblItem.ReferenceDocumentLogicalSystem AS ReferenceDocumentLogicalSystem,
  OutInvcAcctPyblItem.AccountingDocumentItemRef AS AccountingDocumentItemRef,
  OutInvcAcctPyblItem.FiscalPeriod AS FiscalPeriod,
  OutInvcAcctPyblItem.AccountingDocumentCategory AS AccountingDocumentCategory,
  OutInvcAcctPyblItem.PostingDate AS PostingDate,
  OutInvcAcctPyblItem.DocumentDate AS DocumentDate,
  OutInvcAcctPyblItem.AccountingDocumentType AS AccountingDocumentType,
  OutInvcAcctPyblItem.BaseUnit AS BaseUnit,
  OutInvcAcctPyblItem.Quantity AS Quantity,
  OutInvcAcctPyblItem.IN_GSTPartner AS IN_GSTPartner,
  OutInvcAcctPyblItem.IN_GSTPlaceOfSupply AS IN_GSTPlaceOfSupply,
  OutInvcAcctPyblItem.IN_HSNOrSACCode AS IN_HSNOrSACCode,
  OutInvcAcctPyblItem._CompanyCode AS _CompanyCode,
  OutInvcAcctPyblItem._Customer AS _Customer,
  OutInvcAcctPyblItem._DebitCreditCode AS _DebitCreditCode,
  OutInvcAcctPyblItem._FinancialAccountType AS _FinancialAccountType,
  OutInvcAcctPyblItem._FiscalYear AS _FiscalYear,
  OutInvcAcctPyblItem._JournalEntry AS _JournalEntry,
  OutInvcAcctPyblItem._Material AS _Material,
  OutInvcAcctPyblItem._Plant AS _Plant,
  OutInvcAcctPyblItem._Product AS _Product,
  OutInvcAcctPyblItem._ProductText AS _ProductText,
  OutInvcAcctPyblItem._PurchasingDocument AS _PurchasingDocument,
  OutInvcAcctPyblItem._PurchasingDocumentItem AS _PurchasingDocumentItem,
  OutInvcAcctPyblItem._ReferenceDocumentType AS _ReferenceDocumentType,
  OutInvcAcctPyblItem._SalesDoc AS _SalesDoc,
  OutInvcAcctPyblItem._SalesDocItem AS _SalesDocItem,
  OutInvcAcctPyblItem._SalesDocument AS _SalesDocument,
  OutInvcAcctPyblItem._SalesDocumentItem AS _SalesDocumentItem
FROM I_OperationalAcctgDocItem AS OutInvcAcctPyblItem
INNER JOIN I_IN_AcctDocTypeClassfctn ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_OperationalAcctgDocItem AS _OutgInvcRevenueItem ON CompanyCode = _OutgInvcRevenueItem.CompanyCode AND AccountingDocument = _OutgInvcRevenueItem.AccountingDocument AND FiscalYear = _OutgInvcRevenueItem.FiscalYear AND _OutgInvcRevenueItem.FinancialAccountType = 'S' AND _OutgInvcRevenueItem.AccountingDocumentItemType = '' AND _OutgInvcRevenueItem.TransactionTypeDetermination = '' AND _OutgInvcRevenueItem.IsAutomaticallyCreated = ''  -- association [0..*]
LEFT OUTER JOIN I_OperationalAcctgDocItem AS _OutgInvcTaxItem ON CompanyCode = _OutgInvcTaxItem.CompanyCode AND AccountingDocument = _OutgInvcTaxItem.AccountingDocument AND FiscalYear = _OutgInvcTaxItem.FiscalYear AND _OutgInvcTaxItem.FinancialAccountType = 'S' AND _OutgInvcTaxItem.AccountingDocumentItemType = 'T' AND _OutgInvcTaxItem.TransactionTypeDetermination <> '' AND _OutgInvcTaxItem.IsAutomaticallyCreated = 'X'  -- association [0..*]
LEFT OUTER JOIN I_BusinessPlace AS _BusinessPlace ON CompanyCode = _BusinessPlace.CompanyCode AND BusinessPlace = _BusinessPlace.BusinessPlace  -- association [0..1]
;

Learn More