What is C_JointVentureAcctgDtlHierQry in SAP S/4HANA?

C_JointVentureAcctgDtlHierQry is a consumption CDS view in SAP S/4HANA. Joint Venture Acctg Dtl Hierarchy Query It contains 68 fields.

Which tables does C_JointVentureAcctgDtlHierQry read from?

C_JointVentureAcctgDtlHierQry reads data from: I_JointVentureAcctgExtDetail.

What VDM layer is C_JointVentureAcctgDtlHierQry?

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

C_JointVentureAcctgDtlHierQry

DDL: C_JOINTVENTUREACCTGDTLHIERQRY SQL: CPVJVADTLHIERQRY Type: view CONSUMPTION

68 Fields 1 Data Sources

Joint Venture Acctg Dtl Hierarchy Query

C_JointVentureAcctgDtlHierQry is a Consumption CDS View that provides data about "Joint Venture Acctg Dtl Hierarchy Query" in SAP S/4HANA. It reads from 1 data source (I_JointVentureAcctgExtDetail) and exposes 68 fields with key field JointVentureLineItem.

Data Sources (1)

Source	Alias	Join Type
I_JointVentureAcctgExtDetail	I_JointVentureAcctgExtDetail	from

Annotations (9)

Name	Value	Level
EndUserText.label	Joint Venture Acctg Dtl Hierarchy Query	view
Analytics.query	true	view
VDM.viewType	#CONSUMPTION	view
AccessControl.authorizationCheck	#PRIVILEGED_ONLY	view
AbapCatalog.sqlViewName	CPVJVADTLHIERQRY	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.dataClass	#MIXED	view

Fields (68)

Key	Field	Source Field	Description
KEY	JointVentureLineItem	JointVentureLineItem
	Ledger	Ledger	Ledger
	RecordType	RecordType	Reservation Record Type
	SpecialLedgerVersion	SpecialLedgerVersion
	FiscalYear	FiscalYear	G/L Fiscal Year
	Currency	Currency	Valuation Crcy
	UnitOfMeasure	UnitOfMeasure	Unit Protected Qty
	DebitCreditCode	DebitCreditCode	Single-Character Flag
	LedgerFiscalPeriod	LedgerFiscalPeriod
	DocumentType	DocumentType	Order Type
	AccountingDocument	AccountingDocument	Journal Entry
	AccountingDocumentItem	AccountingDocumentItem	Posting View Item
	CompanyCode	CompanyCode	Receiver Company Code
	JointVenture	JointVenture	Joint venture
	ControllingArea	ControllingArea	Controlling Area
	CostCenter	CostCenter	Cost Center
	ChartOfAccounts	ChartOfAccounts	Node Class
	GLAccountType	GLAccountType	G/L Account Type
	GLAccount	GLAccount	General Ledger
	JointVentureEquityGroup	JointVentureEquityGroup	Joint Venture Equity Group
	BusinessArea	BusinessArea	Business Area
	OriginOrder	OriginOrder
	ProjectInternalID	ProjectInternalID	Project Def.
	ProfitCenter	ProfitCenter	Profit Center
	MasterFixedAsset	MasterFixedAsset	Fixed Asset
	FixedAsset	FixedAsset	Sub-number
	AssetTransactionType	AssetTransactionType	Trans.Type
	JointVentureRecoveryCode	JointVentureRecoveryCode	Recovery Ind.
	Partner	Partner	With Partner
	InternalOrder	InternalOrder	Order
	NetworkActivity	NetworkActivity	Operation/Activity
	AdditionalQuantity1Unit	AdditionalQuantity1Unit	Add Unit Meas 1
	DocumentItemText	DocumentItemText	Text
	IsAutomaticallyPosted	IsAutomaticallyPosted	Auto. Posting
	AccountingDocumentType	AccountingDocumentType	Journal Entry Type
	BusinessTransactionType	BusinessTransactionType	Bus.transaction
	PostingDate	PostingDate	Posting Date for GR
	ValDateForCurrencyTranslation	ValDateForCurrencyTranslation
	ValueDate	ValueDate	Value Date
	RefAccountingDocument	RefAccountingDocument	Document Number
	ReferenceDocumentFiscalYear	ReferenceDocumentFiscalYear	Year Cur.Period
	RefJntVentureDocumentLineItem	RefJntVentureDocumentLineItem
	ReferenceDocumentType	ReferenceDocumentType	Reference Document Type
	BusinessTransactionDocItem	BusinessTransactionDocItem	BTD Item ID
	RefAccountingDocumentItem	RefAccountingDocumentItem	Item
	PayrollType	PayrollType
	AccountingDocCreatedByUser	AccountingDocCreatedByUser	User which created overhead document
	DocumentDate	DocumentDate	Journal Entry Date
	TimeEntry	TimeEntry	Entered at
	TaxCode	TaxCode	Tax Code
	BillingMonth	BillingMonth
	PurchaseOrder	PurchaseOrder	Purchasing Document
	PurchaseOrderItem	PurchaseOrderItem	Purchasing Document Item
	TransactionTypeDetermination	TransactionTypeDetermination	Transaction Key
	ActivityType	ActivityType	Activity Type
	PRAAllocationFrequencyCode	PRAAllocationFrequencyCode
	StartDate	StartDate	Valid From
	Material	Material	Vehicle Model
	ReferenceDocument	ReferenceDocument	Reference Document
	ReferenceBillingDocument	ReferenceBillingDocument
	Customer	Customer	Sold-to Party
	Supplier	Supplier	Supplier
	PaymentTerms	PaymentTerms	Pyt Terms
	ProductionMonth	ProductionMonth
	AmountInTransactionCurrency	AmountInTransactionCurrency	Pt Crcy Amt
	QuantityInBaseUnit	QuantityInBaseUnit	Quantity
	AmountInCompanyCodeCurrency	AmountInCompanyCodeCurrency	Local Crcy Amt
	AmountInGlobalCurrency	AmountInGlobalCurrency	Amount in Global 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_JointVentureAcctgDtlHierQry.
-- 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: CPVJVADTLHIERQRY

CREATE VIEW C_JointVentureAcctgDtlHierQry AS
SELECT
  JointVentureLineItem,
  Ledger,
  RecordType,
  SpecialLedgerVersion,
  FiscalYear,
  Currency,
  UnitOfMeasure,
  DebitCreditCode,
  LedgerFiscalPeriod,
  DocumentType,
  AccountingDocument,
  AccountingDocumentItem,
  CompanyCode,
  JointVenture,
  ControllingArea,
  CostCenter,
  ChartOfAccounts,
  GLAccountType,
  GLAccount,
  JointVentureEquityGroup,
  BusinessArea,
  OriginOrder,
  ProjectInternalID,
  ProfitCenter,
  MasterFixedAsset,
  FixedAsset,
  AssetTransactionType,
  JointVentureRecoveryCode,
  Partner,
  InternalOrder,
  NetworkActivity,
  AdditionalQuantity1Unit,
  DocumentItemText,
  IsAutomaticallyPosted,
  AccountingDocumentType,
  BusinessTransactionType,
  PostingDate,
  ValDateForCurrencyTranslation,
  ValueDate,
  RefAccountingDocument,
  ReferenceDocumentFiscalYear,
  RefJntVentureDocumentLineItem,
  ReferenceDocumentType,
  BusinessTransactionDocItem,
  RefAccountingDocumentItem,
  PayrollType,
  AccountingDocCreatedByUser,
  DocumentDate,
  TimeEntry,
  TaxCode,
  BillingMonth,
  PurchaseOrder,
  PurchaseOrderItem,
  TransactionTypeDetermination,
  ActivityType,
  PRAAllocationFrequencyCode,
  StartDate,
  Material,
  ReferenceDocument,
  ReferenceBillingDocument,
  Customer,
  Supplier,
  PaymentTerms,
  ProductionMonth,
  AmountInTransactionCurrency,
  QuantityInBaseUnit,
  AmountInCompanyCodeCurrency,
  AmountInGlobalCurrency
FROM I_JointVentureAcctgExtDetail
;

Depth:

C_JointVentureAcctgDtlHierQry view

I_JointVentureAcctgExtDetail view