C_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 C_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 C_MngJrnlEntrPrkdDocumentItem AS
SELECT
  SourceCompanyCode,
  SourceAccountingDocument,
  SourceFiscalYear,
  ParkedAccountingDocumentItem,
  SourceCompanyCodeName,
  AmountInCompanyCodeCurrency,
  CompanyCodeCurrency,
  GLAccount,
  GLAccountName,
  _ParkedItem.CreditAmountInCoCodeCrcy AS CreditAmountInCoCodeCrcy,
  _ParkedItem.DebitAmountInCoCodeCrcy AS DebitAmountInCoCodeCrcy,
  _ParkedItem.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  _ParkedItem.CreditAmountInTransCrcy AS CreditAmountInTransCrcy,
  _ParkedItem.DebitAmountInTransCrcy AS DebitAmountInTransCrcy,
  _ParkedItem.TransactionCurrency AS TransactionCurrency,
  _ParkedItem.DebitCreditCode AS DebitCreditCode,
  _ParkedItem.CompanyCode AS CompanyCode,
  _ParkedItem._CompanyCode.CompanyCodeName AS CompanyCodeName,
  _ParkedItem.WithholdingTaxAmount AS WithholdingTaxAmount,
  _ParkedItem.WithholdingTaxBaseAmount AS WithholdingTaxBaseAmount,
  _ParkedItem.WithholdingTaxExemptionAmt AS WithholdingTaxExemptionAmt,
  _ParkedItem.Supplier AS Supplier,
  _ParkedItem._Supplier.SupplierName AS SupplierName,
  _ParkedItem.FixedCashDiscount AS FixedCashDiscount,
  _ParkedItem.Customer AS Customer,
  _ParkedItem._Customer.CustomerName AS CustomerName,
  Customer AS CustomerForFilter,
  _Customer.CustomerName AS CustomerNameForFilter,
  _ParkedItem.SpecialGLCode AS SpecialGLCode,
  _ParkedItem._SpecialGLCodeText.SpecialGLCodeName AS SpecialGLCodeName,
  _ParkedItem.SpecialGLTransactionType AS SpecialGLTransactionType,
  _ParkedItem.TaxCountry AS TaxCountry,
  _ParkedItem._TaxCountryText.CountryName AS TaxCountryName,
  _ParkedItem.FinancialTransactionType AS FinancialTransactionType,
  _ParkedItem._FinancialTransactionTypeT.FinancialTransactionTypeName AS FinancialTransactionTypeName,
  _ParkedItem.ChartOfAccounts AS ChartOfAccounts,
  _ParkedItem.BranchAccount AS BranchAccount,
  _ParkedItem.PaymentTerms AS PaymentTerms,
  _ParkedItem._PaymentTermsText.PaymentTermsName AS PaymentTermsName,
  _ParkedItem.CashDiscount1Days AS CashDiscount1Days,
  _ParkedItem.CashDiscount2Days AS CashDiscount2Days,
  _ParkedItem.NetPaymentDays AS NetPaymentDays,
  _ParkedItem.CashDiscount1Percent AS CashDiscount1Percent,
  _ParkedItem.CashDiscount2Percent AS CashDiscount2Percent,
  _ParkedItem.PaymentMethod AS PaymentMethod,
  _ParkedItem.PaymentBlockingReason AS PaymentBlockingReason,
  _ParkedItem._PaymentBlockingReasonText.PaymentBlockingReasonName AS PaymentBlockingReasonName,
  _ParkedItem.InvoiceReference AS InvoiceReference,
  _ParkedItem.InvoiceReferenceFiscalYear AS InvoiceReferenceFiscalYear,
  _ParkedItem.InvoiceItemReference AS InvoiceItemReference,
  _ParkedItem.FollowOnDocumentType AS FollowOnDocumentType,
  _ParkedItem.InvoiceList AS InvoiceList,
  _ParkedItem.DunningKey AS DunningKey,
  _ParkedItem.DunningBlockingReason AS DunningBlockingReason,
  _ParkedItem.LastDunningDate AS LastDunningDate,
  _ParkedItem.DunningLevel AS DunningLevel,
  _ParkedItem.DunningArea AS DunningArea,
  _ParkedItem._DunningAreaText.DunningAreaName AS DunningAreaName,
  _ParkedItem.CreditControlArea AS CreditControlArea,
  _ParkedItem.DataExchangeInstruction1 AS DataExchangeInstruction1,
  _ParkedItem.DataExchangeInstruction2 AS DataExchangeInstruction2,
  _ParkedItem.DataExchangeInstruction3 AS DataExchangeInstruction3,
  _ParkedItem.DataExchangeInstruction4 AS DataExchangeInstruction4,
  _ParkedItem.AlternativePayeePayer AS AlternativePayeePayer,
  _ParkedItem.PaymentReference AS PaymentReference,
  _ParkedItem.TaxSection AS TaxSection,
  _ParkedItem.CashDiscount1DueDate AS CashDiscount1DueDate,
  _ParkedItem.CashDiscount2DueDate AS CashDiscount2DueDate,
  _ParkedItem.BranchCode AS BranchCode,
  _ParkedItem.BPBankAccountInternalID AS BPBankAccountInternalID,
  _ParkedItem.PaymentCurrency AS PaymentCurrency,
  _ParkedItem.TaxAmountInCoCodeCrcy AS TaxAmountInCoCodeCrcy,
  _ParkedItem.TaxAmount AS TaxAmount,
  _ParkedItem.TaxAmountInAdditionalCurrency1 AS TaxAmountInAdditionalCurrency1,
  _ParkedItem.TaxAmountInAdditionalCurrency2 AS TaxAmountInAdditionalCurrency2,
  _ParkedItem.AmountInPaymentCurrency AS AmountInPaymentCurrency,
  _ParkedItem.CashDiscountBaseAmount AS CashDiscountBaseAmount,
  _ParkedItem.CashDiscountAmtInCoCodeCrcy AS CashDiscountAmtInCoCodeCrcy,
  _ParkedItem.CashDiscountAmount AS CashDiscountAmount,
  _ParkedItem.AccountingDocumentType AS AccountingDocumentType,
  _ParkedItem.ControllingArea AS ControllingArea,
  _ParkedItem._ControllingArea.ControllingAreaName AS ControllingAreaName,
  _ParkedItem.PostingKey AS PostingKey,
  _ParkedItem._PostingKeyText.PostingKeyName AS PostingKeyName,
  _ParkedItem.FinancialAccountType AS FinancialAccountType,
  _ParkedItem.BusinessArea AS BusinessArea,
  _ParkedItem._BusinessAreaText.BusinessAreaName AS BusinessAreaName,
  _ParkedItem.PartnerBusinessArea AS PartnerBusinessArea,
  _ParkedItem._PartnerBusinessAreaText.BusinessAreaName AS PartnerBusinessAreaName,
  _ParkedItem.TaxCode AS TaxCode,
  _ParkedItem.TaxType AS TaxType,
  _ParkedItem.ValueDate AS ValueDate,
  _ParkedItem.AssignmentReference AS AssignmentReference,
  _ParkedItem.DocumentItemText AS DocumentItemText,
  _ParkedItem.PartnerCompany AS PartnerCompany,
  _ParkedItem._PartnerCompany.CompanyName AS PartnerCompanyName,
  _ParkedItem.PlanningLevel AS PlanningLevel,
  _ParkedItem.CostCenter AS CostCenter,
  _ParkedItem._CostCenterText.CostCenterName AS CostCenterName,
  _ParkedItem.OrderID AS OrderID,
  _ParkedItem.MasterFixedAsset AS MasterFixedAsset,
  _ParkedItem._MasterFixedAsset.MasterFixedAssetDescription AS MasterFixedAssetDescription,
  _ParkedItem.FixedAsset AS FixedAsset,
  _ParkedItem.FixedAssetExternalID AS FixedAssetExternalID,
  _ParkedItem.AssetTransactionType AS AssetTransactionType,
  _ParkedItem._AssetTransactionTypeText.AssetTransactionTypeName AS AssetTransactionTypeName,
  _ParkedItem.PersonnelNumber AS PersonnelNumber,
  _ParkedItem.IsSalesRelated AS IsSalesRelated,
  _ParkedItem.SpecialGLAccountAssignment AS SpecialGLAccountAssignment,
  _ParkedItem.DueCalculationBaseDate AS DueCalculationBaseDate,
  _ParkedItem.SupplyingCountry AS SupplyingCountry,
  _ParkedItem.Product AS Product,
  _ParkedItem._ProductText.ProductName AS ProductName,
  _ParkedItem.Plant AS Plant,
  _ParkedItem._Plant.PlantName AS PlantName,
  _ParkedItem.PurchasingDocument AS PurchasingDocument,
  _ParkedItem.PurchasingDocumentItem AS PurchasingDocumentItem,
  _ParkedItem.AccountAssignmentNumber AS AccountAssignmentNumber,
  _ParkedItem.MaterialPriceControl AS MaterialPriceControl,
  _ParkedItem.MaterialPriceUnitQty AS MaterialPriceUnitQty,
  _ParkedItem.ValuationArea AS ValuationArea,
  _ParkedItem.InventoryValuationType AS InventoryValuationType,
  _ParkedItem.VATRegistration AS VATRegistration,
  _ParkedItem.VATRegistration AS VATRegistrationForFilter,
  _ParkedItem.PaymentDifferenceReason AS PaymentDifferenceReason,
  _ParkedItem._PaymentDifferenceReasonText.PaymentDifferenceReasonName AS PaymentDifferenceReasonName,
  _ParkedItem.ProfitCenter AS ProfitCenter,
  _ParkedItem._ProfitCenterText.ProfitCenterName AS ProfitCenterName,
  _ParkedItem.JointVenture AS JointVenture,
  _ParkedItem.JointVentureCostRecoveryCode AS JointVentureCostRecoveryCode,
  _ParkedItem.JointVentureEquityGroup AS JointVentureEquityGroup,
  _ParkedItem.TreasuryContractType AS TreasuryContractType,
  _ParkedItem.AssetContract AS AssetContract,
  _ParkedItem.CashFlowType AS CashFlowType,
  _ParkedItem.TaxJurisdiction AS TaxJurisdiction,
  _ParkedItem.REInternalFinNumber AS REInternalFinNumber,
  _ParkedItem.SettlementReferenceDate AS SettlementReferenceDate,
  _ParkedItem.CommitmentItemShortID AS CommitmentItemShortID,
  _ParkedItem.CostObject AS CostObject,
  _ParkedItem.ProjectNetwork AS ProjectNetwork,
  _ParkedItem.ProfitabilitySegment AS ProfitabilitySegment,
  _ParkedItem.JointVentureEquityType AS JointVentureEquityType,
  _ParkedItem.CostOriginGroup AS CostOriginGroup,
  _ParkedItem.PaymentMethodSupplement AS PaymentMethodSupplement,
  _ParkedItem.FundsCenter AS FundsCenter,
  _ParkedItem.Fund AS Fund,
  _ParkedItem._FundText.FundName AS FundName,
  _ParkedItem.Reference1IDByBusinessPartner AS Reference1IDByBusinessPartner,
  _ParkedItem.Reference2IDByBusinessPartner AS Reference2IDByBusinessPartner,
  _ParkedItem.IsNegativePosting AS IsNegativePosting,
  _ParkedItem.PaymentCardPaymentSettlement AS PaymentCardPaymentSettlement,
  _ParkedItem.Reference3IDByBusinessPartner AS Reference3IDByBusinessPartner,
  _ParkedItem.Region AS Region,
  _ParkedItem.BusinessPlace AS BusinessPlace,
  _ParkedItem.CostCtrActivityType AS CostCtrActivityType,
  _ParkedItem._CostCtrActivityTypeT.CostCtrActivityTypeName AS CostCtrActivityTypeName,
  _ParkedItem.WBSElementExternalID AS WBSElementExternalID,
  _ParkedItem.WBSElementInternalID AS WBSElementInternalID,
  _ParkedItem.WBSDescription AS WBSDescription,
  _ParkedItem.GrantID AS GrantID,
  _ParkedItem._GrantText.GrantName AS GrantName,
  _ParkedItem.Segment AS Segment,
  _ParkedItem._SegmentText.SegmentName AS SegmentName,
  _ParkedItem.PartnerSegment AS PartnerSegment,
  _ParkedItem._PartnerSegmentText.SegmentName AS PartnerSegmentName,
  _ParkedItem.NetDueDate AS NetDueDate,
  _ParkedItem.PartnerFund AS PartnerFund,
  _ParkedItem._PartnerFundText.FundName AS ReceiverPostedFundName,
  _ParkedItem.PartnerGrant AS PartnerGrant,
  _ParkedItem._PartnerGrantText.GrantName AS ReceiverPostedGrantName,
  _ParkedItem.BudgetPeriod AS BudgetPeriod,
  _ParkedItem._BudgetPeriodText.BudgetPeriodName AS BudgetPeriodName,
  _ParkedItem.PartnerBudgetPeriod AS PartnerBudgetPeriod,
  _ParkedItem._PartnerBudgetPeriodText.BudgetPeriodName AS ReceiverPostedBudgetPeriodName,
  _ParkedItem.HouseBank AS HouseBank,
  _ParkedItem._HouseBank._Bank.BankName AS HouseBankName,
  _ParkedItem.HouseBankAccount AS HouseBankAccount,
  _ParkedItem._HouseBankAccountText.HouseBankAccountDescription AS HouseBankAccountDescription,
  _ParkedItem.AdditionalCurrency1 AS AdditionalCurrency1,
  _ParkedItem.AdditionalCurrency2 AS AdditionalCurrency2,
  _ParkedItem.AmountInAdditionalCurrency1 AS AmountInAdditionalCurrency1,
  _ParkedItem.CreditAmountInAddlCrcy1 AS CreditAmountInAddlCrcy1,
  _ParkedItem.DebitAmountInAddlCrcy1 AS DebitAmountInAddlCrcy1,
  _ParkedItem.AmountInAdditionalCurrency2 AS AmountInAdditionalCurrency2,
  _ParkedItem.CreditAmountInAddlCrcy2 AS CreditAmountInAddlCrcy2,
  _ParkedItem.DebitAmountInAddlCrcy2 AS DebitAmountInAddlCrcy2,
  _ParkedItem.TaxBaseAmountInCoCodeCrcy AS TaxBaseAmountInCoCodeCrcy,
  _ParkedItem.TaxBaseAmountInTransCrcy AS TaxBaseAmountInTransCrcy,
  _ParkedItem.InvoiceAmtInCoCodeCrcy AS InvoiceAmtInCoCodeCrcy,
  _ParkedItem.PlannedAmtInTransactionCrcy AS PlannedAmtInTransactionCrcy,
  _ParkedItem.InvoiceAmountInFrgnCurrency AS InvoiceAmountInFrgnCurrency,
  _ParkedItem.BaseUnit AS BaseUnit
FROM R_MngJrnlEntrPrkdDocumentItem AS _ParkedItem
LEFT OUTER JOIN C_MngJrnlEntrWhgdTaxItem AS _WithholdingTaxItem ON SourceCompanyCode = _WithholdingTaxItem.CompanyCode AND SourceAccountingDocument = _WithholdingTaxItem.AccountingDocument AND SourceFiscalYear = _WithholdingTaxItem.FiscalYear AND ParkedAccountingDocumentItem = _WithholdingTaxItem.AccountingDocumentItem  -- association [0..*]
LEFT OUTER JOIN C_ManageJournalEntryNote AS _Note ON SourceCompanyCode = _Note.CompanyCode AND SourceAccountingDocument = _Note.AccountingDocument AND SourceFiscalYear = _Note.FiscalYear AND ParkedAccountingDocumentItem = _Note.AccountingDocumentItem  -- association [0..*]
;