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,
  cast(SourceCompanyCodeName as srccompanycodename preserving type) AS SourceCompanyCodeName,
  AmountInCompanyCodeCurrency,
  CompanyCodeCurrency,
  GLAccount,
  GLAccountName,
  _GLAccountText.GLAccountLongName AS GLAccountLongName,
  _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,
  cast(_ParkedItem._CompanyCode.CompanyCodeName as fis_butxt preserving type) 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,
  cast(_SpecialGLCodeText.SpecialGLCodeLongName as specialglcodelongname preserving type) AS SpecialGLCodeName,
  _ParkedItem.SpecialGLTransactionType AS SpecialGLTransactionType,
  _ParkedItem.TaxCountry AS TaxCountry,
  cast(_TaxCountryText.CountryName as fot_tax_country_descr preserving type) AS TaxCountryName,
  _ParkedItem.FinancialTransactionType AS FinancialTransactionType,
  cast(_ParkedItem._FinancialTransactionTypeT.FinancialTransactionTypeName as fincs_fintransactiontypename preserving type) AS FinancialTransactionTypeName,
  _ParkedItem.ChartOfAccounts AS ChartOfAccounts,
  _ParkedItem.BranchAccount AS BranchAccount,
  _ParkedItem.PaymentTerms AS PaymentTerms,
  cast(_ParkedItem._PaymentTermsText.PaymentTermsName as paymenttermsname preserving type) 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,
  cast(_ParkedItem._PartnerBusinessAreaText.BusinessAreaName as fis_partner_gtext_vdm preserving type) 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,
  cast(_ParkedItem._PartnerCompany.CompanyName as fis_rassc_name preserving type) 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,
  cast(_ParkedItem._AssetTransactionTypeText.AssetTransactionTypeName as assettransactiontypename preserving type) AS AssetTransactionTypeName,
  _ParkedItem.PersonnelNumber AS PersonnelNumber,
  _ParkedItem._WorkForcePersonMappings.WorkAssignmentExternalID AS WorkAssignmentExternalID,
  _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,
  cast(_ParkedItem._PaymentDifferenceReasonText.PaymentDifferenceReasonName as paymentdifferencereasonname preserving type) 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,
  cast(_ParkedItem._GrantText.GrantName as fco_grant_name preserving type) AS GrantName,
  _ParkedItem.Segment AS Segment,
  _ParkedItem._SegmentText.SegmentName AS SegmentName,
  _ParkedItem.PartnerSegment AS PartnerSegment,
  cast(_ParkedItem._PartnerSegmentText.SegmentName as fis_partner_segment_name preserving type) AS PartnerSegmentName,
  _ParkedItem.NetDueDate AS NetDueDate,
  _ParkedItem.PartnerFund AS PartnerFund,
  cast(_ParkedItem._PartnerFundText.FundName as receiverpostedfundname preserving type) AS ReceiverPostedFundName,
  _ParkedItem.PartnerGrant AS PartnerGrant,
  cast(_ParkedItem._PartnerGrantText.GrantName as receiverpostedgrantname preserving type) AS ReceiverPostedGrantName,
  _ParkedItem.BudgetPeriod AS BudgetPeriod,
  _ParkedItem._BudgetPeriodText.BudgetPeriodName AS BudgetPeriodName,
  _ParkedItem.PartnerBudgetPeriod AS PartnerBudgetPeriod,
  cast(_ParkedItem._PartnerBudgetPeriodText.BudgetPeriodName as receiverpostedbudgetperiodname preserving type) AS ReceiverPostedBudgetPeriodName,
  _ParkedItem.HouseBank AS HouseBank,
  cast(_ParkedItem._HouseBank._Bank.BankName as farp_banka preserving type) AS HouseBankName,
  _ParkedItem.HouseBankAccount AS HouseBankAccount,
  cast(_ParkedItem._HouseBankAccountText.HouseBankAccountDescription as /pf1/dte_housebank_acct_desc preserving type) 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,
  _ParkedItem.Quantity AS Quantity,
  _ParkedItem.AssetValueDate AS AssetValueDate,
  _ParkedItem.CompanyCodeCurrencyDetnMethod AS CompanyCodeCurrencyDetnMethod,
  _ParkedItem.FunctionalArea AS FunctionalArea,
  _ParkedItem._FunctionalAreaText.FunctionalAreaName AS FunctionalAreaName,
  _ParkedItem.FundedProgram AS FundedProgram,
  _ParkedItem.StateCentralBankPaymentReason AS StateCentralBankPaymentReason,
  _ParkedItem.OrderInternalBillOfOperations AS OrderInternalBillOfOperations,
  _ParkedItem.IsEUTriangularDeal AS IsEUTriangularDeal,
  _ParkedItem.IsNotCashDiscountLiable AS IsNotCashDiscountLiable,
  '' AS UICT_GLAccount,
  '' AS UICT_CreditAmount,
  '' AS UICT_DebitAmount,
  '' AS UICT_CompanyCode,
  '' AS UICT_WithholdingTaxAmount,
  '' AS UICT_WithholdingTaxBaseAmount,
  '' AS UICT_WhgdTaxExemptionAmt,
  '' AS UICT_Supplier,
  '' AS UICT_FixedCashDiscount,
  '' AS UICT_Customer,
  '' AS UICT_SpecialGLCode,
  '' AS UICT_TaxCountry,
  '' AS UICT_FinancialTransactionType,
  '' AS UICT_BranchAccount,
  '' AS UICT_PaymentTerms,
  '' AS UICT_CashDiscount1Days,
  '' AS UICT_CashDiscount2Days,
  '' AS UICT_NetPaymentDays,
  '' AS UICT_CashDiscount1Percent,
  '' AS UICT_CashDiscount2Percent,
  '' AS UICT_PaymentMethod,
  '' AS UICT_PaymentBlockingReason,
  '' AS UICT_InvoiceReference,
  '' AS UICT_InvoiceRefFiscalYear,
  '' AS UICT_InvoiceItemReference,
  '' AS UICT_FollowOnDocumentType,
  '' AS UICT_InvoiceList,
  '' AS UICT_DunningKey,
  '' AS UICT_DunningBlockingReason,
  '' AS UICT_LastDunningDate,
  '' AS UICT_DunningLevel,
  '' AS UICT_DunningArea,
  '' AS UICT_DataExchangeInstruction1,
  '' AS UICT_DataExchangeInstruction2,
  '' AS UICT_DataExchangeInstruction3,
  '' AS UICT_DataExchangeInstruction4,
  '' AS UICT_PaymentReference,
  '' AS UICT_BranchCode,
  '' AS UICT_BPBankAccountInternalID,
  '' AS UICT_AmountInPaymentCurrency,
  '' AS UICT_CashDiscountBaseAmount,
  '' AS UICT_CashDiscountAmount,
  '' AS UICT_ControllingArea,
  '' AS UICT_PostingKey,
  '' AS UICT_BusinessArea,
  '' AS UICT_PartnerBusinessArea,
  '' AS UICT_TaxCode,
  '' AS UICT_ValueDate,
  '' AS UICT_AssignmentReference,
  '' AS UICT_DocumentItemText,
  '' AS UICT_PartnerCompany,
  '' AS UICT_CostCenter,
  '' AS UICT_MasterFixedAsset,
  '' AS UICT_FixedAsset,
  '' AS UICT_AssetTransactionType,
  '' AS UICT_PersonnelNumber,
  '' AS UICT_SpecialGLAcctAssignment,
  '' AS UICT_DueCalculationBaseDate,
  '' AS UICT_SupplyingCountry,
  '' AS UICT_Product,
  '' AS UICT_Plant,
  '' AS UICT_PurchasingDocument,
  '' AS UICT_PurchasingDocumentItem,
  '' AS UICT_VATRegistration,
  '' AS UICT_PaymentDifferenceReason,
  '' AS UICT_ProfitCenter,
  '' AS UICT_JointVenture,
  '' AS UICT_JntVntrCostRecoveryCode,
  '' AS UICT_JointVentureEquityGroup,
  '' AS UICT_TaxJurisdiction,
  '' AS UICT_CostObject,
  '' AS UICT_ProjectNetwork,
  '' AS UICT_JointVentureEquityType,
  '' AS UICT_PaymentMethodSupplement,
  '' AS UICT_Reference1IDByBizPartner,
  '' AS UICT_Reference2IDByBizPartner,
  '' AS UICT_Reference3IDByBizPartner,
  '' AS UICT_Region,
  '' AS UICT_BusinessPlace,
  '' AS UICT_CostCtrActivityType,
  '' AS UICT_Segment,
  '' AS UICT_PartnerSegment,
  '' AS UICT_HouseBank,
  '' AS UICT_HouseBankAccount,
  '' AS UICT_TaxBaseAmountInCoCodeCrcy,
  '' AS UICT_TaxBaseAmountInTransCrcy,
  '' AS UICT_Quantity,
  '' AS UICT_AssetValueDate,
  '' AS UICT_FunctionalArea,
  '' AS UICT_StateCntrlBkPaymentReason,
  '' AS UICT_IsEUTriangularDeal,
  '' AS UICT_IsNotCashDiscountLiable,
  '' AS UICT_WithholdingTaxItem,
  '' AS UICT_CreditAmountInAddlCrcy1,
  '' AS UICT_DebitAmountInAddlCrcy1,
  '' AS UICT_CreditAmountInAddlCrcy2,
  '' AS UICT_DebitAmountInAddlCrcy2,
  '' AS UICT_FinancialManagementArea,
  '' AS UICT_FundsCenter,
  '' AS UICT_FundedProgram,
  '' AS UICT_Fund,
  '' AS UICT_GrantID,
  '' AS UICT_BudgetPeriod,
  '' AS UICT_PartnerFund,
  '' AS UICT_PartnerGrant,
  '' AS UICT_PartnerBudgetPeriod,
  '' AS UICT_PubSecBudgetAccountCoCode,
  '' AS UICT_ProfitabilitySegment,
  cast ('' as abap.char(1)) AS UICT_AuditMask,
  DatabaseTable
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..*]
;