C_RU_UnifiedTaxNtcPaytDocItemQ

DDL: C_RU_UNIFIEDTAXNTCPAYTDOCITEMQ SQL: CRUUTNPQUERY Type: view CONSUMPTION

UTNP Analytical - Query

C_RU_UnifiedTaxNtcPaytDocItemQ is a Consumption CDS View that provides data about "UTNP Analytical - Query" in SAP S/4HANA. It reads from 1 data source (C_RU_UnifiedTaxNtcPaytDocItemC) and exposes 28 fields.

Data Sources (1)

SourceAliasJoin Type
C_RU_UnifiedTaxNtcPaytDocItemC C_RU_UnifiedTaxNtcPaytDocItemC from

Parameters (3)

NameTypeDefault
P_StatryRptgEntity srf_reporting_entity
P_StatryRptCategory srf_rep_cat_id
P_StatryRptRunID srf_report_run_id

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CRUUTNPQUERY view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #CONSUMPTION view
Analytics.query true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label UTNP Analytical - Query view

Fields (28)

KeyFieldSource TableSource FieldDescription
StatryRptgEntity StatryRptgEntity Reporting Entity
StatryRptCategory StatryRptCategory Report ID
StatryRptRunID StatryRptRunID Report Run ID
CompanyCode CompanyCode Receiver Company Code
AccountingDocument AccountingDocument Journal Entry
FiscalYear FiscalYear G/L Fiscal Year
JournalEntryItem JournalEntryItem Journal Entry Item
DueCalculationBaseDate DueCalculationBaseDate Due Calculation Base Date
RU_UnifiedTaxNoticePaymentVers RU_UnifiedTaxNoticePaymentVers Unf Tax Notice Vers
RU_UnifiedTaxNtcPaytVersDesc RU_UnifiedTaxNtcPaytVersDesc
RU_SupplierKPP RU_SupplierKPP Seller KPP
RU_TerritoryClassfctnOKTMO RU_TerritoryClassfctnOKTMO OKTMO
RU_BudgetClassificationCode RU_BudgetClassificationCode KBK
RU_UnifiedTaxNoticePeriodCode RU_UnifiedTaxNoticePeriodCode Period Code
RU_UnifiedTxNoticePeriodNumber RU_UnifiedTxNoticePeriodNumber
InputFiscalYear InputFiscalYear Fiscal Year
Supplier Supplier Supplier
GLAccount GLAccount General Ledger
AccountingDocumentType AccountingDocumentType Journal Entry Type
PostingDate PostingDate Posting Date for GR
DocumentDate DocumentDate Journal Entry Date
CompanyCodeName CompanyCodeName Company Name
RU_BudgetClassfctnCodeDesc RU_BudgetClassfctnCodeDesc
SupplierName SupplierName Supplier Name
GLAccountName GLAccountName Short Text
AccountingDocumentTypeName AccountingDocumentTypeName
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency Local Crcy Amt
CompanyCodeCurrency CompanyCodeCurrency Local Currency

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 C_RU_UnifiedTaxNtcPaytDocItemQ.
-- 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: CRUUTNPQUERY
-- Parameters: P_StatryRptgEntity : srf_reporting_entity, P_StatryRptCategory : srf_rep_cat_id, P_StatryRptRunID : srf_report_run_id

CREATE VIEW C_RU_UnifiedTaxNtcPaytDocItemQ AS
SELECT
  StatryRptgEntity,
  StatryRptCategory,
  StatryRptRunID,
  CompanyCode,
  AccountingDocument,
  FiscalYear,
  JournalEntryItem,
  DueCalculationBaseDate,
  RU_UnifiedTaxNoticePaymentVers,
  RU_UnifiedTaxNtcPaytVersDesc,
  RU_SupplierKPP,
  RU_TerritoryClassfctnOKTMO,
  RU_BudgetClassificationCode,
  RU_UnifiedTaxNoticePeriodCode,
  RU_UnifiedTxNoticePeriodNumber,
  InputFiscalYear,
  Supplier,
  GLAccount,
  AccountingDocumentType,
  PostingDate,
  DocumentDate,
  CompanyCodeName,
  RU_BudgetClassfctnCodeDesc,
  SupplierName,
  GLAccountName,
  AccountingDocumentTypeName,
  AmountInCompanyCodeCurrency,
  CompanyCodeCurrency
FROM C_RU_UnifiedTaxNtcPaytDocItemC
;