SAP table TVPOD (Sales Document: Delivery: POD Data)

SAP table TVPOD has 3 primary key fields being MANDT,HANDLE_LIPS,GRUND.

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
MANDT Client CLNT 3 0 MANDT
HANDLE_LIPS Worldwide unique key for LIPS-VBELN & LIPS_POSNR CHAR 22 0 TSEGGUID_LIPS
GRUND Reason for variance in POD CHAR 4 0 TVPODG REACD
HANDLE_LIKP Worldwide unique key for LIKP-VBELN CHAR 22 0 TSEGGUID_LIKP
UE_HANDLE_LIPS Worldwide unique key for LIPS-VBELN & LIPS_POSNR CHAR 22 0 TSEGGUID_LIPS
VBELN Delivery CHAR 10 0 VBELN_VL
POSNR Delivery Item NUMC 6 0 POSNR_VL
LFIMG_DIFF Deviation in quantity actually delivered in sales unit QUAN 13 3 LFIMG_DIFF
VRKME Sales unit UNIT 3 0 T006 VRKME
LGMNG_DIFF Difference in actual delivery quantity in stockkeeping unit QUAN 13 3 LGMNG_DIFF
MEINS Base Unit of Measure UNIT 3 0 T006 MEINS
UMVKZ Numerator (factor) for conversion of sales quantity into SKU DEC 5 0 UMVKZ
UMVKN Denominator (divisor) for conversion of sales Qty into SKU DEC 5 0 UMVKN
PODMG Actual quantity accepted in sales unit per delivery item QUAN 13 3 PODMG
PODMG_LME POD quantity in stockkeeping units QUAN 13 3 PODMG_LME
PODMG_FLO Internal field: actual qty accepted (sales unit) float FLTP 16 16 PODMG_FLO
LGMNG_DIFF_FLO Internal field: difference in actual deliv. qty in SKU float FLTP 16 16 LGMNG_DIFF_FLO
LFIMG Actual quantity delivered (in sales units) QUAN 13 3 LFIMG
LGMNG Actual quantity delivered in stockkeeping units QUAN 13 3 LGMNG
KCMENG_VME Cumulative batch quantity of all split items in sales units QUAN 15 3 KCMENG_VME
KCMENG Cumulative batch quantity of all split items (in StckUnit) QUAN 15 3 KCMENG
CALCU Quantity calculation for POD CHAR 1 0 CALCU
+ Add
- Subtract
MATNR Material Number CHAR 40 0 MARA MATNR
ARKTX Short text for sales order item CHAR 40 0 ARKTX
PODAT Date (Proof of Delivery) DATS 8 0 PODAT
POTIM Confirmation Time TIMS 6 0 POTIM
RUDAT POD verification date DATS 8 0 RUDAT
RUTIM POD verification time TIMS 6 0 RUTIM
FOBEM Subsequent processing quantities CHAR 1 0 FOBEM
FOBEW Subsequent processing values CHAR 1 0 FOBEW
_DATAAGING Data Filter Value for Data Aging DATS 8 0 DATA_TEMPERATURE
/CWM/LFIMG_DIFF POD Variance from Actual Parallel Quantity Delivered QUAN 13 3 /CWM/LFIMG_DIFF
/CWM/LFIME CWM Delivery Unit of Measure UNIT 3 0 * /CWM/LFIME
/CWM/PODMG POD Actual Parallel Quantity Received QUAN 13 3 /CWM/PODMG
/CWM/PODME CWM Delivery Unit of Measure UNIT 3 0 * /CWM/LFIME
/CWM/KCMENG Cumulatd CWM Batch Quantity of all Split Items (in StckUnit) QUAN 15 3 /CWM/KCMENG
/CWM/LFIMG Actual Delivered Quantity in Parallel Unit of Measure QUAN 13 3 /CWM/LFIMG

TVPOD foreign key relationships

Table Field Check Table Check Field
0 TVPOD MATNR MARA General Material Data MANDT
0 TVPOD MATNR MARA General Material Data MATNR
1 TVPOD MEINS T006 Units of Measurement MANDT
1 TVPOD MEINS T006 Units of Measurement MSEHI
0 TVPOD VRKME T006 Units of Measurement MANDT
0 TVPOD VRKME T006 Units of Measurement MSEHI