R_MngJrnlEntrPrkdDocumentItem

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_MngJrnlEntrPrkdDocumentItem.
-- 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_MngJrnlEntrPrkdDocumentItem AS
SELECT
  SourceCompanyCode,
  SourceAccountingDocument,
  SourceFiscalYear,
  SourceAccountingDocumentItem AS ParkedAccountingDocumentItem,
  _SourceCompanyCode.CompanyCodeName AS SourceCompanyCodeName,
  AmountInCompanyCodeCurrency,
  CreditAmountInCoCodeCrcy,
  DebitAmountInCoCodeCrcy,
  CompanyCodeCurrency,
  AmountInTransactionCurrency,
  CreditAmountInTransCrcy,
  DebitAmountInTransCrcy,
  TransactionCurrency,
  GLAccount,
  _GLAccountText.GLAccountName AS GLAccountName,
  DebitCreditCode,
  SourceAccountingDocumentItem,
  CompanyCode,
  abs( WithholdingTaxAmount ) AS WithholdingTaxAmount,
  abs( WithholdingTaxBaseAmount ) AS WithholdingTaxBaseAmount,
  abs( WithholdingTaxExemptionAmt ) AS WithholdingTaxExemptionAmt,
  Supplier,
  FixedCashDiscount,
  Customer,
  SpecialGLCode,
  SpecialGLTransactionType,
  TaxCountry,
  FinancialTransactionType,
  _CompanyCode.ChartOfAccounts AS ChartOfAccounts,
  BranchAccount,
  PaymentTerms,
  CashDiscount1Days,
  CashDiscount2Days,
  NetPaymentDays,
  CashDiscount1Percent,
  CashDiscount2Percent,
  PaymentMethod,
  PaymentBlockingReason,
  InvoiceReference,
  InvoiceReferenceFiscalYear,
  InvoiceItemReference,
  FollowOnDocumentType,
  InvoiceList,
  DunningKey,
  DunningBlockingReason,
  LastDunningDate,
  DunningLevel,
  DunningArea,
  CreditControlArea,
  DataExchangeInstruction1,
  DataExchangeInstruction2,
  DataExchangeInstruction3,
  DataExchangeInstruction4,
  AlternativePayeePayer,
  PaymentReference,
  TaxSection,
  CashDiscount1DueDate,
  CashDiscount2DueDate,
  BranchCode,
  BPBankAccountInternalID,
  PaymentCurrency,
  abs( TaxAmountInCoCodeCrcy ) AS TaxAmountInCoCodeCrcy,
  abs( TaxAmount ) AS TaxAmount,
  TaxAmountInAdditionalCurrency1,
  TaxAmountInAdditionalCurrency2,
  abs( AmountInPaymentCurrency ) AS AmountInPaymentCurrency,
  abs( CashDiscountBaseAmount ) AS CashDiscountBaseAmount,
  abs( CashDiscountAmtInCoCodeCrcy ) AS CashDiscountAmtInCoCodeCrcy,
  abs( CashDiscountAmount ) AS CashDiscountAmount,
  AccountingDocumentType,
  ControllingArea,
  PostingKey,
  FinancialAccountType,
  BusinessArea,
  PartnerBusinessArea,
  TaxCode,
  TaxType,
  ValueDate,
  AssignmentReference,
  DocumentItemText,
  PartnerCompany,
  PlanningLevel,
  CostCenter,
  OrderID,
  MasterFixedAsset,
  FixedAsset,
  AssetTransactionType,
  PersonnelNumber,
  IsSalesRelated,
  SpecialGLAccountAssignment,
  DueCalculationBaseDate,
  SupplyingCountry,
  Product,
  Plant,
  PurchasingDocument,
  PurchasingDocumentItem,
  AccountAssignmentNumber,
  MaterialPriceControl,
  MaterialPriceUnitQty,
  ValuationArea,
  InventoryValuationType,
  VATRegistration,
  PaymentDifferenceReason,
  ProfitCenter,
  JointVenture,
  JointVentureCostRecoveryCode,
  JointVentureEquityGroup,
  TreasuryContractType,
  AssetContract,
  CashFlowType,
  TaxJurisdiction,
  REInternalFinNumber,
  SettlementReferenceDate,
  CommitmentItemShortID,
  CostObject,
  ProjectNetwork,
  ProfitabilitySegment,
  JointVentureEquityType,
  CostOriginGroup,
  PaymentMethodSupplement,
  FundsCenter,
  Fund,
  _CompanyCode.FinancialManagementArea AS FinancialManagementArea,
  Reference1IDByBusinessPartner,
  Reference2IDByBusinessPartner,
  IsNegativePosting,
  PaymentCardPaymentSettlement,
  Reference3IDByBusinessPartner,
  Region,
  BusinessPlace,
  CostCtrActivityType,
  WBSElementInternalID,
  _WBSElementBasicData.WBSElementExternalID AS WBSElementExternalID,
  _WBSElementBasicData.WBSDescription AS WBSDescription,
  GrantID,
  Segment,
  PartnerSegment,
  NetDueDate,
  PartnerFund,
  PartnerGrant,
  BudgetPeriod,
  PartnerBudgetPeriod,
  HouseBank,
  HouseBankAccount,
  AdditionalCurrency1,
  AdditionalCurrency2,
  abs( AmountInAdditionalCurrency1 ) AS AmountInAdditionalCurrency1,
  CreditAmountInAddlCrcy1,
  DebitAmountInAddlCrcy1,
  AmountInAdditionalCurrency2,
  CreditAmountInAddlCrcy2,
  DebitAmountInAddlCrcy2,
  abs( TaxBaseAmountInCoCodeCrcy ) AS TaxBaseAmountInCoCodeCrcy,
  abs( TaxBaseAmountInTransCrcy ) AS TaxBaseAmountInTransCrcy,
  InvoiceAmtInCoCodeCrcy,
  PlannedAmtInTransactionCrcy,
  InvoiceAmountInFrgnCurrency,
  BaseUnit,
  Quantity,
  AssetValueDate,
  CompanyCodeCurrencyDetnMethod,
  FunctionalArea,
  FundedProgram,
  StateCentralBankPaymentReason,
  OrderInternalBillOfOperations,
  IsEUTriangularDeal,
  IsNotCashDiscountLiable,
  DatabaseTable
FROM P_MngJrnlEntrPrkdDocumentItem AS _ParkedItem
LEFT OUTER JOIN I_GlAccountTextInCompanycode AS _GLAccountText ON _ParkedItem.SourceCompanyCode = _GLAccountText.CompanyCode AND _ParkedItem.GLAccount = _GLAccountText.GLAccount AND _GLAccountText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _SourceCompanyCode ON SourceCompanyCode = _SourceCompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_FinancialTransactionTypeT AS _FinancialTransactionTypeT ON FinancialTransactionType = _FinancialTransactionTypeT.FinancialTransactionType AND _FinancialTransactionTypeT.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CostCenterText AS _CostCenterText ON ControllingArea = _CostCenterText.ControllingArea AND CostCenter = _CostCenterText.CostCenter AND _CostCenterText.ValidityStartDate <= $session.system_date AND _CostCenterText.ValidityEndDate >= $session.system_date AND _CostCenterText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ProfitCenterText AS _ProfitCenterText ON ControllingArea = _ProfitCenterText.ControllingArea AND ProfitCenter = _ProfitCenterText.ProfitCenter AND _ProfitCenterText.ValidityStartDate <= $session.system_date AND _ProfitCenterText.ValidityEndDate >= $session.system_date AND _ProfitCenterText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_FunctionalAreaText AS _FunctionalAreaText ON FunctionalArea = _FunctionalAreaText.FunctionalArea AND _FunctionalAreaText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_BusinessAreaText AS _BusinessAreaText ON BusinessArea = _BusinessAreaText.BusinessArea AND _BusinessAreaText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_BusinessAreaText AS _PartnerBusinessAreaText ON PartnerBusinessArea = _PartnerBusinessAreaText.BusinessArea AND _PartnerBusinessAreaText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SegmentText AS _SegmentText ON Segment = _SegmentText.Segment AND _SegmentText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SegmentText AS _PartnerSegmentText ON PartnerSegment = _PartnerSegmentText.Segment AND _PartnerSegmentText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_Partnercompany AS _PartnerCompany ON PartnerCompany = _PartnerCompany.PartnerCompany  -- association [0..1]
LEFT OUTER JOIN I_PostingKeyText AS _PostingKeyText ON PostingKey = _PostingKeyText.PostingKey AND _PostingKeyText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_SpecialGLCodeText AS _SpecialGLCodeText ON FinancialAccountType = _SpecialGLCodeText.FinancialAccountType AND SpecialGLCode = _SpecialGLCodeText.SpecialGLCode AND _SpecialGLCodeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_MasterFixedAsset AS _MasterFixedAsset ON CompanyCode = _MasterFixedAsset.CompanyCode AND MasterFixedAsset = _MasterFixedAsset.MasterFixedAsset  -- association [0..1]
LEFT OUTER JOIN I_FixedAsset AS _FixedAsset ON CompanyCode = _FixedAsset.CompanyCode AND MasterFixedAsset = _FixedAsset.MasterFixedAsset AND FixedAsset = _FixedAsset.FixedAsset  -- association [0..1]
LEFT OUTER JOIN I_AssetTransactionTypeText AS _AssetTransactionTypeText ON AssetTransactionType = _AssetTransactionTypeText.AssetTransactionType AND _AssetTransactionTypeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CostCenterActivityTypeText AS _CostCtrActivityTypeT ON ControllingArea = _CostCtrActivityTypeT.ControllingArea AND CostCtrActivityType = _CostCtrActivityTypeT.CostCtrActivityType AND _CostCtrActivityTypeT.ValidityStartDate <= $session.system_date AND _CostCtrActivityTypeT.ValidityEndDate >= $session.system_date AND _CostCtrActivityTypeT.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ProductText AS _ProductText ON Product = _ProductText.Product AND _ProductText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_FundText AS _FundText ON FinancialManagementArea = _FundText.FinancialManagementArea AND Fund = _FundText.Fund AND _FundText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_FundText AS _PartnerFundText ON FinancialManagementArea = _PartnerFundText.FinancialManagementArea AND PartnerFund = _PartnerFundText.Fund AND _PartnerFundText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_GrantText AS _GrantText ON GrantID = _GrantText.GrantID AND _GrantText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_BudgetPeriodText AS _BudgetPeriodText ON BudgetPeriod = _BudgetPeriodText.BudgetPeriod AND _BudgetPeriodText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_GrantText AS _PartnerGrantText ON PartnerGrant = _PartnerGrantText.GrantID AND _PartnerGrantText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_BudgetPeriodText AS _PartnerBudgetPeriodText ON PartnerBudgetPeriod = _PartnerBudgetPeriodText.BudgetPeriod AND _PartnerBudgetPeriodText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_PaymentTermsText AS _PaymentTermsText ON PaymentTerms = _PaymentTermsText.PaymentTerms AND _PaymentTermsText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_PaymentBlockingReasonText AS _PaymentBlockingReasonText ON PaymentBlockingReason = _PaymentBlockingReasonText.PaymentBlockingReason AND _PaymentBlockingReasonText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_DunningAreaText AS _DunningAreaText ON CompanyCode = _DunningAreaText.CompanyCode AND DunningArea = _DunningAreaText.DunningArea AND _DunningAreaText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ParkedOplAcctgDocument AS _ParkedOplAcctgDocument ON SourceCompanyCode = _ParkedOplAcctgDocument.SourceCompanyCode AND CompanyCode = _ParkedOplAcctgDocument.CompanyCode AND SourceAccountingDocument = _ParkedOplAcctgDocument.SourceAccountingDocument AND SourceFiscalYear = _ParkedOplAcctgDocument.SourceFiscalYear  -- association [0..1]
LEFT OUTER JOIN I_CustomerCompany AS _CustomerCompany ON Customer = _CustomerCompany.Customer AND CompanyCode = _CustomerCompany.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_SupplierCompany AS _SupplierCompany ON Supplier = _SupplierCompany.Supplier AND CompanyCode = _SupplierCompany.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_Order AS _Order ON OrderID = _Order.OrderID  -- association [0..1]
LEFT OUTER JOIN I_AccountingDocumentType AS _AccountingDocumentType ON AccountingDocumentType = _AccountingDocumentType.AccountingDocumentType  -- association [0..1]
LEFT OUTER JOIN I_CostCenter AS _CurrentCostCenter ON ControllingArea = _CurrentCostCenter.ControllingArea AND CostCenter = _CurrentCostCenter.CostCenter AND _CurrentCostCenter.ValidityStartDate <= $session.system_date AND _CurrentCostCenter.ValidityEndDate >= $session.system_date  -- association [0..1]
LEFT OUTER JOIN I_ProfitCenter AS _CurrentProfitCenter ON ControllingArea = _CurrentProfitCenter.ControllingArea AND ProfitCenter = _CurrentProfitCenter.ProfitCenter AND _CurrentProfitCenter.ValidityStartDate <= $session.system_date AND _CurrentProfitCenter.ValidityEndDate >= $session.system_date  -- association [0..1]
LEFT OUTER JOIN I_GLAccountInCompanyCode AS _GLAccountInCompanyCode ON SourceCompanyCode = _GLAccountInCompanyCode.CompanyCode AND GLAccount = _GLAccountInCompanyCode.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_Housebank AS _HouseBank ON HouseBank = _HouseBank.HouseBank AND CompanyCode = _HouseBank.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_HouseBankAccountText AS _HouseBankAccountText ON HouseBank = _HouseBankAccountText.HouseBank AND CompanyCode = _HouseBankAccountText.CompanyCode AND HouseBankAccount = _HouseBankAccountText.HouseBankAccount AND _HouseBankAccountText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CountryText AS _TaxCountryText ON TaxCountry = _TaxCountryText.Country AND _TaxCountryText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementBasicData ON WBSElementInternalID = _WBSElementBasicData.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_PaymentDifferenceReasonT AS _PaymentDifferenceReasonText ON CompanyCode = _PaymentDifferenceReasonText.CompanyCode AND PaymentDifferenceReason = _PaymentDifferenceReasonText.PaymentDifferenceReason AND _PaymentDifferenceReasonText.Language = $session.system_language  -- association [0..1]
;