I_JointVentureAcctgDetail

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_JointVentureAcctgDetail.
-- 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: IPVJVACCTGDETAIL

CREATE VIEW I_JointVentureAcctgDetail AS
SELECT
  cast(gl_sirid as oiu_vdm_joint_venture_line_itm) AS JointVentureLineItem,
  rldnr AS Ledger,
  rrcty AS RecordType,
  rvers AS SpecialLedgerVersion,
  ryear AS FiscalYear,
  rtcur AS Currency,
  runit AS UnitOfMeasure,
  cast (drcrk as fis_shkzg) AS DebitCreditCode,
  poper AS LedgerFiscalPeriod,
  docct AS DocumentType,
  cast(docnr as oiu_vdm_accounting_document) AS AccountingDocument,
  cast(docln as oiu_vdm_accounting_doc_line_no) AS AccountingDocumentItem,
  cast(rbukrs as fis_bukrs preserving type ) AS CompanyCode,
  rjvnam AS JointVenture,
  regrou AS JointVentureEquityGroup,
  _CompanyCode.ChartOfAccounts AS ChartOfAccounts,
  racct AS GLAccount,
  rbusa AS BusinessArea,
  rkokrs AS ControllingArea,
  rcntr AS CostCenter,
  rordnr AS OriginOrder,
  cast(rprojk as oiu_vdm_internal_wbs_element) AS ProjectInternalID,
  rprctr AS ProfitCenter,
  ranln1 AS MasterFixedAsset,
  ranln2 AS FixedAsset,
  ranbwa AS AssetTransactionType,
  rrecin AS JointVentureRecoveryCode,
  rpartn AS Partner,
  cast(nplnr as oiu_vdm_internal_order) AS InternalOrder,
  vornr AS NetworkActivity,
  cast(aunit as oiu_vdm_addl_unit_of_measure) AS AdditionalQuantity1Unit,
  cast(sgtxt as oiu_vdm_desc_of_line_item) AS DocumentItemText,
  cast(autom as oiu_vdm_automatic_posting) AS IsAutomaticallyPosted,
  cast(docty as oiu_vdm_accounting_doc_type) AS AccountingDocumentType,
  cast(activ as oiu_vdm_business_trans_type) AS BusinessTransactionType,
  budat AS PostingDate,
  wsdat AS ValDateForCurrencyTranslation,
  valut AS ValueDate,
  cast(refdocnr as oiu_vdm_ref_acctg_document) AS RefAccountingDocument,
  cast(refryear as oiu_vdm_reference_doc_year) AS ReferenceDocumentFiscalYear,
  cast(refdocln as oiu_vdm_ref_jv_document_item) AS RefJntVentureDocumentLineItem,
  cast(refdocct as oiu_vdm_reference_doc_type) AS ReferenceDocumentType,
  refactiv AS BusinessTransactionDocItem,
  cast(reffidln as oiu_vdm_ref_acctg_doc_line_itm) AS RefAccountingDocumentItem,
  cast(bilid as oiu_vdm_jv_payroll_type) AS PayrollType,
  cast (usnam as fclm_bam_created_by) AS AccountingDocCreatedByUser,
  bldat AS DocumentDate,
  cputm AS TimeEntry,
  mwskz AS TaxCode,
  billm AS BillingMonth,
  cast(ebeln as vdm_purchaseorder) AS PurchaseOrder,
  cast(ebelp as vdm_purchaseorderitem) AS PurchaseOrderItem,
  cast(ktosl as fac_ktosl) AS TransactionTypeDetermination,
  lstar AS ActivityType,
  cycle AS PRAAllocationFrequencyCode,
  sdate AS StartDate,
  matnr AS Material,
  cast(refawref as oiu_vdm_reference_doc_number) AS ReferenceDocument,
  prodper AS ProductionMonth,
  cast(reffidoc as oiu_vdm_ref_billing_document) AS ReferenceBillingDocument,
  cbcustomer AS Customer,
  cbvendor AS Supplier,
  cbpayterm AS PaymentTerms,
  _LedgerCompanyCodeCrcyRoleVH._CoCodeCurrencyRoleCurrency.Currency AS CompanyCodeCurrency,
  _LedgerCompanyCodeCrcyRoleVH._GlobalCurrencyRoleCurrency.Currency AS GlobalCurrency,
  cast(tsl as oiu_vdm_amount_in_trans_crcy) AS AmountInTransactionCurrency,
  cast(msl as oiu_vdm_quantity_in_base_unit preserving type ) AS QuantityInBaseUnit
FROM jvso1
LEFT OUTER JOIN I_Ledger AS _Ledger ON Ledger = _Ledger.Ledger  -- association [0..1]
LEFT OUTER JOIN I_JVARecordType AS _RecordType ON RecordType = _RecordType.JVARecordType  -- association [0..1]
LEFT OUTER JOIN I_DebitCreditCode AS _DebitCreditCode ON DebitCreditCode = _DebitCreditCode.DebitCreditCode  -- association [0..1]
LEFT OUTER JOIN I_SpecialLedgerVersion AS _SpecialLedgerVersion ON Ledger = _SpecialLedgerVersion.Ledger AND SpecialLedgerVersion = _SpecialLedgerVersion.SpecialLedgerVersion  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON Currency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON UnitOfMeasure = _UnitOfMeasure.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_JVADocumentType AS _DocumentType ON DocumentType = _DocumentType.JVADocumentType  -- association [0..1]
LEFT OUTER JOIN I_JointVenture AS _JointVenture ON CompanyCode = _JointVenture.CompanyCode AND JointVenture = _JointVenture.JointVenture  -- association [0..1]
LEFT OUTER JOIN I_JointVentureEquityGroup AS _JointVentureEquityGroup ON CompanyCode = _JointVentureEquityGroup.CompanyCode AND JointVenture = _JointVentureEquityGroup.JointVenture AND JointVentureEquityGroup = _JointVentureEquityGroup.JointVentureEquityGroup  -- association [0..1]
LEFT OUTER JOIN I_ChartOfAccounts AS _ChartOfAccounts ON ChartOfAccounts = _ChartOfAccounts.ChartOfAccounts  -- association [0..1]
LEFT OUTER JOIN I_GLAccount AS _GLAccount ON CompanyCode = _GLAccount.CompanyCode AND GLAccount = _GLAccount.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_GLAccountInChartOfAccounts AS _GLAccountInChartOfAccounts ON ChartOfAccounts = _GLAccountInChartOfAccounts.ChartOfAccounts AND GLAccount = _GLAccountInChartOfAccounts.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_BusinessArea AS _BusinessArea ON BusinessArea = _BusinessArea.BusinessArea  -- association [0..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_CostCenter AS _CostCenter ON ControllingArea = _CostCenter.ControllingArea AND CostCenter = _CostCenter.CostCenter  -- association [0..*]
LEFT OUTER JOIN I_Order AS _Order ON OriginOrder = _Order.OrderID  -- association [0..1]
LEFT OUTER JOIN I_Order AS _InternalOrder ON InternalOrder = _InternalOrder.OrderID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementBasicData ON ProjectInternalID = _WBSElementBasicData.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_ProfitCenter AS _ProfitCenter ON ProfitCenter = _ProfitCenter.ProfitCenter AND ControllingArea = _ProfitCenter.ControllingArea  -- association [0..*]
LEFT OUTER JOIN I_MasterFixedAsset AS _MasterFixedAsset ON CompanyCode = _MasterFixedAsset.CompanyCode AND MasterFixedAsset = _MasterFixedAsset.MasterFixedAsset  -- association [0..1]
LEFT OUTER JOIN I_FixedAsset AS _FixedAsset ON CompanyCode = _FixedAsset.CompanyCode AND MasterFixedAsset = _FixedAsset.MasterFixedAsset AND FixedAsset = _FixedAsset.FixedAsset  -- association [0..1]
LEFT OUTER JOIN I_AssetTransactionType AS _AssetTransactionType ON AssetTransactionType = _AssetTransactionType.AssetTransactionType  -- association [0..1]
LEFT OUTER JOIN I_JointVentureRecovery AS _JointVentureRecovery ON JointVentureRecoveryCode = _JointVentureRecovery.JointVentureRecoveryCode AND CompanyCode = _JointVentureRecovery.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Partner ON Partner = _Partner.Customer  -- association [0..1]
LEFT OUTER JOIN I_Indicator AS _IsAutomaticallyPosted ON IsAutomaticallyPosted = _IsAutomaticallyPosted.IndicatorValue  -- association [0..1]
LEFT OUTER JOIN I_AccountingDocumentType AS _AccountingDocumentType ON AccountingDocumentType = _AccountingDocumentType.AccountingDocumentType  -- association [0..1]
LEFT OUTER JOIN I_PurchasingDocument AS _PurchasingDocument ON PurchaseOrder = _PurchasingDocument.PurchasingDocument  -- association [0..1]
LEFT OUTER JOIN I_PurchasingDocumentItem AS _PurchasingDocumentItem ON PurchaseOrder = _PurchasingDocumentItem.PurchasingDocument AND PurchaseOrderItem = _PurchasingDocumentItem.PurchasingDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_CostCenterActivityType AS _CostCenterActivityType ON ControllingArea = _CostCenterActivityType.ControllingArea AND ActivityType = _CostCenterActivityType.CostCtrActivityType  -- association [0..*]
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_JVAPayrollType AS _JVAPayrolltype ON PayrollType = _JVAPayrolltype.PayrollType  -- association [0..1]
LEFT OUTER JOIN I_LedgerCompanyCodeCrcyRoles AS _LedgerCompanyCodeCrcyRoleVH ON CompanyCode = _LedgerCompanyCodeCrcyRoleVH.CompanyCode AND Ledger = _LedgerCompanyCodeCrcyRoleVH.Ledger  -- 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]
;