C_SmltdJrnlEntrLedgerView

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_SmltdJrnlEntrLedgerView.
-- 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 C_SmltdJrnlEntrLedgerView 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,
  LedgerGLLineItem,
  SourceLedger,
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  _LedgerText.LedgerName AS LedgerName,
  cast(_CompanyCode.CompanyCodeName as fis_butxt preserving type) AS CompanyCodeName,
  Ledger,
  LedgerFiscalYear,
  GLRecordType,
  JrnlEntrAltvFYConsecutiveID,
  ControllingArea,
  _ControllingArea.ControllingAreaName AS ControllingAreaName,
  BusinessTransactionCategory,
  _BusTransactionCategoryText.BusTransactionCategoryName AS BusTransactionCategoryName,
  BusinessTransactionType,
  ReferenceDocumentType,
  ReferenceDocumentContext,
  ReferenceDocument,
  ReferenceDocumentItem,
  ReferenceDocumentItemGroup,
  FinancialTransactionType,
  cast(_FinancialTransactionTypeT.FinancialTransactionTypeName as fincs_fintransactiontypename preserving type) AS FinancialTransactionTypeName,
  IsReversal,
  IsReversed,
  ReversalReferenceDocumentCntxt,
  ReversalReferenceDocument,
  IsSettlement,
  IsSettled,
  PredecessorReferenceDocCntxt,
  PredecessorReferenceDocItem,
  PredecessorReferenceDocType,
  PredecessorReferenceDocument,
  SourceReferenceDocument,
  SourceReferenceDocumentType,
  SourceReferenceDocumentItem,
  SourceReferenceDocumentCntxt,
  SourceLogicalSystem,
  SourceReferenceDocSubitem,
  IsCommitment,
  JrnlEntryItemObsoleteReason,
  cast(_JrnlEntryItemObsltRsnText.JrnlEntryItemObsoleteRsnName as jrnlentryitemobsoletersnname preserving type) AS JrnlEntryItemObsoleteRsnName,
  GLBusinessTransactionType,
  LogicalSystem,
  GLAccount,
  _GLAccountText.GLAccountName AS GLAccountName,
  _GLAccountText.GLAccountLongName AS GLAccountLongName,
  ChartOfAccounts,
  CostCenter,
  _CostCenterText.CostCenterName AS CostCenterName,
  ProfitCenter,
  _ProfitCenterText.ProfitCenterName AS ProfitCenterName,
  FunctionalArea,
  _FunctionalAreaText.FunctionalAreaName AS FunctionalAreaName,
  BusinessArea,
  _BusinessAreaText.BusinessAreaName AS BusinessAreaName,
  Segment,
  _SegmentText.SegmentName AS SegmentName,
  PartnerCostCenter,
  cast(_PartnerCostCenterText.CostCenterName as fco_partner_cost_center_name preserving type) AS PartnerCostCenterName,
  PartnerProfitCenter,
  cast(_PartnerProfitCenterText.ProfitCenterName as fis_partner_prctr_short_name preserving type) AS PartnerProfitCenterName,
  PartnerFunctionalArea,
  cast(_PartnerFunctionalAreaText.FunctionalAreaName as fis_pfkbtx preserving type) AS PartnerFunctionalAreaName,
  PartnerBusinessArea,
  cast(_PartnerBusinessAreaText.BusinessAreaName as fis_partner_gtext_vdm preserving type) AS PartnerBusinessAreaName,
  PartnerCompany,
  cast(_PartnerCompany.CompanyName as fis_rassc_name preserving type) AS PartnerCompanyName,
  PartnerSegment,
  cast(_PartnerSegmentText.SegmentName as fis_partner_segment_name preserving type) AS PartnerSegmentName,
  PrdcssrJournalEntryCompanyCode,
  cast(_PrdcssrJrnlEntrCompanyCode.CompanyCodeName as prdcssrjrnlentrcompanycodename preserving type) AS PrdcssrJrnlEntrCompanyCodeName,
  PrdcssrJournalEntryFiscalYear,
  PredecessorJournalEntry,
  PredecessorJournalEntryItem,
  CreditAmountInBalanceTransCrcy,
  CreditAmountInTransCrcy,
  CreditAmountInCoCodeCrcy,
  CreditAmountInGlobalCrcy,
  CreditAmountInFunctionalCrcy,
  CreditAmountInFreeDfndCrcy1,
  CreditAmountInFreeDfndCrcy2,
  CreditAmountInFreeDfndCrcy3,
  CreditAmountInFreeDfndCrcy4,
  CreditAmountInFreeDfndCrcy5,
  CreditAmountInFreeDfndCrcy6,
  CreditAmountInFreeDfndCrcy7,
  CreditAmountInFreeDfndCrcy8,
  DebitAmountInBalanceTransCrcy,
  DebitAmountInTransCrcy,
  DebitAmountInCoCodeCrcy,
  DebitAmountInGlobalCrcy,
  DebitAmountInFunctionalCrcy,
  DebitAmountInFreeDfndCrcy1,
  DebitAmountInFreeDfndCrcy2,
  DebitAmountInFreeDfndCrcy3,
  DebitAmountInFreeDfndCrcy4,
  DebitAmountInFreeDfndCrcy5,
  DebitAmountInFreeDfndCrcy6,
  DebitAmountInFreeDfndCrcy7,
  DebitAmountInFreeDfndCrcy8,
  _Item.AmountInBalanceTransacCrcy AS AmountInBalanceTransacCrcy,
  _Item.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  _Item.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  _Item.AmountInGlobalCurrency AS AmountInGlobalCurrency,
  _Item.AmountInFunctionalCurrency AS AmountInFunctionalCurrency,
  _Item.AmountInFreeDefinedCurrency1 AS AmountInFreeDefinedCurrency1,
  _Item.AmountInFreeDefinedCurrency2 AS AmountInFreeDefinedCurrency2,
  _Item.AmountInFreeDefinedCurrency3 AS AmountInFreeDefinedCurrency3,
  _Item.AmountInFreeDefinedCurrency4 AS AmountInFreeDefinedCurrency4,
  _Item.AmountInFreeDefinedCurrency5 AS AmountInFreeDefinedCurrency5,
  _Item.AmountInFreeDefinedCurrency6 AS AmountInFreeDefinedCurrency6,
  _Item.AmountInFreeDefinedCurrency7 AS AmountInFreeDefinedCurrency7,
  _Item.AmountInFreeDefinedCurrency8 AS AmountInFreeDefinedCurrency8,
  BalanceTransactionCurrency,
  TransactionCurrency,
  CompanyCodeCurrency,
  GlobalCurrency,
  FunctionalCurrency,
  FreeDefinedCurrency1,
  FreeDefinedCurrency2,
  FreeDefinedCurrency3,
  FreeDefinedCurrency4,
  FreeDefinedCurrency5,
  FreeDefinedCurrency6,
  FreeDefinedCurrency7,
  FreeDefinedCurrency8,
  BaseUnit,
  Quantity,
  FixedQuantity,
  CostSourceUnit,
  ValuationQuantity,
  ValuationFixedQuantity,
  AdditionalQuantity1Unit,
  AdditionalQuantity1,
  AdditionalQuantity2Unit,
  AdditionalQuantity2,
  AdditionalQuantity3Unit,
  AdditionalQuantity3,
  IncmpltSummableValnQtyUnt,
  IncmpltSummableValnQty,
  IncmpltSummableValnFxdQty,
  DebitCreditCode,
  ExchangeRateDate,
  FiscalPeriod,
  FiscalYearVariant,
  FiscalYearPeriod,
  PostingDate,
  DocumentDate,
  AccountingDocumentType,
  AccountingDocumentItem,
  AssignmentReference,
  AccountingDocumentCategory,
  PostingKey,
  _PostingKeyText.PostingKeyName AS PostingKeyName,
  TransactionTypeDetermination,
  SubLedgerAcctLineItemType,
  _SubLedgerAccLineItemTypeT.SubLedgerAcctLineItemTypeName AS SubLedgerAcctLineItemTypeName,
  CreationDate,
  CreationDateTime,
  EliminationProfitCenter,
  OriginObjectType,
  GLAccountType,
  AlternativeGLAccount,
  cast(_AlternativeGLAccountText.GLAccountName as alternativeglaccountname preserving type) AS AlternativeGLAccountName,
  CountryChartOfAccounts,
  ConsolidationUnit,
  InvoiceReference,
  InvoiceReferenceFiscalYear,
  FollowOnDocumentType,
  InvoiceItemReference,
  PartnerConsolidationUnit,
  Company,
  _Company.CompanyName AS CompanyName,
  ConsolidationChartOfAccounts,
  CnsldtnFinancialStatementItem,
  CnsldtnSubitemCategory,
  cast(_CnsldtnSubItemCategoryText.SubItemCategoryText as cnsldtnsubitemcategorytext preserving type) AS SubItemCategoryText,
  CnsldtnSubitem,
  ReferencePurchaseOrderCategory,
  PurchasingDocument,
  PurchasingDocumentItem,
  AccountAssignmentNumber,
  DocumentItemText,
  SalesDocument,
  SalesDocumentItem,
  Product,
  _ProductText.ProductName AS ProductName,
  ProductGroup,
  Plant,
  _Plant.PlantName AS PlantName,
  Supplier,
  _Supplier.SupplierName AS SupplierName,
  cast(_Supplier.Country as fis_supplier_country preserving type ) AS SupplierCountry,
  Customer,
  _Customer.CustomerName AS CustomerName,
  Customer AS CustomerForFilter,
  _Customer.CustomerName AS CustomerNameForFilter,
  cast(_Customer.Country as fis_customer_country preserving type ) AS CustomerCountry,
  ServicesRenderedDate,
  PerformancePeriodStartDate,
  PerformancePeriodEndDate,
  FinancialAccountType,
  SpecialGLCode,
  cast(_SpecialGLCodeText.SpecialGLCodeLongName as specialglcodelongname preserving type) AS SpecialGLCodeName,
  TaxCode,
  _TaxCodeText.TaxCodeName AS TaxCodeName,
  cast('' as kalsm_d) AS TaxCalculationProcedure,
  TaxCountry,
  cast(_TaxCountryText.CountryName as fot_tax_country_descr preserving type) AS TaxCountryName,
  HouseBank,
  cast(_HouseBank._Bank.BankName as farp_banka preserving type) AS HouseBankName,
  HouseBankAccount,
  cast(_HouseBankAccountText.HouseBankAccountDescription as /pf1/dte_housebank_acct_desc preserving type) AS HouseBankAccountDescription,
  IsOpenItemManaged,
  ClearingDate,
  ClearingJournalEntryFiscalYear,
  ClearingJournalEntry,
  IsCleared,
  ValueDate,
  AssetDepreciationArea,
  MasterFixedAsset,
  _MasterFixedAsset.MasterFixedAssetDescription AS MasterFixedAssetDescription,
  FixedAsset,
  FixedAssetExternalID,
  AssetValueDate,
  AssetTransactionType,
  cast(_AssetTransactionTypeText.AssetTransactionTypeName as assettransactiontypename preserving type) AS AssetTransactionTypeName,
  AssetAcctTransClassfctn,
  DepreciationFiscalPeriod,
  PartnerMasterFixedAsset,
  PartnerFixedAsset,
  AssetClass,
  cast(_AssetClassText.AssetClassName as faa_assetcla preserving type) AS AssetClassName,
  CostEstimate,
  InventorySpecialStockValnType,
  InventorySpecialStockType,
  InventorySpclStkSalesDocument,
  InventorySpclStkSalesDocItm,
  InvtrySpclStockWBSElmntIntID,
  InventorySpecialStockSupplier,
  InventoryValuationType,
  ValuationArea,
  InvtrySpclStockWBSElmntExtID,
  ProductPriceControl,
  SenderGLAccount,
  SenderAccountAssignment,
  SenderAccountAssignmentType,
  ControllingObject,
  CostOriginGroup,
  OriginSenderObject,
  ControllingDebitCreditCode,
  ControllingObjectDebitType,
  OffsettingAccount,
  OffsettingAccountType,
  OffsettingChartOfAccounts,
  LineItemIsCompleted,
  PersonnelNumber,
  _WorkForcePersonMappings.WorkAssignmentExternalID AS WorkAssignmentExternalID,
  BillableControl,
  ControllingObjectClass,
  PartnerCompanyCode,
  cast(_PartnerCompanyCode.CompanyCodeName as fis_partner_company_code_name preserving type) AS PartnerCompanyCodeName,
  PartnerControllingObjectClass,
  OriginCostCtrActivityType,
  cast(_OriginCostCtrActivityTypeT.CostCtrActivityTypeName as origincostctractivitytypename preserving type) AS OriginCostCtrActivityTypeName,
  OriginCostCenter,
  cast(_OriginCostCenterText.CostCenterName as fis_origin_cost_center_name preserving type) AS OriginCostCenterName,
  OriginProfitCenter,
  OriginProduct,
  cast(_OriginProductText.ProductName as fin_aci_orig_prod_name preserving type) AS OriginProductName,
  VarianceOriginGLAccount,
  AccountAssignment,
  AccountAssignmentType,
  _AccountAssignmentTypeT.AccountAssignmentTypeName AS AccountAssignmentTypeName,
  CostCtrActivityType,
  _CostCtrActivityTypeT.CostCtrActivityTypeName AS CostCtrActivityTypeName,
  OrderID,
  OrderCategory,
  WBSElementExternalID,
  WBSElementInternalID,
  WBSDescription,
  PartnerWBSElementInternalID,
  PartnerWBSElementExternalID,
  cast(PartnerWBSElementDescription as fis_partner_wbs_description preserving type) AS PartnerWBSElementDescription,
  WorkPackage,
  ProjectInternalID,
  PartnerProjectInternalID,
  PartnerProjectExternalID,
  cast(PartnerProjectDescription as fis_partner_projectdescription preserving type) AS PartnerProjectDescription,
  ProjectExternalID,
  ProjectDescription,
  OperatingConcern,
  ProjectNetwork,
  RelatedNetworkActivity,
  BusinessProcess,
  CostObject,
  CostAnalysisResource,
  CustomerServiceNotification,
  ServiceDocumentType,
  ServiceDocument,
  ServiceDocumentItem,
  PartnerServiceDocumentType,
  PartnerServiceDocument,
  PartnerServiceDocumentItem,
  ServiceContractType,
  ServiceContract,
  ServiceContractItem,
  BusinessSolutionOrder,
  BusinessSolutionOrderItem,
  ProviderContract,
  ProviderContractItem,
  TimeSheetOvertimeCategory,
  PartnerAccountAssignment,
  PartnerAccountAssignmentType,
  cast(_PartnerAccountAssignmentTypeT.AccountAssignmentTypeName as partaccountassignmenttypename preserving type) AS PartAccountAssignmentTypeName,
  PartnerCostCtrActivityType,
  cast(_PartnerCostCtrActivityTypeT.CostCtrActivityTypeName as partnercostctractivitytypename preserving type) AS PartnerCostCtrActivityTypeName,
  PartnerOrder,
  PartnerOrderCategory,
  PartnerSalesDocument,
  PartnerSalesDocumentItem,
  PartnerProjectNetwork,
  PartnerProjectNetworkActivity,
  PartnerBusinessProcess,
  PartnerCostObject,
  WorkItem,
  BillingDocumentType,
  SalesOrganization,
  DistributionChannel,
  OrganizationDivision,
  SoldProduct,
  SoldProductGroup,
  CustomerGroup,
  cast(_CustomerGroupText.CustomerGroupName as fincs_kdgrp_t preserving type) AS CustomerGroupName,
  CustomerSupplierCountry,
  cast(_CustomerSupplierCountryText.CountryName as fincs_land1_t preserving type) AS CustomerSupplierCountryName,
  CustomerSupplierIndustry,
  _CustomerSupplierIndustryText.CustomerSupplierIndustryName AS CustomerSupplierIndustryName,
  SalesDistrict,
  BillToParty,
  ShipToParty,
  CustomerSupplierCorporateGroup,
  CashLedgerCompanyCode,
  cast(_CashLedgerCompanyCode.CompanyCodeName as cashledgercompanycodename preserving type) AS CashLedgerCompanyCodeName,
  CashLedgerAccount,
  cast(_CashLedgerAccountText.GLAccountName as fis_re_account_name preserving type) AS CashLedgerAccountName,
  FinancialManagementArea,
  FundsCenter,
  FundedProgram,
  Fund,
  _FundText.FundName AS FundName,
  GrantID,
  cast(_GrantText.GrantName as fco_grant_name preserving type) AS GrantName,
  BudgetPeriod,
  _BudgetPeriodText.BudgetPeriodName AS BudgetPeriodName,
  PartnerFund,
  cast(_PartnerFundText.FundName as receiverpostedfundname preserving type) AS ReceiverPostedFundName,
  PartnerGrant,
  cast(_PartnerGrantText.GrantName as receiverpostedgrantname preserving type) AS ReceiverPostedGrantName,
  PartnerBudgetPeriod,
  cast(_PartnerBudgetPeriodText.BudgetPeriodName as receiverpostedbudgetperiodname preserving type) AS ReceiverPostedBudgetPeriodName,
  PubSecBudgetAccount,
  _BudgetAccountText.BudgetAccountName AS BudgetAccountName,
  PubSecBudgetAccountCoCode,
  PubSecBudgetCnsmpnDate,
  PubSecBudgetCnsmpnFsclYear,
  PubSecBudgetCnsmpnFsclPeriod,
  PubSecBudgetIsRelevant,
  PubSecBudgetCnsmpnType,
  _PubSecBdgtCnsmpnTypeText.PubSecBudgetCnsmpnTypeText AS PubSecBudgetCnsmpnTypeText,
  PubSecBudgetCnsmpnAmtType,
  _PubSecBdgtCnsmpnAmtTypeText.PubSecBdgtCnsmpnAmtTypeText AS PubSecBdgtCnsmpnAmtTypeText,
  SponsoredProgram,
  _SponsoredProgramText.SponsoredProgramName AS SponsoredProgramName,
  SponsoredClass,
  _SponsoredClassText.SponsoredClassName AS SponsoredClassName,
  GteeMBudgetValidityNumber,
  CommitmentItem,
  JointVenture,
  JointVentureEquityGroup,
  JointVentureCostRecoveryCode,
  JointVenturePartner,
  JointVentureBillingType,
  JointVentureEquityType,
  JointVentureProductionDate,
  JointVentureBillingDate,
  JointVentureOperationalDate,
  JointVentureAccountingActivity,
  SettlementReferenceDate,
  PartnerVenture,
  PartnerEquityGroup,
  SenderCostRecoveryCode,
  CutbackAccount,
  CutbackCostObject,
  REBusinessEntity,
  RealEstateBuilding,
  RealEstateProperty,
  RERentalObject,
  RealEstateContract,
  cast(REServiceChargeKey as rescsckey preserving type) AS REServiceChargeKey,
  cast(RESettlementUnitID as rescsuid preserving type) AS RESettlementUnitID,
  AccrualObjectType,
  AccrualObjectLogicalSystem,
  AccrualObject,
  AccrualSubobject,
  AccrualItemType,
  AccrualReferenceObject,
  AccrualValueDate,
  FinancialValuationObjectType,
  FinancialValuationObject,
  FinancialValuationSubobject,
  NetDueDate,
  CreditRiskClass,
  IsNegativePosting,
  IsStatisticalOrder,
  IsStatisticalCostCenter,
  IsStatisticalSalesDocument,
  WBSIsStatisticalWBSElement,
  OrderOperation,
  JrnlEntryItemMigrationSource,
  AccountingDocCreatedByUser,
  WithholdingTaxCode,
  BillingDocument,
  ScheduleLine,
  IsNotCashDiscountLiable,
  BranchAccount,
  SpecialGLAccountAssignment,
  DueCalculationBaseDate,
  PaymentTerms,
  cast(_PaymentTermsText.PaymentTermsName as paymenttermsname preserving type) AS PaymentTermsName,
  CashDiscountBaseAmount,
  CashDiscountAmount,
  CashDiscount1Days,
  CashDiscount2Days,
  NetPaymentDays,
  CashDiscount1Percent,
  CashDiscount2Percent,
  PaymentMethod,
  PaymentBlockingReason,
  _PaymentBlockingReasonText.PaymentBlockingReasonName AS PaymentBlockingReasonName,
  FixedCashDiscount,
  cast(_FixedCashDiscountTypeText.UtilsDiscountTypeDescription as fixedcashdiscountname preserving type) AS UtilsDiscountTypeDescription,
  BPBankAccountInternalID,
  StateCentralBankPaymentReason,
  SupplyingCountry,
  cast(_SupplyingCountryText.CountryName as supplyingcountryname preserving type) AS SupplyingCountryName,
  cast( InvoiceList as vbeln_rl) AS InvoiceList,
  DunningKey,
  DunningBlockingReason,
  LastDunningDate,
  DunningLevel,
  DunningArea,
  _DunningAreaText.DunningAreaName AS DunningAreaName,
  WithholdingTaxCertificate,
  VATRegistration,
  VATRegistration AS VATRegistrationForFilter,
  PaymentDifferenceReason,
  cast(_PaymentDifferenceReasonText.PaymentDifferenceReasonName as paymentdifferencereasonname preserving type) AS PaymentDifferenceReasonName,
  TaxJurisdiction,
  IsEUTriangularDeal,
  PaymentMethodSupplement,
  Reference1IDByBusinessPartner,
  Reference2IDByBusinessPartner,
  Reference3IDByBusinessPartner,
  DataExchangeInstruction1,
  DataExchangeInstruction2,
  DataExchangeInstruction3,
  DataExchangeInstruction4,
  Region,
  HasPaymentOrder,
  PaymentReference,
  TaxDeterminationDate,
  BusinessPlace,
  SEPAMandate,
  EarmarkedFundsDocument,
  EarmarkedFundsDocumentItem,
  TaxRateValidityStartDate,
  PaymentReason,
  BranchCode,
  PaymentCurrency,
  NetPaymentAmount,
  TaxBaseAmountInCoCodeCrcy,
  TaxBaseAmountInTransCrcy,
  WithholdingTaxAmount,
  WithholdingTaxExemptionAmt,
  WithholdingTaxBaseAmount,
  FinancialServicesProductGroup,
  _FinServicesProductGroupT.FinServicesProductGroupName AS FinServicesProductGroupName,
  FinancialServicesBranch,
  _FinancialServicesBranchT.FinancialServicesBranchName AS FinancialServicesBranchName,
  FinancialDataSource,
  _FinancialDataSourceT.FinancialDataSourceName AS FinancialDataSourceName,
  ProfitabilitySegment,
  RevenueAccountingContract,
  PerformanceObligation,
  InterestCalculationBlockReason,
  ComponentBreakdown,
  CompBreakdownScaleNumerator,
  '' AS FinancialTransactionTypeIsHdn,
  '' AS PostingKeyIsHidden,
  '' AS CustomerIsHidden,
  '' AS SupplierIsHidden,
  '' AS BranchAccountIsHidden,
  '' AS PartnerCompanyIsHidden,
  '' AS GLAccountIsHidden,
  '' AS CreditAmountIsHidden,
  '' AS CreditAmtInFreeDfndCrcy1IsHdn,
  '' AS CreditAmtInFreeDfndCrcy2IsHdn,
  '' AS CreditAmtInFreeDfndCrcy3IsHdn,
  '' AS CreditAmtInFreeDfndCrcy4IsHdn,
  '' AS CreditAmtInFreeDfndCrcy5IsHdn,
  '' AS CreditAmtInFreeDfndCrcy6IsHdn,
  '' AS CreditAmtInFreeDfndCrcy7IsHdn,
  '' AS CreditAmtInFreeDfndCrcy8IsHdn,
  '' AS DebitAmountIsHidden,
  '' AS DebitAmtInFreeDfndCrcy1IsHdn,
  '' AS DebitAmtInFreeDfndCrcy2IsHdn,
  '' AS DebitAmtInFreeDfndCrcy3IsHdn,
  '' AS DebitAmtInFreeDfndCrcy4IsHdn,
  '' AS DebitAmtInFreeDfndCrcy5IsHdn,
  '' AS DebitAmtInFreeDfndCrcy6IsHdn,
  '' AS DebitAmtInFreeDfndCrcy7IsHdn,
  '' AS DebitAmtInFreeDfndCrcy8IsHdn,
  '' AS AssignmentReferenceIsHidden,
  '' AS Reference1IDByBizPartnerIsHdn,
  '' AS Reference2IDByBizPartnerIsHdn,
  '' AS Reference3IDByBizPartnerIsHdn,
  '' AS ClearingJournalEntryIsHidden,
  '' AS ClearingDateIsHidden,
  '' AS BranchCodeIsHidden,
  '' AS QuantityIsHidden,
  '' AS PerfPeriodStartDateIsHidden,
  '' AS PerformancePeriodEndDateIsHdn,
  '' AS SubLedgerAcctLineItemTypeIsHdn,
  '' AS ServicesRenderedDateIsHidden,
  '' AS LedgerFiscalYearIsHidden,
  '' AS BusinessTransTypeIsHidden,
  '' AS ReferenceDocumentTypeIsHidden,
  '' AS ReferenceDocumentIsHidden,
  '' AS ChartOfAccountsIsHidden,
  '' AS ExchangeRateDateIsHidden,
  '' AS FiscalYearPeriodIsHidden,
  '' AS PostingDateIsHidden,
  '' AS DocumentDateIsHidden,
  '' AS AccountingDocumentTypeIsHidden,
  '' AS AccountAssignmentTypeIsHidden,
  '' AS AccountAssignmentIsHidden,
  '' AS PrtnAccountAssignmentTypeIsHdn,
  '' AS PartnerAccountAssignmentIsHdn,
  '' AS BusinessAreaIsHidden,
  '' AS PartnerBusinessAreaIsHidden,
  '' AS CompanyCodeIsHidden,
  '' AS ControllingAreaIsHidden,
  '' AS ProductIsHidden,
  '' AS CostCenterIsHidden,
  '' AS OrderIDIsHidden,
  '' AS WBSElementExternalIDIsHidden,
  '' AS SalesDocumentIsHidden,
  '' AS SalesDocumentItemIsHidden,
  '' AS ScheduleLineIsHidden,
  '' AS PersonnelNumberIsHidden,
  '' AS ProjectNetworkIsHidden,
  '' AS PlantIsHidden,
  '' AS ProfitCenterIsHidden,
  '' AS PartnerProfitCenterIsHidden,
  '' AS CostObjectIsHidden,
  '' AS FunctionalAreaIsHidden,
  '' AS CostCtrActivityTypeIsHidden,
  '' AS BusinessProcessIsHidden,
  '' AS SegmentIsHidden,
  '' AS PartnerSegmentIsHidden,
  '' AS EarmarkedFundsDocumentIsHidden,
  '' AS EmrkdFundsDocumentItemIsHidden,
  '' AS LineItemIsCompletedIsHidden,
  '' AS SupplierCountryIsHidden,
  '' AS CustomerCountryIsHidden,
  '' AS BillingDocumentTypeIsHidden,
  '' AS CustomerSupplierCorpGroupIsHdn,
  '' AS CreditRiskClassIsHidden,
  '' AS CustomerGroupIsHidden,
  '' AS CustomerSupplierCountryIsHdn,
  '' AS CustomerSupplierIndustryIsHdn,
  '' AS ValueDateIsHidden,
  '' AS PaymentMethodIsHidden,
  '' AS PaymentMethodSupplementIsHdn,
  '' AS PaymentBlockingReasonIsHidden,
  '' AS HouseBankIsHidden,
  '' AS HouseBankAccountIsHidden,
  '' AS BPBankAccountInternalIDIsHdn,
  '' AS DataExchangeInstruction1IsHdn,
  '' AS DataExchangeInstruction2IsHdn,
  '' AS DataExchangeInstruction3IsHdn,
  '' AS DataExchangeInstruction4IsHdn,
  '' AS NetPaymentAmountIsHidden,
  '' AS PaymentReferenceIsHidden,
  '' AS AmountInPaymentCurrencyIsHdn,
  '' AS SEPAMandateIsHidden,
  '' AS HasPaymentOrderIsHidden,
  '' AS PaymentReasonIsHidden,
  '' AS CashDiscountBaseAmountIsHidden,
  '' AS CashDiscountAmountIsHidden,
  '' AS IsNotCashDiscountLiableIsHdn,
  '' AS DueCalculationBaseDateIsHidden,
  '' AS PaymentTermsIsHidden,
  '' AS CashDiscount1DaysIsHidden,
  '' AS CashDiscount1PercentIsHidden,
  '' AS CashDiscount2DaysIsHidden,
  '' AS CashDiscount2PercentIsHidden,
  '' AS NetPaymentDaysIsHidden,
  '' AS FixedCashDiscountIsHidden,
  '' AS NetDueDateIsHidden,
  '' AS PurchasingDocumentIsHidden,
  '' AS PurchasingDocumentItemIsHidden,
  '' AS BillingDocumentIsHidden,
  '' AS InvoiceListIsHidden,
  '' AS InvoiceReferenceIsHidden,
  '' AS FollowOnDocumentTypeIsHidden,
  '' AS InvoiceRefFiscalYearIsHidden,
  '' AS InvoiceItemReferenceIsHidden,
  '' AS SpecialGLAcctAssignmentIsHdn,
  '' AS SpecialGLCodeIsHidden,
  '' AS DunningAreaIsHidden,
  '' AS LastDunningDateIsHidden,
  '' AS DunningBlockingReasonIsHidden,
  '' AS DunningLevelIsHidden,
  '' AS DunningKeyIsHidden,
  '' AS PaymentDifferenceReasonIsHdn,
  '' AS AssetClassIsHidden,
  '' AS MasterFixedAssetIsHidden,
  '' AS FixedAssetIsHidden,
  '' AS AssetDepreciationAreaIsHidden,
  '' AS AssetTransactionTypeIsHidden,
  '' AS AssetValueDateIsHidden,
  '' AS DepreciationFiscalPeriodIsHdn,
  '' AS PartnerMasterFixedAssetIsHdn,
  '' AS PartnerFixedAssetIsHidden,
  '' AS AssetAcctTransClassfctnIsHdn,
  '' AS TaxCodeIsHidden,
  '' AS TaxJurisdictionIsHidden,
  '' AS TaxBaseAmountInCoCodeCrcyIsHdn,
  '' AS TaxBaseAmountInTransCrcyIsHdn,
  '' AS WithholdingTaxCodeIsHidden,
  '' AS WithholdingTaxAmountIsHidden,
  '' AS WhgdTaxExemptionAmtIsHidden,
  '' AS WithholdingTaxCertificateIsHdn,
  '' AS WithholdingTaxBaseAmountIsHdn,
  '' AS IntrstCalcBlockReasonIsHdn,
  '' AS IsEUTriangularDealIsHidden,
  '' AS VATRegistrationIsHidden,
  '' AS RegionIsHidden,
  '' AS TaxDeterminationDateIsHidden,
  '' AS TaxRateValidityStartDateIsHdn,
  '' AS TaxCountryIsHidden,
  '' AS BusinessPlaceIsHidden,
  '' AS SupplyingCountryIsHidden,
  '' AS StateCntrlBkPaymentReasonIsHdn,
  '' AS CashLedgerCompanyCodeIsHidden,
  '' AS CashLedgerAccountIsHidden,
  '' AS PubSecBudgetAccountIsHidden,
  '' AS PubSecBudgetCnsmpnDateIsHidden,
  '' AS PubSecBdgtCnsmpnFsclPerdIsHdn,
  '' AS PubSecBdgtCnsmpnFsclYrIsHidden,
  '' AS PubSecBudgetIsRelevantIsHidden,
  '' AS PubSecBudgetCnsmpnTypeIsHidden,
  '' AS PubSecBudgetCnsmpnAmtTypeIsHdn,
  '' AS SponsoredProgramIsHidden,
  '' AS SponsoredClassIsHidden,
  '' AS GteeMBudgetValidityNumberIsHdn,
  '' AS AlternativeGLAccountIsHidden,
  '' AS ServiceDocumentTypeIsHidden,
  '' AS ServiceDocumentIsHidden,
  '' AS ServiceDocumentItemIsHidden,
  '' AS ServiceContractTypeIsHidden,
  '' AS ServiceContractIsHidden,
  '' AS ServiceContractItemIsHidden,
  '' AS JointVentureIsHidden,
  '' AS JointVentureEquityGroupIsHdn,
  '' AS JntVntrCostRecoveryCodeIsHdn,
  '' AS JointVenturePartnerIsHidden,
  '' AS JntVntrBillingTypeIsHidden,
  '' AS JntVntrProductionDateIsHidden,
  '' AS JntVntrBillingDateIsHidden,
  '' AS JntVntrOperationalDateIsHidden,
  '' AS JntVntrAcctgActivityIsHidden,
  '' AS JointVentureEquityTypeIsHidden,
  '' AS ConsolidationUnitIsHidden,
  '' AS PartnerConsolidationUnitIsHdn,
  '' AS CompanyIsHidden,
  '' AS CnsldtnChartOfAccountsIsHidden,
  '' AS CnsldtnFinStatementItemIsHdn,
  '' AS CnsldtnSubitemCategoryIsHidden,
  '' AS CnsldtnSubitemIsHidden,
  '' AS WithHoldingTaxIDIsHidden,
  '' AS FinancialManagementAreaIsHdn,
  '' AS FiscalPeriodIsHidden,
  '' AS FundIsHidden,
  '' AS GrantIDIsHidden,
  '' AS BudgetPeriodIsHidden,
  '' AS PartnerFundIsHidden,
  '' AS PartnerGrantIsHidden,
  '' AS PartnerBudgetPeriodIsHidden,
  '' AS CommitmentItemIsHidden,
  '' AS REBusinessEntityIsHidden,
  '' AS RealEstateBuildingIsHidden,
  '' AS RealEstatePropertyIsHidden,
  '' AS RERentalObjectIsHidden,
  '' AS RealEstateContractIsHidden,
  '' AS REServiceChargeKeyIsHidden,
  '' AS RESettlementUnitIDIsHidden,
  '' AS PartnerCostCenterIsHidden,
  '' AS PartnerFunctionalAreaIsHidden,
  '' AS PartnerCompanyCodeIsHidden,
  '' AS PartnerCtrlgObjectClassIsHdn,
  '' AS PartnerWBSElementExtIDIsHidden,
  '' AS PartnerProjectExtIDIsHidden,
  '' AS PartnerServiceDocTypeIsHidden,
  '' AS PartnerServiceDocIsHidden,
  '' AS PartnerServiceDocItemIsHidden,
  '' AS PartnerCostCtrActyTypeIsHdn,
  '' AS PartnerOrderIsHidden,
  '' AS PartnerOrderCategoryIsHidden,
  '' AS PartnerSalesDocumentIsHidden,
  '' AS PartnerSalesDocItemIsHidden,
  '' AS PartnerProjectNetworkIsHidden,
  '' AS PartnerProjectNetworkActyIsHdn,
  '' AS PartnerBusinessProcessIsHidden,
  '' AS PartnerCostObjectIsHidden,
  '' AS PartnerVentureIsHidden,
  '' AS PartnerEquityGroupIsHidden,
  '' AS WithholdingTaxItemIsHidden,
  cast ('' as abap.char(1)) AS IntrstCalcBlockReasonIsHidden,
  SampleAccountingDocument,
  AddressAndBankIsSetManually,
  IsOneTimeAccount,
  AlternativePayeeIsAllowed,
  cast( _Customer.AlternativePayeeIsAllowed as farp_isalternativepayer preserving type ) AS PayerIsAlternativePayer,
  cast( _Supplier.AlternativePayeeIsAllowed as farp_isalternativepayee preserving type ) AS PayeeIsAlternativePayee,
  OplAcctgDocItmCntrySpcfcRef1,
  abap.string'' AS DynamicalMetadataString
FROM R_ManageJournalEntryLedgerView AS _Item
LEFT OUTER JOIN I_FixedCashDiscountTypeText AS _FixedCashDiscountTypeText ON FixedCashDiscount = _FixedCashDiscountTypeText.FixedCashDiscount AND _FixedCashDiscountTypeText.Language = $session.system_language  -- 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 C_SmltdJrnlEntrWhldgTaxItem AS _WithholdingTaxItem ON TemporaryAccountingDocument = _WithholdingTaxItem.TemporaryAccountingDocument AND TmpAccountingDocumentType = _WithholdingTaxItem.TmpAccountingDocumentType AND TmpAcctgDocSpecificationArea = _WithholdingTaxItem.TmpAcctgDocSpecificationArea AND TmpAcctgDocumentCreatedByUser = _WithholdingTaxItem.TmpAcctgDocumentCreatedByUser AND AccountingDocumentItem = _WithholdingTaxItem.AccountingDocumentItem  -- association [0..*]
;