LIPS SAP SD document: Delivery: Item data Table and data
LIPS is a standard SAP Table which is used to store SD document: Delivery: Item data data and is available within R/3 SAP systems depending on the version and release level.
Below is the standard documentation available and a few details of the fields which make up this Table. You can view further information about SAP LIPS Table and the data within it using relevant transactions such as SE11, SE80 or SE16. Also check out the Comments section below to view or add related contributions and example screen shots.
Delivery Class: A - Application table containing master and transaction data
Display/Maintenance via SM30: Yes but with Restrictions
Enhancement category i: Can be enhanced (character-type or numeric)
See here for more information about this and other SAP enhancement categories
==>View Table relationships
SAP LIPS Table fields within data Dictionary
| Field | Data Element | Data Type | length (Decimals) | Check table | Description | Conversion Routine |
| MANDT | MANDT | CLNT | 3 | T000 | Client | |
| VBELN | VBELN_VL | CHAR | 10 | VBUK | Delivery | ALPHA |
| POSNR | POSNR_VL | NUMC | 6 | VBUP | Delivery Item | |
| PSTYV | PSTYV_VL | CHAR | 4 | TVPT | Delivery item category | |
| ERNAM | ERNAM | CHAR | 12 | Name of Person who Created the Object | ||
| ERZET | ERZET | TIMS | 6 | Entry time | ||
| ERDAT | ERDAT | DATS | 8 | Date on Which Record Was Created | ||
| MATNR | MATNR | CHAR | 18 | MARA | Material Number | MATN1 |
| MATWA | MATWA | CHAR | 18 | MARA | Material entered | MATN1 |
| MATKL | MATKL | CHAR | 9 | T023 | Material Group | |
| WERKS | WERKS_D | CHAR | 4 | T001W | Plant | |
| LGORT | LGORT_D | CHAR | 4 | T001L | Storage Location | |
| CHARG | CHARG_D | CHAR | 10 | MCHA | Batch Number | |
| LICHN | LICHN | CHAR | 15 | Vendor Batch Number | ||
| KDMAT | KDMAT | CHAR | 35 | Material belonging to the customer | ||
| PRODH | PRODH_D | CHAR | 18 | T179 | Product hierarchy | |
| LFIMG | LFIMG | QUAN | 13(3) | Actual quantity delivered (in sales units) | ||
| MEINS | MEINS | UNIT | 3 | T006 | Base Unit of Measure | CUNIT |
| VRKME | VRKME | UNIT | 3 | T006 | Sales unit | CUNIT |
| UMVKZ | UMVKZ | DEC | 5 | Numerator (factor) for conversion of sales quantity into SKU | ||
| UMVKN | UMVKN | DEC | 5 | Denominator (Divisor) for Conversion of Sales Qty into SKU | ||
| NTGEW | NTGEW_15 | QUAN | 15(3) | Net weight | ||
| BRGEW | BRGEW_15 | QUAN | 15(3) | Gross weight | ||
| GEWEI | GEWEI | UNIT | 3 | T006 | Weight Unit | CUNIT |
| VOLUM | VOLUM_15 | QUAN | 15(3) | Volume | ||
| VOLEH | VOLEH | UNIT | 3 | T006 | Volume unit | CUNIT |
| KZTLF | KZTLF | CHAR | 1 | Partial delivery at item level | ||
| UEBTK | UEBTK | CHAR | 1 | Indicator: Unlimited Overdelivery Allowed | ||
| UEBTO | UEBTO | DEC | 3(1) | Overdelivery Tolerance Limit | ||
| UNTTO | UNTTO | DEC | 3(1) | Underdelivery Tolerance Limit | ||
| CHSPL | CHSPL | CHAR | 1 | Batch split allowed | ||
| FAKSP | FAKSP | CHAR | 2 | TVFS | Block | |
| MBDAT | MBDAT | DATS | 8 | Material Staging/Availability Date | ||
| LGMNG | LGMNG | QUAN | 13(3) | Actual quantity delivered in stockkeeping units | ||
| ARKTX | ARKTX | CHAR | 40 | Short text for sales order item | ||
| LGPBE | LGPBE | CHAR | 10 | Storage Bin | ||
| VBELV | VBELV | CHAR | 10 | VBUK | Originating document | ALPHA |
| POSNV | POSNV | NUMC | 6 | VBUP | Originating item | |
| VBTYV | VBTYP | CHAR | 1 | SD document category | ||
| VGSYS | VGLOGSYS | CHAR | 10 | TBDLS | Logical System in the Preceding Document | ALPHA |
| VGBEL | VGBEL | CHAR | 10 | VBUK | Document number of the reference document | ALPHA |
| VGPOS | VGPOS | NUMC | 6 | VBUP | Item number of the reference item | |
| UPFLU | UPFLL | CHAR | 1 | Update indicator for delivery document flow | ||
| UEPOS | UEPOS | NUMC | 6 | VBUP | Higher-level item in bill of material structures | |
| FKREL | FKREL | CHAR | 1 | Relevant for Billing | ||
| LADGR | LADGR | CHAR | 4 | TLGR | Loading Group | |
| TRAGR | TRAGR | CHAR | 4 | TTGR | Transportation Group | |
| KOMKZ | KOMKZ | CHAR | 1 | Indicator for picking control | ||
| LGNUM | LGNUM | CHAR | 3 | T300 | Warehouse Number / Warehouse Complex | |
| LISPL | LNSPL_LIPS | CHAR | 1 | Split to warehouse number required | ||
| LGTYP | LGTYP | CHAR | 3 | T301 | Storage Type | |
| LGPLA | LGPLA | CHAR | 10 | LAGP | Storage Bin | |
| BWTEX | BWTEX | CHAR | 1 | Indicator: Separate valuation | ||
| BWART | BWART | CHAR | 3 | T156 | Movement Type (Inventory Management) | |
| BWLVS | BWLVS | NUMC | 3 | T333 | Movement Type for Warehouse Management | |
| KZDLG | LVS_KZDLG | CHAR | 1 | Indicator: dynamic storage bin in warehouse management | ||
| BDART | BDART | CHAR | 2 | Requirement type | ||
| PLART | PLART | CHAR | 1 |
* | Planning type | |
| MTART | MTART | CHAR | 4 | T134 | Material Type | |
| XCHPF | XCHPF | CHAR | 1 | Batch management requirement indicator | ||
| XCHAR | XCHAR | CHAR | 1 | Batch management indicator (internal) | ||
| VGREF | VGREF | CHAR | 1 | Preceding document has resulted from reference | ||
| POSAR | POSAR | CHAR | 1 | Item type | ||
| BWTAR | BWTAR_D | CHAR | 10 | T149D | Valuation Type | |
| SUMBD | SUMBD | CHAR | 1 | Summing up of requirements | ||
| MTVFP | MTVFP | CHAR | 2 | TMVF | Checking Group for Availability Check | |
| EANNR | EANNR | CHAR | 13 | European Article Number (EAN) - obsolete!!!!! | ||
| GSBER | GSBER | CHAR | 4 | TGSB | Business Area | |
| VKBUR | VKBUR | CHAR | 4 | TVBUR | Sales Office | |
| VKGRP | VKGRP | CHAR | 3 | TVKGR | Sales Group | |
| VTWEG | VTWEG | CHAR | 2 | TVTW | Distribution Channel | |
| SPART | SPART | CHAR | 2 | TSPA | Division | |
| GRKOR | GRKOR | NUMC | 3 | Delivery group (items are delivered together) | ||
| FMENG | FMENG | CHAR | 1 | Quantity is Fixed | ||
| ANTLF | ANTLF | DEC | 1 | Maximum Number of Partial Deliveries Allowed Per Item | ||
| VBEAF | VBEAF | DEC | 5(2) | Fixed shipping processing time in days (= setup time) | ||
| VBEAV | VBEAV | DEC | 5(2) | Variable shipping processing time in days | ||
| STAFO | STAFO | CHAR | 6 |
* | Update group for statistics update | ALPHA |
| WAVWR | WAVWR | CURR | 13(2) | Cost in document currency | ||
| KZWI1 | KZWI1 | CURR | 13(2) | Subtotal 1 from pricing procedure for condition | ||
| KZWI2 | KZWI2 | CURR | 13(2) | Subtotal 2 from pricing procedure for condition | ||
| KZWI3 | KZWI3 | CURR | 13(2) | Subtotal 3 from pricing procedure for condition | ||
| KZWI4 | KZWI4 | CURR | 13(2) | Subtotal 4 from pricing procedure for condition | ||
| KZWI5 | KZWI5 | CURR | 13(2) | Subtotal 5 from pricing procedure for condition | ||
| KZWI6 | KZWI6 | CURR | 13(2) | Subtotal 6 from pricing procedure for condition | ||
| SOBKZ | SOBKZ | CHAR | 1 | T148 | Special Stock Indicator | |
| AEDAT | AEDAT | DATS | 8 | Changed On | ||
| EAN11 | EAN11 | CHAR | 18 | International Article Number (EAN/UPC) | EAN11 | |
| KVGR1 | KVGR1 | CHAR | 3 | TVV1 | Customer group 1 | |
| KVGR2 | KVGR2 | CHAR | 3 | TVV2 | Customer group 2 | |
| KVGR3 | KVGR3 | CHAR | 3 | TVV3 | Customer group 3 | |
| KVGR4 | KVGR4 | CHAR | 3 | TVV4 | Customer group 4 | |
| KVGR5 | KVGR5 | CHAR | 3 | TVV5 | Customer group 5 | |
| MVGR1 | MVGR1 | CHAR | 3 | TVM1 | Material group 1 | |
| MVGR2 | MVGR2 | CHAR | 3 | TVM2 | Material group 2 | |
| MVGR3 | MVGR3 | CHAR | 3 | TVM3 | Material group 3 | |
| MVGR4 | MVGR4 | CHAR | 3 | TVM4 | Material group 4 | |
| MVGR5 | MVGR5 | CHAR | 3 | TVM5 | Material group 5 | |
| VPZUO | VPZUO | CHAR | 1 | Allocation Indicator | ||
| VGTYP | VBTYP | CHAR | 1 | SD document category | ||
| RFVGTYP | RFVGTYP | CHAR | 1 | Type of preceding document in central system | ||
| KOSTL | KOSTL | CHAR | 10 | CSKS | Cost Center | ALPHA |
| KOKRS | KOKRS | CHAR | 4 | TKA01 | Controlling Area | |
| PAOBJNR | RKEOBJNR | NUMC | 10 | Profitability Segment Number (CO-PA) | ||
| PRCTR | PRCTR | CHAR | 10 |
* | Profit Center | ALPHA |
| PS_PSP_PNR | PS_PSP_PNR | NUMC | 8 |
* | Work Breakdown Structure Element (WBS Element) | ABPSP |
| AUFNR | AUFNR | CHAR | 12 | AUFK | Order Number | ALPHA |
| POSNR_PP | CO_POSNR | NUMC | 4 | Order Item Number | ||
| KDAUF | KDAUF | CHAR | 10 |
* | Sales Order Number | ALPHA |
| KDPOS | KDPOS | NUMC | 6 | Item Number in Sales Order | ||
| VPMAT | VPMAT | CHAR | 18 | MARA | Planning material | MATN1 |
| VPWRK | VPWRK | CHAR | 4 | T001W | Planning plant | |
| PRBME | PRBME | UNIT | 3 | T006 | Base unit of measure for product group | CUNIT |
| UMREF | UMREFF | FLTP | 16(16) | Conversion factor: quantities | ||
| KNTTP | KNTTP | CHAR | 1 | T163K | Account Assignment Category | |
| KZVBR | KZVBR | CHAR | 1 | Consumption Posting | ||
| FIPOS | FIPOS | CHAR | 14 |
* | Commitment Item | FMCIS |
| FISTL | FISTL | CHAR | 16 |
* | Funds Center | |
| GEBER | BP_GEBER | CHAR | 10 |
* | Fund | |
| PCKPF | PCKPF | CHAR | 1 | Packing control | ||
| BEDAR_LF | BEDAR | CHAR | 3 | T459K | Requirements class | |
| CMPNT | CMPNT | CHAR | 1 | ID: Item with active credit function / relevant for credit | ||
| KCMENG | KCMENG | QUAN | 15(3) | Cumulative batch quantity of all split items (in StckUnit) | ||
| KCBRGEW | KCBRGEW | QUAN | 15(3) | Cumulative gross weight of all batch split items | ||
| KCNTGEW | KCNTGEW | QUAN | 15(3) | Cumulative net weight of all batch split items | ||
| KCVOLUM | KCVOLUM | QUAN | 15(3) | Cumulative volume of all batch split items | ||
| UECHA | UECHA | NUMC | 6 | LIPS | Higher-Level Item of Batch Split Item | |
| CUOBJ | CUOBJ_VA | NUMC | 18 | Configuration | ||
| CUOBJ_CH | CUOBJ_CH | NUMC | 18 | Internal object number of the batch classification | ||
| ANZSN | ANZSN | INT4 | 10 | Number of serial numbers | ||
| SERAIL | SERAIL | CHAR | 4 | T377P | Serial Number Profile | |
| KCGEWEI | GEWEI | UNIT | 3 | T006 | Weight Unit | CUNIT |
| KCVOLEH | VOLEH | UNIT | 3 | T006 | Volume unit | CUNIT |
| SERNR | SERNR | CHAR | 8 | SNUM | BOM explosion number | |
| ABRLI | ABRLI | NUMC | 4 | VBLB | Internal delivery schedule number | |
| ABART | ABART | CHAR | 1 | Release type | ||
| ABRVW | ABRVW | CHAR | 3 | TVLV | Usage Indicator | |
| QPLOS | QPLOS | NUMC | 12 | QALS | Inspection Lot Number | |
| QTLOS | QTLOS | NUMC | 6 |
* | Partial lot number | |
| NACHL | NACHL | CHAR | 1 | Customer has not posted goods receipt | ||
| MAGRV | MAGRV | CHAR | 4 | TVEGR | Material Group: Packaging Materials | |
| OBJKO | OBJKO | CHAR | 22 |
* | Object number at header level | |
| OBJPO | OBJPO | CHAR | 22 |
* | Object number at item level | |
| AESKD | AESKD | CHAR | 17 | Customer Engineering Change Status | ||
| SHKZG | SHKZG_VA | CHAR | 1 | Returns Item | ||
| PROSA | PROSA | CHAR | 1 | ID for material determination | ||
| UEPVW | UEPVW | CHAR | 1 | ID for higher-level item usage | ||
| EMPST | EMPST | CHAR | 25 | Receiving point | ||
| ABTNR | ABTNR | CHAR | 4 | TSAB | Department number | |
| KOQUI | KOQUI | CHAR | 1 | Picking is subject to confirmation | ||
| STADAT | STADAT | DATS | 8 | Statistics date | ||
| KNUMH_CH | KNUMH_CH | CHAR | 10 | Number of condition record from batch determination | ||
| PREFE | PREFE | CHAR | 1 | Preference indicator in export/import | ||
| EXART | EXART | CHAR | 2 |
* | Business Transaction Type for Foreign Trade | |
| CLINT | CLINT | NUMC | 10 | KLAH | Internal Class Number | |
| CHMVS | CHMVS | NUMC | 3 | Batches: Exit to quantity proposal | ||
| ABELN | ABELN | CHAR | 10 | AUKO | Allocation Table Number | ALPHA |
| ABELP | ABELP | NUMC | 5 | AUPO | Item number of allocation table | |
| LFIMG_FLO | LFIMG_FLO | FLTP | 16(16) | Internal field/ Do not use / LFIMG in float / MUM | ||
| LGMNG_FLO | LGMNG_FLO | FLTP | 16(16) | Internal field/ Do not use / LGMNG in float / MUM | ||
| KCMENG_FLO | KCMENG_FLO | FLTP | 16(16) | Internal field/ Do not use / KCMENG in float / MUM | ||
| KZUMW | KZUMW | CHAR | 1 | Environmentally Relevant | ||
| KMPMG | KMPMG | QUAN | 13(3) | Component quantity | ||
| AUREL | AUREL | CHAR | 1 | Relevant to Allocation Table | ||
| KPEIN | KPEIN | DEC | 5 | Condition pricing unit | ||
| KMEIN | KMEIN | UNIT | 3 | T006 | Condition unit | CUNIT |
| NETPR | NETPR | CURR | 11(2) | Net price | ||
| NETWR | NETWR | CURR | 15(2) | Net Value in Document Currency | ||
| KOWRR | KOWRR | CHAR | 1 | Statistical values | ||
| KZBEW | KZBEW | CHAR | 1 | Movement Indicator | ||
| MFRGR | MFRGR | CHAR | 8 | TMFG | Material freight group | |
| CHHPV | CHHPV | CHAR | 1 | Pack accumulated batches / movement type item | ||
| ABFOR | ABSFORM_CM | CHAR | 2 | T691K | Form of payment guarantee | |
| ABGES | ABGES_CM | FLTP | 16(16) | Guaranteed (factor between 0 and 1) | ||
| MBUHR | MBUHR | TIMS | 6 | Material Staging Time (Local, Relating to a Plant) | ||
| WKTNR | WKTNR | CHAR | 10 | VBUK | Value contract no. | ALPHA |
| WKTPS | WKTPS | NUMC | 6 | VBUP | Value contract item | |
| J_1BCFOP | J_1BCFOP | CHAR | 10 | J_1BAG | CFOP Code and Extension | CFOBR |
| J_1BTAXLW1 | J_1BTAXLW1 | CHAR | 3 | J_1BATL1 | Tax law: ICMS | ALPHA |
| J_1BTAXLW2 | J_1BTAXLW2 | CHAR | 3 | J_1BATL2 | Tax law: IPI | ALPHA |
| J_1BTXSDC | J_1BTXSDC_ | CHAR | 2 | J_1BTXSDC | SD tax code | |
| SITUA | SITUA | CHAR | 2 |
* | Indicator for situation | |
| RSNUM | RSNUM | NUMC | 10 |
* | Number of Reservation/Dependent Requirement | |
| RSPOS | RSPOS | NUMC | 4 | Item Number of Reservation/Dependent Requirement | ||
| RSART | RSART | CHAR | 1 | Record type | ||
| KANNR | KANNR | CHAR | 35 | KANBAN/sequence number | ||
| KZFME | KZFME | CHAR | 1 | ID: Leading unit of measure for completing a transaction | ||
| PROFL | ADGE_PROFL | CHAR | 3 | TDG41 | Dangerous Goods Indicator Profile | |
| KCMENGVME | KCMENG_VME | QUAN | 15(3) | Cumulative batch quantity of all split items in sales units | ||
| KCMENGVMEF | KCMENGVMEF | FLTP | 16(16) | Cumulated batch split quantity in VRKME and float | ||
| KZBWS | KZBWS | CHAR | 1 | Valuation of Special Stock | ||
| PSPNR | PS_INTNR | NUMC | 8 |
* | Project definition (internal) | KONPD |
| EPRIO | EPRIO | CHAR | 4 |
* | Withdrawal sequence group for stocks | |
| RULES | BF_RULES | CHAR | 4 | T434R | Stock determination rule | |
| KZBEF | LVS_KZBEF | CHAR | 1 | Indicator Inventory Management active | ||
| MPROF | MPROF | CHAR | 4 |
* | Manufacturer Part Profile | |
| EMATN | EMATN | CHAR | 18 | MARA | Material Number Corresponding to Manufacturer Part Number | MATN1 |
| LGBZO | LGBZO | CHAR | 10 | T30C | Staging Area for Warehouse Complex | |
| HANDLE | TSEGGUID_LIPS | CHAR | 22 | Worldwide unique key for LIPS-VBELN & LIPS_POSNR | ||
| VERURPOS | VERURPOS | NUMC | 6 |
* | Distribution delivery: Original item | |
| LIFEXPOS | LIFEXPOS | NUMC | 6 |
* | External item number | |
| NOATP | NO_ATP_CHECK | CHAR | 1 | Indicator: deactivate availability check | ||
| NOPCK | NO_PICKING | CHAR | 1 | Indicator: not relevant for picking | ||
| RBLVS | RBLVS | NUMC | 3 | Reference movement type for WM from material movements | ||
| BERID | BERID | CHAR | 10 | MDLV | MRP Area | |
| BESTQ | BESTQ | CHAR | 1 | Stock Category in the Warehouse Management System | ||
| UMBSQ | BESTQ | CHAR | 1 | Stock Category in the Warehouse Management System | ||
| UMMAT | UMMAT | CHAR | 18 |
* | Receiving/Issuing Material | MATN1 |
| UMWRK | UMWRK | CHAR | 4 |
* | Receiving/Issuing Plant | |
| UMLGO | UMLGO | CHAR | 4 |
* | Receiving/Issuing Storage Location | |
| UMCHA | UMCHA | CHAR | 10 |
* | Receiving/Issuing Batch | |
| UMBAR | UMBAR | CHAR | 10 |
* | Valuation Type of Transfer Batch | |
| UMSOK | UMSOK | CHAR | 1 |
* | Special Stock Indicator for Physical Stock Transfer | |
| SONUM | LVS_SONUM | CHAR | 16 | Special Stock Number | ALPHA | |
| USONU | LVS_SONUM | CHAR | 16 | Special Stock Number | ALPHA | |
| AKKUR | AKKUR | DEC | 9(5) | Exchange rate for letter-of-credit procg in foreign trade | EXCRT | |
| AKMNG | AKMNG | CHAR | 1 | Current Qty Field for Arithmetic Operations in Doc.Process. | ||
| VKGRU | VKGRU | CHAR | 3 |
* | Repair Processing: Classification of Items | |
| SHKZG_UM | SHKZG_UM | CHAR | 1 | Indicator: UNMAT in main posting | ||
| INSMK | MB_INSMK | CHAR | 1 | Stock Type | ||
| KZECH | KZECH | CHAR | 1 | Determination of batch entry in the production/process order | ||
| FLGWM | FLGWM | CHAR | 1 | Indicator: Copy dest. storage data from preceding document | ||
| BERKZ | BERKZ | CHAR | 1 | Material Staging Indicator for Production Supply | ||
| HUPOS | HUPOS | CHAR | 1 | Indicator: Delivery item is a HU item | ||
| NOWAB | NOWAB | CHAR | 1 | Indicator: Item Not Relevant for Goods Movements | ||
| KONTO | SAKNR | CHAR | 10 |
* | G/L Account Number | ALPHA |
| KZEAR | KZEAR | CHAR | 1 | Final Issue for This Reservation | ||
| HSDAT | HSDAT | DATS | 8 | Date of Manufacture | ||
| VFDAT | VFDAT | DATS | 8 | Shelf Life Expiration or Best-Before Date | ||
| LFGJA | LFGJA | NUMC | 4 | Fiscal Year of Current Period | GJAHR | |
| LFBNR | LFBNR | CHAR | 10 | Document No. of a Reference Document | ALPHA | |
| LFPOS | LFPOS | NUMC | 4 | Item of a Reference Document | ||
| GRUND | MB_GRUND | NUMC | 4 | Reason for goods movment | ||
| FOBWA | FOBWA | CHAR | 3 |
* | Subsequent movement type | |
| DLVTP | DLVTP | CHAR | 2 | Delivery Category | ||
| EXBWR | EXBWR | CURR | 13(2) | Externally Entered Posting Amount in Local Currency | ||
| BPMNG | BPMNG | QUAN | 13(3) | Quantity in Purchase Order Price Unit | ||
| EXVKW | EXVKW | CURR | 13(2) | Externally Entered Sales Value in Local Currency | ||
| CMPRE_FLT | CMPRE_FLT | FLTP | 16(16) | Item credit price | ||
| KZPOD | KZPOD | CHAR | 1 | POD indicator (relevance, verification, confirmation) | ||
| LFDEZ | LFDEZ | CHAR | 1 | Not relevant for distribution for WMS | ||
| UMREV | LE_UMREV | FLTP | 16(16) | Conversion Factor of Delivery Quantity VRKME for MEINS | ||
| PODREL | PODREL | CHAR | 1 | POD Control (Proof of Delivery) | ||
| KZUML | KZUML | CHAR | 1 | Stock transfer/transfer posting | ||
| FKBER | FKBER | CHAR | 16 |
* | Functional Area | |
| GRANT_NBR | GM_GRANT_NBR | CHAR | 20 | Grant | ALPHA | |
| KZWSO | KZWSO | CHAR | 1 | Units of measure usage | ||
| GMCONTROL | GMCONTROL | CHAR | 1 | Goods Movement Control | ||
| POSTING_CHANGE | POSTING_CHANGE | CHAR | 1 | Goods Movement Control: HU | ||
| UM_PS_PSP_PNR | UM_PS_PSP_PNR | NUMC | 8 |
* | Receiving/Issuing (WBS Element) | ABPSP |
| PRE_VL_ETENS | ETENS | NUMC | 4 | Sequential Number of Vendor Confirmation | ||
| SPE_GEN_ELIKZ | ELIKZ | CHAR | 1 | "Delivery Completed" Indicator | ||
| SPE_SCRAP_IND | /SPE/DELIVERY_SCRAP_IND | CHAR | 1 | Scrap Indicator for EWM Processing | ||
| SPE_AUTH_NUMBER | /SPE/RET_RMA | CHAR | 20 | Return Material Authorization Number | ALPHA | |
| SPE_INSPOUT_GUID | /SPE/INSP_OUT_GUID_16 | RAW | 16 | Inspections: Inspection outcome GUID set by EWM | ||
| SPE_FOLLOW_UP | /SPE/RET_FOLLOW_UP | CHAR | 4 | Default Follow-Up Activity Code | ||
| SPE_EXP_DATE_EXT | /SPE/RET_EXPIRY_DATE_EXT | DEC | 15 | End date of validity period of returns delivery | ||
| SPE_EXP_DATE_INT | /SPE/RET_EXPIRY_DATE_INT | DEC | 15 | End date of internal validity period of returns delivery | ||
| SPE_AUTH_COMPLET | /SPE/RET_RMA_COMPLETED | CHAR | 1 | RMA completion indicator | ||
| ORMNG | ORMNG_VL | QUAN | 13(3) | Original Quantity of Delivery Item | ||
| SPE_ATP_TMSTMP | /SPE/DE_ATP_TIMESTAMP | DEC | 15 | ATP Time Stamp | ||
| SPE_ORIG_SYS | /SPE/INB_ORIGIN_SYS | CHAR | 1 | Original System Type | ||
| SPE_LIEFFZ | /SPE/LIEFFZ | QUAN | 15(3) | Cumulative Qty for SchedAgr - Vendor's Point of View | ||
| SPE_IMWRK | /SPE/IMWRK_ITEM | CHAR | 1 | Inbound Delivery item has Status 'In Plant' | ||
| SPE_LIFEXPOS2 | /SPE/DE_EXT_IDENT | CHAR | 35 | External item identifier | ||
| SPE_EXCEPT_CODE | /SPE/INB_EXCEPT_CODE_WM | CHAR | 4 | Exception Code Warehouse for Quantity Difference | ||
| SPE_KEEP_QTY | /SPE/KEEP_QUANTITY | QUAN | 13(3) | Retention Quantity for Scrap. Process in EWM | ||
| SPE_ALTERNATE | /SPE/DE_ALTERNATE_PART_NR | CHAR | 40 | Alternate Product Number | ||
| SPE_MAT_SUBST | /SPE/MAT_SUBST | CHAR | 1 | Reason for material substitution | ||
| SPE_STRUC | /SPE/STRUC | NUMC | 3 | Structure of Items That Are Delivered Together | ||
| SPE_APO_QNTYFAC | APOQUANFACTOR | DEC | 5 | Numerator of Quotient for Unit of Measure Conversion | ||
| SPE_APO_QNTYDIV | APOQUANDIVISOR | DEC | 5 | Denominator of Quotient for Unit of Measure Conversion | ||
| SPE_HERKL | HERKL | CHAR | 3 |
* | Country of origin of the material | |
| SPE_BXP_DATE_EXT | /SPE/RET_EXPIRY_DATE_EXT_B | DEC | 15 | Begin date of validity period of returns delivery | ||
| SPE_VERSION | /SPE/DE_DLV_VERSION | NUMC | 4 | Delivery Version at Confirmation | ||
| SPE_COMPL_MVT | /SPE/COMPL_MVT | CHAR | 1 | Completion of Goods Movements after Difference Postings | ||
| J_1BTAXLW4 | J_1BTAXLW4 | CHAR | 3 | J_1BATL4A | COFINS Tax Law | ALPHA |
| J_1BTAXLW5 | J_1BTAXLW5 | CHAR | 3 | J_1BATL5 | PIS Tax Law | ALPHA |
| J_1BTAXLW3 | J_1BTAXLW3 | CHAR | 3 | J_1BATL3 | ISS Tax Law | ALPHA |
| BUDGET_PD | FM_BUDGET_PERIOD | CHAR | 10 |
* | FM: Budget Period | |
| KBNKZ | KBNKZ | CHAR | 1 | Kanban Indicator | ||
| SITKZ | SITKZ | CHAR | 1 | Specification for Issuing Valuated Stock in Transit | ||
| .APPEND | /SAPMP/LBA_DONE | /SAPMP/ DTUC Complete | ||||
| /SAPMP/LBA_NO | /SAPMP/LBADONE | CHAR | 1 | DTUC Complete | ||
| .APPEND | /SAPMP/LIPS_APP | Mill-Append to Table LIPS | ||||
| .INCLUDE | /SAPMP/LIPS_INC | Mill-Include to Table LIPS | ||||
| /SAPMP/ALT_CONV | /SAPMP/ALT_CONV | CHAR | 1 | Mill: Indicator Provisional Conversion Factors | ||
| .APPEND | DIMP_BOR_LIPS | DIMP: Sales Document: Delivery: Item Data | ||||
| LGTOR | LGTOR | CHAR | 3 |
* | Door for Warehouse Number | |
| .APPEND | MILL_SD_LIPS_APP | MILL: Append for Table LIPS | ||||
| MILL_UCDET | MILL_UCDET | CHAR | 1 | Batch Determination for Original Batches | ||
| .APPEND | WRF_CONS_LIPS | Seasonal Procurement: Append for LIPS | ||||
| CONS_ORDER | WRF_CONS_ORDER | CHAR | 1 | Purchase Order for Consignment | ||
| Key field | |
| Non-key field |
LIPS relationships with other tables
ADMIX-Help structure for reading via ADK in LDB(SD)
VBUK-Sales Document: Header Status and Admin. Data
LIKP-SD Document: Delivery Header Data
VBFA-Sales Document Flow
NAST-Message status
VBUP-Sales Document: Item Status
LIPS-SD document: Delivery: Item data
VBPA-Sales Document: Partner
SADR-Address Management: Company data
VBSSSK-Table Generated for View VBSSSK
EIKP-Foreign Trade: Export/Import Header Data
EIPO-Foreign Trade: Export/Import: Item Data
VEKP-SD Document: Shipping Unit Header
VEPO-SD Document: Shipping Unit Item (Content)
STXH-STXD SAPscript text file header
STXL-STXD SAPscript text file lines
ARKOPF-Archiving run header data
VSKOPF-Version: Header - general data for a
RSTHIE-BRST structure of the hierarchy table
PSDYRH-LDB PSJ: Dummy structure under RSTHIE
PROJ-Project definition
PSDYPD-LDB PSJ: Dummy structure under PROJ
VBAK-Sales Document: Header Data
VBUK-Sales Doc.: Header Status and Administrative Data
VBKD-Sales Document: Business Data
VBAP-Sales Document: Item Data
VBUP-Sales Document: Item Status
VBKDPO-Sales document: Business item data (POSNR > 0)
FPLA-Billing plan
FPLT-Billing Plan: Dates
PSDYVB-LDB PSJ: Dummy structure under VBAP
PSDYVK-LDB PSJ: Dummy structure under VBAK
PRPS_R-Project Hierarchy Reporting Structure
PRTE-Scheduling Data for Project Item
PSMLST-Milestone I/O Table
PSTX-PS Texts (Header)
PLAF-Planned order
PSMERK (PSMERK_PRPS)-Characteristics for Summarization for WBS Elements
KBED04-Capacity Requirement Recs for Planned Orders (LDB)
RESB04-Reservation/dependent reqs for plan order (LDB)
PSDYPR-LDB PSJ: Dummy structure under PRPS_R
AUFK-Order master data
AFKO-Order Header Data PP Orders
AFPO-Order Item
AFFL-Work order sequence
ACT01-Activity for LDB 01
AFAB01-Network Relationship (for LDB) - 01
MLSTD-Milestone I/O Table
PSTX1-PS Texts (Header) for Activity (1)
AFFH01-Order PRT Data (for LDB) - 01
KBED01-Capacity Requirement Records (for LDB) - 01
KBEZ-Additional data for table KBED (for ind.req/split)
KPER-Additional data for KBEZ (person split in days)
AFRU02-Order Confirmations (for LDB) -02
RESB01-Reservation/Dependent Requirement for LDB-01
PSDYOK-LDB PSJ: Dummy structure under RESB01
AFRU01-Order Confirmations (for LDB) - 01
PSMERK (PSMERK_ACT)-Charactersitics for Summarization for Activity
PSDYNV-LDB PSJ: Dummy structure under ACT01
AFIH-Maintenance order header
PSDYNP-LDB PSJ: Dummy structure under AUFK
IMTP-Investment programs
IMPR-Investment Program Positions
PSDYIP-LDB PSJ: Dummy structure under IMPR
PSDYPG-LDB PSJ: Dummy structure under IMTP
PEGOB-Peg (master data of the CO object)
PEGQTY-Assigned pegging object quantities
PSDYPEG-LDB PSJ: Dummy Structure Under PEGOB
ELM_PS-Additional data for hierarchy nodes (LDB PSJ)
JSTO-Status object information
PSTAT-Condensed status display
JCDO-Change Documents for Status Object (Table JSTO)
JEST-Individual Status per Object
JCDS-Change docs. for system/user status (table JEST)
ONR00-General Object Number
RPSCO1-Summarization Table for Project Reporting
RPSQT-Summarization table for project reporting (quants)
EVOP (EV_PARAM)-Object parameters for earned value analysis
EVPOC_RPSQT (EV_POC)-Earned value analysis: percentage of completion
EVVAL_RPSCO (EV_VAL)-Earned value analysis: earned value
COBRA-Settlement Rule for Order Settlement
COBRB-Distribution rules for sett. rule for order sett.
BPHI1-Cross-hierarchy data Control
BPTR1-Object Data Control
BPGE1-Totals record total value Control
BPVG1-Table Generated for View BPVG1
BKHS1-Header - Unit Costing (Control + Totals)
HEAD10-SAPscript: Text Header
LINE10-SAPscript: Text Lines
BKHT1-Texts for CKHS
BKIS1-Individual calculation/verification item gen.
BKIT1-Texts for CKIS
BKIP1-Periodic Values for Unit Costing Item
BPJA1-Totals record for total year value Control
BPVJ1-Table Generated for View BPVJ1
BKHS2-Header - Unit Costing (Control + Totals)
HEAD20-SAPscript: Text Header
LINE20-SAPscript: Text Lines
BKHT2-Texts for CKHS
BKIS2-Individual calculation/verification item gen.
BKIT2-Texts for CKIS
BKIP2-Periodic Values for Unit Costing Item
BPPE1-Totals Record for Period Values Control
BPVP1-Table Generated for View BPVP1
BPIG1-Budget Object Index (Overall Budget)
BPIJ1-Budget Object Index (Annual Budget)
COKA1-CO Object: Cost Element Control Data
COKP1-CO Object: Primary Planning Control Data
HEAD11-SAPscript: Text Header
LINE11-SAPscript: Text Lines
CKHS1-Header - Unit Costing (Control + Totals)
CKHT1-Texts for CKHS
HEAD12-SAPscript: Text Header
LINE12-SAPscript: Text Lines
CKIS1-Individual calculation/verification item gen.
CKIT1-Texts for CKIS
CKIP1-Periodic Values for Unit Costing Item
COSP1-CO Object: Cost Totals for External Postings
COVP11-CO object: Line items with doc. header (by period)
COEPD11-CO object: Unvaluated ln. item settlement w/status
COEPBR11-CO Object: Valuated Line Item Settlement
COVJ11-CO object: Line items with doc header (by year)
COVO1-CO Object: Open Items for Line Items (w/o doc.Hdr)
COSPD1-CO object: External cost totals - calculated
COSPP-Transfer of Order in the COSP Table to the Project
COKS1-CO Object: Control Data for Secondary Planning
HEAD13-SAPscript: Text Header
LINE13-SAPscript: Text Lines
COSS1-CO Object: Cost Totals for Internal Postings
COVP12-CO object: Line items with doc. header (by period)
COEPD12-CO object: Unvaluated ln. item settlement w/status
COEPBR12-CO Object: Valuated Line Item Settlement
COVJ12-CO object: Line items with doc header (by year)
COVO12-CO object: Fxd price agreement commitment ln items
COSSD1-CO object: Internal cost totals - calculated
COSSP-Transfer of the Order COSS Table to the Project
COKR1-CO Object: Control Data for Statistical Key Figs
HEAD14-SAPscript: Text Header
LINE14-SAPscript: Text Lines
COSR1-CO Object: Statistical Key Figure Totals
COVPR1-CO object: Stat. key figure line items by period
COVJR1-CO object: Line items stat. key figures (by year)
COSL1-CO Object: Activity Type Totals
COVPL1-CO object: Activity type line items by period
COVJL1-CO object: Line items for acty types (by year)
COSLD-CO object: Activity type sums - calculated
COSB1-CO Object: Total Variances/Results Analyses
COVPB1-CO object: Variance/accrual line items by period
COSBD1-CO object: Sums of variance/accrual - calculated
ANIA1-Depr. simulation for invest. projects
ANIB1-Invest. projects: Depr. simulation analysis report
ANLI1-Link table for capital investment measure -> AuC
FMSU1-FM totals records for financial data
COVFP1-CO object: Financial data line items with doc. hdr
TPI031-CO Objects: Date of Last Interest Run
EKKO-Purchasing Document Header
EKPO-Purchasing Document Item
EKET-Scheduling Agreement Schedule Lines
EKKN-Account Assignment in Purchasing Document
EKBE-Purchasing Document History
EBAN-Purchase requisition
EBKN-Purchase Requisition Account Assignment
FPLA (FPLAPS)-Billing plan for PSP network plan
FPLT (FPLTPS)-Billing plan for PSP/network (dates)
LIKP-SD Document: Delivery Header Data
LIPS-SD document: Delivery: Item data
PSMERK-Characteristics for summarization wo.classificatn
DRAD-Document-object link
KNVK-Customer Master Contact Partner
KNA1-General Data in Customer Master
KNVV-Customer Master Sales Data
KNVP-Customer Master Partner Functions
VBAP-Sales Document: Item Data
LIPS-SD document: Delivery: Item data
VBRP-Billing Document: Item Data
VBKA-Sales Activities
LIKP-SD Document: Delivery Header Data
VBUK-Sales Doc.: Header Status and Administrative Data
LIPS-SD document: Delivery: Item data
VBUP-Sales Document: Item Status
VBFA-Sales Document Flow
VBFAVG-Sales document: Cumulative records,followed by doc
VBPA-Sales Document: Partner
LIPS - SD document: Delivery: Item data LIPOV_WEB - View: Delivery Information Header and Item (WEB) LIPOV_OUTPUT_HEADER - Delivery Monitor: Output Selection Headings LIPOV_OUTPUT - Delivery Monitor: Structure for Output Selection LIPOV_KODAT - Delivery Monitor: Picking Day's Workload LIPOV_GROUP_ITEM - Delivery Monitor: Group List