C_ManageJournalEntryItemTP

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_ManageJournalEntryItemTP.
-- 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_ManageJournalEntryItemTP AS
SELECT
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  AccountingDocumentItem,
  cast(_CompanyCode.CompanyCodeName as fis_butxt preserving type) AS CompanyCodeName,
  ChartOfAccounts,
  ClearingDate,
  ClearingCreationDate,
  ClearingJournalEntry,
  PostingKey,
  _PostingKeyText.PostingKeyName AS PostingKeyName,
  FinancialAccountType,
  SpecialGLCode,
  cast(_SpecialGLCodeText.SpecialGLCodeLongName as specialglcodelongname preserving type) AS SpecialGLCodeName,
  SpecialGLTransactionType,
  DebitCreditCode,
  BusinessArea,
  _BusinessAreaText.BusinessAreaName AS BusinessAreaName,
  PartnerBusinessArea,
  cast(_PartnerBusinessAreaText.BusinessAreaName as fis_partner_gtext_vdm preserving type) AS PartnerBusinessAreaName,
  TaxCode,
  WithholdingTaxCode,
  TaxType,
  TransactionTypeDetermination,
  ValueDate,
  AssignmentReference,
  DocumentItemText,
  PartnerCompany,
  cast(_PartnerCompany.CompanyName as fis_rassc_name preserving type) AS PartnerCompanyName,
  FinancialTransactionType,
  cast(_FinancialTransactionTypeT.FinancialTransactionTypeName as fincs_fintransactiontypename preserving type) AS FinancialTransactionTypeName,
  CorporateGroupAccount,
  PlanningLevel,
  ControllingArea,
  _ControllingArea.ControllingAreaName AS ControllingAreaName,
  CostCenter,
  _CostCenterText.CostCenterName AS CostCenterName,
  OrderID,
  BillingDocument,
  SalesDocument,
  SalesDocumentItem,
  ScheduleLine,
  ServiceDocumentType,
  ServiceDocument,
  ServiceDocumentItem,
  MasterFixedAsset,
  _MasterFixedAsset.MasterFixedAssetDescription AS MasterFixedAssetDescription,
  FixedAsset,
  FixedAssetExternalID,
  AssetTransactionType,
  cast(_AssetTransactionTypeText.AssetTransactionTypeName as assettransactiontypename preserving type) AS AssetTransactionTypeName,
  AssetValueDate,
  PersonnelNumber,
  _WorkForcePersonMappings.WorkAssignmentExternalID AS WorkAssignmentExternalID,
  IsSalesRelated,
  LineItemDisplayIsEnabled,
  IsOpenItemManaged,
  IsNotCashDiscountLiable,
  IsAutomaticallyCreated,
  IsUsedInPaymentTransaction,
  OperationalGLAccount,
  GLAccount,
  _GLAccountText.GLAccountName AS GLAccountName,
  _GLAccountText.GLAccountLongName AS GLAccountLongName,
  Customer,
  _Customer.CustomerName AS CustomerName,
  Customer AS CustomerForFilter,
  _Customer.CustomerName AS CustomerNameForFilter,
  Supplier,
  _Supplier.SupplierName AS SupplierName,
  BranchAccount,
  IsBalanceSheetAccount,
  ProfitLossAccountType,
  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,
  HouseBank,
  cast(_HouseBank._Bank.BankName as farp_banka preserving type) AS HouseBankName,
  BPBankAccountInternalID,
  TaxDistributionCode1,
  TaxDistributionCode2,
  TaxDistributionCode3,
  InvoiceReference,
  InvoiceReferenceFiscalYear,
  InvoiceItemReference,
  FollowOnDocumentType,
  StateCentralBankPaymentReason,
  SupplyingCountry,
  _SupplyingCountryText.CountryName AS SupplyingCountryName,
  InvoiceList,
  BillOfExchangeUsage,
  BillOfExchangePaymentRequest,
  BOEPaymentRequestFiscalYear,
  BOEPaymentRequestCompanyCode,
  AlternativePayeePayer,
  DunningKey,
  DunningBlockingReason,
  LastDunningDate,
  DunningLevel,
  DunningArea,
  _DunningAreaText.DunningAreaName AS DunningAreaName,
  WithholdingTaxCertificate,
  Product,
  _ProductText.ProductName AS ProductName,
  Plant,
  _Plant.PlantName AS PlantName,
  PurchasingDocument,
  PurchasingDocumentItem,
  AccountAssignmentNumber,
  LineItemIsCompleted,
  MaterialPriceControl,
  ValuationArea,
  InventoryValuationType,
  VATRegistration,
  VATRegistration AS VATRegistrationForFilter,
  DelivOfGoodsDestCountry,
  PaymentDifferenceReason,
  cast(_PaymentDifferenceReasonText.PaymentDifferenceReasonName as paymentdifferencereasonname preserving type) AS PaymentDifferenceReasonName,
  ProfitCenter,
  _ProfitCenterText.ProfitCenterName AS ProfitCenterName,
  JointVenture,
  JointVentureCostRecoveryCode,
  JointVentureEquityGroup,
  TreasuryContractType,
  AssetContract,
  CashFlowType,
  TaxJurisdiction,
  REInternalFinNumber,
  SettlementReferenceDate,
  CommitmentItemShortID,
  CostObject,
  ProjectNetwork,
  OrderInternalBillOfOperations,
  OrderIntBillOfOperationsItem,
  WBSElementExternalID,
  WBSElementInternalID,
  WBSDescription,
  ProfitabilitySegment,
  JointVentureEquityType,
  IsEUTriangularDeal,
  CostOriginGroup,
  CompanyCodeCurrencyDetnMethod,
  ClearingIsReversed,
  PaymentMethodSupplement,
  AlternativeGLAccount,
  PartnerProfitCenter,
  cast(_PartnerProfitCenterText.ProfitCenterName as fis_partner_prctr_short_name preserving type) AS PartnerProfitCenterName,
  Reference1IDByBusinessPartner,
  Reference2IDByBusinessPartner,
  IsNegativePosting,
  PaymentCardItem,
  PaymentCardPaymentSettlement,
  CreditControlArea,
  Reference3IDByBusinessPartner,
  DataExchangeInstruction1,
  DataExchangeInstruction2,
  DataExchangeInstruction3,
  DataExchangeInstruction4,
  Region,
  HasPaymentOrder,
  PaymentReference,
  TaxDeterminationDate,
  ClearingItem,
  BusinessPlace,
  TaxSection,
  CostCtrActivityType,
  _CostCtrActivityTypeT.CostCtrActivityTypeName AS CostCtrActivityTypeName,
  AccountsReceivableIsPledged,
  AcctsReceivablePledgingCode,
  BusinessProcess,
  FunctionalArea,
  _FunctionalAreaText.FunctionalAreaName AS FunctionalAreaName,
  CustomerIsInExecution,
  ClearingJournalEntryFiscalYear,
  LedgerGLLineItem,
  Segment,
  _SegmentText.SegmentName AS SegmentName,
  PartnerSegment,
  cast(_PartnerSegmentText.SegmentName as fis_partner_segment_name preserving type) AS PartnerSegmentName,
  PartnerFunctionalArea,
  cast(_PartnerFunctionalAreaText.FunctionalAreaName as fis_pfkbtx preserving type) AS PartnerFunctionalAreaName,
  HouseBankAccount,
  cast(_HouseBankAccountText.HouseBankAccountDescription as /pf1/dte_housebank_acct_desc preserving type) AS HouseBankAccountDescription,
  CostElement,
  PaymentServiceProvider,
  PaymentRefByPaytSrvcProvider,
  SEPAMandate,
  ReferenceDocumentType,
  OriginalReferenceDocument,
  ReferenceDocumentLogicalSystem,
  AccountingDocumentItemRef,
  FiscalPeriod,
  AccountingDocumentCategory,
  PostingDate,
  DocumentDate,
  AccountingDocumentType,
  NetDueDate,
  CashDiscount1DueDate,
  CashDiscount2DueDate,
  OffsettingAccount,
  OffsettingAccountType,
  OffsettingChartOfAccounts,
  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,
  CompanyCodeCurrency,
  AmountInCompanyCodeCurrency,
  CreditAmountInCoCodeCrcy,
  DebitAmountInCoCodeCrcy,
  FunctionalCurrency,
  AmountInFunctionalCurrency,
  CreditAmountInFunctionalCrcy,
  DebitAmountInFunctionalCrcy,
  TransactionCurrency,
  AmountInTransactionCurrency,
  CreditAmountInTransCrcy,
  DebitAmountInTransCrcy,
  BalanceTransactionCurrency,
  CreditAmountInBalanceTransCrcy,
  DebitAmountInBalanceTransCrcy,
  AdditionalCurrency1,
  CreditAmountInAddlCrcy1,
  DebitAmountInAddlCrcy1,
  AdditionalCurrency2,
  CreditAmountInAddlCrcy2,
  DebitAmountInAddlCrcy2,
  BaseUnit,
  Quantity,
  AbsoluteQuantity,
  GoodsMovementEntryUnit,
  QuantityInEntryUnit,
  PurchasingDocumentPriceUnit,
  PurchaseOrderQty,
  MaterialPriceUnitQty,
  EarmarkedFundsDocument,
  EarmarkedFundsDocumentItem,
  PaytSlipWthRefReference,
  TaxRateValidityStartDate,
  PaytSlipWthRefCheckDigit,
  PaytSlipWthRefSubscriber,
  PaymentReason,
  BranchCode,
  PaymentCurrency,
  AmountInPaymentCurrency,
  NetPaymentAmount,
  TaxBaseAmountInCoCodeCrcy,
  TaxBaseAmountInTransCrcy,
  WithholdingTaxAmount,
  WithholdingTaxExemptionAmt,
  WithholdingTaxBaseAmount,
  TaxCountry,
  cast(_TaxCountryText.CountryName as fot_tax_country_descr preserving type) AS TaxCountryName,
  AddressAndBankIsSetManually,
  IsOneTimeAccount,
  AlternativePayeeIsAllowed,
  AddressIsChangedManually,
  cast( _Customer.AlternativePayeeIsAllowed as farp_isalternativepayer preserving type ) AS PayerIsAlternativePayer,
  cast( _Supplier.AlternativePayeeIsAllowed as farp_isalternativepayee preserving type ) AS PayeeIsAlternativePayee,
  OplAcctgDocItmCntrySpcfcRef1,
  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,
  FinancialServicesProductGroup,
  _FinServicesProductGroupT.FinServicesProductGroupName AS FinServicesProductGroupName,
  FinancialServicesBranch,
  _FinancialServicesBranchT.FinancialServicesBranchName AS FinancialServicesBranchName,
  FinancialDataSource,
  _FinancialDataSourceT.FinancialDataSourceName AS FinancialDataSourceName,
  CashDiscountAmtInCoCodeCrcy,
  AccountingDocumentItemType,
  DeliveryOfGoodsReportingCntry,
  RecrrgSuplrInvcIsSrvcInvoice,
  SuplrInvcIsCapitalGoodsRelated,
  AcctgDocItmCustomsTariffNumber,
  AcctgDocItmCstmsClearanceDate,
  ClearingIsLedgerGroupSpecific,
  InvcItmIsExcldFrmPromptPaytAct,
  InterestCalculationBlockReason,
  BillingPeriodOfPerfStartDate,
  BillingPeriodOfPerfEndDate,
  AssetClass,
  virtual UICT_CreditAmount : abap.char(1) AS char1
FROM R_ManageJournalEntryItemTP
LEFT OUTER JOIN C_MngJrnlEntrWhgdTaxItem AS _WithholdingTaxItem ON CompanyCode = _WithholdingTaxItem.CompanyCode AND AccountingDocument = _WithholdingTaxItem.AccountingDocument AND FiscalYear = _WithholdingTaxItem.FiscalYear AND AccountingDocumentItem = _WithholdingTaxItem.AccountingDocumentItem  -- association [0..*]
LEFT OUTER JOIN C_ManageJournalEntryNote AS _Note ON CompanyCode = _Note.CompanyCode AND AccountingDocument = _Note.AccountingDocument AND FiscalYear = _Note.FiscalYear AND AccountingDocumentItem = _Note.AccountingDocumentItem  -- association [0..*]
;