I_IN_IncgInvcAcctPyblItem

DDL: I_IN_INCGINVCACCTPYBLITEM Type: view_entity COMPOSITE
53 Fields 1 Data Sources 1 Associations

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.

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

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED 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 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
IsSalesRelated I_OperationalAcctgDocItem IsSalesRelated Is Sales Related
IsAutomaticallyCreated I_OperationalAcctgDocItem IsAutomaticallyCreated Is Automatically Created
IsUsedInPaymentTransaction I_OperationalAcctgDocItem IsUsedInPaymentTransaction Is Used In Payment Transaction
Supplier I_OperationalAcctgDocItem Supplier Supplier
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
_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

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_IncgInvcAcctPyblItem.
-- 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_IncgInvcAcctPyblItem AS
SELECT
  IncgInvcAcctPyblItem.CompanyCode AS CompanyCode,
  IncgInvcAcctPyblItem.AccountingDocument AS AccountingDocument,
  IncgInvcAcctPyblItem.FiscalYear AS FiscalYear,
  IncgInvcAcctPyblItem.AccountingDocumentItem AS AccountingDocumentItem,
  IncgInvcAcctPyblItem.FinancialAccountType AS FinancialAccountType,
  IncgInvcAcctPyblItem.SpecialGLCode AS SpecialGLCode,
  IncgInvcAcctPyblItem.SpecialGLTransactionType AS SpecialGLTransactionType,
  IncgInvcAcctPyblItem.DebitCreditCode AS DebitCreditCode,
  IncgInvcAcctPyblItem.IsSalesRelated AS IsSalesRelated,
  IncgInvcAcctPyblItem.IsAutomaticallyCreated AS IsAutomaticallyCreated,
  IncgInvcAcctPyblItem.IsUsedInPaymentTransaction AS IsUsedInPaymentTransaction,
  IncgInvcAcctPyblItem.Supplier AS Supplier,
  IncgInvcAcctPyblItem.InvoiceReference AS InvoiceReference,
  IncgInvcAcctPyblItem.InvoiceReferenceFiscalYear AS InvoiceReferenceFiscalYear,
  IncgInvcAcctPyblItem.InvoiceItemReference AS InvoiceItemReference,
  IncgInvcAcctPyblItem.FollowOnDocumentType AS FollowOnDocumentType,
  IncgInvcAcctPyblItem.Material AS Material,
  IncgInvcAcctPyblItem.Product AS Product,
  IncgInvcAcctPyblItem.Plant AS Plant,
  IncgInvcAcctPyblItem.PurchasingDocument AS PurchasingDocument,
  IncgInvcAcctPyblItem.PurchasingDocumentItem AS PurchasingDocumentItem,
  IncgInvcAcctPyblItem.IsNegativePosting AS IsNegativePosting,
  IncgInvcAcctPyblItem.BusinessPlace AS BusinessPlace,
  IncgInvcAcctPyblItem.TaxSection AS TaxSection,
  IncgInvcAcctPyblItem.ReferenceDocumentType AS ReferenceDocumentType,
  IncgInvcAcctPyblItem.OriginalReferenceDocument AS OriginalReferenceDocument,
  IncgInvcAcctPyblItem.ReferenceDocumentLogicalSystem AS ReferenceDocumentLogicalSystem,
  IncgInvcAcctPyblItem.AccountingDocumentItemRef AS AccountingDocumentItemRef,
  IncgInvcAcctPyblItem.FiscalPeriod AS FiscalPeriod,
  IncgInvcAcctPyblItem.AccountingDocumentCategory AS AccountingDocumentCategory,
  IncgInvcAcctPyblItem.PostingDate AS PostingDate,
  IncgInvcAcctPyblItem.DocumentDate AS DocumentDate,
  IncgInvcAcctPyblItem.AccountingDocumentType AS AccountingDocumentType,
  IncgInvcAcctPyblItem.BaseUnit AS BaseUnit,
  IncgInvcAcctPyblItem.Quantity AS Quantity,
  IncgInvcAcctPyblItem.IN_GSTPartner AS IN_GSTPartner,
  IncgInvcAcctPyblItem.IN_GSTPlaceOfSupply AS IN_GSTPlaceOfSupply,
  IncgInvcAcctPyblItem.IN_HSNOrSACCode AS IN_HSNOrSACCode,
  IncgInvcAcctPyblItem._CompanyCode AS _CompanyCode,
  IncgInvcAcctPyblItem._DebitCreditCode AS _DebitCreditCode,
  IncgInvcAcctPyblItem._FinancialAccountType AS _FinancialAccountType,
  IncgInvcAcctPyblItem._FiscalYear AS _FiscalYear,
  IncgInvcAcctPyblItem._JournalEntry AS _JournalEntry,
  IncgInvcAcctPyblItem._Material AS _Material,
  IncgInvcAcctPyblItem._Plant AS _Plant,
  IncgInvcAcctPyblItem._Product AS _Product,
  IncgInvcAcctPyblItem._ProductText AS _ProductText,
  IncgInvcAcctPyblItem._PurchasingDocument AS _PurchasingDocument,
  IncgInvcAcctPyblItem._PurchasingDocumentItem AS _PurchasingDocumentItem,
  IncgInvcAcctPyblItem._ReferenceDocumentType AS _ReferenceDocumentType,
  IncgInvcAcctPyblItem._SpecialGLCode AS _SpecialGLCode,
  IncgInvcAcctPyblItem._Supplier AS _Supplier
FROM I_OperationalAcctgDocItem AS IncgInvcAcctPyblItem
LEFT OUTER JOIN I_BusinessPlace AS _BusinessPlace ON CompanyCode = _BusinessPlace.CompanyCode AND BusinessPlace = _BusinessPlace.BusinessPlace  -- association [0..1]
;

Learn More