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,
  FixedAssetExternalID,
  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,
  _HouseBank._Bank.BankName 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,
  _PaymentDifferenceReasonText.PaymentDifferenceReasonName 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,
  _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,
  _TaxCountryText.CountryName 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,
  _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
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..*]
;