Follow us on LinkedIn for your next SAP project

← Back to Search

SAP Table ADPIC_S_POITEM

PO Item with identifier for the parsing to BAPI_PO_CHANGE

ADPIC_S_POITEM (PO Item with identifier for the parsing to BAPI_PO_CHANGE) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link ADPIC_S_POITEM to other SAP tables.

ADPIC_S_POITEM table fields

Field

Data element

Checktable

Datatype

Length

Decimals

Possible values

LINE_ID

Unique identification of document line

MB_LINE_ID

NUMC

PO_ITEM

Item Number of Purchasing Document

EBELP

NUMC

DELETE_IND

Deletion Indicator in Purchasing Document

ELOEK

CHAR

SHORT_TEXT

Short Text

TXZ01

CHAR

MATERIAL

Material Number

MATNR

CHAR

MATERIAL_EXTERNAL

Long Material Number for MATERIAL Field

MGV_MATERIAL_EXTERNAL

CHAR

MATERIAL_GUID

External GUID for MATERIAL Field

MGV_MATERIAL_GUID

CHAR

MATERIAL_VERSION

Version Number for MATERIAL Field

MGV_MATERIAL_VERSION

CHAR

EMATERIAL

Material Number

EMATNR

CHAR

EMATERIAL_EXTERNAL

Long Material Number for MATERIAL Field

MGV_MATERIAL_EXTERNAL

CHAR

EMATERIAL_GUID

External GUID for MATERIAL Field

MGV_MATERIAL_GUID

CHAR

EMATERIAL_VERSION

Version Number for MATERIAL Field

MGV_MATERIAL_VERSION

CHAR

PLANT

Plant

EWERK

CHAR

STGE_LOC

Storage Location

LGORT_D

CHAR

TRACKINGNO

Requirement Tracking Number

BEDNR

CHAR

MATL_GROUP

Material Group

MATKL

CHAR

INFO_REC

Number of Purchasing Info Record

INFNR

CHAR

VEND_MAT

Material Number Used by Vendor

IDNLF

CHAR

QUANTITY

Purchase Order Quantity

BSTMG

QUAN

PO_UNIT

Purchase Order Unit of Measure

BSTME

UNIT

PO_UNIT_ISO

Order unit in ISO code

BSTME_ISO

CHAR

ORDERPR_UN

Order Price Unit (Purchasing)

BBPRM

UNIT

ORDERPR_UN_ISO

ISO code for purchase order price unit

BBPRM_ISO

CHAR

CONV_NUM1

Numerator for Conversion of Order Price Unit into Order Unit

BPUMZ

DEC

CONV_DEN1

Denominator for Conv. of Order Price Unit into Order Unit

BPUMN

DEC

NET_PRICE

Currency amount for BAPIS (with 9 decimal places)

BAPICUREXT

DEC

PRICE_UNIT

Price Unit

EPEIN

DEC

GR_PR_TIME

Goods Receipt Processing Time in Days

WEBAZ

DEC

TAX_CODE

Tax on sales/purchases code

MWSKZ

CHAR

BON_GRP1

Settlement Group 1 (Purchasing)

EBONU

CHAR

QUAL_INSP

Stock Type

INSMK

CHAR

Value	Description
NULL	Unrestricted use
X	Quality inspection
S	Blocked stock

INFO_UPD

Indicator: Update Info Record

SPINF

CHAR

Value	Description
NULL	No update
A	Update with or without plant
B	Update with plant (if no plant ban)
C	Update without plant (if no plant requirement)

PRNT_PRICE

Price Printout

PRSDR

CHAR

Value	Description
X	Yes
NULL	No

EST_PRICE

Indicator: Estimated Price

SCHPR

CHAR

Value	Description
X	Yes
NULL	No

REMINDER1

Number of Days for First Reminder/Expediter

MAHN1

DEC

REMINDER2

Number of Days for Second Reminder/Expediter

MAHN2

DEC

REMINDER3

Number of Days for Third Reminder/Expediter

MAHN3

DEC

OVER_DLV_TOL

Overdelivery Tolerance Limit

UEBTO

DEC

UNLIMITED_DLV

Indicator: Unlimited Overdelivery Allowed

UEBTK

CHAR

Value	Description
X	Yes
NULL	No

UNDER_DLV_TOL

Underdelivery Tolerance Limit

UNTTO

DEC

VAL_TYPE

Valuation Type

BWTAR_D

CHAR

NO_MORE_GR

"Delivery Completed" Indicator

ELIKZ

CHAR

Value	Description
X	Yes
NULL	No

FINAL_INV

Final Invoice Indicator

EREKZ

CHAR

Value	Description
X	Yes
NULL	No

ITEM_CAT

Item Category in Purchasing Document

PSTYP

CHAR

ACCTASSCAT

Account Assignment Category

KNTTP

CHAR

DISTRIB

Distribution indicator for multiple account assignment

VRTKZ

CHAR

Value	Description
NULL	Single account assignment
1	Distrib. on quantity basis
2	Distribution by percentage

PART_INV

Partial Invoice Indicator

TWRKZ

CHAR

Value	Description
NULL	No multiple account assignment
1	Apportion IR quantities to GR quantities one after another
2	Apportion IR quantities to GR quantities proportionately

GR_IND

Goods Receipt Indicator

WEPOS

CHAR

Value	Description
X	Yes
NULL	No

GR_NON_VAL

Goods Receipt, Non-Valuated

WEUNB

CHAR

Value	Description
X	Yes
NULL	No

IR_IND

Invoice Receipt Indicator

REPOS

CHAR

Value	Description
X	Yes
NULL	No

FREE_ITEM

Free Item

UMSON

CHAR

Value	Description
X	Yes
NULL	No

GR_BASEDIV

Indicator: GR-Based Invoice Verification

WEBRE

CHAR

Value	Description
X	Yes
NULL	No

ACKN_REQD

Order Acknowledgment Requirement

KZABS

CHAR

Value	Description
X	Yes
NULL	No

ACKNOWL_NO

Order Acknowledgment Number

LABNR

CHAR

AGREEMENT

Number of Principal Purchase Agreement

KONNR

CHAR

AGMT_ITEM

Item Number of Principal Purchase Agreement

KTPNR

NUMC

SHIPPING

Shipping Instructions

EVERS

CHAR

CUSTOMER

Customer

EKUNNR

CHAR

COND_GROUP

Condition Group with Vendor

EKKOG

CHAR

NO_DISCT

Item Does Not Qualify for Cash Discount

ESKTOF

CHAR

Value	Description
X	Yes
NULL	No

PLAN_DEL

Planned Delivery Time in Days

EPLIF

DEC

NET_WEIGHT

Net Weight

ENTGE

QUAN

WEIGHTUNIT

Unit of Weight

EGEWE

UNIT

WEIGHTUNIT_ISO

ISO code for unit of weight

EGEWE_ISO

CHAR

TAXJURCODE

Tax Jurisdiction

TXJCD

CHAR

CTRL_KEY

Control Key for Quality Management in Procurement

QSSPUR

CHAR

CONF_CTRL

Confirmation Control Key

BSTAE

CHAR

REV_LEV

Revision Level

REVLV

CHAR

FUND

Fund

BP_GEBER

CHAR

FUNDS_CTR

Funds Center

FISTL

CHAR

CMMT_ITEM

Commitment Item

FIPOS

FMFPO

CHAR

PRICEDATE

Price Determination (Pricing) Date Control

MEPRF

CHAR

Value	Description
NULL	No Control
1	Purchase Order Date
2	Delivery Date
3	Current Date
4	Manual
5	GR Date

PRICE_DATE

Date of Price Determination

PREDT

DATS

GROSS_WT

Gross Weight

BRGEW

QUAN

VOLUME

Volume

VOLUM

QUAN

VOLUMEUNIT

Volume unit

VOLEH

T006

UNIT

VOLUMEUNIT_ISO

Volume unit in ISO code

VOLEH_ISO

CHAR

INCOTERMS1

Incoterms (Part 1)

INCO1

TINC

CHAR

INCOTERMS2

Incoterms (Part 2)

INCO2

CHAR

PRE_VENDOR

Prior Vendor

KOLIF

LFA1

CHAR

VEND_PART

Vendor Subrange

LTSNR

WYT1

CHAR

HL_ITEM

Higher-Level Item in Purchasing Documents

UEBPO

EKPO

NUMC

GR_TO_DATE

Latest Possible Goods Receipt

LEWED

DATS

SUPP_VENDOR

Vendor to be supplied/who is to receive delivery

EMLIF

LFA1

CHAR

SC_VENDOR

Subcontracting vendor

LBLKZ

CHAR

Value	Description
X	Yes
NULL	No

KANBAN_IND

Kanban Indicator

KBNKZ

CHAR

Value	Description
X	Replenishment Element for Kanban
Y	Scheduling Agreement for Summarized JIT Call

ERS

Evaluated Receipt Settlement (ERS)

XERSY

CHAR

Value	Description
X	Yes
NULL	No

R_PROMO

Promotion

WAKTION

WAKH

CHAR

POINTS

Number of Points

ANZPU

QUAN

POINT_UNIT

Points unit

PUNEI

UNIT

POINT_UNIT_ISO

ISO code for points unit

PUNEI_ISO

CHAR

SEASON

Season Category

SAISO

CHAR

SEASON_YR

Season Year

SAISJ

CHAR

BON_GRP2

Settlement Group 2 (Rebate Settlement, Purchasing)

EBON2

CHAR

BON_GRP3

Settlement Group 3 (Rebate Settlement, Purchasing)

EBON3

CHAR

SETT_ITEM

Item Relevant to Subsequent (Period-End Rebate) Settlement

EBONY

CHAR

Value	Description
X	Yes
NULL	No

MINREMLIFE

Minimum Remaining Shelf Life

MHDRZ

DEC

RFQ_NO

RFQ Number

ANFNR

CHAR

RFQ_ITEM

Item Number of RFQ

ANFPS

NUMC

PREQ_NO

Purchase Requisition Number

BANFN

CHAR

PREQ_ITEM

Item Number of Purchase Requisition

BNFPO

NUMC

REF_DOC

Reference Document Number

REFBS

CHAR

REF_ITEM

Item of reference document

REFPS

NUMC

SI_CAT

Subitem Category, Purchasing Document

UPTYP

CHAR

RET_ITEM

Returns Item

RETPO

CHAR

Value	Description
X	Yes
NULL	No

AT_RELEV

Relevant to Allocation Table

AUREL

CHAR

Value	Description
NULL	Non-allocation-table-relevant
1	Allocation-table-relevant: placement in storage
2	Allocation-table-relevant: cross-docking
3	Allocation-table-relevant: flow through
4	Allocation-table-relevant: cross docking/flow through
5	Alloc.-table-relevant: cross docking/placement in storage

ORDER_REASON

Reason for Ordering

BSGRU

CHAR

BRAS_NBM

Brazilian NCM Code

J_1BNBMCO1

CHAR

MATL_USAGE

Usage of the material

J_1BMATUSE

CHAR

Value	Description
NULL	Resale
1	Industrialisation
2	Consumption
3	Asset

MAT_ORIGIN

Origin of the material

J_1BMATORG

CHAR

Value	Description
1	Foreign - imported directly
2	Foreign - acquired nationally
NULL	National - except indicated for codes 3, 4, 5 or 8
3	National - with import content over 40% and below/equal 70%
4	National - production with tax incentive
5	National - with import content less than or equal to 40%
6	Foreign - imp direct,no similar nat.,Res.CAMEX & nat.gas
7	Foreign - acquired nat.,no similar nat.,Res.CAMEX & nat.gas
8	National - with import content over 70%

IN_HOUSE

Produced in-house

J_1BOWNPRO

CHAR

Value	Description
X	Yes
NULL	No

INDUS3

Material CFOP category

J_1BINDUS3

CHAR

Value	Description
00	material
01	electricity
02	communication
03	transportation
04	animal

INF_INDEX

Inflation Index

J_1AINDXP

J_1AINFT20

CHAR

UNTIL_DATE

Inflation Index Date

J_1AIDATEP

DATS

DELIV_COMPL

"Outward Delivery Completed" Indicator

EGLKZ

CHAR

Value	Description
X	Yes
NULL	No

PART_DELIV

Partial Delivery at Item Level (Stock Transfer)

KZTUL

CHAR

Value	Description
NULL	Partial delivery allowed
A	Create a delivery with qty. greater than zero
B	Create only one delivery (also with quantity = 0)

SHIP_BLOCKED

Item blocked for SD delivery

NOVET

CHAR

Value	Description
X	Yes
NULL	No

PREQ_NAME

Name of Requisitioner/Requester

AFNAM

CHAR

PERIOD_IND_EXPIRATION_DATE

Period Indicator for Shelf Life Expiration Date

DATTP

CHAR

INT_OBJ_NO

Configuration (internal object number)

CUOBJ

NUMC

PCKG_NO

Package number

PACKNO

ESLH

NUMC

BATCH

Batch Number

CHARG_D

CHAR

VENDRBATCH

Vendor Batch Number

LICHN

CHAR

CALCTYPE

Pricing type

KNPRS

CHAR

Value	Description
A	Copy price components and redetermine scales
B	Carry out new pricing
C	Copy manual pricing elements and redetermine the others
D	Copy pricing elements unchanged
E	Adopt price components and fix values
F	Copy pricing elements, turn value and fix
G	Copy pricing elements unchanged and redetermine taxes
H	Redetermine freight conditions
I	Redetermine rebate conditions
J	Redetermine confirmed purch. net price / value (KNTYP=d)
K	Adopt price components and cose. Redetermine taxes.
M	Copy pricing elements, turn value
N	Transfer pricing components unchanged, new cost
O	Redetermine variant conditions (KNTYP=O)
Q	Redetermine calculation conditions (KNTYP=Q)
R	Apply Price Parts and Bonus Conditions
U	Redetermine precious metal conditions (KNTYP=U)
X	Customer reserve X
Y	Customer reserve Y
Z	Customer reserve Z
1	Customer reserve 1
2	Customer reserve 2
3	Customer reserve 3
4	Customer reserve 4
5	Customer reserve 5
6	Customer reserve 6
7	Customer reserve 7
8	Customer reserve 8
9	Customer reserve 9
S	Ship & Debit (IBU HiTec)

GRANT_NBR

Grant

GM_GRANT_NBR

CHAR

CMMT_ITEM_LONG

Commitment Item

FM_FIPEX

CHAR

FUNC_AREA_LONG

Functional Area

FKBER

CHAR

NO_ROUNDING

Indicator: suppress rounding in purchase order item

NO_ROUNDING

CHAR

Value	Description
X	Yes
NULL	No

PO_PRICE

Price Adoption: 1 = Gross, 2 = Net

BAPI_PO_PRICE

CHAR

Value	Description
NULL	Do not adopt
1	As gross price
2	As net price

SUPPL_STLOC

Issuing Storage Location for Stock Transport Order

RESLO

CHAR

SRV_BASED_IV

Indicator for Service-Based Invoice Verification

LEBRE

CHAR

Value	Description
X	Yes
NULL	No

FUNDS_RES

Document Number for Earmarked Funds

KBLNR_FI

CHAR

RES_ITEM

Earmarked Funds: Document Item

KBLPOS

NUMC

ORIG_ACCEPT

Acceptance At Origin

WEORA

CHAR

Value	Description
X	Yes
NULL	No

ALLOC_TBL

Allocation Table Number

ABELN

CHAR

ALLOC_TBL_ITEM

Item number of allocation table

ABELP

NUMC

SRC_STOCK_TYPE

Stock Type of Source Storage Location in STO

/SPE/INSMK_SRC

CHAR

Value	Description
NULL	Unrestricted use
X	Quality inspection
S	Blocked stock

REASON_REJ

Reason for rejection of quotations and sales orders

ABGRU

CHAR

CRM_SALES_ORDER_NO

CRM Sales Order Number for TPOP Process

/SPE/VBELN_CRM

CHAR

CRM_SALES_ORDER_ITEM_NO

CRM Sales Order Item Number in TPOP Process

/SPE/POSNR_CRM

NUMC

CRM_REF_SALES_ORDER_NO

CRM Reference Order Number for TPOP Process

/SPE/REF_VBELN_CRM

CHAR

CRM_REF_SO_ITEM_NO

CRM Reference Sales Order Item Number in TPOP Process

/SPE/REF_POSNR_CRM

CHAR

PRIO_URGENCY

Requirement Urgency

PRIO_URG

NUMC

PRIO_REQUIREMENT

Requirement Priority

PRIO_REQ

NUMC

Value	Description
000	Restriction Due to APO (Format INT1); 000 Only Internal

REASON_CODE

Goods Receipt Reason Code

/SAPPSPRO/_GR_REASON_CODE

CHAR

FUND_LONG

Long Fund (Obsolete)

FM_FUND_LONG

CHAR

LONG_ITEM_NUMBER

Item Number Length

EXLIN

CHAR

EXTERNAL_SORT_NUMBER

External Sorting

EXSNR

NUMC

EXTERNAL_HIERARCHY_TYPE

External Hierarchy Category

EHTYP

CHAR

RETENTION_PERCENTAGE

Retention in Percent

RETPZ

DEC

DOWNPAY_TYPE

Down Payment Indicator

ME_DPTYP

CHAR

DOWNPAY_AMOUNT

Down Payment Amount in BAPI

BAPIMEDOWNPAY

DEC

DOWNPAY_PERCENT

Down Payment Percentage

ME_DPPCNT

DEC

DOWNPAY_DUEDATE

Due Date for Down Payment

ME_DPDDAT

DATS

EXT_RFX_NUMBER

Document Number of External Document

ME_PUR_EXT_DOC_ID

CHAR

EXT_RFX_ITEM

Item Number of External Document

ME_PUR_EXT_DOC_ITEM_ID

CHAR

EXT_RFX_SYSTEM

Logical System

LOGSYSTEM

CHAR

SRM_CONTRACT_ID

Central Contract

SRM_CONTRACT_ID

CHAR

SRM_CONTRACT_ITM

Central Contract Item Number

SRM_CONTRACT_ITEM

NUMC

BUDGET_PERIOD

FM: Budget Period

FM_BUDGET_PERIOD

CHAR

BLOCK_REASON_ID

Blocking Reason - ID

BLK_REASON_ID

CHAR

BLOCK_REASON_TEXT

Blocking Reason - Text

BLK_REASON_TXT

CHAR

SPE_CRM_FKREL

Billing Relevance CRM

/SPE/FKREL_CRM

CHAR

Value	Description
NULL	Not relevant for billing
A	Delivery-related billing document
B	Relevant for order-related billing - status acc.to order qty
C	Relevant for ord.-related billing - status acc.to target qty
D	Relevant for pro forma
F	Order-related billing doc. - status according to invoice qty
G	Order-related billing of the delivery quantity
H	Delivery-related billing - no zero quantities
I	Order-relevant billing - billing plan
J	Relevant for deliveries across EU countries
K	Delivery-related invoices for partial quantity
L	Pro forma - no zero quantities
M	Delivery-related invoices-no zero qtys (incl main batch itm)
N	Pro forma - no zero quantities (including main batch items)
P	Delivery-related invoices for CSFG - No batch split items
Q	Delivery-related invoices for CRM
R	Delivery-related invoices for CRM - No zero quantities
S	IBS-DI: Order-Related Bill. Doc. with DP w/o Billing Plan
T	Delivery-Related Invoices for CRM with IB in CRM
U	Delivery-Rel. Invoices for CRM with IB in CRM - No Zero Qtys
V	Delivery-Related ICB of Stock Transport Orders in CRM

DATE_QTY_FIXED

Delivery Date and Quantity Fixed

ME_FIXMG

CHAR

Value	Description
NULL	Not Fixed
X	Fixed for Planning and Rescheduling
P	Fixed for Planning

GI_BASED_GR

Indicator for GI-based goods receipt

WABWE

CHAR

Value	Description
X	Yes
NULL	No

SHIPTYPE

Shipping type

VERSART

CHAR

HANDOVERLOC

Location for a physical handover of goods

HANDOVER_LOC

CHAR

ADPIC_S_POITEM foreign key relationships

Table	Field	Foreign key table	Foreign key field	Check table	Check field
ADPIC_S_POITEM	CMMT_ITEM	T001	FIKRS	FMFPO FIFM: Commitment Item	FIKRS
ADPIC_S_POITEM	CMMT_ITEM	ADPIC_S_POITEM	CMMT_ITEM	FMFPO FIFM: Commitment Item	FIPOS
ADPIC_S_POITEM	CMMT_ITEM	SYST	DATLO	FMFPO FIFM: Commitment Item	DATBIS
ADPIC_S_POITEM	CMMT_ITEM	SYST	MANDT	FMFPO FIFM: Commitment Item	MANDT
ADPIC_S_POITEM	HL_ITEM	SYST	MANDT	EKPO Purchasing Document Item	MANDT
ADPIC_S_POITEM	HL_ITEM	EKPO	EBELP	EKPO Purchasing Document Item	EBELN
ADPIC_S_POITEM	HL_ITEM	ADPIC_S_POITEM	HL_ITEM	EKPO Purchasing Document Item	EBELP
ADPIC_S_POITEM	INCOTERMS1	SYST	MANDT	TINC Customers: Incoterms	MANDT
ADPIC_S_POITEM	INCOTERMS1	ADPIC_S_POITEM	INCOTERMS1	TINC Customers: Incoterms	INCO1
ADPIC_S_POITEM	INF_INDEX	SYST	MANDT	J_1AINFT20 Inflation: Index Definition	MANDT
ADPIC_S_POITEM	INF_INDEX	ADPIC_S_POITEM	INF_INDEX	J_1AINFT20 Inflation: Index Definition	J_1AINDX
ADPIC_S_POITEM	PCKG_NO	SYST	MANDT	ESLH Service Package Header Data	MANDT
ADPIC_S_POITEM	PCKG_NO	ADPIC_S_POITEM	PCKG_NO	ESLH Service Package Header Data	PACKNO
ADPIC_S_POITEM	PRE_VENDOR	SYST	MANDT	LFA1 Vendor Master (General Section)	MANDT
ADPIC_S_POITEM	PRE_VENDOR	ADPIC_S_POITEM	PRE_VENDOR	LFA1 Vendor Master (General Section)	LIFNR
ADPIC_S_POITEM	R_PROMO	SYST	MANDT	WAKH Promotion Header Data, IS-R	MANDT
ADPIC_S_POITEM	R_PROMO	ADPIC_S_POITEM	R_PROMO	WAKH Promotion Header Data, IS-R	AKTNR
ADPIC_S_POITEM	SUPP_VENDOR	SYST	MANDT	LFA1 Vendor Master (General Section)	MANDT
ADPIC_S_POITEM	SUPP_VENDOR	ADPIC_S_POITEM	SUPP_VENDOR	LFA1 Vendor Master (General Section)	LIFNR
ADPIC_S_POITEM	VEND_PART	ADPIC_S_POITEM	PRE_VENDOR	WYT1 Vendor Subrange	LIFNR
ADPIC_S_POITEM	VEND_PART	ADPIC_S_POITEM	VEND_PART	WYT1 Vendor Subrange	LTSNR
ADPIC_S_POITEM	VEND_PART	SYST	MANDT	WYT1 Vendor Subrange	MANDT
ADPIC_S_POITEM	VOLUMEUNIT	ADPIC_S_POITEM	VOLUMEUNIT	T006 Units of Measurement	MSEHI
ADPIC_S_POITEM	VOLUMEUNIT	SYST	MANDT	T006 Units of Measurement	MANDT