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,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  ChartOfAccounts,
  ClearingDate,
  ClearingCreationDate,
  ClearingJournalEntry,
  PostingKey,
  _PostingKeyText.PostingKeyName AS PostingKeyName,
  FinancialAccountType,
  SpecialGLCode,
  _SpecialGLCodeText.SpecialGLCodeName AS SpecialGLCodeName,
  SpecialGLTransactionType,
  DebitCreditCode,
  BusinessArea,
  _BusinessAreaText.BusinessAreaName AS BusinessAreaName,
  PartnerBusinessArea,
  _PartnerBusinessAreaText.BusinessAreaName AS PartnerBusinessAreaName,
  TaxCode,
  WithholdingTaxCode,
  TaxType,
  TransactionTypeDetermination,
  ValueDate,
  AssignmentReference,
  DocumentItemText,
  PartnerCompany,
  _PartnerCompany.CompanyName AS PartnerCompanyName,
  FinancialTransactionType,
  _FinancialTransactionTypeT.FinancialTransactionTypeName 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,
  _FixedAsset.FixedAssetDescription AS FixedAssetDescription,
  AssetTransactionType,
  _AssetTransactionTypeText.AssetTransactionTypeName AS AssetTransactionTypeName,
  AssetValueDate,
  PersonnelNumber,
  IsSalesRelated,
  LineItemDisplayIsEnabled,
  IsOpenItemManaged,
  IsNotCashDiscountLiable,
  IsAutomaticallyCreated,
  IsUsedInPaymentTransaction,
  OperationalGLAccount,
  GLAccount,
  _GLAccountText.GLAccountName AS GLAccountName,
  Customer,
  _Customer.CustomerName AS CustomerName,
  Customer AS CustomerForFilter,
  _Customer.CustomerName AS CustomerNameForFilter,
  Supplier,
  _Supplier.SupplierName AS SupplierName,
  BranchAccount,
  IsBalanceSheetAccount,
  ProfitLossAccountType,
  SpecialGLAccountAssignment,
  DueCalculationBaseDate,
  PaymentTerms,
  _PaymentTermsText.PaymentTermsName AS PaymentTermsName,
  CashDiscountBaseAmount,
  CashDiscountAmount,
  CashDiscount1Days,
  CashDiscount2Days,
  NetPaymentDays,
  CashDiscount1Percent,
  CashDiscount2Percent,
  PaymentMethod,
  PaymentBlockingReason,
  _PaymentBlockingReasonText.PaymentBlockingReasonName AS PaymentBlockingReasonName,
  FixedCashDiscount,
  _FixedCashDiscountTypeText.UtilsDiscountTypeDescription AS UtilsDiscountTypeDescription,
  HouseBank,
  _HouseBankText.HouseBankName AS HouseBankName,
  BPBankAccountInternalID,
  TaxDistributionCode1,
  TaxDistributionCode2,
  TaxDistributionCode3,
  InvoiceReference,
  InvoiceReferenceFiscalYear,
  InvoiceItemReference,
  FollowOnDocumentType,
  StateCentralBankPaymentReason,
  SupplyingCountry,
  _SupplyingCountryText.CountryName AS SupplyingCountryName,
  InvoiceList,
  BillOfExchangeUsage,
  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,
  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,
  _PartnerProfitCenterText.ProfitCenterName 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,
  _PartnerSegmentText.SegmentName AS PartnerSegmentName,
  PartnerFunctionalArea,
  _PartnerFunctionalAreaText.FunctionalAreaName AS PartnerFunctionalAreaName,
  HouseBankAccount,
  _HouseBankAccountText.HouseBankAccountDescription AS HouseBankAccountDescription,
  CostElement,
  PaymentServiceProvider,
  PaymentRefByPaytSrvcProvider,
  SEPAMandate,
  ReferenceDocumentType,
  OriginalReferenceDocument,
  ReferenceDocumentLogicalSystem,
  AccountingDocumentItemRef,
  FiscalPeriod,
  AccountingDocumentCategory,
  PostingDate,
  DocumentDate,
  AccountingDocumentType,
  NetDueDate,
  CashDiscount1DueDate,
  CashDiscount2DueDate,
  OffsettingAccount,
  OffsettingAccountType,
  OffsettingChartOfAccounts,
  CashLedgerCompanyCode,
  _CashLedgerCompanyCode.CompanyCodeName AS CashLedgerCompanyCodeName,
  CashLedgerAccount,
  _CashLedgerAccountText.GLAccountName AS CashLedgerAccountName,
  FinancialManagementArea,
  FundsCenter,
  FundedProgram,
  Fund,
  _FundText.FundName AS FundName,
  GrantID,
  _GrantText.GrantName AS GrantName,
  BudgetPeriod,
  _BudgetPeriodText.BudgetPeriodName AS BudgetPeriodName,
  PartnerFund,
  _PartnerFundText.FundName AS ReceiverPostedFundName,
  PartnerGrant,
  _PartnerGrantText.GrantName AS ReceiverPostedGrantName,
  PartnerBudgetPeriod,
  _PartnerBudgetPeriodText.BudgetPeriodName 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,
  AddressAndBankIsSetManually,
  IsOneTimeAccount,
  AlternativePayeeIsAllowed,
  AddressIsChangedManually,
  PayerIsAlternativePayer,
  PayeeIsAlternativePayee,
  OplAcctgDocItmCntrySpcfcRef1,
  CustomerGroup,
  _CustomerGroupText.CustomerGroupName AS CustomerGroupName,
  CustomerSupplierCountry,
  _CustomerSupplierCountryText.CountryName 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,
  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..*]
;