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

Field Description Data Type Length Decimals Checktable Data Element
LINE_ID Unique identification of document line NUMC 6 0 MB_LINE_ID
PO_ITEM Item Number of Purchasing Document NUMC 5 0 * EBELP
DELETE_IND Deletion Indicator in Purchasing Document CHAR 1 0 ELOEK
SHORT_TEXT Short Text CHAR 40 0 TXZ01
MATERIAL Material Number (18 Characters) CHAR 18 0 MATNR18
MATERIAL_EXTERNAL Long Material Number for MATERIAL Field CHAR 40 0 MGV_MATERIAL_EXTERNAL
MATERIAL_GUID External GUID for MATERIAL Field CHAR 32 0 MGV_MATERIAL_GUID
MATERIAL_VERSION Version Number for MATERIAL Field CHAR 10 0 MGV_MATERIAL_VERSION
EMATERIAL Material Number (18 Characters, Compatibility Mode) CHAR 18 0 EMATNR18
EMATERIAL_EXTERNAL Long Material Number for MATERIAL Field CHAR 40 0 MGV_MATERIAL_EXTERNAL
EMATERIAL_GUID External GUID for MATERIAL Field CHAR 32 0 MGV_MATERIAL_GUID
EMATERIAL_VERSION Version Number for MATERIAL Field CHAR 10 0 MGV_MATERIAL_VERSION
PLANT Plant CHAR 4 0 * EWERK
STGE_LOC Storage location CHAR 4 0 * LGORT_D
TRACKINGNO Requirement Tracking Number CHAR 10 0 BEDNR
MATL_GROUP Material Group CHAR 9 0 MATKL
INFO_REC Number of purchasing info record CHAR 10 0 INFNR
VEND_MAT Material Number Used by Supplier CHAR 35 0 IDNLF
QUANTITY Purchase Order Quantity QUAN 13 3 BSTMG
PO_UNIT Purchase Order Unit of Measure UNIT 3 0 * BSTME
PO_UNIT_ISO Order unit in ISO code CHAR 3 0 * BSTME_ISO
ORDERPR_UN Order Price Unit (Purchasing) UNIT 3 0 * BBPRM
ORDERPR_UN_ISO ISO code for purchase order price unit CHAR 3 0 * BBPRM_ISO
CONV_NUM1 Numerator for Conversion of Order Price Unit into Order Unit DEC 5 0 BPUMZ
CONV_DEN1 Denominator for Conv. of Order Price Unit into Order Unit DEC 5 0 BPUMN
NET_PRICE Currency amount for BAPIS (with 9 decimal places) DEC 28 9 BAPICUREXT
PRICE_UNIT Price unit DEC 5 0 EPEIN
GR_PR_TIME Goods receipt processing time in days DEC 3 0 WEBAZ
TAX_CODE Tax on sales/purchases code CHAR 2 0 * MWSKZ
BON_GRP1 Settlement Group 1 (Purchasing) CHAR 2 0 EBONU
QUAL_INSP Stock Type CHAR 1 0 INSMK
Unrestricted use
S Blocked stock
X Quality inspection
INFO_UPD Indicator: Update Info Record CHAR 1 0 SPINF
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 CHAR 1 0 PRSDR
EST_PRICE Indicator: Estimated Price CHAR 1 0 SCHPR
REMINDER1 Number of Days for First Reminder/Expediter DEC 3 0 MAHN1
REMINDER2 Number of Days for Second Reminder/Expediter DEC 3 0 MAHN2
REMINDER3 Number of Days for Third Reminder/Expediter DEC 3 0 MAHN3
OVER_DLV_TOL Overdelivery Tolerance DEC 3 1 UEBTO
UNLIMITED_DLV Unlimited Overdelivery Allowed CHAR 1 0 UEBTK
UNDER_DLV_TOL Underdelivery Tolerance DEC 3 1 UNTTO
VAL_TYPE Valuation Type CHAR 10 0 * BWTAR_D
NO_MORE_GR "Delivery Completed" Indicator CHAR 1 0 ELIKZ
FINAL_INV Final Invoice Indicator CHAR 1 0 EREKZ
ITEM_CAT Item category in purchasing document CHAR 1 0 * PSTYP
ACCTASSCAT Account Assignment Category CHAR 1 0 * KNTTP
DISTRIB Distribution Indicator for Multiple Account Assignment CHAR 1 0 VRTKZ
Single Account Assignment
1 Distrib. on Quantity Basis
2 Distribution by Percentage
3 Distribution by Amount
PART_INV Partial invoice indicator CHAR 1 0 TWRKZ
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 CHAR 1 0 WEPOS
GR_NON_VAL Goods Receipt, Non-Valuated CHAR 1 0 WEUNB
IR_IND Invoice receipt indicator CHAR 1 0 REPOS
FREE_ITEM Free Item CHAR 1 0 UMSON
GR_BASEDIV Indicator: GR-Based Invoice Verification CHAR 1 0 WEBRE
ACKN_REQD Order Acknowledgment Requirement CHAR 1 0 KZABS
ACKNOWL_NO Order Acknowledgment Number CHAR 20 0 LABNR
AGREEMENT Number of principal purchase agreement CHAR 10 0 * KONNR
AGMT_ITEM Item number of principal purchase agreement NUMC 5 0 * KTPNR
SHIPPING Shipping Instructions CHAR 2 0 * EVERS
CUSTOMER Customer CHAR 10 0 * EKUNNR
COND_GROUP Condition Group with Supplier CHAR 4 0 EKKOG
NO_DISCT Item Does Not Qualify for Cash Discount CHAR 1 0 ESKTOF
PLAN_DEL Planned Delivery Time in Days DEC 3 0 EPLIF
NET_WEIGHT Net Weight QUAN 13 3 ENTGE
WEIGHTUNIT Unit of Weight UNIT 3 0 * EGEWE
WEIGHTUNIT_ISO ISO code for unit of weight CHAR 3 0 * EGEWE_ISO
TAXJURCODE Tax Jurisdiction CHAR 15 0 * TXJCD
CTRL_KEY Control Key for Quality Management in Procurement CHAR 8 0 * QSSPUR
CONF_CTRL Confirmation Control Key CHAR 4 0 * BSTAE
REV_LEV Revision Level CHAR 2 0 REVLV
FUND Fund CHAR 10 0 * BP_GEBER
FUNDS_CTR Funds Center CHAR 16 0 * FISTL
CMMT_ITEM Commitment Item CHAR 14 0 FMFPO FIPOS
PRICEDATE Price Determination (Pricing) Date Control CHAR 1 0 MEPRF
No Control
1 Purchase Order Date
2 Delivery Date
3 Current Date
4 Manual
5 GR/Post. Date
6 GR/Doc. Date
PRICE_DATE Date of Price Determination DATS 8 0 PREDT
GROSS_WT Gross weight QUAN 13 3 BRGEW
VOLUME Volume QUAN 13 3 VOLUM
VOLUMEUNIT Volume unit UNIT 3 0 T006 VOLEH
VOLUMEUNIT_ISO Volume unit in ISO code CHAR 3 0 * VOLEH_ISO
INCOTERMS1 Incoterms (Part 1) CHAR 3 0 TINC INCO1
INCOTERMS2 Incoterms (Part 2) CHAR 28 0 INCO2
PRE_VENDOR Prior Supplier CHAR 10 0 LFA1 KOLIF
VEND_PART Supplier Subrange CHAR 6 0 WYT1 LTSNR
HL_ITEM Higher-Level Item in Purchasing Documents NUMC 5 0 EKPO UEBPO
GR_TO_DATE Latest Possible Goods Receipt DATS 8 0 LEWED
SUPP_VENDOR Supplier to be Supplied/Who is to Receive Delivery CHAR 10 0 LFA1 EMLIF
SC_VENDOR Subcontracting Supplier CHAR 1 0 LBLKZ
KANBAN_IND Kanban Indicator CHAR 1 0 KBNKZ
X Replenishment Element for Kanban
Y Scheduling Agreement for Summarized JIT Call
Z Scheduling Agreement for JIT calls
ERS Evaluated Receipt Settlement (ERS) CHAR 1 0 XERSY
R_PROMO Promotion CHAR 10 0 WAKH WAKTION
POINTS Number of Points QUAN 13 3 ANZPU
POINT_UNIT Points Unit UNIT 3 0 * PUNEI
POINT_UNIT_ISO ISO code for points unit CHAR 3 0 * PUNEI_ISO
SEASON Season Category CHAR 4 0 * SAISO
SEASON_YR Season Year CHAR 4 0 SAISJ
BON_GRP2 Settlement Group 2 (Rebate Settlement, Purchasing) CHAR 2 0 EBON2
BON_GRP3 Settlement Group 3 (Rebate Settlement, Purchasing) CHAR 2 0 EBON3
SETT_ITEM Item Relevant to Subsequent (Period-End Rebate) Settlement CHAR 1 0 EBONY
MINREMLIFE Minimum Remaining Shelf Life DEC 4 0 MHDRZ
RFQ_NO RFQ Number CHAR 10 0 * ANFNR
RFQ_ITEM Item Number of RFQ NUMC 5 0 * ANFPS
PREQ_NO Purchase Requisition Number CHAR 10 0 BANFN
PREQ_ITEM Item number of purchase requisition NUMC 5 0 * BNFPO
REF_DOC Reference Document Number CHAR 10 0 * REFBS
REF_ITEM Item of reference document NUMC 5 0 * REFPS
SI_CAT Subitem Category, Purchasing Document CHAR 1 0 * UPTYP
RET_ITEM Returns Item CHAR 1 0 RETPO
AT_RELEV Relevant to Allocation Table CHAR 1 0 AUREL
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 CHAR 3 0 * BSGRU
BRAS_NBM Brazilian NCM Code CHAR 16 0 J_1BNBMCO1
MATL_USAGE Usage of the material CHAR 1 0 J_1BMATUSE
0 Resale
1 Industrialisation
2 Consumption
3 Asset
4 Consumption for Main Activity
MAT_ORIGIN Origin of the material CHAR 1 0 J_1BMATORG
0 National - except indicated for codes 3, 4, 5 or 8
1 Foreign - imported directly
2 Foreign - acquired nationally
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 CHAR 1 0 J_1BOWNPRO
INDUS3 Material CFOP category CHAR 2 0 J_1BINDUS3
00 material
01 electricity
02 communication
03 transportation
04 animal
INF_INDEX Inflation Index CHAR 5 0 J_1AINFT20 J_1AINDXP
UNTIL_DATE Inflation Index Date DATS 8 0 J_1AIDATEP
DELIV_COMPL "Outward Delivery Completed" Indicator CHAR 1 0 EGLKZ
PART_DELIV Partial Delivery at Item Level (Stock Transfer) CHAR 1 0 KZTUL
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 CHAR 1 0 NOVET
PREQ_NAME Name of requisitioner/requester CHAR 12 0 AFNAM
PERIOD_IND_EXPIRATION_DATE Period Indicator for Shelf Life Expiration Date CHAR 1 0 DATTP
Day
1 Week
2 Month
3 Year
INT_OBJ_NO Configuration (internal object number) NUMC 18 0 CUOBJ
PCKG_NO Package number NUMC 10 0 ESLH PACKNO
BATCH Batch Number CHAR 10 0 * CHARG_D
VENDRBATCH Supplier Batch Number CHAR 15 0 LICHN
CALCTYPE Pricing Type CHAR 1 0 KNPRS
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
A Copy price elements and redetermine scales
B Carry out new pricing
C Copy manual price elements and redetermine the others
D Copy price elements unchanged
E Copy price elements and fix values
F Copy price elements, turn value and fix
G Copy price elements unchanged and redetermine taxes
H Redetermine freight conditions
I Redetermine rebate conditions
J Redetermine confirmed purch. net price / value (KNTYP=d)
K Copy price elements and cost. Redetermine taxes.
M Copy price elements, turn value
N Copy price elements unchanged, new cost
O Redetermine variant conditions (KNTYP=O)
Q Redetermine calculation conditions (KNTYP=Q)
R Copy price elements and rebate conditions. Redetermine taxes
S Ship & Debit (IBU HiTec)
U Redetermine precious metal conditions (KNTYP=U)
X Customer reserve X
Y Customer reserve Y
Z Customer reserve Z
GRANT_NBR Grant CHAR 20 0 GM_GRANT_NBR
CMMT_ITEM_LONG Commitment Item CHAR 24 0 * FM_FIPEX
FUNC_AREA_LONG Functional Area CHAR 16 0 * FKBER
NO_ROUNDING Indicator: suppress rounding in purchase order item CHAR 1 0 NO_ROUNDING
PO_PRICE Price Adoption: 1 = Gross, 2 = Net CHAR 1 0 BAPI_PO_PRICE
SUPPL_STLOC Issuing Storage Location for Stock Transport Order CHAR 4 0 * RESLO
SRV_BASED_IV Indicator for Service-Based Invoice Verification CHAR 1 0 LEBRE
FUNDS_RES Document Number for Earmarked Funds CHAR 10 0 * KBLNR_FI
RES_ITEM Earmarked Funds: Document Item NUMC 3 0 * KBLPOS
ORIG_ACCEPT Acceptance At Origin CHAR 1 0 WEORA
ALLOC_TBL Allocation Table CHAR 10 0 * ABELN
ALLOC_TBL_ITEM Allocation Table Item NUMC 5 0 * ABELP
SRC_STOCK_TYPE Stock Type of Source Storage Location in STO CHAR 1 0 /SPE/INSMK_SRC
REASON_REJ Reason for rejection of quotations and sales orders CHAR 2 0 ABGRU
CRM_SALES_ORDER_NO CRM Sales Order Number for TPOP Process CHAR 10 0 /SPE/VBELN_CRM
CRM_SALES_ORDER_ITEM_NO CRM Sales Order Item Number in TPOP Process NUMC 6 0 /SPE/POSNR_CRM
CRM_REF_SALES_ORDER_NO CRM Reference Order Number for TPOP Process CHAR 35 0 /SPE/REF_VBELN_CRM
CRM_REF_SO_ITEM_NO CRM Reference Sales Order Item Number in TPOP Process CHAR 6 0 /SPE/REF_POSNR_CRM
PRIO_URGENCY Requirement Urgency NUMC 2 0 * PRIO_URG
PRIO_REQUIREMENT Requirement Priority NUMC 3 0 PRIO_REQ
000 Restriction Due to APO (Format INT1); 000 Only Internal
REASON_CODE Goods Receipt Reason Code CHAR 4 0 /SAPPSPRO/_GR_REASON_CODE
FUND_LONG Long Fund (Obsolete) CHAR 20 0 FM_FUND_LONG
LONG_ITEM_NUMBER Hierarchy Number CHAR 40 0 EXLIN
EXTERNAL_SORT_NUMBER External Sort Number NUMC 5 0 EXSNR
EXTERNAL_HIERARCHY_TYPE External Hierarchy Category CHAR 4 0 * EHTYP
RETENTION_PERCENTAGE Retention in Percent DEC 5 2 RETPZ
DOWNPAY_TYPE Down Payment Indicator CHAR 4 0 ME_DPTYP
DOWNPAY_AMOUNT Down Payment Amount in BAPI DEC 23 4 BAPIMEDOWNPAY
DOWNPAY_PERCENT Down Payment Percentage DEC 5 2 ME_DPPCNT
DOWNPAY_DUEDATE Due Date for Down Payment DATS 8 0 ME_DPDDAT
EXT_RFX_NUMBER Document Number of External Document CHAR 35 0 ME_PUR_EXT_DOC_ID
EXT_RFX_ITEM Item Number of External Document CHAR 10 0 ME_PUR_EXT_DOC_ITEM_ID
EXT_RFX_SYSTEM Logical System CHAR 10 0 * LOGSYSTEM
SRM_CONTRACT_ID Central Contract CHAR 10 0 SRM_CONTRACT_ID
SRM_CONTRACT_ITM Central Contract Item Number NUMC 10 0 SRM_CONTRACT_ITEM
BUDGET_PERIOD Budget Period CHAR 10 0 * FM_BUDGET_PERIOD
BLOCK_REASON_ID Blocking Reason - ID CHAR 4 0 BLK_REASON_ID
BLOCK_REASON_TEXT Blocking Reason - Text CHAR 40 0 BLK_REASON_TXT
SPE_CRM_FKREL Billing Relevance CRM CHAR 1 0 /SPE/FKREL_CRM
DATE_QTY_FIXED Delivery Date and Quantity Fixed CHAR 1 0 ME_FIXMG
Not Fixed
P Fixed for Planning
X Fixed for Planning and Rescheduling
GI_BASED_GR Indicator for GI-based goods receipt CHAR 1 0 WABWE
SHIPTYPE Shipping Type CHAR 2 0 * VERSART
HANDOVERLOC Location for a physical handover of goods CHAR 10 0 HANDOVER_LOC
TC_AUT_DET Tax Code Automatically Determined CHAR 2 0 * J_1BTC_AUT_DET
MANUAL_TC_REASON Manual Tax Code Reason CHAR 2 0 * J_1BMANUAL_TC_REASON
FISCAL_INCENTIVE Tax Incentive Type CHAR 4 0 * J_1BFISCAL_INCENTIVE_CODE
FISCAL_INCENTIVE_ID Incentive ID CHAR 4 0 * J_1BFISCAL_INCENTIVE_ID
TAX_SUBJECT_ST Tax Subject to Substituição Tributária CHAR 1 0 J_1BTC_TAX_SUBJECT_ST
REQ_SEGMENT Requirement Segment CHAR 16 0 SGT_RCAT16
STK_SEGMENT Stock Segment CHAR 16 0 SGT_SCAT16
SF_TXJCD Jurisdiction Code of the Point of Origin CHAR 15 0 * J_1BCTE_SJCD
INCOTERMS2L Incoterms Location 1 CHAR 70 0 INCO2_L
INCOTERMS3L Incoterms Location 2 CHAR 70 0 INCO3_L
MATERIAL_LONG Material No. CHAR 40 0 * MATNR40
EMATERIAL_LONG Material Number (40 Characters, Technical Requirement) CHAR 40 0 * EMATNR40
SERVICEPERFORMER Service Performer CHAR 10 0 * SERVICEPERFORMER
PRODUCTTYPE Product Type Group CHAR 2 0 PRODUCT_TYPE
STARTDATE Start Date for Period of Performance DATS 8 0 MMPUR_SERVPROC_PERIOD_START
ENDDATE End Date for Period of Performance DATS 8 0 MMPUR_SERVPROC_PERIOD_END
REQ_SEG_LONG Requirement Segment CHAR 40 0 SGT_RCAT40
STK_SEG_LONG Stock Segment CHAR 40 0 SGT_SCAT40
EXPECTED_VALUE Currency amount for BAPIS (with 9 decimal places) DEC 28 9 BAPICUREXT
LIMIT_AMOUNT Currency amount for BAPIS (with 9 decimal places) DEC 28 9 BAPICUREXT
EXT_REF External Reference ID CHAR 70 0 MMPUR_EXTERNALREFERENCEID
GL_ACCOUNT G/L Account Number CHAR 10 0 SAKNR
COSTCENTER Cost Center CHAR 10 0 * KOSTL
WBS_ELEMENT Work Breakdown Structure Element (WBS Element) CHAR 24 0 PS_POSID
COMMODITY_CODE Commodity Code CHAR 30 0 /SAPSLL/COMCO
INTRASTAT_SERVICE_CODE Intrastat Service Code CHAR 30 0 /SAPSLL/ISVCO
CONTRACT_FOR_LIMIT Purchase Contract for Enhanced Limit CHAR 10 0 * CTR_FOR_LIMIT
TAXCALCDATE Date for Determining Tax Rates DATS 8 0 TXDAT
TAXCOUNTRY Tax Reporting Country/Region CHAR 3 0 FOT_TAX_COUNTRY
STATUS_PCS Product Compliance Supplier Check Status (Item) CHAR 1 0 MMPUR_PC_STATUS_PCS
OK – Not Relevant
A OK – Approved
B OK – Approved as Exemption
C Blocked – By Supplier
D Blocked – Not approved as Exemption
G Blocked – Decision Pending
STATUS_PMA Product Marketability Status (Item) CHAR 1 0 MMPUR_PC_STATUS_PMA
OK – Not Relevant
A OK – Approved
B OK – Approved as Exemption
C Blocked – By Destination Country
D Blocked – Not approved as Exemption
G Blocked – Decision Pending
STATUS_DG Dangerous Goods Status (Item) CHAR 1 0 MMPUR_PC_STATUS_DG
OK – Not Relevant
A OK – No Dangerous Goods
B OK – Transport Allowed
C Warning – Transport Restricted
F Blocked – Transport Forbidden
G Blocked – Decision Pending
STATUS_SDS Safety Data Sheet Status (Item) CHAR 1 0 MMPUR_PC_STATUS_SDS
OK – Not Relevant
A OK – Not Required
B OK – Available
C Warning – Request Pending
D OK - Approved as Exemption
E Blocked - Data Missing
F Blocked – Not Approved as Exemption
G Blocked – Decision Pending
TXS_BUSINESS_TRANSACTION Tax Service Business Transaction CHAR 4 0 TXS_BUSINESS_TRANSACTION
TXS_USAGE_PURPOSE Tax Service Usage Purpose CHAR 25 0 TXS_USAGE_PURPOSE

ADPIC_S_POITEM foreign key relationships

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