SAP ABAP Table ADPIC_S_POITEM (PO Item with identifier for the parsing to BAPI_PO_CHANGE)

Hierarchy

☛ ECC-DIMP (Software Component) DIMP
   ⤷ IS-AD-MPN (Application Component) Manufacturer Part Number
     ⤷ ADPIC (Package) A&D Parts Interchangeability Enhancements

Basic Data

Table Category	INTTAB	Structure
Structure	ADPIC_S_POITEM	Table Relationship Diagram
Short Description	PO Item with identifier for the parsing to BAPI_PO_CHANGE

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	LINE_ID	☐	MB_LINE_ID	MB_LINE_ID	NUMC	6	0	Unique identification of document line
2	.INCLUDE	☐				0	0	Purchase Order Item
3	PO_ITEM	☐	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	*
4	DELETE_IND	☐	ELOEK	ELOEK	CHAR	1	0	Deletion indicator in purchasing document
5	SHORT_TEXT	☐	TXZ01	TEXT40	CHAR	40	0	Short Text
6	MATERIAL	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
7	MATERIAL_EXTERNAL	☐	MGV_MATERIAL_EXTERNAL	MATNR_EXT	CHAR	40	0	Long Material Number for MATERIAL Field
8	MATERIAL_GUID	☐	MGV_MATERIAL_GUID	MATNR_EGUID	CHAR	32	0	External GUID for MATERIAL Field
9	MATERIAL_VERSION	☐	MGV_MATERIAL_VERSION	MATNR_VERS	CHAR	10	0	Version Number for MATERIAL Field
10	EMATERIAL	☐	EMATNR	MATNR	CHAR	18	0	Material number	*
11	EMATERIAL_EXTERNAL	☐	MGV_MATERIAL_EXTERNAL	MATNR_EXT	CHAR	40	0	Long Material Number for MATERIAL Field
12	EMATERIAL_GUID	☐	MGV_MATERIAL_GUID	MATNR_EGUID	CHAR	32	0	External GUID for MATERIAL Field
13	EMATERIAL_VERSION	☐	MGV_MATERIAL_VERSION	MATNR_VERS	CHAR	10	0	Version Number for MATERIAL Field
14	PLANT	☐	EWERK	WERKS	CHAR	4	0	Plant	*
15	STGE_LOC	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	*
16	TRACKINGNO	☐	BEDNR	CHAR10	CHAR	10	0	Requirement Tracking Number
17	MATL_GROUP	☐	MATKL	MATKL	CHAR	9	0	Material Group	*
18	INFO_REC	☐	INFNR	INFNR	CHAR	10	0	Number of purchasing info record	*
19	VEND_MAT	☐	IDNLF	IDNEX	CHAR	35	0	Material Number Used by Vendor
20	QUANTITY	☐	BSTMG	MENG13	QUAN	13	3	Purchase Order Quantity
21	PO_UNIT	☐	BSTME	MEINS	UNIT	3	0	Order unit	*
22	PO_UNIT_ISO	☐	BSTME_ISO	ISOCD_UNIT	CHAR	3	0	Order unit in ISO code	*
23	ORDERPR_UN	☐	BBPRM	MEINS	UNIT	3	0	Order Price Unit (purchasing)	*
24	ORDERPR_UN_ISO	☐	BBPRM_ISO	ISOCD_UNIT	CHAR	3	0	ISO Code for Purchase Order Price Unit	*
25	CONV_NUM1	☐	BPUMZ	UMBSZ	DEC	5	0	Numerator for Conversion of Order Price Unit into Order Unit
26	CONV_DEN1	☐	BPUMN	UMBSN	DEC	5	0	Denominator for Conv. of Order Price Unit into Order Unit
27	NET_PRICE	☐	BAPICUREXT	BAPICUREXT	DEC	28	9	Currency amount for BAPIS (with 9 decimal places)
28	PRICE_UNIT	☐	EPEIN	DEC5	DEC	5	0	Price unit
29	GR_PR_TIME	☐	WEBAZ	DEC3	DEC	3	0	Goods receipt processing time in days
30	TAX_CODE	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	*
31	BON_GRP1	☐	EBONU	EBONU	CHAR	2	0	Settlement Group 1 (Purchasing)
32	QUAL_INSP	☐	INSMK	INSMK	CHAR	1	0	Stock Type
33	INFO_UPD	☐	SPINF	SPINF	CHAR	1	0	Indicator: Update Info Record
34	PRNT_PRICE	☐	PRSDR	XFELD	CHAR	1	0	Price Printout
35	EST_PRICE	☐	SCHPR	XFELD	CHAR	1	0	Indicator: Estimated Price
36	REMINDER1	☐	MAHN1	MAHNT	DEC	3	0	Number of Days for First Reminder/Expediter
37	REMINDER2	☐	MAHN2	MAHNT	DEC	3	0	Number of Days for Second Reminder/Expediter
38	REMINDER3	☐	MAHN3	MAHNT	DEC	3	0	Number of Days for Third Reminder/Expediter
39	OVER_DLV_TOL	☐	UEBTO	PRZ21	DEC	3	1	Overdelivery Tolerance Limit
40	UNLIMITED_DLV	☐	UEBTK	XFELD	CHAR	1	0	Indicator: Unlimited Overdelivery Allowed
41	UNDER_DLV_TOL	☐	UNTTO	PRZ21	DEC	3	1	Underdelivery Tolerance Limit
42	VAL_TYPE	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	*
43	NO_MORE_GR	☐	ELIKZ	XFELD	CHAR	1	0	"Delivery Completed" Indicator
44	FINAL_INV	☐	EREKZ	XFELD	CHAR	1	0	Final Invoice Indicator
45	ITEM_CAT	☐	PSTYP	PSTYP	CHAR	1	0	Item category in purchasing document	*
46	ACCTASSCAT	☐	KNTTP	KNTTP	CHAR	1	0	Account assignment category	*
47	DISTRIB	☐	VRTKZ	VRTKZ	CHAR	1	0	Distribution indicator for multiple account assignment
48	PART_INV	☐	TWRKZ	TWRKZ	CHAR	1	0	Partial invoice indicator
49	GR_IND	☐	WEPOS	XFELD	CHAR	1	0	Goods Receipt Indicator
50	GR_NON_VAL	☐	WEUNB	XFELD	CHAR	1	0	Goods Receipt, Non-Valuated
51	IR_IND	☐	REPOS	XFELD	CHAR	1	0	Invoice receipt indicator
52	FREE_ITEM	☐	UMSON	XFELD	CHAR	1	0	Free Item
53	GR_BASEDIV	☐	WEBRE	XFELD	CHAR	1	0	Indicator: GR-Based Invoice Verification
54	ACKN_REQD	☐	KZABS	XFELD	CHAR	1	0	Order Acknowledgment Requirement
55	ACKNOWL_NO	☐	LABNR	TEXT20	CHAR	20	0	Order Acknowledgment Number
56	AGREEMENT	☐	KONNR	EBELN	CHAR	10	0	Number of principal purchase agreement	*
57	AGMT_ITEM	☐	KTPNR	EBELP	NUMC	5	0	Item number of principal purchase agreement	*
58	SHIPPING	☐	EVERS	EVERS	CHAR	2	0	Shipping Instructions	*
59	CUSTOMER	☐	EKUNNR	KUNNR	CHAR	10	0	Customer	*
60	COND_GROUP	☐	EKKOG	CHAR4	CHAR	4	0	Condition Group with Vendor
61	NO_DISCT	☐	ESKTOF	XFELD	CHAR	1	0	Item Does Not Qualify for Cash Discount
62	PLAN_DEL	☐	EPLIF	DEC3	DEC	3	0	Planned Delivery Time in Days
63	NET_WEIGHT	☐	ENTGE	MENG13	QUAN	13	3	Net Weight
64	WEIGHTUNIT	☐	EGEWE	MEINS	UNIT	3	0	Unit of Weight	*
65	WEIGHTUNIT_ISO	☐	EGEWE_ISO	ISOCD_UNIT	CHAR	3	0	ISO Code for Unit of Weight	*
66	TAXJURCODE	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	*
67	CTRL_KEY	☐	QSSPUR	QSSPUR	CHAR	8	0	Control Key for Quality Management in Procurement	*
68	CONF_CTRL	☐	BSTAE	BSTAE	CHAR	4	0	Confirmation Control Key	*
69	REV_LEV	☐	REVLV	REVLV	CHAR	2	0	Revision level
70	FUND	☐	BP_GEBER	BP_GEBER	CHAR	10	0	Fund	*
71	FUNDS_CTR	☐	FISTL	FISTL	CHAR	16	0	Funds Center	*
72	CMMT_ITEM	☐	FIPOS	FIPOS	CHAR	14	0	Commitment Item	FMFPO
73	PRICEDATE	☐	MEPRF	MEPRF	CHAR	1	0	Price Determination (Pricing) Date Control
74	PRICE_DATE	☐	PREDT	DATUM	DATS	8	0	Date of Price Determination
75	GROSS_WT	☐	BRGEW	MENG13	QUAN	13	3	Gross weight
76	VOLUME	☐	VOLUM	MENG13	QUAN	13	3	Volume
77	VOLUMEUNIT	☐	VOLEH	MEINS	UNIT	3	0	Volume unit	T006
78	VOLUMEUNIT_ISO	☐	VOLEH_ISO	ISOCD_UNIT	CHAR	3	0	Volume unit in ISO code	*
79	INCOTERMS1	☐	INCO1	INCO1	CHAR	3	0	Incoterms (part 1)	TINC
80	INCOTERMS2	☐	INCO2	INCO2	CHAR	28	0	Incoterms (part 2)
81	PRE_VENDOR	☐	KOLIF	LIFNR	CHAR	10	0	Prior Vendor	LFA1
82	VEND_PART	☐	LTSNR	LTSNR	CHAR	6	0	Vendor Subrange	WYT1
83	HL_ITEM	☐	UEBPO	EBELP	NUMC	5	0	Higher-Level Item in Purchasing Documents	EKPO
84	GR_TO_DATE	☐	LEWED	DATUM	DATS	8	0	Latest Possible Goods Receipt
85	SUPP_VENDOR	☐	EMLIF	LIFNR	CHAR	10	0	Vendor to be supplied/who is to receive delivery	LFA1
86	SC_VENDOR	☐	LBLKZ	XFELD	CHAR	1	0	Subcontracting vendor
87	KANBAN_IND	☐	KBNKZ	KBNKZ	CHAR	1	0	Kanban Indicator
88	ERS	☐	XERSY	XFELD	CHAR	1	0	Evaluated Receipt Settlement (ERS)
89	R_PROMO	☐	WAKTION	WAKTION	CHAR	10	0	Promotion	WAKH
90	POINTS	☐	ANZPU	MENG13	QUAN	13	3	Number of Points
91	POINT_UNIT	☐	PUNEI	MEINS	UNIT	3	0	Points unit	*
92	POINT_UNIT_ISO	☐	PUNEI_ISO	ISOCD_UNIT	CHAR	3	0	ISO Code for Points Unit	*
93	SEASON	☐	SAISO	SAISO	CHAR	4	0	Season Category	*
94	SEASON_YR	☐	SAISJ	CJAHR	CHAR	4	0	Season Year
95	BON_GRP2	☐	EBON2	EBONU	CHAR	2	0	Settlement Group 2 (Rebate Settlement, Purchasing)
96	BON_GRP3	☐	EBON3	EBONU	CHAR	2	0	Settlement Group 3 (Rebate Settlement, Purchasing)
97	SETT_ITEM	☐	EBONY	XFELD	CHAR	1	0	Item Relevant to Subsequent (Period-End Rebate) Settlement
98	MINREMLIFE	☐	MHDRZ	DEC4	DEC	4	0	Minimum Remaining Shelf Life
99	RFQ_NO	☐	ANFNR	EBELN	CHAR	10	0	RFQ Number	*
100	RFQ_ITEM	☐	ANFPS	EBELP	NUMC	5	0	Item Number of RFQ	*
101	PREQ_NO	☐	BANFN	BANFN	CHAR	10	0	Purchase requisition number
102	PREQ_ITEM	☐	BNFPO	BNFPO	NUMC	5	0	Item number of purchase requisition	*
103	REF_DOC	☐	REFBS	EBELN	CHAR	10	0	Reference Document Number	*
104	REF_ITEM	☐	REFPS	EBELP	NUMC	5	0	Item of reference document	*
105	SI_CAT	☐	UPTYP	UPTYP	CHAR	1	0	Subitem Category, Purchasing Document	*
106	RET_ITEM	☐	RETPO	XFELD	CHAR	1	0	Returns Item
107	AT_RELEV	☐	AUREL	AUREL	CHAR	1	0	Relevant to Allocation Table
108	ORDER_REASON	☐	BSGRU	BSGRU	CHAR	3	0	Reason for Ordering
109	BRAS_NBM	☐	J_1BNBMCO1	STEUC	CHAR	16	0	Brazilian NCM Code	*
110	MATL_USAGE	☐	J_1BMATUSE	J_1BMATUSE	CHAR	1	0	Usage of the material
111	MAT_ORIGIN	☐	J_1BMATORG	J_1BMATORG	CHAR	1	0	Origin of the material
112	IN_HOUSE	☐	J_1BOWNPRO	XFELD	CHAR	1	0	Produced in-house
113	INDUS3	☐	J_1BINDUS3	J_1BINDUS3	CHAR	2	0	Material CFOP category
114	INF_INDEX	☐	J_1AINDXP	J_1AINDXP	CHAR	5	0	Inflation Index	J_1AINFT20
115	UNTIL_DATE	☐	J_1AIDATEP	J_1AUDATEP	DATS	8	0	Last day of the time period where the index value is valid
116	DELIV_COMPL	☐	EGLKZ	XFELD	CHAR	1	0	"Outward Delivery Completed" Indicator
117	PART_DELIV	☐	KZTUL	KZTUL	CHAR	1	0	Partial Delivery at Item Level (Stock Transfer)
118	SHIP_BLOCKED	☐	NOVET	XFELD	CHAR	1	0	Item blocked for SD delivery
119	PREQ_NAME	☐	AFNAM	AFNAM	CHAR	12	0	Name of requisitioner/requester
120	PERIOD_IND_EXPIRATION_DATE	☐	DATTP	DATTP	CHAR	1	0	Period Indicator for Shelf Life Expiration Date
121	INT_OBJ_NO	☐	CUOBJ	CUOBJ	NUMC	18	0	Configuration (internal object number)
122	PCKG_NO	☐	PACKNO	PACKNO	NUMC	10	0	Package number	ESLH
123	BATCH	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	*
124	VENDRBATCH	☐	LICHN	LICHN	CHAR	15	0	Vendor Batch Number
125	CALCTYPE	☐	KNPRS	KNPRS	CHAR	1	0	Pricing type
126	GRANT_NBR	☐	GM_GRANT_NBR	GM_GRANT_NBR	CHAR	20	0	Grant
127	CMMT_ITEM_LONG	☐	FM_FIPEX	FM_FIPEX	CHAR	24	0	Commitment item	*
128	FUNC_AREA_LONG	☐	FKBER	FKBER	CHAR	16	0	Functional Area	*
129	NO_ROUNDING	☐	NO_ROUNDING	XFELD	CHAR	1	0	Indicator: Suppress Rounding in Purchase Order Item
130	PO_PRICE	☐	BAPI_PO_PRICE	BPUEB	CHAR	1	0	Price Adoption: 1 = Gross, 2 = Net
131	SUPPL_STLOC	☐	RESLO	LGORT	CHAR	4	0	Issuing Storage Location for Stock Transport Order	*
132	SRV_BASED_IV	☐	LEBRE	XFELD	CHAR	1	0	Indicator for Service-Based Invoice Verification
133	FUNDS_RES	☐	KBLNR_FI	KBLNR	CHAR	10	0	Document number for earmarked funds	*
134	RES_ITEM	☐	KBLPOS	KBLPOS	NUMC	3	0	Earmarked Funds: Document Item	*
135	ORIG_ACCEPT	☐	WEORA	XFELD	CHAR	1	0	Acceptance At Origin
136	ALLOC_TBL	☐	ABELN	ABELN	CHAR	10	0	Allocation Table Number	*
137	ALLOC_TBL_ITEM	☐	ABELP	ABELP	NUMC	5	0	Item number of allocation table	*
138	SRC_STOCK_TYPE	☐	/SPE/INSMK_SRC	INSMK	CHAR	1	0	Stock Type of Source Storage Location in STO
139	REASON_REJ	☐	ABGRU	ABGRU	CHAR	2	0	Reason for rejection of quotations and sales orders
140	CRM_SALES_ORDER_NO	☐	/SPE/VBELN_CRM	/SPE/VBELN_CRM	CHAR	10	0	CRM Sales Order Number for TPOP Process
141	CRM_SALES_ORDER_ITEM_NO	☐	/SPE/POSNR_CRM	/SPE/POSNR_CRM	NUMC	6	0	CRM Sales Order Item Number in TPOP Process
142	CRM_REF_SALES_ORDER_NO	☐	/SPE/REF_VBELN_CRM	/SPE/REF_VBELN_CRM	CHAR	35	0	CRM Reference Order Number for TPOP Process
143	CRM_REF_SO_ITEM_NO	☐	/SPE/REF_POSNR_CRM	/SPE/REF_POSNR_CRM	CHAR	6	0	CRM Reference Sales Order Item Number in TPOP Process
144	PRIO_URGENCY	☐	PRIO_URG	PRIO_URG	NUMC	2	0	Requirement Urgency	*
145	PRIO_REQUIREMENT	☐	PRIO_REQ	PRIO_REQ	NUMC	3	0	Requirement Priority	*
146	REASON_CODE	☐	/SAPPSPRO/_GR_REASON_CODE	/SAPPSPRO/_GR_REASON_CODE	CHAR	4	0	Goods Receipt Reason Code
147	FUND_LONG	☐	FM_FUND_LONG	FM_FUND	CHAR	20	0	Fonds
148	LONG_ITEM_NUMBER	☐	EXLIN	EXLIN	CHAR	40	0	Item Number Length
149	EXTERNAL_SORT_NUMBER	☐	EXSNR	EXSNR	NUMC	5	0	External Sorting
150	EXTERNAL_HIERARCHY_TYPE	☐	EHTYP	EHTYP	CHAR	4	0	External Hierarchy Category	*
151	RETENTION_PERCENTAGE	☐	RETPZ	PRZ32	DEC	5	2	Retention in Percent
152	DOWNPAY_TYPE	☐	ME_DPTYP	ME_DPTYPE_DOMAIN	CHAR	4	0	Down Payment Indicator
153	DOWNPAY_AMOUNT	☐	BAPIMEDOWNPAY	BAPICURR	DEC	23	4	Down Payment Amount in BAPI
154	DOWNPAY_PERCENT	☐	ME_DPPCNT	PRZ32	DEC	5	2	Down Payment Percentage
155	DOWNPAY_DUEDATE	☐	ME_DPDDAT	DATS	DATS	8	0	Due Date for Down Payment
156	EXT_RFX_NUMBER	☐	ME_PUR_EXT_DOC_ID	ME_EXT_DOC_ID	CHAR	35	0	Document Number of External Document
157	EXT_RFX_ITEM	☐	ME_PUR_EXT_DOC_ITEM_ID	ME_EXT_DOC_ITEM_ID	CHAR	10	0	Item Number of External Document
158	EXT_RFX_SYSTEM	☐	LOGSYSTEM	LOGSYS	CHAR	10	0	Logical System	*
159	SRM_CONTRACT_ID	☐	SRM_CONTRACT_ID	BBP_BAPI_EBELN	CHAR	10	0	Central Contract
160	SRM_CONTRACT_ITM	☐	SRM_CONTRACT_ITEM	BBP_ITEMNO	NUMC	10	0	Central Contract Item Number
161	BUDGET_PERIOD	☐	FM_BUDGET_PERIOD	FM_BUDGET_PERIOD	CHAR	10	0	FM: Budget Period	*
162	BLOCK_REASON_ID	☐	BLK_REASON_ID	BLK_REASON_ID	CHAR	4	0	Blocking Reason - ID
163	BLOCK_REASON_TEXT	☐	BLK_REASON_TXT	BLK_REASON_TXT	CHAR	40	0	Blocking Reason - Text
164	SPE_CRM_FKREL	☐	/SPE/FKREL_CRM	FKREL	CHAR	1	0	Billing Relevance CRM
165	DATE_QTY_FIXED	☐	ME_FIXMG	ME_FIXMG	CHAR	1	0	Delivery Date and Quantity Fixed
166	GI_BASED_GR	☐	WABWE	XFELD	CHAR	1	0	Indicator for GI-based goods receipt
167	SHIPTYPE	☐	VERSART	VERSART	CHAR	2	0	Shipping type	*
168	HANDOVERLOC	☐	HANDOVER_LOC	HANDOVER_LOC	CHAR	10	0	Location for a physical handover of goods

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ADPIC_S_POITEM	CMMT_ITEM	FMFPO	FIPOS	REF	C	CN
2	ADPIC_S_POITEM	HL_ITEM	EKPO	EBELP
3	ADPIC_S_POITEM	INCOTERMS1	TINC	INCO1	REF	1	N
4	ADPIC_S_POITEM	INF_INDEX	J_1AINFT20	J_1AINDX	KEY	1	CN
5	ADPIC_S_POITEM	PCKG_NO	ESLH	PACKNO	KEY	1	N
6	ADPIC_S_POITEM	PRE_VENDOR	LFA1	LIFNR	REF	1	CN
7	ADPIC_S_POITEM	R_PROMO	WAKH	AKTNR	KEY	1	N
8	ADPIC_S_POITEM	SUPP_VENDOR	LFA1	LIFNR	KEY	1	N
9	ADPIC_S_POITEM	VEND_PART	WYT1	LTSNR	KEY	1	N
10	ADPIC_S_POITEM	VOLUMEUNIT	T006	MSEHI	REF	1	N

History

Last changed by/on	SAP	20140121
SAP Release Created in	500