P_DeltaResidualOpenItem

DDL: P_DELTARESIDUALOPENITEM SQL: PGROITD Type: view CONSUMPTION
72 Fields 4 Data Sources

P_DeltaResidualOpenItem is a Consumption CDS View in SAP S/4HANA. It reads from 4 data sources (I_AccountingDocument, I_OperationalAcctgDocItem, I_AccountingDocument, I_OperationalAcctgDocItem) and exposes 72 fields with key fields CompanyCode, ClearedFiscalYear, ClearedAccountingDocument, ClearedAccountingDocumentItem, FiscalYear.

Data Sources (4)

SourceAliasJoin Type
I_AccountingDocument ClearedHeader inner
I_OperationalAcctgDocItem ClearedItem from
I_AccountingDocument ClearingHeader inner
I_OperationalAcctgDocItem InvoiceItem inner

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName PGROITD view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
Metadata.ignorePropagatedAnnotations true view
VDM.private true view
VDM.viewType #CONSUMPTION view

Fields (72)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_OperationalAcctgDocItem CompanyCode Receiver Company Code
KEY ClearedFiscalYear I_OperationalAcctgDocItem FiscalYear G/L Fiscal Year
KEY ClearedAccountingDocument I_OperationalAcctgDocItem AccountingDocument Journal Entry
KEY ClearedAccountingDocumentItem I_OperationalAcctgDocItem AccountingDocumentItem Posting View Item
KEY FiscalYear NewResidualItem FiscalYear G/L Fiscal Year
KEY AccountingDocument NewResidualItem AccountingDocument Journal Entry
KEY AccountingDocumentItem NewResidualItem AccountingDocumentItem Posting View Item
CreationDate I_AccountingDocument AccountingDocumentCreationDate Journal Entry Date
CreationTime I_AccountingDocument CreationTime Time of Change
DebitCreditCode NewResidualItem DebitCreditCode Single-Character Flag
CompanyCodeCurrency NewResidualItem CompanyCodeCurrency Local Currency
AmountInCompanyCodeCurrency NewResidualItem AmountInCompanyCodeCurrency Local Crcy Amt
TransactionCurrency NewResidualItem TransactionCurrency Transaction Currency
AmountInTransactionCurrency NewResidualItem AmountInTransactionCurrency Pt Crcy Amt
Customer NewResidualItem Customer Sold-to Party
BillingDocument NewResidualItem BillingDocument SD Document
AssignmentReference NewResidualItem AssignmentReference Assignment Reference
InvoiceReferenceFiscalYear NewResidualItem InvoiceReferenceFiscalYear Invoice Reference Fiscal Year
InvoiceReference NewResidualItem InvoiceReference Invoice Reference
InvoiceItemReference NewResidualItem InvoiceItemReference Item
AccountingDocumentHeaderText I_AccountingDocument AccountingDocumentHeaderText Doc.Header Text
DocumentItemText NewResidualItem DocumentItemText Text
PaymentDifferenceReason NewResidualItem PaymentDifferenceReason Reason Code
ClearingDate NewResidualItem ClearingDate Clearing Date
ClearingCreationDate NewResidualItem ClearingCreationDate Clrg Creation Date
ClearingDocFiscalYear NewResidualItem ClearingDocFiscalYear Fiscal Year of Clearing Journal Entry
ClearingAccountingDocument NewResidualItem ClearingAccountingDocument Clearing Journal Entry
ClearingItem NewResidualItem ClearingItem Clearing Item
ClearedCashDiscountAmount I_OperationalAcctgDocItem CashDiscountAmount CD Amount
PostingDate NewResidualItem PostingDate Posting Date for GR
DocumentDate NewResidualItem DocumentDate Journal Entry Date
NetDueDate NewResidualItem NetDueDate Net Due Date
CashDiscountBaseAmount NewResidualItem CashDiscountBaseAmount Cash Dscnt Base Amt
CashDiscountAmount NewResidualItem CashDiscountAmount CD Amount
PaymentTerms NewResidualItem PaymentTerms Pyt Terms
CashDiscount1Days NewResidualItem CashDiscount1Days Days from Baseline Date for Payment
CashDiscount2Days NewResidualItem CashDiscount2Days Days from Baseline Date for Payment
NetPaymentDays NewResidualItem NetPaymentDays Net Pmt Terms Period
CashDiscount1Percent NewResidualItem CashDiscount1Percent Disc. Percent 1
CashDiscount2Percent NewResidualItem CashDiscount2Percent Disc. Percent 2
DueCalculationBaseDate NewResidualItem DueCalculationBaseDate Due Calculation Base Date
FixedCashDiscount NewResidualItem FixedCashDiscount Fixed Cash Discount
PaymentBlockingReason NewResidualItem PaymentBlockingReason Pmnt block
II_DebitCreditCode I_OperationalAcctgDocItem DebitCreditCode Single-Character Flag
II_CompanyCodeCurrency I_OperationalAcctgDocItem CompanyCodeCurrency Local Currency
II_AmountInCompanyCodeCurrency I_OperationalAcctgDocItem AmountInCompanyCodeCurrency Local Crcy Amt
II_TransactionCurrency I_OperationalAcctgDocItem TransactionCurrency Transaction Currency
II_AmountInTransactionCurrency I_OperationalAcctgDocItem AmountInTransactionCurrency Pt Crcy Amt
II_Customer I_OperationalAcctgDocItem Customer Sold-to Party
II_BillingDocument I_OperationalAcctgDocItem BillingDocument SD Document
II_AssignmentReference I_OperationalAcctgDocItem AssignmentReference Assignment Reference
II_DocumentItemText I_OperationalAcctgDocItem DocumentItemText Text
II_PaymentDifferenceReason I_OperationalAcctgDocItem PaymentDifferenceReason Reason Code
II_ClearingDate I_OperationalAcctgDocItem ClearingDate Clearing Date
II_ClearingCreationDate I_OperationalAcctgDocItem ClearingCreationDate Clrg Creation Date
II_ClearingDocFiscalYear I_OperationalAcctgDocItem ClearingDocFiscalYear Fiscal Year of Clearing Journal Entry
II_ClearingAccountingDocument I_OperationalAcctgDocItem ClearingAccountingDocument Clearing Journal Entry
II_ClearingItem
II_PostingDate I_OperationalAcctgDocItem PostingDate Posting Date for GR
II_DocumentDate I_OperationalAcctgDocItem DocumentDate Journal Entry Date
II_NetDueDate I_OperationalAcctgDocItem NetDueDate Net Due Date
II_CashDiscountBaseAmount I_OperationalAcctgDocItem CashDiscountBaseAmount Cash Dscnt Base Amt
II_CashDiscountAmount I_OperationalAcctgDocItem CashDiscountAmount CD Amount
II_PaymentTerms I_OperationalAcctgDocItem PaymentTerms Pyt Terms
II_CashDiscount1Days I_OperationalAcctgDocItem CashDiscount1Days Days from Baseline Date for Payment
II_CashDiscount2Days I_OperationalAcctgDocItem CashDiscount2Days Days from Baseline Date for Payment
II_NetPaymentDays I_OperationalAcctgDocItem NetPaymentDays Net Pmt Terms Period
II_CashDiscount1Percent I_OperationalAcctgDocItem CashDiscount1Percent Disc. Percent 1
II_CashDiscount2Percent I_OperationalAcctgDocItem CashDiscount2Percent Disc. Percent 2
II_DueCalculationBaseDate I_OperationalAcctgDocItem DueCalculationBaseDate Due Calculation Base Date
II_FixedCashDiscount I_OperationalAcctgDocItem FixedCashDiscount Fixed Cash Discount
II_PaymentBlockingReason I_OperationalAcctgDocItem PaymentBlockingReason Pmnt block

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_DeltaResidualOpenItem.
-- 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: PGROITD

CREATE VIEW P_DeltaResidualOpenItem AS
SELECT
  ClearedItem.CompanyCode AS CompanyCode,
  ClearedItem.FiscalYear AS ClearedFiscalYear,
  ClearedItem.AccountingDocument AS ClearedAccountingDocument,
  ClearedItem.AccountingDocumentItem AS ClearedAccountingDocumentItem,
  NewResidualItem.FiscalYear AS FiscalYear,
  NewResidualItem.AccountingDocument AS AccountingDocument,
  NewResidualItem.AccountingDocumentItem AS AccountingDocumentItem,
  ClearingHeader.AccountingDocumentCreationDate AS CreationDate,
  ClearingHeader.CreationTime AS CreationTime,
  NewResidualItem.DebitCreditCode AS DebitCreditCode,
  NewResidualItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  NewResidualItem.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  NewResidualItem.TransactionCurrency AS TransactionCurrency,
  NewResidualItem.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  NewResidualItem.Customer AS Customer,
  NewResidualItem.BillingDocument AS BillingDocument,
  NewResidualItem.AssignmentReference AS AssignmentReference,
  NewResidualItem.InvoiceReferenceFiscalYear AS InvoiceReferenceFiscalYear,
  NewResidualItem.InvoiceReference AS InvoiceReference,
  NewResidualItem.InvoiceItemReference AS InvoiceItemReference,
  ClearingHeader.AccountingDocumentHeaderText AS AccountingDocumentHeaderText,
  NewResidualItem.DocumentItemText AS DocumentItemText,
  NewResidualItem.PaymentDifferenceReason AS PaymentDifferenceReason,
  NewResidualItem.ClearingDate AS ClearingDate,
  NewResidualItem.ClearingCreationDate AS ClearingCreationDate,
  NewResidualItem.ClearingDocFiscalYear AS ClearingDocFiscalYear,
  NewResidualItem.ClearingAccountingDocument AS ClearingAccountingDocument,
  NewResidualItem.ClearingItem AS ClearingItem,
  ClearedItem.CashDiscountAmount AS ClearedCashDiscountAmount,
  NewResidualItem.PostingDate AS PostingDate,
  NewResidualItem.DocumentDate AS DocumentDate,
  NewResidualItem.NetDueDate AS NetDueDate,
  NewResidualItem.CashDiscountBaseAmount AS CashDiscountBaseAmount,
  NewResidualItem.CashDiscountAmount AS CashDiscountAmount,
  NewResidualItem.PaymentTerms AS PaymentTerms,
  NewResidualItem.CashDiscount1Days AS CashDiscount1Days,
  NewResidualItem.CashDiscount2Days AS CashDiscount2Days,
  NewResidualItem.NetPaymentDays AS NetPaymentDays,
  NewResidualItem.CashDiscount1Percent AS CashDiscount1Percent,
  NewResidualItem.CashDiscount2Percent AS CashDiscount2Percent,
  NewResidualItem.DueCalculationBaseDate AS DueCalculationBaseDate,
  NewResidualItem.FixedCashDiscount AS FixedCashDiscount,
  NewResidualItem.PaymentBlockingReason AS PaymentBlockingReason,
  InvoiceItem.DebitCreditCode AS II_DebitCreditCode,
  InvoiceItem.CompanyCodeCurrency AS II_CompanyCodeCurrency,
  InvoiceItem.AmountInCompanyCodeCurrency AS II_AmountInCompanyCodeCurrency,
  InvoiceItem.TransactionCurrency AS II_TransactionCurrency,
  InvoiceItem.AmountInTransactionCurrency AS II_AmountInTransactionCurrency,
  InvoiceItem.Customer AS II_Customer,
  InvoiceItem.BillingDocument AS II_BillingDocument,
  InvoiceItem.AssignmentReference AS II_AssignmentReference,
  InvoiceItem.DocumentItemText AS II_DocumentItemText,
  InvoiceItem.PaymentDifferenceReason AS II_PaymentDifferenceReason,
  InvoiceItem.ClearingDate AS II_ClearingDate,
  InvoiceItem.ClearingCreationDate AS II_ClearingCreationDate,
  InvoiceItem.ClearingDocFiscalYear AS II_ClearingDocFiscalYear,
  InvoiceItem.ClearingAccountingDocument AS II_ClearingAccountingDocument,
  cast( InvoiceItem.ClearingItem as agzei ) AS II_ClearingItem,
  InvoiceItem.PostingDate AS II_PostingDate,
  InvoiceItem.DocumentDate AS II_DocumentDate,
  InvoiceItem.NetDueDate AS II_NetDueDate,
  InvoiceItem.CashDiscountBaseAmount AS II_CashDiscountBaseAmount,
  InvoiceItem.CashDiscountAmount AS II_CashDiscountAmount,
  InvoiceItem.PaymentTerms AS II_PaymentTerms,
  InvoiceItem.CashDiscount1Days AS II_CashDiscount1Days,
  InvoiceItem.CashDiscount2Days AS II_CashDiscount2Days,
  InvoiceItem.NetPaymentDays AS II_NetPaymentDays,
  InvoiceItem.CashDiscount1Percent AS II_CashDiscount1Percent,
  InvoiceItem.CashDiscount2Percent AS II_CashDiscount2Percent,
  InvoiceItem.DueCalculationBaseDate AS II_DueCalculationBaseDate,
  InvoiceItem.FixedCashDiscount AS II_FixedCashDiscount,
  InvoiceItem.PaymentBlockingReason AS II_PaymentBlockingReason
FROM I_OperationalAcctgDocItem AS ClearedItem
INNER JOIN I_AccountingDocument AS ClearingHeader ON /* join condition not captured in parsed metadata */
INNER JOIN I_AccountingDocument AS ClearedHeader ON /* join condition not captured in parsed metadata */
INNER JOIN I_OperationalAcctgDocItem AS InvoiceItem ON /* join condition not captured in parsed metadata */
;

Learn More