P_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 P_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 P_MngJrnlEntrPrkdDocumentItem AS
SELECT
  SourceCompanyCode,
  SourceAccountingDocument,
  SourceFiscalYear,
  SourceAccountingDocumentItem AS ParkedAccountingDocumentItem,
  AmountInCompanyCodeCurrency,
  CompanyCodeCurrency,
  AmountInTransactionCurrency,
  TransactionCurrency,
  GLAccount,
  DebitCreditCode,
  SourceAccountingDocumentItem,
  CompanyCode,
  cast( cast( '0.0' as abap.curr( 23,2)) as fis_qbshb preserving type ) AS WithholdingTaxAmount,
  cast( cast( '0.0' as abap.curr( 23,2)) as fis_qsshb preserving type ) AS WithholdingTaxBaseAmount,
  cast( cast( '0.0' as abap.curr( 23,2)) as fis_qsfbt preserving type ) AS WithholdingTaxExemptionAmt,
  cast( '' as fis_lifnr ) AS Supplier,
  cast( '' as farp_dzbfix preserving type ) AS FixedCashDiscount,
  cast( '' as fis_kunnr ) AS Customer,
  cast( '' as fac_umskz preserving type ) AS SpecialGLCode,
  cast( '' as farp_umsks preserving type ) AS SpecialGLTransactionType,
  cast( '' as fot_tax_country ) AS TaxCountry,
  cast( '' as fis_rmvct ) AS FinancialTransactionType,
  cast( '' as ktopl ) AS ChartOfAccounts,
  cast( '' as farp_filkd ) AS BranchAccount,
  cast( '' as farp_dzterm ) AS PaymentTerms,
  cast( '0.0' as farp_dzbd1t ) AS CashDiscount1Days,
  cast( '0.0' as farp_dzbd2t ) AS CashDiscount2Days,
  cast( '0.0' as farp_dzbd3t ) AS NetPaymentDays,
  cast( '0.0' as dzbd1p_farp ) AS CashDiscount1Percent,
  cast( '0.0' as dzbd2p_farp ) AS CashDiscount2Percent,
  cast( '' as farp_schzw_bseg preserving type ) AS PaymentMethod,
  cast( '' as farp_dzlspr preserving type ) AS PaymentBlockingReason,
  cast( '' as farp_rebzg ) AS InvoiceReference,
  cast( '0000' as fis_rebzj_no_conv preserving type ) AS InvoiceReferenceFiscalYear,
  cast( '000' as fis_rebzz preserving type ) AS InvoiceItemReference,
  cast( '' as farp_rebzt preserving type ) AS FollowOnDocumentType,
  cast( '00000000' as farp_samnr preserving type ) AS InvoiceList,
  cast( '' as farp_mschl preserving type ) AS DunningKey,
  cast( '' as farp_mansp preserving type ) AS DunningBlockingReason,
  cast( '00000000' as farp_madat ) AS LastDunningDate,
  cast( '0' as farp_mahns_d preserving type ) AS DunningLevel,
  cast( '' as farp_maber ) AS DunningArea,
  cast( '' as farp_kkber ) AS CreditControlArea,
  cast( '00' as farp_dtat16 preserving type ) AS DataExchangeInstruction1,
  cast( '00' as farp_dtat17 preserving type ) AS DataExchangeInstruction2,
  cast( '00' as farp_dtat18 preserving type ) AS DataExchangeInstruction3,
  cast( '00' as farp_dtat19 preserving type ) AS DataExchangeInstruction4,
  cast( '' as fis_empfb ) AS AlternativePayeePayer,
  cast( '' as farp_kidno ) AS PaymentReference,
  cast( '' as fis_secco ) AS TaxSection,
  cast( '00000000' as farp_sk1dt ) AS CashDiscount1DueDate,
  cast( '00000000' as farp_sk2dt ) AS CashDiscount2DueDate,
  cast( '' as bcode ) AS BranchCode,
  cast( '' as farp_bvtyp ) AS BPBankAccountInternalID,
  cast( '' as farp_pycur ) AS PaymentCurrency,
  cast( cast( '0.0' as abap.curr( 23,2)) as fis_mwsts preserving type ) AS TaxAmountInCoCodeCrcy,
  cast( cast( '0.0' as abap.curr( 23,2)) as wmwst_shl preserving type ) AS TaxAmount,
  cast( cast( '0.0' as abap.curr( 23,2)) as fis_mwst2 preserving type ) AS TaxAmountInAdditionalCurrency1,
  cast( cast( '0.0' as abap.curr( 23,2)) as fis_mwst3 preserving type ) AS TaxAmountInAdditionalCurrency2,
  cast( cast( '0.0' as abap.curr( 23,2)) as pyamt_farp preserving type ) AS AmountInPaymentCurrency,
  cast( cast( '0.0' as abap.curr( 23,2)) as fis_skfbt preserving type ) AS CashDiscountBaseAmount,
  cast( cast( '0.0' as abap.curr( 23,2)) as fis_sknto preserving type ) AS CashDiscountAmtInCoCodeCrcy,
  cast( cast( '0.0' as abap.curr( 23,2)) as fis_wskto preserving type ) AS CashDiscountAmount,
  AccountingDocumentType,
  ControllingArea,
  PostingKey,
  FinancialAccountType,
  BusinessArea,
  PartnerBusinessArea,
  TaxCode,
  TaxType,
  cast( '00000000' as valut ) AS ValueDate,
  AssignmentReference,
  DocumentItemText,
  cast( '' as fis_rassc ) AS PartnerCompany,
  cast( '' as fdlev ) AS PlanningLevel,
  CostCenter,
  OrderID,
  MasterFixedAsset,
  FixedAsset,
  cast( AssetTransactionType as fco_asset_transaction_type preserving type ) AS AssetTransactionType,
  PersonnelNumber,
  cast( '' as farp_xumsw preserving type ) AS IsSalesRelated,
  SpecialGLAccountAssignment,
  cast( '00000000' as dzfbdt ) AS DueCalculationBaseDate,
  cast( '' as fac_landl ) AS SupplyingCountry,
  Product,
  Plant,
  cast( '' as fis_ebeln ) AS PurchasingDocument,
  cast( '00000' as fis_ebelp preserving type ) AS PurchasingDocumentItem,
  cast( '00' as dzekkn preserving type ) AS AccountAssignmentNumber,
  cast( '' as fis_vprsv preserving type ) AS MaterialPriceControl,
  cast( '00000' as fis_peinh ) AS MaterialPriceUnitQty,
  cast( '' as bwkey ) AS ValuationArea,
  cast( '' as bwtar_d ) AS InventoryValuationType,
  cast( '' as farp_stceg ) AS VATRegistration,
  cast( '' as farp_rstgr ) AS PaymentDifferenceReason,
  ProfitCenter,
  JointVenture,
  cast( '' as jv_recind ) AS JointVentureCostRecoveryCode,
  JointVentureEquityGroup,
  cast('' as fis_rantyp preserving type ) AS TreasuryContractType,
  cast('' as fis_ranl ) AS AssetContract,
  cast( '' as farp_sbewart ) AS CashFlowType,
  TaxJurisdiction,
  REInternalFinNumber,
  cast( '00000000' as farp_dabrbez ) AS SettlementReferenceDate,
  CommitmentItemShortID,
  CostObject,
  ProjectNetwork,
  ProfitabilitySegment,
  cast( '' as jv_etype ) AS JointVentureEquityType,
  cast( '' as hrkft ) AS CostOriginGroup,
  cast( '' as farp_uzawe ) AS PaymentMethodSupplement,
  FundsCenter,
  Fund,
  cast( '' as farp_xref1 ) AS Reference1IDByBusinessPartner,
  Reference2IDByBusinessPartner,
  IsNegativePosting,
  cast( '' as farp_ccbtc ) AS PaymentCardPaymentSettlement,
  Reference3IDByBusinessPartner,
  Region,
  BusinessPlace,
  CostCtrActivityType,
  WBSElementInternalID,
  GrantID,
  Segment,
  PartnerSegment,
  cast( '00000000' as farp_netdt ) AS NetDueDate,
  PartnerFund,
  PartnerGrant,
  BudgetPeriod,
  PartnerBudgetPeriod,
  cast( '' as farp_hbkid ) AS HouseBank,
  cast( '' as fac_hktid ) AS HouseBankAccount,
  AdditionalCurrency1,
  AdditionalCurrency2,
  AmountInAdditionalCurrency1,
  AmountInAdditionalCurrency2,
  TaxBaseAmountInCoCodeCrcy,
  TaxBaseAmountInTransCrcy,
  cast( '0.0' as fis_reewr ) AS InvoiceAmtInCoCodeCrcy,
  cast( '0.0' as fis_fdwbt ) AS PlannedAmtInTransactionCrcy,
  cast( '0.0' as fis_refwr ) AS InvoiceAmountInFrgnCurrency,
  BaseUnit,
  Quantity,
  AssetValueDate,
  CompanyCodeCurrencyDetnMethod,
  FunctionalArea,
  FundedProgram,
  cast( '' as lzbkz ) AS StateCentralBankPaymentReason,
  cast( '0000000000' as fis_ordintbillofops preserving type ) AS OrderInternalBillOfOperations,
  cast( '' as fis_xegdr preserving type ) AS IsEUTriangularDeal,
  IsNotCashDiscountLiable,
  cast( '' as ps_posid_edit ) AS WBSElementExternalID,
  cast( '' as ps_s4_post1 ) AS WBSDescription,
  cast( 'VBSEGS' as tabname ) AS DatabaseTable,
  _SourceCompanyCode.CompanyCodeName AS SourceCompanyCodeName,
  _SourceParkedOplAcctgDocument.FinancialManagementArea AS FinancialManagementArea
FROM I_ParkedOplAcctgDocAssetItem AS _ParkedItem
-- UNION ALL with additional select branch(es): I_ParkedOplAcctgDocRblsItem, I_ParkedOplAcctgDocPyblsItem, I_ParkedOplAcctgDocGLItem
;