What is C_BR_ReportingRefNFCube in SAP S/4HANA?

C_BR_ReportingRefNFCube is a consumption CDS view in SAP S/4HANA. EFD-C113-L012 - Referenced NF Cube It contains 15 fields.

Which tables does C_BR_ReportingRefNFCube read from?

C_BR_ReportingRefNFCube reads data from: C_BR_ReportingNFHeaderCube, P_BR_ReportingNFExport.

What VDM layer is C_BR_ReportingRefNFCube?

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

C_BR_ReportingRefNFCube

DDL: C_BR_REPORTINGREFNFCUBE SQL: CBRREFNFCUBE Type: view CONSUMPTION

15 Fields 2 Data Sources

EFD-C113-L012 - Referenced NF Cube

C_BR_ReportingRefNFCube is a Consumption CDS View (Cube) that provides data about "EFD-C113-L012 - Referenced NF Cube" in SAP S/4HANA. It reads from 2 data sources (C_BR_ReportingNFHeaderCube, P_BR_ReportingNFExport) and exposes 15 fields with key field CompanyCode.

Data Sources (2)

Source	Alias	Join Type
C_BR_ReportingNFHeaderCube	C_BR_ReportingNFHeaderCube	from
P_BR_ReportingNFExport	exp	inner

Parameters (3)

Name	Type	Default
P_StatryRptgEntity	srf_reporting_entity
P_StatryRptCategory	srf_rep_cat_id
P_StatryRptRunID	srf_report_run_id

Annotations (15)

Name	Value	Level
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.sqlViewName	CBRREFNFCUBE	view
AccessControl.authorizationCheck	#CHECK	view
AccessControl.personalData.blocking	#NOT_REQUIRED	view
Analytics.dataCategory	#CUBE	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
EndUserText.label	EFD-C113-L012 - Referenced NF Cube	view
Metadata.ignorePropagatedAnnotations	true	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.usageType.serviceQuality	#X	view
ObjectModel.usageType.sizeCategory	#XXL	view
VDM.viewType	#CONSUMPTION	view
Metadata.allowExtensions	true	view
VDM.lifecycle.status	#DEPRECATED	view
VDM.lifecycle.successor		view

Fields (15)

Key	Field	Source Table	Source Field	Description
KEY	CompanyCode	doc	CompanyCode	Receiver Company Code
	BusinessPlace
	BR_NotaFiscal
	NF_ID99asBR_AdditionalNFInfoKey
	BR_NFPostingDate
	DT_E_SC113asBR_SPEDReportRegister
	BR_NFDirection
	BR_NFIssuedBy
	BR_NFPartnerendasBusinessPartner
	BR_NFModel
	BR_NFSeries
	BR_NFSubSeries
	BR_NFeNumber
	BR_NFIssueDate
	BR_NFeAccessKey

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

CREATE VIEW C_BR_ReportingRefNFCube AS
SELECT
  doc.CompanyCode AS CompanyCode
FROM C_BR_ReportingNFHeaderCube
INNER JOIN P_BR_ReportingNFExport AS exp ON /* join condition not captured in parsed metadata */
;

Depth:

C_BR_ReportingRefNFCube view

C_BR_ReportingNFHeaderCube view
P_BR_ReportingNFExport view