P_ITEM_ONLINE

DDL: P_ITEM_ONLINE SQL: PITEMONLINE Type: view BASIC
54 Fields 1 Data Sources

P_ITEM_ONLINE is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (rseg) and exposes 54 fields with key fields SupplierInvoice, FiscalYear, SupplierInvoiceItem.

Data Sources (1)

SourceAliasJoin Type
rseg rseg from

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PITEMONLINE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
VDM.private true view
VDM.lifecycle.contract.type #NONE view

Fields (54)

KeyFieldSource TableSource FieldDescription
KEY SupplierInvoice rseg belnr SD Document
KEY FiscalYear rseg gjahr Settlement Year
KEY SupplierInvoiceItem rseg buzei Posting View Item
PurchaseOrder rseg ebeln Source PurchDoc
PurchaseOrderItem rseg ebelp Item pur. doc.
Plant rseg werks Receiving Plant
SupplierInvoiceItemText rseg sgtxt Text
PurchaseOrderItemMaterial rseg matnr Vehicle Model
PurchaseOrderQuantityUnit rseg bstme Unit.Order
QuantityInPurchaseOrderUnit rseg menge WarrCountValue
PurchaseOrderPriceUnit rseg bprme PO Price Unit
QtyInPurchaseOrderPriceUnit rseg bpmng Qty. in OPUn
StockUnit rseg meins Valuation Unit
SuplrInvcDeliveryCostCndnType rseg kschl Tax Item Type
SuplrInvcDeliveryCostCndnStep rseg stunr Step Number
SuplrInvcDeliveryCostCndnCount rseg zaehk Counter
SupplierInvoiceItemAmount rseg wrbtr Gross Amount
IsSubsequentDebitCredit rseg tbtkz Subseq. Dr/Cr
TaxCode rseg mwskz Tax Code
TaxJurisdiction rseg txjcd Tax Jurisdict.
ReferenceDocument rseg lfbnr Reference Doc.
ReferenceDocumentFiscalYear rseg lfgja Year Cur.Period
ReferenceDocumentItem rseg lfpos Ref. Doc. Item
PurchaseContract rseg erp_contract_id Agreement
PurchaseContractItem rseg erp_contract_itm Agreement Item
DebitCreditCode rseg shkzg Returns
FreightSupplier rseg lifnr Vendor no.
IsNotCashDiscountLiable rseg xskrl W/o CashDsc.
SuplrInvcItemHasPriceVariance rseg spgrp Block.Reas.:Prc
SuplrInvcItemHasQtyVariance rseg spgrm Block.Reas.:Qty
SuplrInvcItemHasDateVariance rseg spgrt Bl. Reason Date
SuplrInvcItemHasOrdPrcQtyVarc rseg spgrg Block.Reas: OPQ
SuplrInvcItemHasOtherVariance rseg spgrq Man.Block.Reasn
SuplrInvcItemHasAmountOutsdTol rseg spgrs Blkg Reas. Amount
SuplrInvcItmHasQualityVariance rseg spgrc Block: Quality
PurchasingDocumentItemCategory rseg pstyp Item Category
ProductType rseg producttype Product Type Group
TaxCountry rseg tax_country Tax Ctry/Rgn
InventoryValuationType rseg bwtar Valuation Type
SuplrInvcItmUnplndDelivCost rseg bnkan DCs share
SuplrInvcPurgDocItmCompanyCode rseg bukrs Value
IsFinallyInvoiced rseg erekz Final Invoice Ind.
RetentionAmountInDocCurrency rseg retamt_fc Retent. in Doc. Crcy
RetentionPercentage rseg retpc Retention %
RetentionDueDate rseg retduedt Due Date
TaxDeterminationDate rseg txdat Tax Date
IN_HSNOrSACCode rseg hsn_sac HSN/SAC Code
IN_CustomDutyAssessableValue rseg customs_val Assessable Val.
NL_ChainLiabilityStartDate rseg enh_date1 WKA Start Date
NL_ChainLiabilityEndDate rseg enh_date2 WKA end date
NL_ChainLiabilityDescription rseg enh_char1 Work descr.
NL_ChainLbltyCnstrctnSiteDesc rseg enh_char2 Construc. site
NL_ChainLiabilityPercent rseg enh_percent Percentage
NL_ChainLiabilityDuration rseg enh_numc1 Wrk. time hours

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_ONLINE.
-- 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: PITEMONLINE

CREATE VIEW P_ITEM_ONLINE AS
SELECT
  rseg.belnr AS SupplierInvoice,
  rseg.gjahr AS FiscalYear,
  rseg.buzei AS SupplierInvoiceItem,
  rseg.ebeln AS PurchaseOrder,
  rseg.ebelp AS PurchaseOrderItem,
  rseg.werks AS Plant,
  rseg.sgtxt AS SupplierInvoiceItemText,
  rseg.matnr AS PurchaseOrderItemMaterial,
  rseg.bstme AS PurchaseOrderQuantityUnit,
  rseg.menge AS QuantityInPurchaseOrderUnit,
  rseg.bprme AS PurchaseOrderPriceUnit,
  rseg.bpmng AS QtyInPurchaseOrderPriceUnit,
  rseg.meins AS StockUnit,
  rseg.kschl AS SuplrInvcDeliveryCostCndnType,
  rseg.stunr AS SuplrInvcDeliveryCostCndnStep,
  rseg.zaehk AS SuplrInvcDeliveryCostCndnCount,
  rseg.wrbtr AS SupplierInvoiceItemAmount,
  rseg.tbtkz AS IsSubsequentDebitCredit,
  rseg.mwskz AS TaxCode,
  rseg.txjcd AS TaxJurisdiction,
  rseg.lfbnr AS ReferenceDocument,
  rseg.lfgja AS ReferenceDocumentFiscalYear,
  rseg.lfpos AS ReferenceDocumentItem,
  rseg.erp_contract_id AS PurchaseContract,
  rseg.erp_contract_itm AS PurchaseContractItem,
  rseg.shkzg AS DebitCreditCode,
  rseg.lifnr AS FreightSupplier,
  rseg.xskrl AS IsNotCashDiscountLiable,
  rseg.spgrp AS SuplrInvcItemHasPriceVariance,
  rseg.spgrm AS SuplrInvcItemHasQtyVariance,
  rseg.spgrt AS SuplrInvcItemHasDateVariance,
  rseg.spgrg AS SuplrInvcItemHasOrdPrcQtyVarc,
  rseg.spgrq AS SuplrInvcItemHasOtherVariance,
  rseg.spgrs AS SuplrInvcItemHasAmountOutsdTol,
  rseg.spgrc AS SuplrInvcItmHasQualityVariance,
  rseg.pstyp AS PurchasingDocumentItemCategory,
  rseg.producttype AS ProductType,
  rseg.tax_country AS TaxCountry,
  rseg.bwtar AS InventoryValuationType,
  rseg.bnkan AS SuplrInvcItmUnplndDelivCost,
  rseg.bukrs AS SuplrInvcPurgDocItmCompanyCode,
  rseg.erekz AS IsFinallyInvoiced,
  rseg.retamt_fc AS RetentionAmountInDocCurrency,
  rseg.retpc AS RetentionPercentage,
  rseg.retduedt AS RetentionDueDate,
  rseg.txdat AS TaxDeterminationDate,
  rseg.hsn_sac AS IN_HSNOrSACCode,
  rseg.customs_val AS IN_CustomDutyAssessableValue,
  rseg.enh_date1 AS NL_ChainLiabilityStartDate,
  rseg.enh_date2 AS NL_ChainLiabilityEndDate,
  rseg.enh_char1 AS NL_ChainLiabilityDescription,
  rseg.enh_char2 AS NL_ChainLbltyCnstrctnSiteDesc,
  rseg.enh_percent AS NL_ChainLiabilityPercent,
  rseg.enh_numc1 AS NL_ChainLiabilityDuration
FROM rseg
;

Learn More