R_ManageJournalEntryItem

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 R_ManageJournalEntryItem.
-- 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 R_ManageJournalEntryItem AS
SELECT
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  AccountingDocumentItem,
  ChartOfAccounts,
  ClearingDate,
  ClearingCreationDate,
  ClearingJournalEntry,
  PostingKey,
  FinancialAccountType,
  SpecialGLCode,
  SpecialGLTransactionType,
  DebitCreditCode,
  BusinessArea,
  PartnerBusinessArea,
  TaxCode,
  WithholdingTaxCode,
  TaxType,
  TransactionTypeDetermination,
  ValueDate,
  AssignmentReference,
  DocumentItemText,
  PartnerCompany,
  FinancialTransactionType,
  CorporateGroupAccount,
  PlanningLevel,
  ControllingArea,
  CostCenter,
  OrderID,
  BillingDocument,
  SalesDocument,
  SalesDocumentItem,
  ScheduleLine,
  ServiceDocumentType,
  ServiceDocument,
  ServiceDocumentItem,
  MasterFixedAsset,
  FixedAsset,
  AssetTransactionType,
  AssetValueDate,
  PersonnelNumber,
  IsSalesRelated,
  LineItemDisplayIsEnabled,
  IsOpenItemManaged,
  IsNotCashDiscountLiable,
  IsAutomaticallyCreated,
  IsUsedInPaymentTransaction,
  OperationalGLAccount,
  GLAccount,
  Customer,
  Supplier,
  BranchAccount,
  IsBalanceSheetAccount,
  ProfitLossAccountType,
  SpecialGLAccountAssignment,
  DueCalculationBaseDate,
  cast( CashDiscountAbsoluteBaseAmount as fis_skfbt ) AS CashDiscountBaseAmount,
  cast( CashDiscountAbsoluteAmount as fis_wskto ) AS CashDiscountAmount,
  PaymentTerms,
  CashDiscount1Days,
  CashDiscount2Days,
  NetPaymentDays,
  CashDiscount1Percent,
  CashDiscount2Percent,
  PaymentMethod,
  PaymentBlockingReason,
  FixedCashDiscount,
  HouseBank,
  BPBankAccountInternalID,
  TaxDistributionCode1,
  TaxDistributionCode2,
  TaxDistributionCode3,
  InvoiceReference,
  InvoiceReferenceFiscalYear,
  InvoiceItemReference,
  FollowOnDocumentType,
  StateCentralBankPaymentReason,
  SupplyingCountry,
  InvoiceList,
  BillOfExchangeUsage,
  DunningKey,
  DunningBlockingReason,
  LastDunningDate,
  DunningLevel,
  DunningArea,
  WithholdingTaxCertificate,
  Product,
  Plant,
  PurchasingDocument,
  PurchasingDocumentItem,
  AccountAssignmentNumber,
  IsCompletelyDelivered,
  IsCompletelyDelivered AS LineItemIsCompleted,
  MaterialPriceControl,
  ValuationArea,
  InventoryValuationType,
  VATRegistration,
  DelivOfGoodsDestCountry,
  PaymentDifferenceReason,
  ProfitCenter,
  JointVenture,
  JointVentureCostRecoveryCode,
  JointVentureEquityGroup,
  TreasuryContractType,
  AssetContract,
  CashFlowType,
  TaxJurisdiction,
  REInternalFinNumber,
  SettlementReferenceDate,
  cast(CommitmentItem as fm_fipex) AS CommitmentItem,
  CommitmentItemShortID,
  CostObject,
  ProjectNetwork,
  OrderInternalBillOfOperations,
  OrderIntBillOfOperationsItem,
  cast( WBSElementInternalID as fis_wbsint_no_conv ) AS WBSElementInternalID,
  ProfitabilitySegment_2 AS ProfitabilitySegment,
  JointVentureEquityType,
  IsEUTriangularDeal,
  CostOriginGroup,
  CompanyCodeCurrencyDetnMethod,
  ClearingIsReversed,
  PaymentMethodSupplement,
  AlternativeGLAccount,
  PartnerProfitCenter,
  Reference1IDByBusinessPartner,
  Reference2IDByBusinessPartner,
  IsNegativePosting,
  PaymentCardItem,
  PaymentCardPaymentSettlement,
  CreditControlArea,
  Reference3IDByBusinessPartner,
  DataExchangeInstruction1,
  DataExchangeInstruction2,
  DataExchangeInstruction3,
  DataExchangeInstruction4,
  Region,
  HasPaymentOrder,
  PaymentReference,
  TaxDeterminationDate,
  ClearingItem,
  BusinessPlace,
  TaxSection,
  CostCtrActivityType,
  AcctsReceivablePledgingCode,
  BusinessProcess,
  FunctionalArea,
  CustomerIsInExecution,
  ClearingJournalEntryFiscalYear,
  LedgerGLLineItem,
  Segment,
  PartnerSegment,
  PartnerFunctionalArea,
  HouseBankAccount,
  CostElement,
  PaymentServiceProvider,
  PaymentRefByPaytSrvcProvider,
  SEPAMandate,
  ReferenceDocumentType,
  OriginalReferenceDocument,
  ReferenceDocumentLogicalSystem,
  AccountingDocumentItemRef,
  FiscalPeriod,
  AccountingDocumentCategory,
  PostingDate,
  DocumentDate,
  AccountingDocumentType,
  NetDueDate,
  CashDiscount1DueDate,
  CashDiscount2DueDate,
  OffsettingAccount,
  OffsettingAccountType,
  OffsettingChartOfAccounts,
  CashLedgerCompanyCode,
  CashLedgerAccount,
  FundsCenter,
  FundedProgram,
  Fund,
  GrantID,
  BudgetPeriod,
  PartnerFund,
  PartnerGrant,
  PartnerBudgetPeriod,
  PubSecBudgetAccount,
  PubSecBudgetAccountCoCode,
  CompanyCodeCurrency,
  AmountInCompanyCodeCurrency,
  FunctionalCurrency,
  AmountInFunctionalCurrency,
  TransactionCurrency,
  AmountInTransactionCurrency,
  BalanceTransactionCurrency,
  cast( AbsltAmtInBalanceTransacCrcy as fis_tsl ) AS AmountInBalanceTransacCrcy,
  AdditionalCurrency1,
  cast( AbsltAmtInAdditionalCurrency1 as fis_dmbe2) AS AmountInAdditionalCurrency1,
  cast(case DebitCreditCode when 'S' then AmountInAdditionalCurrency1 else abap.curr'0.00' end as fis_dmbe2) as DebitAmountInAddlCrcy1 AS 00endasfis_dmbe2asDebitAmountInAddlCrcy1,
  AdditionalCurrency2,
  AmountInAdditionalCurrency2,
  cast(case DebitCreditCode when 'S' then AmountInAdditionalCurrency2 else abap.curr'0.00' end as fis_dmbe3) as DebitAmountInAddlCrcy2 AS 00endasfis_dmbe3asDebitAmountInAddlCrcy2,
  PaymentCurrency,
  cast(AbsltAmountInPaymentCurrency as fis_pyamt) AS AmountInPaymentCurrency,
  BaseUnit,
  cast( Quantity as fis_absolute_quantity ) AS AbsoluteQuantity,
  GoodsMovementEntryUnit,
  QuantityInEntryUnit,
  PurchasingDocumentPriceUnit,
  PurchaseOrderQty,
  MaterialPriceUnitQty,
  EarmarkedFundsDocument,
  EarmarkedFundsDocumentItem,
  cast( PaytSlipWthRefReference as fac_mje_esrre preserving type ) AS PaytSlipWthRefReference,
  TaxRateValidityStartDate,
  PaytSlipWthRefCheckDigit,
  PaytSlipWthRefSubscriber,
  PaymentReason,
  BranchCode,
  cast( NetPaymentAbsoluteAmount as fis_nebtr ) AS NetPaymentAmount,
  cast( TaxAbsltBaseAmountInCoCodeCrcy as hwbas_shl ) AS TaxBaseAmountInCoCodeCrcy,
  cast( TaxAbsltBaseAmountInTransCrcy as fwbas_shl ) AS TaxBaseAmountInTransCrcy,
  cast( WithholdingTaxAbsoluteAmount as fis_qbshb ) AS WithholdingTaxAmount,
  cast( WhldgTaxExemptionAbsltAmount as fis_qsfbt ) AS WithholdingTaxExemptionAmt,
  cast( WithholdingTaxAbsoluteBaseAmt as fis_qsshb ) AS WithholdingTaxBaseAmount,
  TaxCountry,
  AddressAndBankIsSetManually,
  OplAcctgDocItmCntrySpcfcRef1,
  cast(FinancialServicesProductGroup as ffs_product_group preserving type) AS FinancialServicesProductGroup,
  cast(FinancialServicesBranch as ffs_branch_id preserving type) AS FinancialServicesBranch,
  cast(FinancialDataSource as ffs_datasource_id preserving type) AS FinancialDataSource,
  CustomerGroup,
  CustomerSupplierCountry,
  CustomerSupplierIndustry,
  cast( CashDiscAbsltAmtInCoCodeCrcy as fis_sknto ) AS CashDiscountAmtInCoCodeCrcy,
  AccountingDocumentItemType,
  AlternativePayeePayer,
  DownPaymentIsNetProcedure,
  cast( TaxAbsltAmountInCoCodeCrcy as fis_mwsts ) AS TaxAmountInCoCodeCrcy,
  cast( TaxAbsoluteAmount as wmwst_shl ) AS TaxAmount,
  RecrrgSuplrInvcIsSrvcInvoice,
  SuplrInvcIsCapitalGoodsRelated,
  AcctgDocItmCustomsTariffNumber,
  AcctgDocItmCstmsClearanceDate,
  ClearingIsLedgerGroupSpecific,
  InvcItmIsExcldFrmPromptPaytAct,
  InterestCalculationBlockReason,
  cast( '' as fis_cession_kz_ind) AS AccountsReceivableIsPledged,
  cast( '' as anlkl) AS AssetClass
FROM I_OperationalAcctgDocItem
-- UNION ALL with additional select branch(es): I_AddlLedgerOplAcctgDocItem
;