I_APProcFlwSuplrInvcAcctMaint

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_APProcFlwSuplrInvcAcctMaint.
-- 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: IAPINVACCMNT

CREATE VIEW I_APProcFlwSuplrInvcAcctMaint AS
SELECT
  rbkp.belnr AS SupplierInvoice,
  rbkp.gjahr AS FiscalYear,
  rbkp.root_key AS SupplierInvoiceUUID,
  rbkp.bukrs AS CompanyCode,
  cast( rbkp.bldat as invdt preserving type) AS DocumentDate,
  rbkp.budat AS PostingDate,
  rbkp.reindat AS InvoiceReceiptDate,
  rbkp.xblnr AS SupplierInvoiceIDByInvcgParty,
  rbkp.lifnr AS InvoicingParty,
  rbkp.waers AS DocumentCurrency,
  rbkp.rmwwr AS InvoiceGrossAmount,
  rbkp.xrech AS IsInvoice,
  rbkp.beznk AS UnplannedDeliveryCost,
  rbkp.bktxt AS DocumentHeaderText,
  rbkp.erfnam AS CreatedByUser,
  rbkp.usnam AS LastChangedByUser,
  rbkp.ername AS SuplrInvcExtCreatedByUser,
  rbkp.cpudt AS CreationDate,
  rbkp.wskto AS ManualCashDiscount,
  cast( rbkp.zfbdt as mmiv_zfbdt preserving type ) AS DueCalculationBaseDate,
  rbkp.zbd1p AS CashDiscount1Percent,
  rbkp.zbd1t AS CashDiscount1Days,
  rbkp.zbd2p AS CashDiscount2Percent,
  rbkp.zbd2t AS CashDiscount2Days,
  rbkp.zbd3t AS NetPaymentDays,
  rbkp.zlspr AS PaymentBlockingReason,
  rbkp.blart AS AccountingDocumentType,
  rbkp.rbstat AS SupplierInvoiceStatus,
  rbkp.ivtyp AS SupplierInvoiceOrigin,
  rbkp.business_network_origin AS BusinessNetworkOrigin,
  rbkp.stblg AS ReverseDocument,
  rbkp.stjah AS ReverseDocumentFiscalYear,
  rbkp.vgart AS SuplrInvcTransactionCategory,
  rbkp.lieffn AS SuplrInvcManuallyReducedAmount,
  rbkp.lieffmw AS SuplrInvcManualReductionTaxAmt,
  rbkp.arkuen AS SuplrInvcAutomReducedAmount,
  rbkp.arkuemw AS SuplrInvcAutomReductionTaxAmt,
  rbkp.bvtyp AS BPBankAccountInternalID,
  rbkp.lzbkz AS StateCentralBankPaymentReason,
  rbkp.landl AS SupplyingCountry,
  rbkp.zlsch AS PaymentMethod,
  rbkp.uzawe AS PaymentMethodSupplement,
  rbkp.kidno AS PaymentReference,
  rbkp.rebzg AS InvoiceReference,
  rbkp.rebzj AS InvoiceReferenceFiscalYear,
  rbkp.zbfix AS FixedCashDiscount,
  rbkp.mwskz_bnk AS UnplannedDeliveryCostTaxCode,
  rbkp.txjcd_bnk AS UnplndDelivCostTaxJurisdiction,
  rbkp.zuonr AS AssignmentReference,
  cast ( rbkp.sgtxt as farp_sgtxt preserving type ) AS SupplierPostingLineItemText,
  rbkp.xmwst AS TaxIsCalculatedAutomatically,
  rbkp.bupla AS BusinessPlace,
  rbkp.esrnr AS PaytSlipWthRefSubscriber,
  rbkp.esrpz AS PaytSlipWthRefCheckDigit,
  rbkp.esrre AS PaytSlipWthRefReference,
  rbkp.iseopblocked AS IsEndOfPurposeBlocked,
  rbkp.secco AS BusinessSectionCode,
  rbkp.gsber AS BusinessArea,
  rbkp.txdat AS TaxDeterminationDate,
  rbkp.egmld AS DeliveryOfGoodsReportingCntry,
  rbkp.stceg AS SupplierVATRegistration,
  rbkp.xegdr AS IsEUTriangularDeal,
  rbkp.vatdate AS TaxReportingDate,
  rbkp.tax_country AS TaxCountry,
  rbkp.tax_country_bnk AS UnplndDeliveryCostTaxCountry,
  rbkp.prepay_status AS SuplrInvcPrepaymentStatus,
  rbkp.glo_ref1_hd AS JrnlEntryCntrySpecificRef1,
  rbkp.glo_dat1_hd AS JrnlEntryCntrySpecificDate1,
  rbkp.glo_ref2_hd AS JrnlEntryCntrySpecificRef2,
  rbkp.glo_dat2_hd AS JrnlEntryCntrySpecificDate2,
  rbkp.glo_ref3_hd AS JrnlEntryCntrySpecificRef3,
  rbkp.glo_dat3_hd AS JrnlEntryCntrySpecificDate3,
  rbkp.glo_ref4_hd AS JrnlEntryCntrySpecificRef4,
  rbkp.glo_dat4_hd AS JrnlEntryCntrySpecificDate4,
  rbkp.glo_ref5_hd AS JrnlEntryCntrySpecificRef5,
  rbkp.glo_dat5_hd AS JrnlEntryCntrySpecificDate5,
  rbkp.glo_bp1_hd AS JrnlEntryCntrySpecificBP1,
  rbkp.glo_bp2_hd AS JrnlEntryCntrySpecificBP2
FROM rbkp
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON InvoicingParty = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON DocumentCurrency = _Currency.Currency  -- association [0..1]
;