P_RblsItmForKeyDteDuePerd1b

DDL: P_RBLSITMFORKEYDTEDUEPERD1B SQL: PRBLSKDATDUE1B Type: view COMPOSITE
29 Fields 1 Data Sources 1 Associations

P_RblsItmForKeyDteDuePerd1b is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_GLAccountLineItemRawData) and exposes 29 fields with key fields CompanyCode, AccountingDocument, AccountingDocumentItem, PostingFiscalYear. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_GLAccountLineItemRawData Receivables from

Parameters (3)

NameTypeDefault
P_KeyDate sydate
P_PeriodType fis_period_type
P_CompanyCode fis_bukrs

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_CalendarDate _CalendarDate _CalendarDate.CalendarDate = $parameters.P_KeyDate

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PRBLSKDATDUE1B view
VDM.viewType #COMPOSITE view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view

Fields (29)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_GLAccountLineItemRawData CompanyCode Receiver Company Code
KEY AccountingDocument I_GLAccountLineItemRawData AccountingDocument Journal Entry
KEY AccountingDocumentItem I_GLAccountLineItemRawData AccountingDocumentItem Posting View Item
KEY PostingFiscalYear I_GLAccountLineItemRawData FiscalYear G/L Fiscal Year
InvoiceReference I_GLAccountLineItemRawData InvoiceReference Invoice Reference
InvoiceItemReference I_GLAccountLineItemRawData InvoiceItemReference Item
InvoiceReferenceFiscalYear I_GLAccountLineItemRawData InvoiceReferenceFiscalYear Invoice Reference Fiscal Year
ClearingDate I_GLAccountLineItemRawData ClearingDate Clearing Date
PostingDate I_GLAccountLineItemRawData PostingDate Posting Date for GR
DocumentDate I_GLAccountLineItemRawData DocumentDate Journal Entry Date
FinancialAccountType I_GLAccountLineItemRawData FinancialAccountType Fin. Account Type
DebitCreditCode I_GLAccountLineItemRawData DebitCreditCode Single-Character Flag
Customer I_GLAccountLineItemRawData Customer Sold-to Party
FollowOnDocumentType I_GLAccountLineItemRawData FollowOnDocumentType Follow-On Document Type
NetDueDate I_GLAccountLineItemRawData NetDueDate Net Due Date
SpecialGLCode I_GLAccountLineItemRawData SpecialGLCode Special G/L Ind
GLAccount I_GLAccountLineItemRawData GLAccount General Ledger
CompanyCodeCurrency I_GLAccountLineItemRawData CompanyCodeCurrency Local Currency
FunctionalCurrency I_GLAccountLineItemRawData FunctionalCurrency Functional Currency
GlobalCurrency I_GLAccountLineItemRawData GlobalCurrency GM Billing Element: Global Currency
AmountInCompanyCodeCurrency I_GLAccountLineItemRawData AmountInCompanyCodeCurrency Local Crcy Amt
AmountInFunctionalCurrency I_GLAccountLineItemRawData AmountInFunctionalCurrency Amount in Functional Currency
AmountInGlobalCurrency I_GLAccountLineItemRawData AmountInGlobalCurrency Amount in Global Currency
PostingKey I_GLAccountLineItemRawData PostingKey Posting Key
AccountingDocumentCategory I_GLAccountLineItemRawData AccountingDocumentCategory Journal Entry Category
BusinessArea I_GLAccountLineItemRawData BusinessArea Business Area
FiscalPeriod I_GLAccountLineItemRawData FiscalPeriod Tax period
CalendarYearendasReportingYear
CalendarWeekendasReportingPeriod

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_RblsItmForKeyDteDuePerd1b.
-- 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: PRBLSKDATDUE1B
-- Parameters: P_KeyDate : sydate, P_PeriodType : fis_period_type, P_CompanyCode : fis_bukrs

CREATE VIEW P_RblsItmForKeyDteDuePerd1b AS
SELECT
  Receivables.CompanyCode AS CompanyCode,
  Receivables.AccountingDocument AS AccountingDocument,
  Receivables.AccountingDocumentItem AS AccountingDocumentItem,
  Receivables.FiscalYear AS PostingFiscalYear,
  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,
  Receivables.GlobalCurrency AS GlobalCurrency,
  Receivables.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  Receivables.AmountInFunctionalCurrency AS AmountInFunctionalCurrency,
  Receivables.AmountInGlobalCurrency AS AmountInGlobalCurrency,
  Receivables.PostingKey AS PostingKey,
  Receivables.AccountingDocumentCategory AS AccountingDocumentCategory,
  Receivables.BusinessArea AS BusinessArea,
  Receivables.FiscalPeriod AS FiscalPeriod,
  case $parameters.P_PeriodType when 'F' then _FiscalPeriod.FiscalYear when 'M' then _CalendarDate.CalendarYear when 'W' then _CalendarDate.CalendarYear end as ReportingYear AS CalendarYearendasReportingYear,
  case $parameters.P_PeriodType when 'F' then _FiscalPeriod.FiscalPeriod when 'M' then cast(_CalendarDate.CalendarMonth as char3) when 'W' then _CalendarDate.CalendarWeek end as ReportingPeriod AS CalendarWeekendasReportingPeriod
FROM I_GLAccountLineItemRawData AS Receivables
LEFT OUTER JOIN I_CalendarDate AS _CalendarDate ON _CalendarDate.CalendarDate = $parameters.P_KeyDate  -- association [0..1]
;

Learn More