P_RblsItmForKeyDteDuePerd1a

DDL: P_RBLSITMFORKEYDTEDUEPERD1A SQL: PRBLSKDATDUE1A Type: view COMPOSITE
39 Fields 2 Data Sources

P_RblsItmForKeyDteDuePerd1a is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_OperationalAcctgDocItem, I_OperationalAcctgDocItem) and exposes 39 fields with key fields CompanyCode, AccountingDocument, AccountingDocumentItem, FiscalYear.

Data Sources (2)

SourceAliasJoin Type
I_OperationalAcctgDocItem Receivables from
I_OperationalAcctgDocItem ReferencedInvoices left_outer

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName PRBLSKDATDUE1A view
VDM.viewType #COMPOSITE view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (39)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_OperationalAcctgDocItem CompanyCode Receiver Company Code
KEY AccountingDocument I_OperationalAcctgDocItem AccountingDocument Journal Entry
KEY AccountingDocumentItem I_OperationalAcctgDocItem AccountingDocumentItem Posting View Item
KEY FiscalYear I_OperationalAcctgDocItem FiscalYear G/L Fiscal Year
InvoiceReference I_OperationalAcctgDocItem InvoiceReference Invoice Reference
InvoiceItemReference I_OperationalAcctgDocItem InvoiceItemReference Item
InvoiceReferenceFiscalYear I_OperationalAcctgDocItem InvoiceReferenceFiscalYear Invoice Reference Fiscal Year
ClearingDate I_OperationalAcctgDocItem ClearingDate Clearing Date
PostingDate I_OperationalAcctgDocItem PostingDate Posting Date for GR
DocumentDate I_OperationalAcctgDocItem DocumentDate Journal Entry Date
FinancialAccountType I_OperationalAcctgDocItem FinancialAccountType Fin. Account Type
DebitCreditCode I_OperationalAcctgDocItem DebitCreditCode Single-Character Flag
Customer I_OperationalAcctgDocItem Customer Sold-to Party
FollowOnDocumentType I_OperationalAcctgDocItem FollowOnDocumentType Follow-On Document Type
NetDueDate I_OperationalAcctgDocItem NetDueDate Net Due Date
SpecialGLCode I_OperationalAcctgDocItem SpecialGLCode Special G/L Ind
GLAccount I_OperationalAcctgDocItem GLAccount General Ledger
CompanyCodeCurrency I_OperationalAcctgDocItem CompanyCodeCurrency Local Currency
FunctionalCurrency I_OperationalAcctgDocItem FunctionalCurrency Functional Currency
GlobalCurrency
TransactionCurrency I_OperationalAcctgDocItem TransactionCurrency Transaction Currency
AmountInCompanyCodeCurrency I_OperationalAcctgDocItem AmountInCompanyCodeCurrency Local Crcy Amt
AmountInFunctionalCurrency I_OperationalAcctgDocItem AmountInFunctionalCurrency Amount in Functional Currency
AmountInGlobalCurrency
AmountInTransactionCurrency I_OperationalAcctgDocItem AmountInTransactionCurrency Pt Crcy Amt
PostingKey I_OperationalAcctgDocItem PostingKey Posting Key
AccountingDocumentCategory I_OperationalAcctgDocItem AccountingDocumentCategory Journal Entry Category
BusinessArea I_OperationalAcctgDocItem BusinessArea Business Area
FiscalPeriod I_OperationalAcctgDocItem FiscalPeriod Tax period
IsUsedInPaymentTransaction I_OperationalAcctgDocItem IsUsedInPaymentTransaction Is Used In Payment Transaction
RefInvcDocumentDate I_OperationalAcctgDocItem DocumentDate Journal Entry Date
RefInvcFinancialAccountType I_OperationalAcctgDocItem FinancialAccountType Fin. Account Type
RefInvcDebitCreditCode I_OperationalAcctgDocItem DebitCreditCode Single-Character Flag
RefInvcNetPaymentDays I_OperationalAcctgDocItem NetPaymentDays Net Pmt Terms Period
RefInvcCashDiscount2Days I_OperationalAcctgDocItem CashDiscount2Days Days from Baseline Date for Payment
RefInvcCashDiscount1Days I_OperationalAcctgDocItem CashDiscount1Days Days from Baseline Date for Payment
RefInvcDueCalculationBaseDate I_OperationalAcctgDocItem DueCalculationBaseDate Due Calculation Base Date
RefInvcInvoiceReference I_OperationalAcctgDocItem InvoiceReference Invoice Reference
RefInvcNetDueDate I_OperationalAcctgDocItem NetDueDate Net Due Date

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_RblsItmForKeyDteDuePerd1a.
-- 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: PRBLSKDATDUE1A

CREATE VIEW P_RblsItmForKeyDteDuePerd1a AS
SELECT
  Receivables.CompanyCode AS CompanyCode,
  Receivables.AccountingDocument AS AccountingDocument,
  Receivables.AccountingDocumentItem AS AccountingDocumentItem,
  Receivables.FiscalYear AS FiscalYear,
  Receivables.InvoiceReference AS InvoiceReference,
  Receivables.InvoiceItemReference AS InvoiceItemReference,
  Receivables.InvoiceReferenceFiscalYear AS InvoiceReferenceFiscalYear,
  Receivables.ClearingDate AS ClearingDate,
  Receivables.PostingDate AS PostingDate,
  Receivables.DocumentDate AS DocumentDate,
  Receivables.FinancialAccountType AS FinancialAccountType,
  Receivables.DebitCreditCode AS DebitCreditCode,
  Receivables.Customer AS Customer,
  Receivables.FollowOnDocumentType AS FollowOnDocumentType,
  Receivables.NetDueDate AS NetDueDate,
  Receivables.SpecialGLCode AS SpecialGLCode,
  Receivables.GLAccount AS GLAccount,
  Receivables.CompanyCodeCurrency AS CompanyCodeCurrency,
  Receivables.FunctionalCurrency AS FunctionalCurrency,
  cast('EUR' as fis_rkcur ) AS GlobalCurrency,
  Receivables.TransactionCurrency AS TransactionCurrency,
  Receivables.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  Receivables.AmountInFunctionalCurrency AS AmountInFunctionalCurrency,
  cast(0 as fis_ksl) AS AmountInGlobalCurrency,
  Receivables.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  Receivables.PostingKey AS PostingKey,
  Receivables.AccountingDocumentCategory AS AccountingDocumentCategory,
  Receivables.BusinessArea AS BusinessArea,
  Receivables.FiscalPeriod AS FiscalPeriod,
  Receivables.IsUsedInPaymentTransaction AS IsUsedInPaymentTransaction,
  ReferencedInvoices.DocumentDate AS RefInvcDocumentDate,
  ReferencedInvoices.FinancialAccountType AS RefInvcFinancialAccountType,
  ReferencedInvoices.DebitCreditCode AS RefInvcDebitCreditCode,
  ReferencedInvoices.NetPaymentDays AS RefInvcNetPaymentDays,
  ReferencedInvoices.CashDiscount2Days AS RefInvcCashDiscount2Days,
  ReferencedInvoices.CashDiscount1Days AS RefInvcCashDiscount1Days,
  ReferencedInvoices.DueCalculationBaseDate AS RefInvcDueCalculationBaseDate,
  ReferencedInvoices.InvoiceReference AS RefInvcInvoiceReference,
  ReferencedInvoices.NetDueDate AS RefInvcNetDueDate
FROM I_OperationalAcctgDocItem AS Receivables
LEFT OUTER JOIN I_OperationalAcctgDocItem AS ReferencedInvoices ON /* join condition not captured in parsed metadata */
;

Learn More