What is P_RU_OneTimeAcctData in SAP S/4HANA?

P_RU_OneTimeAcctData is a consumption CDS view in SAP S/4HANA. It contains 23 fields.

Which tables does P_RU_OneTimeAcctData read from?

P_RU_OneTimeAcctData reads data from: P_RU_OneTimeAcctData1, P_RU_OneTimeAcctData1, P_OrganizationNameConsum.

What VDM layer is P_RU_OneTimeAcctData?

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

P_RU_OneTimeAcctData

DDL: P_RU_ONETIMEACCTDATA SQL: PRUONETIMEACCT Type: view CONSUMPTION

23 Fields 3 Data Sources

P_RU_OneTimeAcctData is a Consumption CDS View in SAP S/4HANA. It reads from 3 data sources (P_RU_OneTimeAcctData1, P_RU_OneTimeAcctData1, P_OrganizationNameConsum) and exposes 23 fields with key fields CompanyCode, AccountingDocument, FiscalYear, AccountingDocumentItem, AccountingDocument.

Data Sources (3)

Source	Alias	Join Type
P_RU_OneTimeAcctData1	OneTimeAccBP	from
P_RU_OneTimeAcctData1	OneTimeAccBP	union_all
P_OrganizationNameConsum	OrgName	inner

Annotations (7)

Name	Value	Level
VDM.private	true	view
VDM.viewType	#CONSUMPTION	view
AbapCatalog.sqlViewName	PRUONETIMEACCT	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
AccessControl.authorizationCheck	#NOT_REQUIRED	view
ClientHandling.algorithm	#SESSION_VARIABLE	view

Fields (23)

Key	Field	Source Table	Source Field	Description
KEY	CompanyCode	P_RU_OneTimeAcctData1	CompanyCode	Receiver Company Code
KEY	AccountingDocument	P_RU_OneTimeAcctData1	AccountingDocument	Journal Entry
KEY	FiscalYear	P_RU_OneTimeAcctData1	FiscalYear	G/L Fiscal Year
KEY	AccountingDocumentItem	P_RU_OneTimeAcctData1	AccountingDocumentItem	Posting View Item
	BusinessPartnerFullName	P_RU_OneTimeAcctData1	BusinessPartnerFullName	Broker Name
	AddressID	P_RU_OneTimeAcctData1	AddressID	Ship-to address
	BPIsOrganization	P_RU_OneTimeAcctData1	BPIsOrganization
	RU_PartnerOrganizationINN	P_RU_OneTimeAcctData1	RU_PartnerOrganizationINN	BP INN
	RU_PartnerOrganizationKPP	P_RU_OneTimeAcctData1	RU_PartnerOrganizationKPP	BP KPP
	RU_PartnerPersonINN	P_RU_OneTimeAcctData1	RU_PartnerPersonINN	BP Pers. INN
	IsNaturalPerson	P_RU_OneTimeAcctData1	IsNaturalPerson	Natural person
	CompanyCode			Receiver Company Code
KEY	AccountingDocument	P_RU_OneTimeAcctData1	AccountingDocument	Journal Entry
KEY	FiscalYear	P_RU_OneTimeAcctData1	FiscalYear	G/L Fiscal Year
KEY	AccountingDocumentItem	P_RU_OneTimeAcctData1	AccountingDocumentItem	Posting View Item
	BusinessPartnerFullName	P_RU_OneTimeAcctData1	BusinessPartnerFullName	Broker Name
	AddressID	P_RU_OneTimeAcctData1	AddressID	Ship-to address
	BPIsOrganization	P_RU_OneTimeAcctData1	BPIsOrganization
	RU_PartnerOrganizationINN	P_RU_OneTimeAcctData1	RU_PartnerOrganizationINN	BP INN
	RU_PartnerOrganizationKPP	P_RU_OneTimeAcctData1	RU_PartnerOrganizationKPP	BP KPP
	RU_PartnerPersonINN	P_RU_OneTimeAcctData1	RU_PartnerPersonINN	BP Pers. INN
	IsNaturalPerson	P_RU_OneTimeAcctData1	IsNaturalPerson	Natural person
	OrganizationName	P_OrganizationNameConsum	OrganizationName

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_OneTimeAcctData.
-- 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: PRUONETIMEACCT

CREATE VIEW P_RU_OneTimeAcctData AS
SELECT
  OneTimeAccBP.CompanyCode AS CompanyCode,
  OneTimeAccBP.AccountingDocument AS AccountingDocument,
  OneTimeAccBP.FiscalYear AS FiscalYear,
  OneTimeAccBP.AccountingDocumentItem AS AccountingDocumentItem,
  OneTimeAccBP.BusinessPartnerFullName AS BusinessPartnerFullName,
  OneTimeAccBP.AddressID AS AddressID,
  OneTimeAccBP.BPIsOrganization AS BPIsOrganization,
  OneTimeAccBP.RU_PartnerOrganizationINN AS RU_PartnerOrganizationINN,
  OneTimeAccBP.RU_PartnerOrganizationKPP AS RU_PartnerOrganizationKPP,
  OneTimeAccBP.RU_PartnerPersonINN AS RU_PartnerPersonINN,
  OneTimeAccBP.IsNaturalPerson AS IsNaturalPerson,
  OrgName.OrganizationName AS OrganizationName
FROM P_RU_OneTimeAcctData1 AS OneTimeAccBP
INNER JOIN P_OrganizationNameConsum AS OrgName ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): P_RU_OneTimeAcctData1
;

Depth:

P_RU_OneTimeAcctData view