ICA_MatchingOplAcctgDocItem

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 ICA_MatchingOplAcctgDocItem.
-- 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 ICA_MatchingOplAcctgDocItem AS
SELECT
  a.bukrs AS CompanyCode,
  a.belnr AS AccountingDocument,
  a.gjahr AS FiscalYear,
  a.buzei AS AccountingDocumentItem,
  cast ('' as ica_method_id) AS MatchingMethodID,
  c.ktopl AS ChartOfAccounts,
  a.buzid AS AccountingDocumentItemType,
  a.augdt AS ClearingDate,
  a.augcp AS ClearingCreationDate,
  a.auggj AS ClearingJournalEntryFiscalYear,
  cast( a.auggj as fis_auggj_no_conv_depre preserving type ) AS ClearingDocFiscalYear,
  a.augbl AS ClearingJournalEntry,
  cast( a.augbl as fis_augbl_depre preserving type ) AS ClearingAccountingDocument,
  a.bschl AS PostingKey,
  a.koart AS FinancialAccountType,
  a.umskz AS SpecialGLCode,
  a.umsks AS SpecialGLTransactionType,
  a.shkzg AS DebitCreditCode,
  a.gsber AS BusinessArea,
  a.pargb AS PartnerBusinessArea,
  a.mwskz AS TaxCode,
  a.tax_country AS TaxCountry,
  a.txdat_from AS TaxRateValidityStartDate,
  a.qsskz AS WithholdingTaxCode,
  a.mwart AS TaxType,
  a.txgrp AS TaxItemGroup,
  a.ktosl AS TransactionTypeDetermination,
  a.valut AS ValueDate,
  a.zuonr AS AssignmentReference,
  a.sgtxt AS DocumentItemText,
  a.vbund AS PartnerCompany,
  a.bewar AS FinancialTransactionType,
  a.altkt AS CorporateGroupAccount,
  a.fdlev AS PlanningLevel,
  a.kokrs AS ControllingArea,
  a.kostl AS CostCenter,
  a.aufnr AS OrderID,
  a.vbeln AS BillingDocument,
  a.vbel2 AS SalesDocument,
  a.posn2 AS SalesDocumentItem,
  a.eten2 AS ScheduleLine,
  a.service_doc_type AS ServiceDocumentType,
  a.service_doc_id AS ServiceDocument,
  a.service_doc_item_id AS ServiceDocumentItem,
  a.anln1 AS MasterFixedAsset,
  a.anln2 AS FixedAsset,
  a.anbwa AS AssetTransactionType,
  a.bzdat AS AssetValueDate,
  a.pernr AS PersonnelNumber,
  a.xumsw AS IsSalesRelated,
  a.xkres AS LineItemDisplayIsEnabled,
  a.xopvw AS IsOpenItemManaged,
  cast( a.xcpdd as farp_xcpdd ) AS AddressAndBankIsSetManually,
  a.xanet AS DownPaymentIsNetProcedure,
  a.xskrl AS IsNotCashDiscountLiable,
  a.xauto AS IsAutomaticallyCreated,
  a.xzahl AS IsUsedInPaymentTransaction,
  a.saknr AS OperationalGLAccount,
  a.hkont AS GLAccount,
  a.kunnr AS Customer,
  a.lifnr AS Supplier,
  a.filkd AS BranchAccount,
  a.xbilk AS IsBalanceSheetAccount,
  a.gvtyp AS ProfitLossAccountType,
  a.hzuon AS SpecialGLAccountAssignment,
  a.zfbdt AS DueCalculationBaseDate,
  a.zterm AS PaymentTerms,
  a.zbd1t AS CashDiscount1Days,
  a.zbd2t AS CashDiscount2Days,
  a.zbd3t AS NetPaymentDays,
  a.zbd1p AS CashDiscount1Percent,
  a.zbd2p AS CashDiscount2Percent,
  a.zlsch AS PaymentMethod,
  a.zlspr AS PaymentBlockingReason,
  a.zbfix AS FixedCashDiscount,
  a.hbkid AS HouseBank,
  a.bvtyp AS BPBankAccountInternalID,
  a.mwsk1 AS TaxDistributionCode1,
  a.mwsk2 AS TaxDistributionCode2,
  a.mwsk3 AS TaxDistributionCode3,
  a.rebzg AS InvoiceReference,
  a.rebzj AS InvoiceReferenceFiscalYear,
  a.rebzz AS InvoiceItemReference,
  a.rebzt AS FollowOnDocumentType,
  a.lzbkz AS StateCentralBankPaymentReason,
  a.landl AS SupplyingCountry,
  a.samnr AS InvoiceList,
  a.disbn AS BillOfExchangeUsageDocument,
  a.wverw AS BillOfExchangeUsage,
  a.mschl AS DunningKey,
  a.mansp AS DunningBlockingReason,
  a.madat AS LastDunningDate,
  a.manst AS DunningLevel,
  a.maber AS DunningArea,
  a.esrnr AS PaytSlipWthRefSubscriber,
  a.esrre AS PaytSlipWthRefReference,
  a.esrpz AS PaytSlipWthRefCheckDigit,
  a.qsznr AS WithholdingTaxCertificate,
  cast( a.matnr as productnumber ) AS Product,
  a.werks AS Plant,
  a.ebeln AS PurchasingDocument,
  a.ebelp AS PurchasingDocumentItem,
  a.zekkn AS AccountAssignmentNumber,
  a.elikz AS IsCompletelyDelivered,
  a.vprsv AS MaterialPriceControl,
  a.bwkey AS ValuationArea,
  a.bwtar AS InventoryValuationType,
  a.stceg AS VATRegistration,
  a.egbld AS DelivOfGoodsDestCountry,
  a.eglld AS DelivOfGoodsOriginCountry,
  a.rstgr AS PaymentDifferenceReason,
  a.prctr AS ProfitCenter,
  a.vname AS JointVenture,
  a.recid AS JointVentureCostRecoveryCode,
  a.egrup AS JointVentureEquityGroup,
  cast( a.vptnr as jv_part_cds preserving type ) AS JointVenturePartner,
  a.vertt AS TreasuryContractType,
  a.vertn AS AssetContract,
  a.vbewa AS CashFlowType,
  a.txjcd AS TaxJurisdiction,
  cast( a.imkey as recaimkeyfi preserving type ) AS REInternalFinNumber,
  a.imkey AS RealEstateObject,
  a.dabrz AS SettlementReferenceDate,
  a.fipos AS CommitmentItem,
  cast( a.fipos as fis_fipos_shortid preserving type ) AS CommitmentItemShortID,
  a.kstrg AS CostObject,
  a.nplnr AS ProjectNetwork,
  a.aufpl AS OrderInternalBillOfOperations,
  a.aplzl AS OrderIntBillOfOperationsItem,
  cast( a.projk as fis_wbsint_no_conv preserving type ) AS WBSElementInternalID,
  cast( a.paobjnr as rkeobjnr_char ) AS ProfitabilitySegment_2,
  a.etype AS JointVentureEquityType,
  a.xegdr AS IsEUTriangularDeal,
  a.hrkft AS CostOriginGroup,
  a.hwmet AS CompanyCodeCurrencyDetnMethod,
  a.xragl AS ClearingIsReversed,
  a.uzawe AS PaymentMethodSupplement,
  a.lokkt AS AlternativeGLAccount,
  a.fistl AS FundsCenter,
  a.geber AS Fund,
  a.stbuk AS TaxCompanyCode,
  a.pprct AS PartnerProfitCenter,
  a.xref1 AS Reference1IDByBusinessPartner,
  a.xref2 AS Reference2IDByBusinessPartner,
  a.kblnr AS EarmarkedFundsDocument,
  a.kblpos AS EarmarkedFundsDocumentItem,
  a.xnegp AS IsNegativePosting,
  a.rfzei AS PaymentCardItem,
  a.ccbtc AS PaymentCardPaymentSettlement,
  a.kkber AS CreditControlArea,
  a.empfb AS AlternativePayeePayer,
  a.xref3 AS Reference3IDByBusinessPartner,
  a.dtws1 AS DataExchangeInstruction1,
  a.dtws2 AS DataExchangeInstruction2,
  a.dtws3 AS DataExchangeInstruction3,
  a.dtws4 AS DataExchangeInstruction4,
  a.grirg AS Region,
  a.xpypr AS HasPaymentOrder,
  a.kidno AS PaymentReference,
  a.txdat AS TaxDeterminationDate,
  a.agzei AS ClearingItem,
  a.bupla AS BusinessPlace,
  a.secco AS TaxSection,
  a.lstar AS CostCtrActivityType,
  a.cession_kz AS AccountsReceivableIsPledged,
  cast( a.cession_kz as fis_cession_kz_code preserving type ) AS AcctsReceivablePledgingCode,
  a.prznr AS BusinessProcess,
  a.grant_nbr AS GrantID,
  a.fkber_long AS FunctionalArea,
  a.gmvkz AS CustomerIsInExecution,
  a.measure AS FundedProgram,
  a.docln AS LedgerGLLineItem,
  a.segment AS Segment,
  a.psegment AS PartnerSegment,
  a.pfkber AS PartnerFunctionalArea,
  a.hktid AS HouseBankAccount,
  a.kstar AS CostElement,
  a.taxps AS TaxItemAcctgDocItemRef,
  a.pays_prov AS PaymentServiceProvider,
  a.pays_tran AS PaymentRefByPaytSrvcProvider,
  a.mndid AS SEPAMandate,
  a.awtyp AS ReferenceDocumentType,
  a.awkey AS OriginalReferenceDocument,
  a.awsys AS ReferenceDocumentLogicalSystem,
  a.posnr AS AccountingDocumentItemRef,
  a.h_monat AS FiscalPeriod,
  a.h_bstat AS AccountingDocumentCategory,
  a.h_budat AS PostingDate,
  a.h_bldat AS DocumentDate,
  a.h_blart AS AccountingDocumentType,
  a.netdt AS NetDueDate,
  a.sk1dt AS CashDiscount1DueDate,
  a.sk2dt AS CashDiscount2DueDate,
  a.gkont AS OffsettingAccount,
  a.gkart AS OffsettingAccountType,
  a.pgeber AS PartnerFund,
  a.pgrant_nbr AS PartnerGrant,
  a.budget_pd AS BudgetPeriod,
  a.pbudget_pd AS PartnerBudgetPeriod,
  a.j_1tpbupl AS BranchCode,
  cast( a.prodper as jv_prodper_cds preserving type ) AS JointVentureProductionDate,
  a.glo_ref1 AS OplAcctgDocItmCntrySpcfcRef1,
  a.payt_rsn AS PaymentReason,
  a.re_bukrs AS CashLedgerCompanyCode,
  a.re_account AS CashLedgerAccount,
  a.bdgt_account_cocode AS PubSecBudgetAccountCoCode,
  a.bdgt_account AS PubSecBudgetAccount,
  a.h_hwaer AS CompanyCodeCurrency,
  a.dmbtr AS AmountInCompanyCodeCurrency,
  a.rfccur AS FunctionalCurrency,
  a.fcsl AS AmountInFunctionalCurrency,
  a.mwsts AS TaxAmountInCoCodeCrcy,
  a.hwbas AS TaxBaseAmountInCoCodeCrcy,
  a.bdiff AS ValuationDiffAmtInCoCodeCrcy,
  a.sknto AS CashDiscountAmtInCoCodeCrcy,
  a.dmbt1 AS TaxBrkdwnAmount1InCoCodeCrcy,
  a.dmbt2 AS TaxBrkdwnAmount2InCoCodeCrcy,
  a.dmbt3 AS TaxBrkdwnAmount3InCoCodeCrcy,
  a.navhw AS NonDcblTaxAmountInCoCodeCrcy,
  a.rewrt AS InvoiceAmtInCoCodeCrcy,
  a.h_waers AS TransactionCurrency,
  a.wrbtr AS AmountInTransactionCurrency,
  a.txbfw AS OriginalTaxBaseAmount,
  a.wmwst AS TaxAmount,
  a.fwbas AS TaxBaseAmountInTransCrcy,
  a.qsshb AS WithholdingTaxBaseAmount,
  a.fdwbt AS PlannedAmtInTransactionCrcy,
  a.skfbt AS CashDiscountBaseAmount,
  a.wskto AS CashDiscountAmount,
  a.nebtr AS NetPaymentAmount,
  a.wrbt1 AS TaxBrkdwnAmount1InTransCrcy,
  a.wrbt2 AS TaxBrkdwnAmount2InTransCrcy,
  a.wrbt3 AS TaxBrkdwnAmount3InTransCrcy,
  a.qbshb AS WithholdingTaxAmount,
  a.qsfbt AS WithholdingTaxExemptionAmt,
  a.navfw AS NonDcblTaxAmountInTransCrcy,
  a.rewwr AS InvoiceAmountInFrgnCurrency,
  a.pswsl AS BalanceTransactionCurrency,
  a.pswbt AS AmountInBalanceTransacCrcy,
  a.h_hwae2 AS AdditionalCurrency1,
  a.bdif2 AS ValuationDiffAmtInAddlCrcy1,
  a.dmbe2 AS AmountInAdditionalCurrency1,
  a.mwst2 AS TaxAmountInAdditionalCurrency1,
  a.h_hwae3 AS AdditionalCurrency2,
  a.dmbe3 AS AmountInAdditionalCurrency2,
  a.mwst3 AS TaxAmountInAdditionalCurrency2,
  a.bdif3 AS ValuationDiffAmtInAddlCrcy2,
  a.pycur AS PaymentCurrency,
  a.pyamt AS AmountInPaymentCurrency,
  a.meins AS BaseUnit,
  a.menge AS Quantity,
  a.erfme AS GoodsMovementEntryUnit,
  a.erfmg AS QuantityInEntryUnit,
  a.bprme AS PurchasingDocumentPriceUnit,
  a.bpmng AS PurchaseOrderQty,
  a.peinh AS MaterialPriceUnitQty,
  a.kblnr AS EarmarkedFunds,
  a.kblpos AS EarmarkedFundsItem,
  a.gst_part AS IN_GSTPartner,
  a.plc_sup AS IN_GSTPlaceOfSupply,
  a.hsn_sac AS IN_HSNOrSACCode,
  cast ( b.aedat as fis_lastmanualchangedate preserving type ) AS LastManualChangeDate,
  cast ( b.upddt as fis_lastautomaticchangedate preserving type) AS LastAutomaticChangeDate,
  b.wwert AS ExchangeRateDate,
  b.usnam AS AccountingDocCreatedByUser,
  b.tcode AS TransactionCode,
  b.bvorg AS IntercompanyTransaction,
  b.xblnr AS DocumentReferenceID,
  b.dbblg AS RecurringAccountingDocument,
  b.stblg AS ReverseDocument,
  b.stjah AS ReverseDocumentFiscalYear,
  b.bktxt AS AccountingDocumentHeaderText,
  b.xnetb AS NetAmountIsPosted,
  b.xrueb AS JrnlEntryIsPostedToPrevPeriod,
  b.glvor AS BusinessTransactionType,
  b.grpid AS BatchInputSession,
  b.fikrs AS FinancialManagementArea,
  b.xstov AS ReversalIsPlanned,
  b.stodt AS PlannedReversalDate,
  b.xmwst AS TaxIsCalculatedAutomatically,
  b.curt2 AS AdditionalCurrency1Role,
  b.curt3 AS AdditionalCurrency2Role,
  b.xsnet AS TaxBaseAmountIsNetAmount,
  b.ausbk AS SourceCompanyCode,
  b.awsys AS LogicalSystem,
  b.txkrs AS TaxExchangeRate,
  b.stgrd AS ReversalReason,
  cast(b.ppnam as fis_ppnam preserving type ) AS ParkedByUser,
  b.ppdat AS ParkingDate,
  b.pptme AS ParkingTime,
  b.brnch AS Branch,
  b.numpg AS NmbrOfPages,
  b.adisc AS IsDiscountDocument,
  b.xref1_hd AS Reference1InDocumentHeader,
  b.xref2_hd AS Reference2InDocumentHeader,
  b.reindat AS InvoiceReceiptDate,
  b.rldnr AS Ledger,
  b.ldgrp AS LedgerGroup,
  cast(b.xblnr_alt as fis_xblnr_alt_alpha preserving type ) AS AlternativeReferenceDocument,
  b.vatdate AS TaxReportingDate,
  b.fulfilldate AS TaxFulfillmentDate,
  b.doccat AS AccountingDocumentClass,
  b.kurst AS ExchangeRateType,
  b.logsystem_sender AS SenderLogicalSystem,
  b.bukrs_sender AS SenderCompanyCode,
  b.belnr_sender AS SenderAccountingDocument,
  b.gjahr_sender AS SenderFiscalYear,
  b.aworg_rev AS ReversalReferenceDocumentCntxt,
  b.awref_rev AS ReversalReferenceDocument,
  b.penrc AS LatePaymentReason,
  b.knumv AS SalesDocumentCondition,
  b.xreversing AS IsReversal,
  b.xreversed AS IsReversed,
  b.glbtgrp AS GLBusinessTransactionGroup,
  b.co_valdt AS CostAccountingValuationDate,
  b.glo_ref1_hd AS JrnlEntryCntrySpecificRef1,
  b.glo_dat1_hd AS JrnlEntryCntrySpecificDate1,
  b.glo_ref2_hd AS JrnlEntryCntrySpecificRef2,
  b.glo_dat2_hd AS JrnlEntryCntrySpecificDate2,
  b.glo_ref3_hd AS JrnlEntryCntrySpecificRef3,
  b.glo_dat3_hd AS JrnlEntryCntrySpecificDate3,
  b.glo_ref4_hd AS JrnlEntryCntrySpecificRef4,
  b.glo_dat4_hd AS JrnlEntryCntrySpecificDate4,
  b.glo_ref5_hd AS JrnlEntryCntrySpecificRef5,
  b.glo_dat5_hd AS JrnlEntryCntrySpecificDate5,
  b.glo_bp1_hd AS JrnlEntryCntrySpecificBP1,
  b.glo_bp2_hd AS JrnlEntryCntrySpecificBP2,
  b.whtdate AS WithholdingTaxReportingDate,
  c.rcomp AS Company
FROM bseg AS a
INNER JOIN bkpf AS b ON /* join condition not captured in parsed metadata */
INNER JOIN t001 AS c ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN E_OperationalAcctgDocItem AS _Extension ON CompanyCode = _Extension.CompanyCode AND FiscalYear = _Extension.FiscalYear AND AccountingDocument = _Extension.AccountingDocument AND AccountingDocumentItem = _Extension.AccountingDocumentItem  -- association [1]
;