P_ITEM_ONLINE

CDS View

P_ITEM_ONLINE is a CDS View in S/4HANA. It contains 46 fields. 6 CDS views read from this table.

Used by 6 CDS view(s) 46 fields

CDS Views using this table (6)

ViewTypeJoinVDMDescription
I_APProcFlwRstrcdSuplrInvc view from COMPOSITE Restricted Invoice
I_SuplrInvcItemLogsUnion view from BASIC SI Item union of batch and online items
N_SupplierInvoiceItemPurOrdRef view from Search Model Supplier Invoice Item Purchase Order Reference
P_SUPLRINVCITEMLOGSUNION view from BASIC
P_SuplrInvcItm view from CONSUMPTION Supplier Invoice Item Details
P_SuplrInvcItmOverview view from CONSUMPTION Supplier Invoice Item Overview

Fields (46)

KeyField CDS FieldsUsed in Views
KEY FiscalYear FiscalYear 6
KEY SupplierInvoice PurchasingDocument,SupplierInvoice 6
KEY SupplierInvoiceItem SupplierInvoiceItem 4
DebitCreditCode DebitCreditCode 4
FreightSupplier FreightSupplier 4
IN_HSNOrSACCode IN_HSNOrSACCode 1
InventoryValuationType InventoryValuationType 1
IsFinallyInvoiced IsFinallyInvoiced 1
IsNotCashDiscountLiable IsNotCashDiscountLiable 4
IsSubsequentDebitCredit IsSubsequentDebitCredit 4
Plant Plant 4
ProductType ProductType 1
PurchaseContract PurchaseContract 3
PurchaseContractItem PurchaseContractItem 3
PurchaseOrder PurchaseOrder 4
PurchaseOrderItem PurchaseOrderItem 4
PurchaseOrderItemMaterial PurchaseOrderItemMaterial 4
PurchaseOrderPriceUnit PurchaseOrderPriceUnit 4
PurchaseOrderQuantityUnit PurchaseOrderQuantityUnit 4
PurchasingDocumentItemCategory PurchasingDocumentItemCategory 3
QtyInPurchaseOrderPriceUnit QtyInPurchaseOrderPriceUnit 4
QuantityInPurchaseOrderUnit QuantityInPurchaseOrderUnit 4
ReferenceDocument ReferenceDocument 4
ReferenceDocumentFiscalYear ReferenceDocumentFiscalYear 4
ReferenceDocumentItem ReferenceDocumentItem 4
RetentionAmountInDocCurrency RetentionAmountInDocCurrency 1
RetentionDueDate RetentionDueDate 1
RetentionPercentage RetentionPercentage 1
SuplrInvcDeliveryCostCndnCount SuplrInvcDeliveryCostCndnCount 4
SuplrInvcDeliveryCostCndnStep SuplrInvcDeliveryCostCndnStep 4
SuplrInvcDeliveryCostCndnType SuplrInvcDeliveryCostCndnType 4
SuplrInvcItemHasAmountOutsdTol SuplrInvcItemHasAmountOutsdTol 4
SuplrInvcItemHasDateVariance SuplrInvcItemHasDateVariance 4
SuplrInvcItemHasOrdPrcQtyVarc SuplrInvcItemHasOrdPrcQtyVarc 4
SuplrInvcItemHasOtherVariance SuplrInvcItemHasOtherVariance 4
SuplrInvcItemHasPriceVariance SuplrInvcItemHasPriceVariance 4
SuplrInvcItemHasQtyVariance SuplrInvcItemHasQtyVariance 4
SuplrInvcItmHasQualityVariance SuplrInvcItmHasQualityVariance 4
SuplrInvcItmUnplndDelivCost SuplrInvcItmUnplndDelivCost 1
SuplrInvcPurgDocItmCompanyCode SuplrInvcPurgDocItmCompanyCode 1
SupplierInvoiceItemAmount SupplierInvoiceItemAmount 4
SupplierInvoiceItemText SupplierInvoiceItemText 4
TaxCode TaxCode 4
TaxCountry TaxCountry 1
TaxDeterminationDate TaxDeterminationDate 1
TaxJurisdiction TaxJurisdiction 4 
@AbapCatalog.sqlViewName: 'PITEMONLINE'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@AccessControl.personalData.blocking: #REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #BASIC 
@VDM.private: true
@VDM.lifecycle.contract.type: #NONE
@AbapCatalog.preserveKey:true 

define view P_ITEM_ONLINE
  as select from rseg
{
  key rseg.belnr                           as SupplierInvoice,
  key rseg.gjahr                           as FiscalYear,
  key 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.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,
      //Localization fields

      rseg.hsn_sac                         as IN_HSNOrSACCode,
      rseg.customs_val                     as IN_CustomDutyAssessableValue
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"RSEG"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More