I_ParkedReceivablesItem

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_ParkedReceivablesItem.
-- 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: IFIPARKEDARITEM

CREATE VIEW I_ParkedReceivablesItem AS
SELECT
  cast( vbsegd.belnr as farp_belnr_d preserving type ) AS AccountingDocument,
  cast( vbsegd.gjahr as fis_gjahr preserving type ) AS FiscalYear,
  cast( vbsegd.buzei as farp_buzei preserving type ) AS AccountingDocumentItem,
  cast( vbsegd.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,
  cast(vbsegd.pargb as fis_pargb preserving type ) AS PartnerBusinessArea,
  cast(mwskz as farp_mwskz preserving type ) AS TaxCode,
  tax_country AS TaxCountry,
  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,
  valut AS ValueDate,
  cast(zuonr as fis_zuonr preserving type ) AS AssignmentReference,
  cast(sgtxt as farp_sgtxt ) AS DocumentItemText,
  cast(bewar as fis_rmvct preserving type ) 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,
  cast(anbwa as fac_anbwa preserving type ) AS AssetTransactionType,
  cast(xumsw as farp_xumsw) AS IsSalesRelated,
  cast(hkont as fis_racct preserving type ) AS GLAccount,
  cast(kunnr as fis_kunnr preserving type ) AS Debtor,
  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 preserving type ) AS PaymentTerms,
  cast(zbd1t as farp_dzbd1t preserving type ) AS CashDiscount1Days,
  cast(zbd2t as farp_dzbd2t preserving type ) AS CashDiscount2Days,
  cast(zbd3t as farp_dzbd3t preserving type ) 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(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,
  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,
  cast(fipos as fis_fipos_shortid preserving type ) AS CommitmentItemShortID,
  cast( uzawe as farp_uzawe preserving type ) AS PaymentMethodSupplement,
  cast( fistl as farp_fistl preserving type ) AS FundsCenter,
  geber AS Fund,
  cast( xref1 as farp_xref1) AS Reference1IDByBusinessPartner,
  cast( xref2 as farp_xref2) AS Reference2IDByBusinessPartner,
  cast( kkber as farp_kkber preserving type ) AS CreditControlArea,
  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) 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,
  j_1tpbupl AS BranchCode,
  budget_pd AS BudgetPeriod,
  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 vbsegd
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_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_CreditControlArea AS _CreditControlArea ON CreditControlArea = _CreditControlArea.CreditControlArea  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _PaymentCurrency ON PaymentCurrency = _PaymentCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON TransactionCurrency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _CompanyCodeCurrency ON CompanyCodeCurrency = _CompanyCode.Currency  -- association [0..1]
;