I_JointVentureAcctgExtDetail

DDL: I_JOINTVENTUREACCTGEXTDETAIL SQL: IPVJVACCTGEXTDTL Type: view COMPOSITE Package: OIU_VDM_CDS
111 Fields 1 Data Sources 6 Associations

Joint Venture Accounting Extended Detail

I_JointVentureAcctgExtDetail (Composite)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Public Edition with built-in and side-by-side extension capabilities.

Joint Venture Accounting Extended Detail · Cross Applications

I_JointVentureAcctgExtDetail is a Composite CDS View (Cube) that provides data about "Joint Venture Accounting Extended Detail" in SAP S/4HANA. It reads from 1 data source (I_JointVentureAcctgDetail) and exposes 111 fields with key field JointVentureLineItem. It has 6 associations to related views. Part of development package OIU_VDM_CDS.

SAP API Hub

CategoryComposite
StateC1
Line of BusinessCross Applications
Application ComponentIS-OIL-PRA
CapabilitiesData Source for Data Extraction,Data Source in SQL Select
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Not Released
PackageCross Applications for SAP S/4HANA Cloud Public Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
I_JointVentureAcctgDetail I_JointVentureAcctgDetail from

Associations (6)

CardinalityTargetAliasCondition
[0..1] I_LedgerCompanyCodeCrcyRoles _LedgerCompanyCodeCrcyRoleVH $projection.CompanyCode = _LedgerCompanyCodeCrcyRoleVH.CompanyCode and $projection.Ledger = _LedgerCompanyCodeCrcyRoleVH.Ledger
[0..1] I_TaxCode _TaxCode $projection.TaxCode = _TaxCode.TaxCode and $projection.TaxCalculationProcedure = _TaxCode.TaxCalculationProcedure
[0..1] I_GLAccountType _GLAccountType $projection.GLAccountType = _GLAccountType.GLAccountType
[0..1] I_Currency _GlobalCurrency $projection.GlobalCurrency = _GlobalCurrency.Currency
[0..1] I_Currency _CompanyCodeCurrency $projection.CompanyCodeCurrency = _CompanyCodeCurrency.Currency
[0..1] I_TaxCalculationProcedure _TaxCalculationProcedure $projection.TaxCalculationProcedure = _TaxCalculationProcedure.TaxCalculationProcedure

Annotations (13)

NameValueLevelField
EndUserText.label Joint Venture Accounting Extended Detail view
Analytics.dataCategory #CUBE view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
Analytics.dataExtraction.enabled true view
VDM.viewType #COMPOSITE view
AbapCatalog.sqlViewName IPVJVACCTGEXTDTL view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.sapObjectNodeType.name PRAJointVentureAcctgExtDetail view

Fields (111)

KeyFieldSource TableSource FieldDescription
KEY JointVentureLineItem JointVentureLineItem Joint Venture Record Number
Ledger Ledger Ledger
RecordType RecordType Reservation Record Type
SpecialLedgerVersion SpecialLedgerVersion Version: Tax rt
FiscalYear FiscalYear G/L Fiscal Year
Currency Currency Valuation Crcy
UnitOfMeasure UnitOfMeasure Base Unit of Measure
DebitCreditCode DebitCreditCode Single-Character Flag
LedgerFiscalPeriod LedgerFiscalPeriod Posting periods
DocumentType DocumentType Document Category
AccountingDocument AccountingDocument Accounting Document
AccountingDocumentItem AccountingDocumentItem Line Item in Joint Venture Document
CompanyCode CompanyCode Receiver Company Code
JointVenture JointVenture Joint venture
JointVentureEquityGroup JointVentureEquityGroup Joint Venture Equity Group
ChartOfAccounts ChartOfAccounts Chart of Accounts
GLAccount GLAccount General Ledger
GLAccountType _GLAccountInChartOfAccounts GLAccountType Type of a General Ledger Account
BusinessArea BusinessArea Business Area
ControllingArea ControllingArea Controlling Area
CostCenter CostCenter Cost Center
OriginOrder OriginOrder Order Number
ProjectInternalID ProjectInternalID Internal WBS Element
ProfitCenter ProfitCenter Profit Center
MasterFixedAsset MasterFixedAsset Main Asset Number
FixedAsset FixedAsset Asset Subnumber
AssetTransactionType AssetTransactionType Asset Transaction Type
JointVentureRecoveryCode JointVentureRecoveryCode Recovery Indicator
Partner Partner Partner account number
InternalOrder InternalOrder Internal Order
NetworkActivity NetworkActivity Operation/Activity
AdditionalQuantity1Unit AdditionalQuantity1Unit Additional unit of measure
DocumentItemText DocumentItemText Description of Line Item
IsAutomaticallyPosted IsAutomaticallyPosted Automatic Posting
AccountingDocumentType AccountingDocumentType Accounting Document Type
BusinessTransactionType BusinessTransactionType Business Transaction Type
PostingDate PostingDate Posting Date in the Document
ValDateForCurrencyTranslation ValDateForCurrencyTranslation Value Date for Currency Translation
ValueDate ValueDate Value Date
RefAccountingDocument RefAccountingDocument Ref Accounting Document
ReferenceDocumentFiscalYear ReferenceDocumentFiscalYear Reference Doc Year
RefJntVentureDocumentLineItem RefJntVentureDocumentLineItem Ref JV Document Item
ReferenceDocumentType ReferenceDocumentType Reference Document Type
BusinessTransactionDocItem BusinessTransactionDocItem Business Transaction
RefAccountingDocumentItem RefAccountingDocumentItem Ref Accounting Document Line Item
PayrollType PayrollType Payroll Type
AccountingDocCreatedByUser AccountingDocCreatedByUser User which created overhead document
DocumentDate DocumentDate Document Date in Document
TimeEntry TimeEntry Time of Entry
TaxCalculationProcedure Procedure (Pricing, Output Control, Acct. Det., Costing,...)
TaxCode TaxCode Tax on Sales/Purchases Code
BillingMonth BillingMonth Billing Month
PurchaseOrder PurchaseOrder Purchase Order Number
PurchaseOrderItem PurchaseOrderItem Item Number of Purchase Order
TransactionTypeDetermination TransactionTypeDetermination Transaction Key
ActivityType ActivityType Activity Type
PRAAllocationFrequencyCode PRAAllocationFrequencyCode Single-Character Flag
StartDate StartDate Valid From
Material Material Material Number
ReferenceDocument ReferenceDocument Reference Document Number
ProductionMonth ProductionMonth Production Month (Date to find period and year)
ReferenceBillingDocument ReferenceBillingDocument Ref Billing Document
Customer Customer Customer Number
Supplier Supplier Account Number of Supplier
PaymentTerms PaymentTerms Key for Terms of Payment
AmountInTransactionCurrency AmountInTransactionCurrency Amount in Transaction Currency
QuantityInBaseUnit QuantityInBaseUnit Quantity in Base Unit
CompanyCodeCurrency Currency Key
GlobalCurrency Currency Key
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency Value in local currency
AmountInGlobalCurrency AmountInGlobalCurrency Amount in Global Currency
_AccountingDocumentType _AccountingDocumentType
_AssetTransactionType _AssetTransactionType
_BusinessArea _BusinessArea
_ChartOfAccounts _ChartOfAccounts
_CompanyCode _CompanyCode
_ControllingArea _ControllingArea
_CostCenter _CostCenter
_CostCenterActivityType _CostCenterActivityType
_Currency _Currency
_Customer _Customer
_DebitCreditCode _DebitCreditCode
_DocumentType _DocumentType
_FixedAsset _FixedAsset
_GLAccount _GLAccount
_GLAccountInChartOfAccounts _GLAccountInChartOfAccounts
_InternalOrder _InternalOrder
_IsAutomaticallyPosted _IsAutomaticallyPosted
_JointVenture _JointVenture
_JointVentureEquityGroup _JointVentureEquityGroup
_JointVentureRecovery _JointVentureRecovery
_JVAPayrolltype _JVAPayrolltype
_Ledger _Ledger
_MasterFixedAsset _MasterFixedAsset
_Material _Material
_Order _Order
_Partner _Partner
_ProfitCenter _ProfitCenter
_PurchasingDocument _PurchasingDocument
_PurchasingDocumentItem _PurchasingDocumentItem
_RecordType _RecordType
_SpecialLedgerVersion _SpecialLedgerVersion
_Supplier _Supplier
_TaxCode _TaxCode
_UnitOfMeasure _UnitOfMeasure
_WBSElementBasicData _WBSElementBasicData
_GLAccountType _GLAccountType
_LedgerCompanyCodeCrcyRoleVH _LedgerCompanyCodeCrcyRoleVH
_CompanyCodeCurrency _CompanyCodeCurrency
_GlobalCurrency _GlobalCurrency
_TaxCalculationProcedure _TaxCalculationProcedure

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 I_JointVentureAcctgExtDetail.
-- 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: IPVJVACCTGEXTDTL

CREATE VIEW I_JointVentureAcctgExtDetail AS
SELECT
  JointVentureLineItem,
  Ledger,
  RecordType,
  SpecialLedgerVersion,
  FiscalYear,
  Currency,
  UnitOfMeasure,
  DebitCreditCode,
  LedgerFiscalPeriod,
  DocumentType,
  AccountingDocument,
  AccountingDocumentItem,
  CompanyCode,
  JointVenture,
  JointVentureEquityGroup,
  ChartOfAccounts,
  GLAccount,
  _GLAccountInChartOfAccounts.GLAccountType AS GLAccountType,
  BusinessArea,
  ControllingArea,
  CostCenter,
  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,
  _CompanyCode._Country.TaxCalculationProcedure AS TaxCalculationProcedure,
  TaxCode,
  BillingMonth,
  PurchaseOrder,
  PurchaseOrderItem,
  TransactionTypeDetermination,
  ActivityType,
  PRAAllocationFrequencyCode,
  StartDate,
  Material,
  ReferenceDocument,
  ProductionMonth,
  ReferenceBillingDocument,
  Customer,
  Supplier,
  PaymentTerms,
  AmountInTransactionCurrency,
  QuantityInBaseUnit,
  _LedgerCompanyCodeCrcyRoleVH._CoCodeCurrencyRoleCurrency.Currency AS CompanyCodeCurrency,
  _LedgerCompanyCodeCrcyRoleVH._GlobalCurrencyRoleCurrency.Currency AS GlobalCurrency,
  AmountInCompanyCodeCurrency,
  AmountInGlobalCurrency
FROM I_JointVentureAcctgDetail
LEFT OUTER JOIN I_LedgerCompanyCodeCrcyRoles AS _LedgerCompanyCodeCrcyRoleVH ON CompanyCode = _LedgerCompanyCodeCrcyRoleVH.CompanyCode AND Ledger = _LedgerCompanyCodeCrcyRoleVH.Ledger  -- association [0..1]
LEFT OUTER JOIN I_TaxCode AS _TaxCode ON TaxCode = _TaxCode.TaxCode AND TaxCalculationProcedure = _TaxCode.TaxCalculationProcedure  -- association [0..1]
LEFT OUTER JOIN I_GLAccountType AS _GLAccountType ON GLAccountType = _GLAccountType.GLAccountType  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _GlobalCurrency ON GlobalCurrency = _GlobalCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _CompanyCodeCurrency ON CompanyCodeCurrency = _CompanyCodeCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_TaxCalculationProcedure AS _TaxCalculationProcedure ON TaxCalculationProcedure = _TaxCalculationProcedure.TaxCalculationProcedure  -- association [0..1]
;

Learn More