C_JointVentureAuditQuery

DDL: C_JOINTVENTUREAUDITQUERY SQL: CJVAUDITQ Type: view CONSUMPTION Package: GJVA
74 Fields 1 Data Sources

Joint Venture Audit Report Query

C_JointVentureAuditQuery is a Consumption CDS View that provides data about "Joint Venture Audit Report Query" in SAP S/4HANA. It reads from 1 data source (I_JointVentureAuditCube) and exposes 74 fields. Part of development package GJVA.

Data Sources (1)

SourceAliasJoin Type
I_JointVentureAuditCube I_JointVentureAuditCube from

Parameters (1)

NameTypeDefault
P_JVAPeriodAmtThreshold jv_per_amt_cds

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CJVAUDITQ view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
EndUserText.label Joint Venture Audit Report Query view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
VDM.viewType #CONSUMPTION view
Analytics.query true view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (74)

KeyFieldSource TableSource FieldDescription
CompanyCode CompanyCode Receiver Company Code
LedgerFiscalYear LedgerFiscalYear
FiscalPeriod FiscalPeriod Tax period
JointVenture JointVenture Joint venture
JointVentureEquityGroup JointVentureEquityGroup Joint Venture Equity Group
JntVntrRcvryCodeIsBillable JntVntrRcvryCodeIsBillable
GLAccount GLAccount General Ledger
CostCenter CostCenter Cost Center
OrderID OrderID Order ID
ProjectNetwork ProjectNetwork Order
WBSElementInternalID WBSElementInternalID WBS Internal ID
JointVentureCostRecoveryCode JointVentureCostRecoveryCode Recovery Ind.
Ledger Ledger Ledger
ProfitCenter ProfitCenter Profit Center
BusinessArea BusinessArea Business Area
MasterFixedAsset MasterFixedAsset Fixed Asset
FixedAsset FixedAsset Sub-number
AssetTransactionType AssetTransactionType Trans.Type
AccountingDocument AccountingDocument Journal Entry
JointVenturePartner JointVenturePartner Joint Venture Partner
LedgerGLLineItem LedgerGLLineItem Journal Entry Item
JointVentureBillingType JointVentureBillingType
PostingDate PostingDate Posting Date for GR
DocumentDate DocumentDate Journal Entry Date
AccountingDocumentType AccountingDocumentType Journal Entry Type
AccountingDocCreatedByUser AccountingDocCreatedByUser User which created overhead document
ControllingArea ControllingArea Controlling Area
JointVentureEquityType JointVentureEquityType Joint Venture Equity Type
Supplier Supplier Supplier
Customer Customer Sold-to Party
Product Product Product Sold
SalesDocument SalesDocument SD Document
SalesOrganization SalesOrganization Sales Organization
Plant Plant Valuation Area
CostObject CostObject Cost Object
PartnerAccountAssignment PartnerAccountAssignment Partner Account Assignment
PartnerAccountAssignmentType PartnerAccountAssignmentType Partner Account Assignment Type
DocumentItemText DocumentItemText Text
PurchasingDocumentItem PurchasingDocumentItem Purchasing Doc. Item
PartnerCostCenter PartnerCostCenter Sender Cost Ctr
SupplierName SupplierName Supplier Name
RelatedNetworkActivity RelatedNetworkActivity Netwk activity
RealEstateContract RealEstateContract Real Estate Contract
TaxCode TaxCode Tax Code
ControllingBusTransacType ControllingBusTransacType CO Bus. Transaction
BusinessTransactionCategory BusinessTransactionCategory Business Transaction Category
BusinessTransactionType BusinessTransactionType Bus.transaction
ReferenceDocumentType ReferenceDocumentType Reference Document Type
Quantity Quantity Value
BaseUnit BaseUnit Unit of Measure
TransactionCurrency TransactionCurrency Transaction Currency
AmountInTransactionCurrency AmountInTransactionCurrency Pt Crcy Amt
CompanyCodeCurrency CompanyCodeCurrency Local Currency
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency Local Crcy Amt
GlobalCurrency GlobalCurrency GM Billing Element: Global Currency
AmountInGlobalCurrency AmountInGlobalCurrency Amount in Global Currency
BalanceTransactionCurrency BalanceTransactionCurrency Currency
AmountInBalanceTransacCrcy AmountInBalanceTransacCrcy Amount in Balance Transaction Currency
FreeDefinedCurrency1 FreeDefinedCurrency1 Freely Defined Currency 1
AmountInFreeDefinedCurrency1 AmountInFreeDefinedCurrency1 Amount in Freely Defined Currency 1
FreeDefinedCurrency2 FreeDefinedCurrency2 Freely Defined Currency 2
AmountInFreeDefinedCurrency2 AmountInFreeDefinedCurrency2 Amount in Freely Defined Currency 2
FreeDefinedCurrency3 FreeDefinedCurrency3 Freely Defined Currency 3
AmountInFreeDefinedCurrency3 AmountInFreeDefinedCurrency3 Amount in Freely Defined Currency 3
FreeDefinedCurrency4 FreeDefinedCurrency4 Freely Defined Currency 4
AmountInFreeDefinedCurrency4 AmountInFreeDefinedCurrency4 Amount in Freely Defined Currency 4
FreeDefinedCurrency5 FreeDefinedCurrency5 Freely Defined Currency 5
AmountInFreeDefinedCurrency5 AmountInFreeDefinedCurrency5 Amount in Freely Defined Currency 5
FreeDefinedCurrency6 FreeDefinedCurrency6 Freely Defined Currency 6
AmountInFreeDefinedCurrency6 AmountInFreeDefinedCurrency6 Amount in Freely Defined Currency 6
FreeDefinedCurrency7 FreeDefinedCurrency7 Freely Defined Currency 7
AmountInFreeDefinedCurrency7 AmountInFreeDefinedCurrency7 Amount in Freely Defined Currency 7
FreeDefinedCurrency8 FreeDefinedCurrency8 Freely Defined Currency 8
AmountInFreeDefinedCurrency8 AmountInFreeDefinedCurrency8 Amount in Freely Defined Currency 8

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_JointVentureAuditQuery.
-- 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: CJVAUDITQ
-- Parameters: P_JVAPeriodAmtThreshold : jv_per_amt_cds

CREATE VIEW C_JointVentureAuditQuery AS
SELECT
  CompanyCode,
  LedgerFiscalYear,
  FiscalPeriod,
  JointVenture,
  JointVentureEquityGroup,
  JntVntrRcvryCodeIsBillable,
  GLAccount,
  CostCenter,
  OrderID,
  ProjectNetwork,
  WBSElementInternalID,
  JointVentureCostRecoveryCode,
  Ledger,
  ProfitCenter,
  BusinessArea,
  MasterFixedAsset,
  FixedAsset,
  AssetTransactionType,
  AccountingDocument,
  JointVenturePartner,
  LedgerGLLineItem,
  JointVentureBillingType,
  PostingDate,
  DocumentDate,
  AccountingDocumentType,
  AccountingDocCreatedByUser,
  ControllingArea,
  JointVentureEquityType,
  Supplier,
  Customer,
  Product,
  SalesDocument,
  SalesOrganization,
  Plant,
  CostObject,
  PartnerAccountAssignment,
  PartnerAccountAssignmentType,
  DocumentItemText,
  PurchasingDocumentItem,
  PartnerCostCenter,
  SupplierName,
  RelatedNetworkActivity,
  RealEstateContract,
  TaxCode,
  ControllingBusTransacType,
  BusinessTransactionCategory,
  BusinessTransactionType,
  ReferenceDocumentType,
  Quantity,
  BaseUnit,
  TransactionCurrency,
  AmountInTransactionCurrency,
  CompanyCodeCurrency,
  AmountInCompanyCodeCurrency,
  GlobalCurrency,
  AmountInGlobalCurrency,
  BalanceTransactionCurrency,
  AmountInBalanceTransacCrcy,
  FreeDefinedCurrency1,
  AmountInFreeDefinedCurrency1,
  FreeDefinedCurrency2,
  AmountInFreeDefinedCurrency2,
  FreeDefinedCurrency3,
  AmountInFreeDefinedCurrency3,
  FreeDefinedCurrency4,
  AmountInFreeDefinedCurrency4,
  FreeDefinedCurrency5,
  AmountInFreeDefinedCurrency5,
  FreeDefinedCurrency6,
  AmountInFreeDefinedCurrency6,
  FreeDefinedCurrency7,
  AmountInFreeDefinedCurrency7,
  FreeDefinedCurrency8,
  AmountInFreeDefinedCurrency8
FROM I_JointVentureAuditCube
;

Learn More