P_RU_SuplrInvcLogsItem

DDL: P_RU_SUPLRINVCLOGSITEM SQL: PRUSUPINVLI Type: view CONSUMPTION
20 Fields 3 Data Sources 1 Associations

P_RU_SuplrInvcLogsItem is a Consumption CDS View in SAP S/4HANA. It reads from 3 data sources (P_RU_AcctgDocReferenceID, I_PurchasingDocumentItem, I_SupplierInvoiceItemPurOrdRef) and exposes 20 fields. It has 1 association to related views.

Data Sources (3)

SourceAliasJoin Type
P_RU_AcctgDocReferenceID InvoiceAccDocHead inner
I_PurchasingDocumentItem PurchDocItem inner
I_SupplierInvoiceItemPurOrdRef SuplrInvoiceItem from

Associations (1)

CardinalityTargetAliasCondition
[0..1] P_RU_MaterialRcptDateMMMvtMatD _refGoodsRcptMatDoc _refGoodsRcptMatDoc.CompanyCode = InvoiceAccDocHead.CompanyCode and _refGoodsRcptMatDoc.PurchaseOrder = SuplrInvoiceItem.PurchaseOrder and _refGoodsRcptMatDoc.PurchaseOrderItem = SuplrInvoiceItem.PurchaseOrderItem and _refGoodsRcptMatDoc.MaterialDocument = SuplrInvoiceItem.ReferenceDocument and _refGoodsRcptMatDoc.MaterialDocumentYear = SuplrInvoiceItem.ReferenceDocumentFiscalYear and _refGoodsRcptMatDoc.MaterialDocumentItem = SuplrInvoiceItem.ReferenceDocumentItem

Annotations (6)

NameValueLevelField
VDM.private true view
VDM.viewType #CONSUMPTION view
AbapCatalog.sqlViewName PRUSUPINVLI view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (20)

KeyFieldSource TableSource FieldDescription
CompanyCode P_RU_AcctgDocReferenceID CompanyCode Receiver Company Code
AccountingDocument P_RU_AcctgDocReferenceID AccountingDocument Journal Entry
FiscalYear P_RU_AcctgDocReferenceID FiscalYear G/L Fiscal Year
DocumentDate P_RU_AcctgDocReferenceID DocumentDate Journal Entry Date
PostingDate P_RU_AcctgDocReferenceID PostingDate Posting Date for GR
ReferenceDocumentType P_RU_AcctgDocReferenceID ReferenceDocumentType Reference Document Type
IsReversal P_RU_AcctgDocReferenceID IsReversal Reversal doc.
IsReversed P_RU_AcctgDocReferenceID IsReversed Reversed?
SupplierInvoice I_SupplierInvoiceItemPurOrdRef SupplierInvoice
SupplierInvoiceFiscalYear I_SupplierInvoiceItemPurOrdRef FiscalYear G/L Fiscal Year
SupplierInvoiceItem I_SupplierInvoiceItemPurOrdRef SupplierInvoiceItem
PurchaseOrder I_SupplierInvoiceItemPurOrdRef PurchaseOrder Purchasing Document
PurchaseOrderItem I_SupplierInvoiceItemPurOrdRef PurchaseOrderItem Purchasing Document Item
ReferenceDocument I_SupplierInvoiceItemPurOrdRef ReferenceDocument Reference Document
ReferenceDocumentFiscalYear I_SupplierInvoiceItemPurOrdRef ReferenceDocumentFiscalYear Year Cur.Period
ReferenceDocumentItem I_SupplierInvoiceItemPurOrdRef ReferenceDocumentItem Reference item
PurchasingDocumentItemCategory I_SupplierInvoiceItemPurOrdRef PurchasingDocumentItemCategory Item Category
GoodsReceiptIsExpected I_PurchasingDocumentItem GoodsReceiptIsExpected Goods Receipt
InvoiceIsGoodsReceiptBased I_PurchasingDocumentItem InvoiceIsGoodsReceiptBased GR-Based IV
_refGoodsRcptMatDoc _refGoodsRcptMatDoc

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 P_RU_SuplrInvcLogsItem.
-- 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.
-- SQL view name: PRUSUPINVLI

CREATE VIEW P_RU_SuplrInvcLogsItem AS
SELECT
  InvoiceAccDocHead.CompanyCode AS CompanyCode,
  InvoiceAccDocHead.AccountingDocument AS AccountingDocument,
  InvoiceAccDocHead.FiscalYear AS FiscalYear,
  InvoiceAccDocHead.DocumentDate AS DocumentDate,
  InvoiceAccDocHead.PostingDate AS PostingDate,
  InvoiceAccDocHead.ReferenceDocumentType AS ReferenceDocumentType,
  InvoiceAccDocHead.IsReversal AS IsReversal,
  InvoiceAccDocHead.IsReversed AS IsReversed,
  SuplrInvoiceItem.SupplierInvoice AS SupplierInvoice,
  SuplrInvoiceItem.FiscalYear AS SupplierInvoiceFiscalYear,
  SuplrInvoiceItem.SupplierInvoiceItem AS SupplierInvoiceItem,
  SuplrInvoiceItem.PurchaseOrder AS PurchaseOrder,
  SuplrInvoiceItem.PurchaseOrderItem AS PurchaseOrderItem,
  SuplrInvoiceItem.ReferenceDocument AS ReferenceDocument,
  SuplrInvoiceItem.ReferenceDocumentFiscalYear AS ReferenceDocumentFiscalYear,
  SuplrInvoiceItem.ReferenceDocumentItem AS ReferenceDocumentItem,
  SuplrInvoiceItem.PurchasingDocumentItemCategory AS PurchasingDocumentItemCategory,
  PurchDocItem.GoodsReceiptIsExpected AS GoodsReceiptIsExpected,
  PurchDocItem.InvoiceIsGoodsReceiptBased AS InvoiceIsGoodsReceiptBased
FROM I_SupplierInvoiceItemPurOrdRef AS SuplrInvoiceItem
INNER JOIN P_RU_AcctgDocReferenceID AS InvoiceAccDocHead ON /* join condition not captured in parsed metadata */
INNER JOIN I_PurchasingDocumentItem AS PurchDocItem ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_RU_MaterialRcptDateMMMvtMatD AS _refGoodsRcptMatDoc ON _refGoodsRcptMatDoc.CompanyCode = InvoiceAccDocHead.CompanyCode AND _refGoodsRcptMatDoc.PurchaseOrder = SuplrInvoiceItem.PurchaseOrder AND _refGoodsRcptMatDoc.PurchaseOrderItem = SuplrInvoiceItem.PurchaseOrderItem AND _refGoodsRcptMatDoc.MaterialDocument = SuplrInvoiceItem.ReferenceDocument AND _refGoodsRcptMatDoc.MaterialDocumentYear = SuplrInvoiceItem.ReferenceDocumentFiscalYear AND _refGoodsRcptMatDoc.MaterialDocumentItem = SuplrInvoiceItem.ReferenceDocumentItem  -- association [0..1]
;

Learn More