P_ITEM_BATCH

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 P_ITEM_BATCH.
-- 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: PITEMBATCH

CREATE VIEW P_ITEM_BATCH AS
SELECT
  rbdrseg.rblnr AS SupplierInvoice,
  rbdrseg.rjahr AS FiscalYear,
  rbdrseg.rblgp AS SupplierInvoiceItem,
  rbdrseg.ebeln AS PurchaseOrder,
  rbdrseg.ebelp AS PurchaseOrderItem,
  rbdrseg.werks AS Plant,
  rbdrseg.sgtxt AS SupplierInvoiceItemText,
  rbdrseg.matnr AS PurchaseOrderItemMaterial,
  rbdrseg.meins AS PurchaseOrderQuantityUnit,
  rbdrseg.menge AS QuantityInPurchaseOrderUnit,
  rbdrseg.bprme AS PurchaseOrderPriceUnit,
  rbdrseg.bpmng AS QtyInPurchaseOrderPriceUnit,
  rbdrseg.basme AS StockUnit,
  rbdrseg.kschl AS SuplrInvcDeliveryCostCndnType,
  rbdrseg.stunr AS SuplrInvcDeliveryCostCndnStep,
  rbdrseg.zaehk AS SuplrInvcDeliveryCostCndnCount,
  rbdrseg.wrbtr AS SupplierInvoiceItemAmount,
  rbdrseg.tbtkz AS IsSubsequentDebitCredit,
  rbdrseg.mwskz AS TaxCode,
  rbdrseg.txjcd AS TaxJurisdiction,
  rbdrseg.lfbnr AS ReferenceDocument,
  rbdrseg.lfgja AS ReferenceDocumentFiscalYear,
  rbdrseg.lfpos AS ReferenceDocumentItem,
  cast ( ' ' as konnr preserving type) AS PurchaseContract,
  cast ( '00000' as ktpnr preserving type) AS PurchaseContractItem,
  rbdrseg.shkzg AS DebitCreditCode,
  cast ( ' ' as lifnr preserving type) AS FreightSupplier,
  rbdrseg.xskrl AS IsNotCashDiscountLiable,
  rbdrseg.spgrp AS SuplrInvcItemHasPriceVariance,
  rbdrseg.spgrm AS SuplrInvcItemHasQtyVariance,
  rbdrseg.spgrt AS SuplrInvcItemHasDateVariance,
  rbdrseg.spgrg AS SuplrInvcItemHasOrdPrcQtyVarc,
  rbdrseg.spgrq AS SuplrInvcItemHasOtherVariance,
  rbdrseg.spgrs AS SuplrInvcItemHasAmountOutsdTol,
  rbdrseg.spgrc AS SuplrInvcItmHasQualityVariance,
  rbdrseg.pstyp AS PurchasingDocumentItemCategory,
  rbdrseg.producttype AS ProductType,
  rbdrseg.tax_country AS TaxCountry,
  rbdrseg.bwtar AS InventoryValuationType,
  rbdrseg.bukrs AS SuplrInvcPurgDocItmCompanyCode,
  rbdrseg.erekz AS IsFinallyInvoiced,
  rbdrseg.retamt_fc AS RetentionAmountInDocCurrency,
  rbdrseg.retpc AS RetentionPercentage,
  rbdrseg.retduedt AS RetentionDueDate,
  rbdrseg.hsn_sac AS IN_HSNOrSACCode,
  rbdrseg.customs_val AS IN_CustomDutyAssessableValue,
  rbdrseg.txdat AS TaxDeterminationDate,
  cast ( '00000000' as abap.numc(8) ) AS NL_ChainLiabilityStartDate,
  cast ( '00000000' as abap.numc(8) ) AS NL_ChainLiabilityEndDate,
  cast ( ' ' as wka_descr preserving type ) AS NL_ChainLiabilityDescription,
  cast ( ' ' as wka_despl preserving type ) AS NL_ChainLbltyCnstrctnSiteDesc,
  cast ( 0 as abap.dec(5,2) ) AS NL_ChainLiabilityPercent,
  cast ( '0000000000' as wka_hours preserving type ) AS NL_ChainLiabilityDuration
FROM rbdrseg
;