I_ParkedPayablesItem

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 I_ParkedPayablesItem.
-- 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.
-- SQL view name: IFIPARKEDAPITEM

CREATE VIEW I_ParkedPayablesItem AS
SELECT
  cast( vbsegk.belnr as farp_belnr_d preserving type ) AS AccountingDocument,
  cast( vbsegk.gjahr as fis_gjahr preserving type ) AS FiscalYear,
  cast( buzei as farp_buzei preserving type ) AS AccountingDocumentItem,
  cast( vbsegk.bukrs as fis_bukrs preserving type ) AS CompanyCode,
  cast( bschl as farp_bschl preserving type ) AS PostingKey,
  cast( umskz as fac_umskz preserving type ) AS SpecialGLCode,
  cast( umsks as farp_umsks preserving type ) AS SpecialGLTransactionType,
  cast( gsber as fis_rbusa preserving type ) AS BusinessArea,
  vbsegk.pargb AS PartnerBusinessArea,
  cast( mwskz as farp_mwskz preserving type ) AS TaxCode,
  tax_country AS TaxCountry,
  qsskz AS WithholdingTaxCode,
  case shkzg when 'H' then cast(-wrbtr as abap.curr( 23,2)) when 'S' then cast( wrbtr as abap.curr( 23,2)) else cast( wrbtr as abap.curr( 23,2)) end as AmountInTransactionCurrency AS curr232endasAmountInTransactionCurrency,
  case shkzg when 'H' then cast(-mwsts as abap.curr( 23,2)) when 'S' then cast( mwsts as abap.curr( 23,2)) else cast( mwsts as abap.curr( 23,2)) end as TaxAmountInCoCodeCrcy AS curr232endasTaxAmountInCoCodeCrcy,
  case shkzg when 'H' then cast(-wmwst as abap.curr( 23,2)) when 'S' then cast( wmwst as abap.curr( 23,2)) else cast( wmwst as abap.curr( 23,2)) end as TaxAmount AS curr232endasTaxAmount,
  case shkzg when 'H' then cast(-fwbas as abap.curr( 23,2)) when 'S' then cast( fwbas as abap.curr( 23,2)) else cast( fwbas as abap.curr( 23,2)) end as TaxBaseAmountInTransCrcy AS curr232endasTaxBaseAmountInTransCrcy,
  case shkzg when 'H' then cast(-hwbas as abap.curr( 23,2)) when 'S' then cast( hwbas as abap.curr( 23,2)) else cast( hwbas as abap.curr( 23,2)) end as TaxBaseAmountInCoCodeCrcy AS curr232endasTaxBaseAmountInCoCodeCrcy,
  mwart AS TaxType,
  case shkzg when 'H' then cast(-qsshb as abap.curr( 23,2)) when 'S' then cast( qsshb as abap.curr( 23,2)) else cast( qsshb as abap.curr( 23,2)) end as WithholdingTaxBaseAmount AS curr232endasWithholdingTaxBaseAmount,
  valut AS ValueDate,
  cast( zuonr as fis_zuonr preserving type ) AS AssignmentReference,
  cast( sgtxt as farp_sgtxt ) AS DocumentItemText,
  bewar AS FinancialTransactionType,
  fdlev AS PlanningLevel,
  case shkzg when 'H' then cast(-fdwbt as abap.curr( 23,2)) when 'S' then cast( fdwbt as abap.curr( 23,2)) else cast( fdwbt as abap.curr( 23,2)) end as PlannedAmtInTransactionCrcy AS curr232endasPlannedAmtInTransactionCrcy,
  anbwa AS AssetTransactionType,
  cast(xumsw as farp_xumsw ) AS IsSalesRelated,
  cast( hkont as fis_racct preserving type ) AS GLAccount,
  lifnr AS Creditor,
  cast( filkd as farp_filkd preserving type ) AS BranchAccount,
  cast( hzuon as hzuon preserving type ) AS SpecialGLAccountAssignment,
  zfbdt AS DueCalculationBaseDate,
  cast( zterm as farp_dzterm ) AS PaymentTerms,
  cast(zbd1t as farp_dzbd1t ) AS CashDiscount1Days,
  cast(zbd2t as farp_dzbd2t ) AS CashDiscount2Days,
  cast(zbd3t as farp_dzbd3t ) AS NetPaymentDays,
  zbd1p AS CashDiscount1Percent,
  zbd2p AS CashDiscount2Percent,
  case shkzg when 'H' then cast(-skfbt as abap.curr( 23,2)) when 'S' then cast( skfbt as abap.curr( 23,2)) else cast( skfbt as abap.curr( 23,2)) end as CashDiscountBaseAmount AS curr232endasCashDiscountBaseAmount,
  case shkzg when 'H' then cast(-sknto as abap.curr( 23,2)) when 'S' then cast( sknto as abap.curr( 23,2)) else cast( sknto as abap.curr( 23,2)) end as CashDiscountAmtInCoCodeCrcy AS curr232endasCashDiscountAmtInCoCodeCrcy,
  case shkzg when 'H' then cast(-wskto as abap.curr( 23,2)) when 'S' then cast( wskto as abap.curr( 23,2)) else cast( wskto as abap.curr( 23,2)) end as CashDiscountAmount AS curr232endasCashDiscountAmount,
  cast( zlsch as farp_schzw_bseg preserving type ) AS PaymentMethod,
  cast( zlspr as farp_dzlspr preserving type ) AS PaymentBlockingReason,
  cast( zbfix as farp_dzbfix preserving type ) AS FixedCashDiscount,
  cast( hbkid as farp_hbkid preserving type ) AS HouseBank,
  cast( rebzg as farp_rebzg preserving type ) AS InvoiceReference,
  cast( rebzj as fis_rebzj preserving type ) AS InvoiceReferenceFiscalYear,
  cast( rebzz as fis_rebzz preserving type ) AS InvoiceItemReference,
  cast( rebzt as farp_rebzt preserving type ) AS FollowOnDocumentType,
  cast( lzbkz as fac_lzbkz preserving type ) AS StateCentralBankPaymentReason,
  cast( landl as fac_landl preserving type ) AS SupplyingCountry,
  cast( samnr as farp_samnr preserving type ) AS InvoiceList,
  cast( mschl as farp_mschl preserving type ) AS DunningKey,
  cast( mansp as farp_mansp preserving type ) AS DunningBlockingReason,
  cast( madat as farp_madat preserving type ) AS LastDunningDate,
  cast( manst as farp_mahns_d preserving type ) AS DunningLevel,
  cast( maber as farp_maber preserving type ) AS DunningArea,
  case shkzg when 'H' then cast(-qbshb as abap.curr( 23,2)) when 'S' then cast( qbshb as abap.curr( 23,2)) else cast( qbshb as abap.curr( 23,2)) end as WithholdingTaxAmount AS curr232endasWithholdingTaxAmount,
  case shkzg when 'H' then cast(-qsfbt as abap.curr( 23,2)) when 'S' then cast( qsfbt as abap.curr( 23,2)) else cast( qsfbt as abap.curr( 23,2)) end as WithholdingTaxExemptionAmt AS curr232endasWithholdingTaxExemptionAmt,
  case shkzg when 'H' then cast(-rewrt as abap.curr( 23,2)) when 'S' then cast( rewrt as abap.curr( 23,2)) else cast( rewrt as abap.curr( 23,2)) end as InvoiceAmtInCoCodeCrcy AS curr232endasInvoiceAmtInCoCodeCrcy,
  case shkzg when 'H' then cast(-rewwr as abap.curr( 23,2)) when 'S' then cast( rewwr as abap.curr( 23,2)) else cast( rewwr as abap.curr( 23,2)) end as InvoiceAmountInFrgnCurrency AS curr232endasInvoiceAmountInFrgnCurrency,
  cast( stceg as farp_stceg preserving type ) AS VATRegistration,
  cast( rstgr as farp_rstgr preserving type ) AS PaymentDifferenceReason,
  vname AS JointVenture,
  egrup AS JointVentureEquityGroup,
  vertt AS TreasuryContractType,
  vertn AS AssetContract,
  cast( vbewa as farp_sbewart preserving type ) AS CashFlowType,
  dabrz AS SettlementReferenceDate,
  cast( fipos as fis_fipos_shortid preserving type ) AS CommitmentItemShortID,
  cast( uzawe as farp_uzawe ) AS PaymentMethodSupplement,
  cast( fistl as farp_fistl ) AS FundsCenter,
  geber AS Fund,
  cast( xref1 as farp_xref1 ) AS Reference1IDByBusinessPartner,
  cast( xref2 as farp_xref2 ) AS Reference2IDByBusinessPartner,
  xref3 AS Reference3IDByBusinessPartner,
  cast( dtws1 as farp_dtat16 ) AS DataExchangeInstruction1,
  cast( dtws2 as farp_dtat17 ) AS DataExchangeInstruction2,
  cast( dtws3 as farp_dtat18 ) AS DataExchangeInstruction3,
  cast( dtws4 as farp_dtat19 ) AS DataExchangeInstruction4,
  empfb AS AlternativePayeePayer,
  cast( kidno as farp_kidno preserving type ) AS PaymentReference,
  cast( pycur as farp_pycur preserving type ) AS PaymentCurrency,
  cast( bupla as farp_bupla preserving type ) AS BusinessPlace,
  secco AS TaxSection,
  grant_nbr AS GrantID,
  fkber AS FunctionalArea,
  cast( gmvkz as gmvkzd ) AS CustomerIsInExecution,
  hktid AS HouseBankAccount,
  cast( netdt as farp_netdt preserving type ) AS NetDueDate,
  cast( sk1dt as farp_sk1dt preserving type ) AS CashDiscount1DueDate,
  sk2dt AS CashDiscount2DueDate,
  budget_pd AS BudgetPeriod,
  j_1tpbupl AS BranchCode,
  bvtyp AS BPBankAccountInternalID,
  _header.usnam AS AccountingDocCreatedByUser,
  _header.vatdate AS TaxReportingDate,
  _header.waers AS TransactionCurrency,
  cast( _header.hwaer as farp_hwaer preserving type ) AS CompanyCodeCurrency,
  cast( _header.hwae2 as fis_hwae2 preserving type ) AS AdditionalCurrency1,
  cast( _header.hwae3 as fis_hwae3 preserving type ) AS AdditionalCurrency2,
  cast( _header.awtyp as fis_awtyp ) AS ReferenceDocumentType,
  cast( _header.awkey as fac_awkey ) AS OriginalReferenceDocument,
  cast( _header.awsys as fis_awsys ) AS ReferenceDocumentLogicalSystem,
  payt_rsn AS PaymentReason
FROM vbsegk
INNER JOIN vbkpf AS _header ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_PostingKey AS _PostingKey ON PostingKey = _PostingKey.PostingKey  -- association [0..1]
LEFT OUTER JOIN I_DebitCreditCode AS _DebitCreditCode ON DebitCreditCode = _DebitCreditCode.DebitCreditCode  -- association [0..1]
LEFT OUTER JOIN I_BusinessArea AS _BusinessArea ON BusinessArea = _BusinessArea.BusinessArea  -- association [0..1]
LEFT OUTER JOIN I_BusinessArea AS _PartnerBusinessArea ON PartnerBusinessArea = _PartnerBusinessArea.BusinessArea  -- association [0..1]
LEFT OUTER JOIN I_TaxType AS _TaxType ON TaxType = _TaxType.TaxType  -- association [0..1]
LEFT OUTER JOIN I_FinancialTransactionType AS _FinancialTransactionType ON FinancialTransactionType = _FinancialTransactionType.FinancialTransactionType  -- association [0..1]
LEFT OUTER JOIN I_GLAccount AS _GLAccount ON GLAccount = _GLAccount.GLAccount AND CompanyCode = _GLAccount.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_PaymentBlockingReason AS _PaymentBlockingReason ON PaymentBlockingReason = _PaymentBlockingReason.PaymentBlockingReason  -- association [0..1]
LEFT OUTER JOIN I_Country AS _SupplyingCountry ON SupplyingCountry = _SupplyingCountry.Country  -- association [0..1]
LEFT OUTER JOIN I_DunningBlockingReasonCode AS _DunningBlockingReasonCode ON DunningBlockingReason = _DunningBlockingReasonCode.DunningBlockingReason  -- association [0..1]
LEFT OUTER JOIN I_DunningArea AS _DunningArea ON CompanyCode = _DunningArea.CompanyCode AND DunningArea = _DunningArea.DunningArea  -- association [0..1]
LEFT OUTER JOIN I_PaymentDifferenceReason AS _PaymentDiffReason ON PaymentDifferenceReason = _PaymentDiffReason.PaymentDifferenceReason AND CompanyCode = _PaymentDiffReason.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _PaymentCurrency ON PaymentCurrency = _PaymentCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _CompanyCodeCurrency ON CompanyCodeCurrency = _CompanyCodeCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON TransactionCurrency = _Currency.Currency  -- association [0..1]
;