What is P_RU_VatReturnMainSection4 in SAP S/4HANA?

P_RU_VatReturnMainSection4 is a consumption CDS view in SAP S/4HANA. Main Section of VAT Return: get additional data It contains 36 fields.

Which tables does P_RU_VatReturnMainSection4 read from?

P_RU_VatReturnMainSection4 reads data from: P_RU_VatReturnMainSection3, I_RU_SupplierData, P_RU_SupplierOKTMOSingle.

What VDM layer is P_RU_VatReturnMainSection4?

P_RU_VatReturnMainSection4 is classified as a Consumption view optimized for specific business scenarios and reporting.

P_RU_VatReturnMainSection4

DDL: P_RU_VATRETURNMAINSECTION4 SQL: PRUVATRETMS4 Type: view CONSUMPTION Package: GLO_FIN_IS_VAT_RU_RETURN

36 Fields 3 Data Sources 1 Associations

Main Section of VAT Return: get additional data

P_RU_VatReturnMainSection4 is a Consumption CDS View that provides data about "Main Section of VAT Return: get additional data" in SAP S/4HANA. It reads from 3 data sources (P_RU_VatReturnMainSection3, I_RU_SupplierData, P_RU_SupplierOKTMOSingle) and exposes 36 fields. It has 1 association to related views. Part of development package GLO_FIN_IS_VAT_RU_RETURN.

Data Sources (3)

Source	Alias	Join Type
P_RU_VatReturnMainSection3	P_RU_VatReturnMainSection3	from
I_RU_SupplierData	SupplierData	left_outer
P_RU_SupplierOKTMOSingle	SupplierOKTMO	left_outer

Parameters (4)

Name	Type	Default
P_StatryRptgEntity	srf_reporting_entity
P_StatryRptCategory	srf_rep_cat_id
P_StatryRptRunID	srf_report_run_id
P_FiscalYearVariant	fis_periv

Associations (1)

Cardinality	Target	Alias	Condition
[0..1]	P_ReportCategoryParameters4	_RptgEntityCfg	`_RptgEntityCfg.StatryRptgEntity = $parameters.P_StatryRptgEntity and _RptgEntityCfg.StatryRptCategory = $parameters.P_StatryRptCategory`

Annotations (5)

Name	Value	Level
VDM.private	true	view
VDM.viewType	#CONSUMPTION	view
AbapCatalog.sqlViewName	PRUVATRETMS4	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
AccessControl.authorizationCheck	#NOT_REQUIRED	view

Fields (36)

Field	Source Table	Source Field	Description
CompanyCode	VatReturnMainSection	CompanyCode	Receiver Company Code
AccountingDocument	VatReturnMainSection	AccountingDocument	Journal Entry
FiscalYear	VatReturnMainSection	FiscalYear	G/L Fiscal Year
SourceDocument	VatReturnMainSection	SourceDocument	Document
ExternalInvoice	VatReturnMainSection	ExternalInvoice	External Number
SourceDocumentFiscalYear	VatReturnMainSection	SourceDocumentFiscalYear
PostingDate	VatReturnMainSection	PostingDate	Posting Date for GR
TaxReportingDate	VatReturnMainSection	TaxReportingDate	Tax Reporting Date
DocumentDate	VatReturnMainSection	DocumentDate	Journal Entry Date
CompanyCodeCurrency	VatReturnMainSection	CompanyCodeCurrency	Local Currency
BusinessTransactionType	VatReturnMainSection	BusinessTransactionType	Bus.transaction
AccountingDocumentType	VatReturnMainSection	AccountingDocumentType	Journal Entry Type
TaxCode	VatReturnMainSection	TaxCode	Tax Code
RU_VATReturnVersion	VatReturnMainSection	RU_VATReturnVersion	VAT Return Version
RU_VATReturnSection	VatReturnMainSection	RU_VATReturnSection	VAT Return Section
RU_VATReturnSectionType	VatReturnMainSection	RU_VATReturnSectionType	Section Type
RU_VATSubScenarioVersion	VatReturnMainSection	RU_VATSubScenarioVersion	Subscenario Version
RU_VATSubScenario	VatReturnMainSection	RU_VATSubScenario	Subscenario
RU_VATScenario	VatReturnMainSection	RU_VATScenario	VAT Scenario
VATReturnOperation	VatReturnMainSection	VATReturnOperation	Operation Code
TaxBoxByTaxAuthority	VatReturnMainSection	TaxBoxByTaxAuthority
VATReturnItemDescription	VatReturnMainSection	VATReturnItemDescription
TaxBaseAmountInCoCodeCrcy	VatReturnMainSection	TaxBaseAmountInCoCodeCrcy	TxBaseAmt CoCodeCrcy
TaxAmountInCoCodeCrcy	VatReturnMainSection	TaxAmountInCoCodeCrcy	Tax Amount in Company Code Currency
ExportInvcConfirmedFiscalYear	VatReturnMainSection	ExportInvcConfirmedFiscalYear	Reporting Year
FiscalPeriod	VatReturnMainSection	FiscalPeriod	Tax period
Supplier	VatReturnMainSection	Supplier	Supplier
BusinessPartnerCategory	I_RU_SupplierData	BusinessPartnerCategory	Partner Cat.
RU_PartnerOrganizationINN	I_RU_SupplierData	RU_PartnerOrganizationINN	BP INN
RU_PartnerOrganizationKPP	I_RU_SupplierData	RU_PartnerOrganizationKPP	BP KPP
SupplierName	I_RU_SupplierData	SupplierName	Supplier Name
RU_PartnerPersonINN	I_RU_SupplierData	RU_PartnerPersonINN	BP Pers. INN
FirstName	I_RU_SupplierData	FirstName	First Name
LastName	I_RU_SupplierData	LastName	Last Name
MiddleName	I_RU_SupplierData	MiddleName	Middle Name
AuthorizationGroup	I_RU_SupplierData	AuthorizationGroup	AuthorizGroup

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_VatReturnMainSection4.
-- 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: PRUVATRETMS4
-- Parameters: P_StatryRptgEntity : srf_reporting_entity, P_StatryRptCategory : srf_rep_cat_id, P_StatryRptRunID : srf_report_run_id, P_FiscalYearVariant : fis_periv

CREATE VIEW P_RU_VatReturnMainSection4 AS
SELECT
  VatReturnMainSection.CompanyCode AS CompanyCode,
  VatReturnMainSection.AccountingDocument AS AccountingDocument,
  VatReturnMainSection.FiscalYear AS FiscalYear,
  VatReturnMainSection.SourceDocument AS SourceDocument,
  VatReturnMainSection.ExternalInvoice AS ExternalInvoice,
  VatReturnMainSection.SourceDocumentFiscalYear AS SourceDocumentFiscalYear,
  VatReturnMainSection.PostingDate AS PostingDate,
  VatReturnMainSection.TaxReportingDate AS TaxReportingDate,
  VatReturnMainSection.DocumentDate AS DocumentDate,
  VatReturnMainSection.CompanyCodeCurrency AS CompanyCodeCurrency,
  VatReturnMainSection.BusinessTransactionType AS BusinessTransactionType,
  VatReturnMainSection.AccountingDocumentType AS AccountingDocumentType,
  VatReturnMainSection.TaxCode AS TaxCode,
  VatReturnMainSection.RU_VATReturnVersion AS RU_VATReturnVersion,
  VatReturnMainSection.RU_VATReturnSection AS RU_VATReturnSection,
  VatReturnMainSection.RU_VATReturnSectionType AS RU_VATReturnSectionType,
  VatReturnMainSection.RU_VATSubScenarioVersion AS RU_VATSubScenarioVersion,
  VatReturnMainSection.RU_VATSubScenario AS RU_VATSubScenario,
  VatReturnMainSection.RU_VATScenario AS RU_VATScenario,
  VatReturnMainSection.VATReturnOperation AS VATReturnOperation,
  VatReturnMainSection.TaxBoxByTaxAuthority AS TaxBoxByTaxAuthority,
  VatReturnMainSection.VATReturnItemDescription AS VATReturnItemDescription,
  VatReturnMainSection.TaxBaseAmountInCoCodeCrcy AS TaxBaseAmountInCoCodeCrcy,
  VatReturnMainSection.TaxAmountInCoCodeCrcy AS TaxAmountInCoCodeCrcy,
  VatReturnMainSection.ExportInvcConfirmedFiscalYear AS ExportInvcConfirmedFiscalYear,
  VatReturnMainSection.FiscalPeriod AS FiscalPeriod,
  VatReturnMainSection.Supplier AS Supplier,
  SupplierData.BusinessPartnerCategory AS BusinessPartnerCategory,
  SupplierData.RU_PartnerOrganizationINN AS RU_PartnerOrganizationINN,
  SupplierData.RU_PartnerOrganizationKPP AS RU_PartnerOrganizationKPP,
  SupplierData.SupplierName AS SupplierName,
  SupplierData.RU_PartnerPersonINN AS RU_PartnerPersonINN,
  SupplierData.FirstName AS FirstName,
  SupplierData.LastName AS LastName,
  SupplierData.MiddleName AS MiddleName,
  SupplierData.AuthorizationGroup AS AuthorizationGroup
FROM P_RU_VatReturnMainSection3
LEFT OUTER JOIN I_RU_SupplierData AS SupplierData ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_RU_SupplierOKTMOSingle AS SupplierOKTMO ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_ReportCategoryParameters4 AS _RptgEntityCfg ON _RptgEntityCfg.StatryRptgEntity = $parameters.P_StatryRptgEntity AND _RptgEntityCfg.StatryRptCategory = $parameters.P_StatryRptCategory  -- association [0..1]
;

Depth:

P_RU_VatReturnMainSection4 view