P_SmltdJournalEntryItemCommon

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 P_SmltdJournalEntryItemCommon.
-- 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.

CREATE VIEW P_SmltdJournalEntryItemCommon AS
SELECT
  cast('' as fdc_accdoc_tmp_doc_id) AS TemporaryAccountingDocument,
  cast('' as fdc_accdoc_tmp_doc_type preserving type ) AS TmpAccountingDocumentType,
  cast('' as indx_relid) AS TmpAcctgDocSpecificationArea,
  cast('' as username) AS TmpAcctgDocumentCreatedByUser,
  AccountAssignmentNumber,
  AccountingDocument,
  AccountingDocumentCategory,
  AccountingDocumentItem,
  AccountingDocumentType,
  '' AS AccountingDocumentTypeIsHidden,
  AddressAndBankIsSetManually,
  AlternativeGLAccount,
  AmountInCompanyCodeCurrency,
  AmountInTransactionCurrency,
  AssetTransactionType,
  '' AS AssetTransactionTypeIsHidden,
  cast(_AssetTransactionTypeText.AssetTransactionTypeName as assettransactiontypename preserving type) AS AssetTransactionTypeName,
  AssetValueDate,
  '' AS AssetValueDateIsHidden,
  AssignmentReference,
  '' AS AssignmentReferenceIsHidden,
  BPBankAccountInternalID,
  '' AS BPBankAccountInternalIDIsHdn,
  BalanceTransactionCurrency,
  BaseUnit,
  BillingDocument,
  '' AS BillingDocumentIsHidden,
  BranchAccount,
  '' AS BranchAccountIsHidden,
  BranchCode,
  '' AS BranchCodeIsHidden,
  BudgetPeriod,
  '' AS BudgetPeriodIsHidden,
  BusinessArea,
  '' AS BusinessAreaIsHidden,
  BusinessPlace,
  '' AS BusinessPlaceIsHidden,
  BusinessProcess,
  '' AS BusinessProcessIsHidden,
  CashDiscount1Days,
  '' AS CashDiscount1DaysIsHidden,
  CashDiscount1Percent,
  '' AS CashDiscount1PercentIsHidden,
  CashDiscount2Days,
  '' AS CashDiscount2DaysIsHidden,
  CashDiscount2Percent,
  '' AS CashDiscount2PercentIsHidden,
  CashDiscountAmount,
  '' AS CashDiscountAmountIsHidden,
  CashDiscountBaseAmount,
  '' AS CashDiscountBaseAmountIsHidden,
  CashLedgerAccount,
  '' AS CashLedgerAccountIsHidden,
  cast(_CashLedgerAccountText.GLAccountName as fis_re_account_name preserving type) AS CashLedgerAccountName,
  CashLedgerCompanyCode,
  '' AS CashLedgerCompanyCodeIsHidden,
  cast(_CashLedgerCompanyCode.CompanyCodeName as cashledgercompanycodename preserving type) AS CashLedgerCompanyCodeName,
  ChartOfAccounts,
  '' AS ChartOfAccountsIsHidden,
  ClearingDate,
  '' AS ClearingDateIsHidden,
  ClearingJournalEntry,
  ClearingJournalEntryFiscalYear,
  '' AS ClearingJournalEntryIsHidden,
  CompanyCode,
  CompanyCodeCurrency,
  '' AS CompanyCodeIsHidden,
  cast(_CompanyCode.CompanyCodeName as fis_butxt preserving type) AS CompanyCodeName,
  ControllingArea,
  '' AS ControllingAreaIsHidden,
  CostCenter,
  '' AS CostCenterIsHidden,
  CostCtrActivityType,
  '' AS CostCtrActivityTypeIsHidden,
  _CostCtrActivityTypeT.CostCtrActivityTypeName AS CostCtrActivityTypeName,
  CostObject,
  '' AS CostObjectIsHidden,
  CostOriginGroup,
  CreditAmountInBalanceTransCrcy,
  CreditAmountInCoCodeCrcy,
  CreditAmountInFunctionalCrcy,
  CreditAmountInTransCrcy,
  Customer,
  CustomerGroup,
  '' AS CustomerGroupIsHidden,
  cast(_CustomerGroupText.CustomerGroupName as fincs_customergroupname preserving type) AS CustomerGroupName,
  '' AS CustomerIsHidden,
  CustomerSupplierCountry,
  '' AS CustomerSupplierCountryIsHdn,
  cast(_CustomerSupplierCountryText.CountryName as fincs_land1_t preserving type) AS CustomerSupplierCountryName,
  CustomerSupplierIndustry,
  '' AS CustomerSupplierIndustryIsHdn,
  _CustomerSupplierIndustryText.CustomerSupplierIndustryName AS CustomerSupplierIndustryName,
  DataExchangeInstruction1,
  '' AS DataExchangeInstruction1IsHdn,
  DataExchangeInstruction2,
  '' AS DataExchangeInstruction2IsHdn,
  DataExchangeInstruction3,
  '' AS DataExchangeInstruction3IsHdn,
  DataExchangeInstruction4,
  '' AS DataExchangeInstruction4IsHdn,
  DebitAmountInBalanceTransCrcy,
  DebitAmountInCoCodeCrcy,
  DebitAmountInFunctionalCrcy,
  DebitAmountInTransCrcy,
  DebitCreditCode,
  DocumentDate,
  '' AS DocumentDateIsHidden,
  DocumentItemText,
  DueCalculationBaseDate,
  '' AS DueCalculationBaseDateIsHidden,
  DunningArea,
  '' AS DunningAreaIsHidden,
  DunningBlockingReason,
  '' AS DunningBlockingReasonIsHidden,
  DunningKey,
  '' AS DunningKeyIsHidden,
  DunningLevel,
  '' AS DunningLevelIsHidden,
  abap.string'' AS DynamicalMetadataString,
  EarmarkedFundsDocument,
  '' AS EarmarkedFundsDocumentIsHidden,
  EarmarkedFundsDocumentItem,
  '' AS EmrkdFundsDocumentItemIsHidden,
  _FinServicesProductGroupT.FinServicesProductGroupName AS FinServicesProductGroupName,
  FinancialAccountType,
  FinancialDataSource,
  _FinancialDataSourceT.FinancialDataSourceName AS FinancialDataSourceName,
  cast('' as fikrs) AS FinancialManagementArea,
  '' AS FinancialManagementAreaIsHdn,
  FinancialServicesBranch,
  _FinancialServicesBranchT.FinancialServicesBranchName AS FinancialServicesBranchName,
  FinancialServicesProductGroup,
  FinancialTransactionType,
  '' AS FinancialTransactionTypeIsHdn,
  cast(_FinancialTransactionTypeT.FinancialTransactionTypeName as fincs_fintransactiontypename preserving type) AS FinancialTransactionTypeName,
  FiscalPeriod,
  '' AS FiscalPeriodIsHidden,
  FiscalYear,
  FixedAsset,
  '' AS FixedAssetIsHidden,
  FixedCashDiscount,
  '' AS FixedCashDiscountIsHidden,
  FollowOnDocumentType,
  '' AS FollowOnDocumentTypeIsHidden,
  FunctionalArea,
  '' AS FunctionalAreaIsHidden,
  FunctionalCurrency,
  Fund,
  '' AS FundIsHidden,
  FundedProgram,
  FundsCenter,
  GLAccount,
  '' AS GLAccountIsHidden,
  GrantID,
  '' AS GrantIDIsHidden,
  cast(_GrantText.GrantName as ftr_gen_grant_name preserving type) AS GrantName,
  HasPaymentOrder,
  '' AS HasPaymentOrderIsHidden,
  HouseBank,
  HouseBankAccount,
  cast(_HouseBankAccountText.HouseBankAccountDescription as /pf1/dte_housebank_acct_desc preserving type) AS HouseBankAccountDescription,
  '' AS HouseBankAccountIsHidden,
  '' AS HouseBankIsHidden,
  cast(_HouseBank._Bank.BankName as farp_banka preserving type) AS HouseBankName,
  InterestCalculationBlockReason,
  '' AS IntrstCalcBlockReasonIsHdn,
  InventoryValuationType,
  InvoiceItemReference,
  '' AS InvoiceItemReferenceIsHidden,
  '' AS InvoiceList,
  '' AS InvoiceListIsHidden,
  '' AS InvoiceRefFiscalYearIsHidden,
  InvoiceReference,
  InvoiceReferenceFiscalYear,
  '' AS InvoiceReferenceIsHidden,
  IsEUTriangularDeal,
  '' AS IsEUTriangularDealIsHidden,
  IsNegativePosting,
  IsNotCashDiscountLiable,
  '' AS IsNotCashDiscountLiableIsHdn,
  cast ( '' as xcpdk ) AS IsOneTimeAccount,
  IsOpenItemManaged,
  JointVenture,
  JointVentureCostRecoveryCode,
  JointVentureEquityGroup,
  '' AS JointVentureEquityGroupIsHdn,
  JointVentureEquityType,
  '' AS JointVentureEquityTypeIsHidden,
  '' AS JointVentureIsHidden,
  '' AS JntVntrCostRecoveryCodeIsHdn,
  LastDunningDate,
  '' AS LastDunningDateIsHidden,
  LineItemIsCompleted,
  '' AS LineItemIsCompletedIsHidden,
  MasterFixedAsset,
  '' AS MasterFixedAssetIsHidden,
  NetDueDate,
  '' AS NetDueDateIsHidden,
  NetPaymentAmount,
  '' AS NetPaymentAmountIsHidden,
  NetPaymentDays,
  '' AS NetPaymentDaysIsHidden,
  OffsettingAccount,
  OffsettingAccountType,
  OffsettingChartOfAccounts,
  OplAcctgDocItmCntrySpcfcRef1,
  OrderID,
  '' AS OrderIDIsHidden,
  PartnerBudgetPeriod,
  '' AS PartnerBudgetPeriodIsHidden,
  PartnerBusinessArea,
  '' AS PartnerBusinessAreaIsHidden,
  cast(_PartnerBusinessAreaText.BusinessAreaName as fis_partner_busarea_name preserving type) AS PartnerBusinessAreaName,
  PartnerCompany,
  '' AS PartnerCompanyIsHidden,
  cast(_PartnerCompany.CompanyName as fis_rassc_name preserving type) AS PartnerCompanyName,
  PartnerFunctionalArea,
  '' AS PartnerFunctionalAreaIsHidden,
  cast(_PartnerFunctionalAreaText.FunctionalAreaName as fis_pfkbtx preserving type) AS PartnerFunctionalAreaName,
  PartnerFund,
  '' AS PartnerFundIsHidden,
  PartnerGrant,
  '' AS PartnerGrantIsHidden,
  PartnerProfitCenter,
  '' AS PartnerProfitCenterIsHidden,
  cast(_PartnerProfitCenterText.ProfitCenterName as fis_partner_prctr_short_name preserving type) AS PartnerProfitCenterName,
  PartnerSegment,
  '' AS PartnerSegmentIsHidden,
  cast(_PartnerSegmentText.SegmentName as fis_partner_segment_name preserving type) AS PartnerSegmentName,
  cast( '' as farp_isalternativepayee preserving type ) AS PayeeIsAlternativePayee,
  cast( '' as farp_isalternativepayer preserving type ) AS PayerIsAlternativePayer,
  PaymentBlockingReason,
  '' AS PaymentBlockingReasonIsHidden,
  PaymentCurrency,
  PaymentDifferenceReason,
  '' AS PaymentDifferenceReasonIsHdn,
  cast(_PaymentDifferenceReasonText.PaymentDifferenceReasonName as paymentdifferencereasonname preserving type) AS PaymentDifferenceReasonName,
  PaymentMethod,
  '' AS PaymentMethodIsHidden,
  PaymentMethodSupplement,
  '' AS PaymentMethodSupplementIsHdn,
  PaymentReason,
  '' AS PaymentReasonIsHidden,
  PaymentReference,
  '' AS PaymentReferenceIsHidden,
  PaymentTerms,
  '' AS PaymentTermsIsHidden,
  cast(_PaymentTermsText.PaymentTermsName as paymenttermsname preserving type) AS PaymentTermsName,
  PersonnelNumber,
  '' AS PersonnelNumberIsHidden,
  Plant,
  '' AS PlantIsHidden,
  PostingDate,
  '' AS PostingDateIsHidden,
  PostingKey,
  '' AS PostingKeyIsHidden,
  Product,
  '' AS ProductIsHidden,
  cast(_ProductText.ProductName as productdescription preserving type) AS ProductName,
  ProfitCenter,
  '' AS ProfitCenterIsHidden,
  ProfitabilitySegment,
  ProjectNetwork,
  '' AS ProjectNetworkIsHidden,
  PubSecBudgetAccount,
  PubSecBudgetAccountCoCode,
  '' AS PubSecBudgetAccountIsHidden,
  PurchasingDocument,
  '' AS PurchasingDocumentIsHidden,
  PurchasingDocumentItem,
  '' AS PurchasingDocumentItemIsHidden,
  Quantity,
  '' AS QuantityIsHidden,
  cast(_PartnerBudgetPeriodText.BudgetPeriodName as receiverpostedbudgetperiodname preserving type) AS ReceiverPostedBudgetPeriodName,
  cast(_PartnerFundText.FundName as receiverpostedfundname preserving type) AS ReceiverPostedFundName,
  cast(_PartnerGrantText.GrantName as receiverpostedgrantname preserving type) AS ReceiverPostedGrantName,
  '' AS Reference1IDByBizPartnerIsHdn,
  Reference1IDByBusinessPartner,
  '' AS Reference2IDByBizPartnerIsHdn,
  Reference2IDByBusinessPartner,
  '' AS Reference3IDByBizPartnerIsHdn,
  Reference3IDByBusinessPartner,
  ReferenceDocumentType,
  '' AS ReferenceDocumentTypeIsHidden,
  Region,
  '' AS RegionIsHidden,
  SEPAMandate,
  '' AS SEPAMandateIsHidden,
  SalesDocument,
  SalesDocumentItem,
  '' AS SalesDocumentIsHidden,
  '' AS SalesDocumentItemIsHidden,
  ScheduleLine,
  '' AS ScheduleLineIsHidden,
  Segment,
  '' AS SegmentIsHidden,
  ServiceDocument,
  '' AS ServiceDocumentIsHidden,
  ServiceDocumentItem,
  '' AS ServiceDocumentItemIsHidden,
  ServiceDocumentType,
  '' AS ServiceDocumentTypeIsHidden,
  SettlementReferenceDate,
  SpecialGLAccountAssignment,
  '' AS SpecialGLAcctAssignmentIsHdn,
  SpecialGLCode,
  '' AS SpecialGLCodeIsHidden,
  cast(_SpecialGLCodeText.SpecialGLCodeLongName as specialglcodelongname preserving type) AS SpecialGLCodeName,
  StateCentralBankPaymentReason,
  '' AS StateCntrlBkPaymentReasonIsHdn,
  Supplier,
  '' AS SupplierIsHidden,
  cast(_Supplier.SupplierName as suppliername preserving type) AS SupplierName,
  SupplyingCountry,
  '' AS SupplyingCountryIsHidden,
  cast(_SupplyingCountryText.CountryName as supplyingcountryname preserving type) AS SupplyingCountryName,
  TaxBaseAmountInCoCodeCrcy,
  '' AS TaxBaseAmountInCoCodeCrcyIsHdn,
  TaxBaseAmountInTransCrcy,
  '' AS TaxBaseAmountInTransCrcyIsHdn,
  cast('' as kalsm_d) AS TaxCalculationProcedure,
  TaxCode,
  '' AS TaxCodeIsHidden,
  _TaxCodeText.TaxCodeName AS TaxCodeName,
  TaxCountry,
  '' AS TaxCountryIsHidden,
  cast(_TaxCountryText.CountryName as fot_tax_country_descr preserving type) AS TaxCountryName,
  TaxDeterminationDate,
  '' AS TaxDeterminationDateIsHidden,
  TaxJurisdiction,
  '' AS TaxJurisdictionIsHidden,
  TaxRateValidityStartDate,
  '' AS TaxRateValidityStartDateIsHdn,
  TransactionCurrency,
  TransactionTypeDetermination,
  cast(_FixedCashDiscountTypeText.UtilsDiscountTypeDescription as fixedcashdiscountname preserving type) AS UtilsDiscountTypeDescription,
  VATRegistration,
  '' AS VATRegistrationIsHidden,
  ValuationArea,
  ValueDate,
  '' AS ValueDateIsHidden,
  _WBSElementBasicData.WBSElementExternalID AS WBSElementExternalID,
  '' AS WBSElementExternalIDIsHidden,
  _WBSElementBasicData.WBSDescription AS WBSDescription,
  WBSElementInternalID,
  WithholdingTaxAmount,
  '' AS WithholdingTaxAmountIsHidden,
  WithholdingTaxBaseAmount,
  '' AS WithholdingTaxBaseAmountIsHdn,
  WithholdingTaxCertificate,
  '' AS WithholdingTaxCertificateIsHdn,
  WithholdingTaxCode,
  '' AS WithholdingTaxCodeIsHidden,
  WithholdingTaxExemptionAmt,
  '' AS WhgdTaxExemptionAmtIsHidden,
  '' AS WithholdingTaxItemIsHidden,
  _BudgetAccountText.BudgetAccountName AS BudgetAccountName,
  _BudgetPeriodText.BudgetPeriodName AS BudgetPeriodName,
  _BusinessAreaText.BusinessAreaName AS BusinessAreaName,
  _ControllingArea.ControllingAreaName AS ControllingAreaName,
  _CostCenterText.CostCenterName AS CostCenterName,
  _Customer.CustomerName AS CustomerName,
  _DunningAreaText.DunningAreaName AS DunningAreaName,
  _FunctionalAreaText.FunctionalAreaName AS FunctionalAreaName,
  _FundText.FundName AS FundName,
  _GLAccountText.GLAccountName AS GLAccountName,
  _GLAccountText.GLAccountLongName AS GLAccountLongName,
  _MasterFixedAsset.MasterFixedAssetDescription AS MasterFixedAssetDescription,
  _PaymentBlockingReasonText.PaymentBlockingReasonName AS PaymentBlockingReasonName,
  _Plant.PlantName AS PlantName,
  _PostingKeyText.PostingKeyName AS PostingKeyName,
  _ProfitCenterText.ProfitCenterName AS ProfitCenterName,
  _SegmentText.SegmentName AS SegmentName,
  _WorkForcePersonMappings.WorkAssignmentExternalID AS WorkAssignmentExternalID
FROM R_ManageJournalEntryItem
LEFT OUTER JOIN C_SmltdJrnlEntrWhldgTaxItem AS _WithholdingTaxItem ON TemporaryAccountingDocument = _WithholdingTaxItem.TemporaryAccountingDocument AND TmpAccountingDocumentType = _WithholdingTaxItem.TmpAccountingDocumentType AND TmpAcctgDocSpecificationArea = _WithholdingTaxItem.TmpAcctgDocSpecificationArea AND TmpAcctgDocumentCreatedByUser = _WithholdingTaxItem.TmpAcctgDocumentCreatedByUser  -- association [0..*]
LEFT OUTER JOIN I_AssetTransactionTypeText AS _AssetTransactionTypeText ON AssetTransactionType = _AssetTransactionTypeText.AssetTransactionType AND _AssetTransactionTypeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_BudgetPeriodText AS _BudgetPeriodText ON BudgetPeriod = _BudgetPeriodText.BudgetPeriod AND _BudgetPeriodText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_BudgetPeriodText AS _PartnerBudgetPeriodText ON PartnerBudgetPeriod = _PartnerBudgetPeriodText.BudgetPeriod AND _PartnerBudgetPeriodText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_BusinessAreaText AS _BusinessAreaText ON BusinessArea = _BusinessAreaText.BusinessArea AND _BusinessAreaText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_BusinessAreaText AS _PartnerBusinessAreaText ON PartnerBusinessArea = _PartnerBusinessAreaText.BusinessArea AND _PartnerBusinessAreaText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CashLedgerCompanyCode ON CashLedgerCompanyCode = _CashLedgerCompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_CostCenterActivityTypeText AS _CostCtrActivityTypeT ON ControllingArea = _CostCtrActivityTypeT.ControllingArea AND CostCtrActivityType = _CostCtrActivityTypeT.CostCtrActivityType AND PostingDate <= _CostCtrActivityTypeT.ValidityEndDate AND PostingDate >= _CostCtrActivityTypeT.ValidityStartDate AND _CostCtrActivityTypeT.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CostCenterText AS _CostCenterText ON ControllingArea = _CostCenterText.ControllingArea AND CostCenter = _CostCenterText.CostCenter AND PostingDate <= _CostCenterText.ValidityEndDate AND PostingDate >= _CostCenterText.ValidityStartDate AND _CostCenterText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CountryText AS _CustomerSupplierCountryText ON CustomerSupplierCountry = _CustomerSupplierCountryText.Country AND _CustomerSupplierCountryText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_CustomerGroupText AS _CustomerGroupText ON CustomerGroup = _CustomerGroupText.CustomerGroup AND _CustomerGroupText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CustomerSupplierIndustryText AS _CustomerSupplierIndustryText ON CustomerSupplierIndustry = _CustomerSupplierIndustryText.Industry AND _CustomerSupplierIndustryText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_DunningAreaText AS _DunningAreaText ON CompanyCode = _DunningAreaText.CompanyCode AND DunningArea = _DunningAreaText.DunningArea AND _DunningAreaText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_FinancialDataSourceT AS _FinancialDataSourceT ON FinancialDataSource = _FinancialDataSourceT.FinancialDataSource AND _FinancialDataSourceT.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_FinancialServicesBranchT AS _FinancialServicesBranchT ON FinancialServicesBranch = _FinancialServicesBranchT.FinancialServicesBranch AND _FinancialServicesBranchT.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_FinancialTransactionTypeT AS _FinancialTransactionTypeT ON FinancialTransactionType = _FinancialTransactionTypeT.FinancialTransactionType AND _FinancialTransactionTypeT.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_FinServicesProductGroupT AS _FinServicesProductGroupT ON FinancialServicesProductGroup = _FinServicesProductGroupT.FinancialServicesProductGroup AND _FinServicesProductGroupT.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_FixedCashDiscountTypeText AS _FixedCashDiscountTypeText ON FixedCashDiscount = _FixedCashDiscountTypeText.FixedCashDiscount AND _FixedCashDiscountTypeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_FunctionalAreaText AS _FunctionalAreaText ON FunctionalArea = _FunctionalAreaText.FunctionalArea AND _FunctionalAreaText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_FunctionalAreaText AS _PartnerFunctionalAreaText ON PartnerFunctionalArea = _PartnerFunctionalAreaText.FunctionalArea AND _PartnerFunctionalAreaText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_FundText AS _FundText ON '' = _FundText.FinancialManagementArea AND Fund = _FundText.Fund AND _FundText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_FundText AS _PartnerFundText ON '' = _PartnerFundText.FinancialManagementArea AND PartnerFund = _PartnerFundText.Fund AND _PartnerFundText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_GLAccountText AS _GLAccountText ON ChartOfAccounts = _GLAccountText.ChartOfAccounts AND GLAccount = _GLAccountText.GLAccount AND _GLAccountText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_GlAccountTextInCompanycode AS _CashLedgerAccountText ON CashLedgerCompanyCode = _CashLedgerAccountText.CompanyCode AND CashLedgerAccount = _CashLedgerAccountText.GLAccount AND _CashLedgerAccountText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_GrantText AS _GrantText ON GrantID = _GrantText.GrantID AND _GrantText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_GrantText AS _PartnerGrantText ON PartnerGrant = _PartnerGrantText.GrantID AND _PartnerGrantText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_Housebank AS _HouseBank ON HouseBank = _HouseBank.HouseBank AND CompanyCode = _HouseBank.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_HouseBankAccountText AS _HouseBankAccountText ON HouseBank = _HouseBankAccountText.HouseBank AND CompanyCode = _HouseBankAccountText.CompanyCode AND HouseBankAccount = _HouseBankAccountText.HouseBankAccount AND _HouseBankAccountText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_MasterFixedAsset AS _MasterFixedAsset ON CompanyCode = _MasterFixedAsset.CompanyCode AND MasterFixedAsset = _MasterFixedAsset.MasterFixedAsset  -- association [0..1]
LEFT OUTER JOIN I_Partnercompany AS _PartnerCompany ON PartnerCompany = _PartnerCompany.PartnerCompany  -- association [0..1]
LEFT OUTER JOIN I_PaymentBlockingReasonText AS _PaymentBlockingReasonText ON PaymentBlockingReason = _PaymentBlockingReasonText.PaymentBlockingReason AND _PaymentBlockingReasonText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_PaymentDifferenceReasonT AS _PaymentDifferenceReasonText ON CompanyCode = _PaymentDifferenceReasonText.CompanyCode AND PaymentDifferenceReason = _PaymentDifferenceReasonText.PaymentDifferenceReason AND _PaymentDifferenceReasonText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_PaymentTermsText AS _PaymentTermsText ON PaymentTerms = _PaymentTermsText.PaymentTerms AND _PaymentTermsText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_PostingKeyText AS _PostingKeyText ON PostingKey = _PostingKeyText.PostingKey AND _PostingKeyText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ProductText AS _ProductText ON Product = _ProductText.Product AND _ProductText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ProfitCenterText AS _PartnerProfitCenterText ON ControllingArea = _PartnerProfitCenterText.ControllingArea AND PartnerProfitCenter = _PartnerProfitCenterText.ProfitCenter AND PostingDate <= _PartnerProfitCenterText.ValidityEndDate AND PostingDate >= _PartnerProfitCenterText.ValidityStartDate AND _PartnerProfitCenterText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ProfitCenterText AS _ProfitCenterText ON ControllingArea = _ProfitCenterText.ControllingArea AND ProfitCenter = _ProfitCenterText.ProfitCenter AND PostingDate <= _ProfitCenterText.ValidityEndDate AND PostingDate >= _ProfitCenterText.ValidityStartDate AND _ProfitCenterText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_PubSecBudgetAccountText AS _BudgetAccountText ON PubSecBudgetAccount = _BudgetAccountText.PubSecBudgetAccount AND PubSecBudgetAccountCoCode = _BudgetAccountText.PubSecBudgetAccountCoCode AND _BudgetAccountText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SegmentText AS _PartnerSegmentText ON PartnerSegment = _PartnerSegmentText.Segment AND _PartnerSegmentText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SegmentText AS _SegmentText ON Segment = _SegmentText.Segment AND _SegmentText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SpecialGLCodeText AS _SpecialGLCodeText ON FinancialAccountType = _SpecialGLCodeText.FinancialAccountType AND SpecialGLCode = _SpecialGLCodeText.SpecialGLCode AND _SpecialGLCodeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_CountryText AS _SupplyingCountryText ON SupplyingCountry = _SupplyingCountryText.Country AND _SupplyingCountryText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_TaxCodeText AS _TaxCodeText ON TaxCode = _TaxCodeText.TaxCode AND _TaxCodeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CountryText AS _TaxCountryText ON TaxCountry = _TaxCountryText.Country AND _TaxCountryText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementBasicData ON WBSElementInternalID = _WBSElementBasicData.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_WorkforcePersonMappings_1 AS _WorkForcePersonMappings ON PersonnelNumber = _WorkForcePersonMappings.WorkAssignment  -- association [0..1]
;