I_ParkedOplAcctgDocPyblsItem

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_ParkedOplAcctgDocPyblsItem.
-- 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 I_ParkedOplAcctgDocPyblsItem AS
SELECT
  ausbk AS SourceCompanyCode,
  cast( belnr as fis_belnr preserving type ) AS SourceAccountingDocument,
  cast( gjahr as fis_gjahr_no_conv preserving type ) AS SourceFiscalYear,
  cast( bzkey as fis_parked_ap_item preserving type ) AS ParkedAcctgDocPyblsItem,
  cast( buzei as fis_buzei preserving type ) AS SourceAccountingDocumentItem,
  cast( 'K' as farp_koart preserving type ) AS FinancialAccountType,
  cast( bukrs as fis_bukrs preserving type ) AS CompanyCode,
  cast( lifnr as fis_lifnr preserving type ) AS Supplier,
  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( vbsegk.pargb as fis_pargb preserving type ) AS PartnerBusinessArea,
  cast( mwskz as farp_mwskz preserving type ) AS TaxCode,
  tax_country AS TaxCountry,
  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,
  cast( anbwa as fac_anbwa preserving type ) AS AssetTransactionType,
  cast( xumsw as farp_xumsw) AS IsSalesRelated,
  _CompanyCode.ChartOfAccounts AS ChartOfAccounts,
  cast( hkont as fis_racct preserving type ) AS GLAccount,
  cast( filkd as farp_filkd preserving type ) AS BranchAccount,
  hzuon 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,
  cast( zbd1p as dzbd1p_farp preserving type ) AS CashDiscount1Percent,
  cast( zbd2p as dzbd2p_farp preserving type ) AS CashDiscount2Percent,
  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,
  cast( egrup as jv_egroup_cds preserving type ) AS JointVentureEquityGroup,
  cast( vertt as fis_rantyp preserving type ) AS TreasuryContractType,
  cast( vertn as fis_ranl preserving type ) AS AssetContract,
  cast( vbewa as farp_sbewart preserving type ) AS CashFlowType,
  cast( fipos as fis_fipos_shortid preserving type ) AS CommitmentItemShortID,
  fdlev AS PlanningLevel,
  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 preserving type ) AS Reference1IDByBusinessPartner,
  cast( xref2 as farp_xref2 preserving type ) AS Reference2IDByBusinessPartner,
  cast( xref3 as fis_xref3 preserving type ) AS Reference3IDByBusinessPartner,
  cast( dtws1 as farp_dtat16 preserving type ) AS DataExchangeInstruction1,
  cast( dtws2 as farp_dtat17 preserving type ) AS DataExchangeInstruction2,
  cast( dtws3 as farp_dtat18 preserving type ) AS DataExchangeInstruction3,
  cast( dtws4 as farp_dtat19 preserving type ) AS DataExchangeInstruction4,
  cast( empfb as fis_empfb preserving type ) AS AlternativePayeePayer,
  cast( kidno as farp_kidno preserving type ) AS PaymentReference,
  cast( bupla as farp_bupla preserving type ) AS BusinessPlace,
  cast( secco as fis_secco preserving type ) AS TaxSection,
  grant_nbr AS GrantID,
  cast( fkber as fm_farea preserving type ) AS FunctionalArea,
  cast( hktid as fac_hktid preserving type ) AS HouseBankAccount,
  cast( netdt as farp_netdt preserving type ) AS NetDueDate,
  cast( sk1dt as farp_sk1dt preserving type ) AS CashDiscount1DueDate,
  cast( sk2dt as farp_sk2dt preserving type ) AS CashDiscount2DueDate,
  j_1tpbupl AS BranchCode,
  budget_pd AS BudgetPeriod,
  cast( bvtyp as farp_bvtyp preserving type ) AS BPBankAccountInternalID,
  cast( dabrz as farp_dabrbez preserving type ) AS SettlementReferenceDate,
  cast( payt_rsn as farp_payt_rsn preserving type ) AS PaymentReason,
  cast( zbfix as farp_dzbfix preserving type ) AS FixedCashDiscount,
  cast( btype as jv_bilind_cds preserving type ) AS JointVentureBillingType,
  qsskz AS WithholdingTaxCode,
  cast( pycur as farp_pycur preserving type ) AS PaymentCurrency,
  _ParkedOplAcctgDocument.TransactionCurrency AS TransactionCurrency,
  _ParkedOplAcctgDocument.CompanyCodeCurrency AS CompanyCodeCurrency,
  _ParkedOplAcctgDocument.AdditionalCurrency1 AS AdditionalCurrency1,
  _ParkedOplAcctgDocument.AdditionalCurrency2 AS AdditionalCurrency2
FROM vbsegk
LEFT OUTER JOIN I_CompanyCode AS _SourceCompanyCode ON SourceCompanyCode = _SourceCompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearForCompanyCode AS _SourceFiscalYear ON SourceFiscalYear = _SourceFiscalYear.FiscalYear AND SourceCompanyCode = _SourceFiscalYear.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_ParkedOplAcctgDocument AS _ParkedOplAcctgDocument ON SourceCompanyCode = _ParkedOplAcctgDocument.SourceCompanyCode AND CompanyCode = _ParkedOplAcctgDocument.CompanyCode AND SourceAccountingDocument = _ParkedOplAcctgDocument.SourceAccountingDocument AND SourceFiscalYear = _ParkedOplAcctgDocument.SourceFiscalYear  -- association [0..1]
LEFT OUTER JOIN I_ParkedOplAcctgDocument AS _SourceParkedOplAcctgDocument ON SourceCompanyCode = _SourceParkedOplAcctgDocument.SourceCompanyCode AND SourceCompanyCode = _SourceParkedOplAcctgDocument.CompanyCode AND SourceAccountingDocument = _SourceParkedOplAcctgDocument.SourceAccountingDocument AND SourceFiscalYear = _SourceParkedOplAcctgDocument.SourceFiscalYear  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_SupplierCompany AS _SupplierCompany ON Supplier = _SupplierCompany.Supplier AND CompanyCode = _SupplierCompany.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_FinancialAccountType AS _FinancialAccountType ON FinancialAccountType = _FinancialAccountType.FinancialAccountType  -- 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_SpecialGLCode AS _SpecialGLCode ON SpecialGLCode = _SpecialGLCode.SpecialGLCode AND FinancialAccountType = _SpecialGLCode.FinancialAccountType  -- 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_Country AS _TaxCountry ON TaxCountry = _TaxCountry.Country  -- association [0..1]
LEFT OUTER JOIN I_TaxType AS _TaxType ON TaxType = _TaxType.TaxType  -- association [0..1]
LEFT OUTER JOIN I_AssetTransactionType AS _AssetTransactionType ON AssetTransactionType = _AssetTransactionType.AssetTransactionType  -- association [0..1]
LEFT OUTER JOIN I_ChartOfAccounts AS _ChartOfAccounts ON ChartOfAccounts = _ChartOfAccounts.ChartOfAccounts  -- association [0..1]
LEFT OUTER JOIN I_GLAccountInChartOfAccounts AS _GLAccountInChartOfAccounts ON ChartOfAccounts = _GLAccountInChartOfAccounts.ChartOfAccounts AND GLAccount = _GLAccountInChartOfAccounts.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _CompanyCodeCurrency ON CompanyCodeCurrency = _CompanyCodeCurrency.Currency  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _TransactionCurrency ON TransactionCurrency = _TransactionCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _AdditionalCurrency1 ON AdditionalCurrency1 = _AdditionalCurrency1.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _AdditionalCurrency2 ON AdditionalCurrency2 = _AdditionalCurrency2.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _PaymentCurrency ON PaymentCurrency = _PaymentCurrency.Currency  -- association [0..1]
;