SAP table LIPSPO (LIPS Reference Data Purchase Order)
SAP table LIPSPO has 2 primary key fields being MANDT,HANDLE_ITEM.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
Field
Description
Data Type
Length
Decimals
Checktable
Data Element
Client
CLNT
3
0
MANDT
Worldwide unique key for LIPS-VBELN & LIPS_POSNR
CHAR
22
0
TSEGGUID_LIPS
HANDLE_OBJ
Worldwide unique key for LIKP-VBELN
CHAR
22
0
TSEGGUID_LIKP
PONUM
Purchasing Document Number
CHAR
10
0
EBELN
ITMNO
Item Number of Purchasing Document
NUMC
5
0
EBELP
EKORG
Purchasing organization
CHAR
4
0
EKORG
EKGRP
Purchasing Group
CHAR
3
0
EKGRP
BSTYP
Purchasing Document Category
CHAR
1
0
BSTYP
Possible values
A
Request for quotation
B
Purchase requisition
C
Central Contract
F
Purchase order
I
Info record
K
Contract
L
Scheduling agreement
N
Central Request for Quotation
O
Quotation
Q
Service entry sheet
R
Request for Quotation
S
Simplified service entry sheet
T
Central Quotation
W
Source list
BSART
Order Type (Purchasing)
CHAR
4
0
BSART
BSAKZ
Control indicator for purchasing document type
CHAR
1
0
BSAKZ
Possible values
C
Subordinate Document
H
Hierarchy
R
Purchase requisition for outline agreement
T
Transport
LOEKZ
Asset class marked for deletion
CHAR
1
0
LOEKZ
STATU
Status field string
CHAR
10
0
STATU_VL
BEDAT
Purchase Order Date
DATS
8
0
BEDAT
ELIKZ
"Delivery Completed" Indicator
CHAR
1
0
ELIKZ
PSTYP
Item category in purchasing document
CHAR
1
0
PSTYP
WEPOS
Goods Receipt Indicator
CHAR
1
0
WEPOS
WEUNB
Goods Receipt, Non-Valuated
CHAR
1
0
WEUNB
WEBRE
Indicator: GR-Based Invoice Verification
CHAR
1
0
WEBRE
EILDT
Start Date for GR-Based Settlement
DATS
8
0
EILDT
USR01
Additional data field 1 for delivery schedules
CHAR
35
0
USR01_D
USR02
Additional data field 2 for delivery schedules
CHAR
35
0
USR02_D
USR03
Additional data field 3 for delivery schedules
CHAR
35
0
USR03_D
USR04
Additional data field 4 for delivery schedules
CHAR
10
0
USR04_D
USR05
Additional data field 5 for delivery schedules
CHAR
10
0
USR05_D
_DATAAGING
Data Filter Value for Data Aging
DATS
8
0
DATA_TEMPERATURE
PPRCTR
Partner Profit Center
CHAR
10
0
*
PPRCTR
PARGB
Trading partner's business area
CHAR
4
0
*
PARGB
AUART
Sales Document Type
CHAR
4
0
*
AUART
ANZ_POS_GRKOR
Number of Items in Delivery Group
INT4
10
0
SHP_ANZ_POS_GRKOR
CHARG
Batch Number
CHAR
10
0
*
CHARG_D