SAP Table ROIO_GR_LIPS_BADI

Delivery item fields fo cross-docking BAdI

ROIO_GR_LIPS_BADI (Delivery item fields fo cross-docking BAdI) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link ROIO_GR_LIPS_BADI to other SAP tables.

ROIO_GR_LIPS_BADI table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
MATNR Material Number MATNR MARA CHAR 18 0
MATKL Material Group MATKL T023 CHAR 9 0
WERKS Plant WERKS_D T001W CHAR 4 0
LGORT Storage Location LGORT_D T001L CHAR 4 0
CHARG Batch Number CHARG_D MCHA CHAR 10 0
LICHN Vendor Batch Number LICHN CHAR 15 0
KDMAT Material belonging to the customer KDMAT CHAR 35 0
PRODH Product hierarchy PRODH_D T179 CHAR 18 0
NTGEW Net weight NTGEW_15 QUAN 15 3
BRGEW Gross weight BRGEW_15 QUAN 15 3
GEWEI Weight Unit GEWEI T006 UNIT 3 0
VOLUM Volume VOLUM_15 QUAN 15 3
VOLEH Volume unit VOLEH T006 UNIT 3 0
FAKSP Block FAKSP TVFS CHAR 2 0
ARKTX Short text for sales order item ARKTX CHAR 40 0
LGPBE Storage Bin LGPBE CHAR 10 0
LADGR Loading Group LADGR TLGR CHAR 4 0
TRAGR Transportation Group TRAGR TTGR CHAR 4 0
LGNUM Warehouse Number / Warehouse Complex LGNUM T300 CHAR 3 0
LGTYP Storage Type LGTYP T301 CHAR 3 0
LGPLA Storage Bin LGPLA LAGP CHAR 10 0
BDART Requirement type BDART CHAR 2 0
PLART Planning type PLART CHAR 1 0
MTART Material Type MTART T134 CHAR 4 0
XCHPF Batch management requirement indicator XCHPF CHAR 1 0
X Yes
NULL No
XCHAR Batch management indicator (internal) XCHAR CHAR 1 0
X Yes
NULL No
BWTAR Valuation Type BWTAR_D T149D CHAR 10 0
GSBER Business Area GSBER TGSB CHAR 4 0
VKBUR Sales Office VKBUR TVBUR CHAR 4 0
VKGRP Sales Group VKGRP TVKGR CHAR 3 0
VTWEG Distribution Channel VTWEG TVTW CHAR 2 0
SPART Division SPART TSPA CHAR 2 0
GRKOR Delivery group (items are delivered together) GRKOR NUMC 3 0
AEDAT Changed On AEDAT DATS 8 0
EAN11 International Article Number (EAN/UPC) EAN11 CHAR 18 0
KVGR1 Customer group 1 KVGR1 TVV1 CHAR 3 0
KVGR2 Customer group 2 KVGR2 TVV2 CHAR 3 0
KVGR3 Customer group 3 KVGR3 TVV3 CHAR 3 0
KVGR4 Customer group 4 KVGR4 TVV4 CHAR 3 0
KVGR5 Customer group 5 KVGR5 TVV5 CHAR 3 0
MVGR1 Material group 1 MVGR1 TVM1 CHAR 3 0
MVGR2 Material group 2 MVGR2 TVM2 CHAR 3 0
MVGR3 Material group 3 MVGR3 TVM3 CHAR 3 0
MVGR4 Material group 4 MVGR4 TVM4 CHAR 3 0
MVGR5 Material group 5 MVGR5 TVM5 CHAR 3 0
VPZUO Allocation Indicator VPZUO CHAR 1 0
NULL No consumption with customer requirements
1 Consume planning with assembly
2 Consume planning w/o assembly
3 Consume planning material (w/o assembly)
VGTYP SD document category VBTYP CHAR 1 0
A Inquiry
B Quotation
C Order
D Item proposal
E Scheduling agreement
F Scheduling agreement with external service agent
G Contract
H Returns
I Order w/o charge
J Delivery
K Credit memo request
L Debit memo request
M Invoice
N Invoice cancellation
O Credit memo
P Debit memo
Q WMS transfer order
R Goods movement
S Credit memo cancellation
T Returns delivery for order
U Pro forma invoice
V Purchase Order
W Independent reqts plan
X Handling unit
0 Master contract
1 Sales activities (CAS)
2 External transaction
3 Invoice list
4 Credit memo list
5 Intercompany invoice
6 Intercompany credit memo
7 Delivery/shipping notification
8 Shipment
a Shipment costs
b CRM Opportunity
c Unverified delivery
d Trading Contract
e Allocation table
f Additional Billing Documents
g Rough Goods Receipt (only IS-Retail)
h Cancel Goods Issue
i Goods receipt
j JIT call
n Reserved
o Reserved
p Goods Movement (Documentation)
q Reserved
r TD Transport (only IS-Oil)
s Load Confirmation, Reposting (Only IS-Oil)
t Gain / Loss (Only IS-Oil)
u Reentry into Storage (Only IS-Oil)
v Data Collation (only IS-Oil)
w Reservation (Only IS-Oil)
x Load Confirmation, Goods Receipt (Only IS-Oil)
$ (AFS)
+ Accounting Document (Temporary)
- Accounting Document (Temporary)
# Revenue Recognition (Temporary)
~ Revenue Cancellation (Temporary)
Revenue Recognition/New View (Temporary)
NULL Revenue Cancellation/New View (Temporary)
: Service Order
. Service Notification
& Warehouse Document
* Pick Order
, Shipment Document
^ Reserved
| Reserved
k Agency Document
RFVGTYP Type of preceding document in central system RFVGTYP CHAR 1 0
A Inquiry
B Quotation
C Order
D Item proposal
E Scheduling agreement
F Scheduling agreement with external service agent
G Contract
H Returns
I Order w/o charge
J Delivery
K Credit memo request
L Debit memo request
M Invoice
N Invoice cancellation
O Credit memo
P Debit memo
Q WMS transfer order
R Goods movement
S Credit memo cancellation
T Returns delivery for order
U Pro forma invoice
V Purchase Order
W Independent reqts plan
X Handling unit
0 Master contract
1 Sales activities (CAS)
2 External transaction
3 Invoice list
4 Credit memo list
5 Intercompany invoice
6 Intercompany credit memo
7 Delivery/shipping notification
8 Shipment
a Shipment costs
b CRM Opportunity
c Unverified delivery
d Trading Contract
e Allocation table
f Additional Billing Documents
g Rough Goods Receipt (only IS-Retail)
h Cancel Goods Issue
i Goods receipt
j JIT call
n Reserved
o Reserved
p Goods Movement (Documentation)
q Reserved
r TD Transport (only IS-Oil)
s Load Confirmation, Reposting (Only IS-Oil)
t Gain / Loss (Only IS-Oil)
u Reentry into Storage (Only IS-Oil)
v Data Collation (only IS-Oil)
w Reservation (Only IS-Oil)
x Load Confirmation, Goods Receipt (Only IS-Oil)
$ (AFS)
+ Accounting Document (Temporary)
- Accounting Document (Temporary)
# Revenue Recognition (Temporary)
~ Revenue Cancellation (Temporary)
Revenue Recognition/New View (Temporary)
NULL Revenue Cancellation/New View (Temporary)
: Service Order
. Service Notification
& Warehouse Document
* Pick Order
, Shipment Document
^ Reserved
| Reserved
k Agency Document
KOSTL Cost Center KOSTL CSKS CHAR 10 0
KOKRS Controlling Area KOKRS TKA01 CHAR 4 0
PAOBJNR Profitability Segment Number (CO-PA) RKEOBJNR NUMC 10 0
PRCTR Profit Center PRCTR CHAR 10 0
PS_PSP_PNR Work Breakdown Structure Element (WBS Element) PS_PSP_PNR NUMC 8 0
AUFNR Order Number AUFNR AUFK CHAR 12 0
POSNR_PP Order Item Number CO_POSNR NUMC 4 0
KDAUF Sales Order Number KDAUF CHAR 10 0
KDPOS Item Number in Sales Order KDPOS NUMC 6 0
VPMAT Planning material VPMAT MARA CHAR 18 0
VPWRK Planning plant VPWRK T001W CHAR 4 0
PRBME Base unit of measure for product group PRBME T006 UNIT 3 0
UMREF Conversion factor: quantities UMREFF FLTP 16 16
KNTTP Account Assignment Category KNTTP T163K CHAR 1 0
KZVBR Consumption Posting KZVBR CHAR 1 0
NULL No consumption
V Consumption
A Asset
E Sales order
P Project
FIPOS Commitment Item FIPOS CHAR 14 0
FISTL Funds Center FISTL CHAR 16 0
GEBER Fund BP_GEBER CHAR 10 0
PCKPF Packing control PCKPF CHAR 1 0
NULL Can be packed
A Must be packed
B Cannot be packed
PSPNR Project definition (internal) PS_INTNR NUMC 8 0
EMATN Material Number Corresponding to Manufacturer Part Number EMATN MARA CHAR 18 0
BERID MRP Area BERID MDLV CHAR 10 0
BESTQ Stock Category in the Warehouse Management System BESTQ CHAR 1 0
NULL Available Stock
Q Stock in Quality Control
R Returns Stock
S Blocked Stock
UMBSQ Stock Category in the Warehouse Management System BESTQ CHAR 1 0
NULL Available Stock
Q Stock in Quality Control
R Returns Stock
S Blocked Stock
UMMAT Receiving/Issuing Material UMMAT CHAR 18 0
UMWRK Receiving/Issuing Plant UMWRK CHAR 4 0
UMLGO Receiving/Issuing Storage Location UMLGO CHAR 4 0
UMCHA Receiving/Issuing Batch UMCHA CHAR 10 0
UMBAR Valuation Type of Transfer Batch UMBAR CHAR 10 0
UMSOK Special Stock Indicator for Physical Stock Transfer UMSOK CHAR 1 0
SONUM Special Stock Number LVS_SONUM CHAR 16 0
USONU Special Stock Number LVS_SONUM CHAR 16 0
HSDAT Date of Manufacture HSDAT DATS 8 0
VFDAT Shelf Life Expiration or Best-Before Date VFDAT DATS 8 0
OII_CONLG Consignment Stock Receiving S/Loc in Delivery OIO_CONLG CHAR 4 0

ROIO_GR_LIPS_BADI foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
ROIO_GR_LIPS_BADI AUFNR ROIO_GR_LIPS_BADI AUFNR AUFK Order master data AUFNR
ROIO_GR_LIPS_BADI AUFNR ROIO_GR_LIPS_BADI MANDT AUFK Order master data MANDT
ROIO_GR_LIPS_BADI BERID ROIO_GR_LIPS_BADI MANDT MDLV Customizing MRP Area MANDT
ROIO_GR_LIPS_BADI BERID ROIO_GR_LIPS_BADI BERID MDLV Customizing MRP Area BERID
ROIO_GR_LIPS_BADI BWTAR ROIO_GR_LIPS_BADI MANDT T149D Global Valuation Types MANDT
ROIO_GR_LIPS_BADI BWTAR ROIO_GR_LIPS_BADI BWTAR T149D Global Valuation Types BWTAR
ROIO_GR_LIPS_BADI CHARG ROIO_GR_LIPS_BADI MATNR MCHA Batches MATNR
ROIO_GR_LIPS_BADI CHARG ROIO_GR_LIPS_BADI WERKS MCHA Batches WERKS
ROIO_GR_LIPS_BADI CHARG ROIO_GR_LIPS_BADI CHARG MCHA Batches CHARG
ROIO_GR_LIPS_BADI CHARG ROIO_GR_LIPS_BADI MANDT MCHA Batches MANDT
ROIO_GR_LIPS_BADI EMATN ROIO_GR_LIPS_BADI MANDT MARA General Material Data MANDT
ROIO_GR_LIPS_BADI EMATN ROIO_GR_LIPS_BADI EMATN MARA General Material Data MATNR
ROIO_GR_LIPS_BADI FAKSP ROIO_GR_LIPS_BADI MANDT TVFS Billing: Reasons for Blocking MANDT
ROIO_GR_LIPS_BADI FAKSP ROIO_GR_LIPS_BADI FAKSP TVFS Billing: Reasons for Blocking FAKSP
ROIO_GR_LIPS_BADI GEWEI ROIO_GR_LIPS_BADI MANDT T006 Units of Measurement MANDT
ROIO_GR_LIPS_BADI GEWEI ROIO_GR_LIPS_BADI GEWEI T006 Units of Measurement MSEHI
ROIO_GR_LIPS_BADI GSBER ROIO_GR_LIPS_BADI MANDT TGSB Business Areas MANDT
ROIO_GR_LIPS_BADI GSBER ROIO_GR_LIPS_BADI GSBER TGSB Business Areas GSBER
ROIO_GR_LIPS_BADI KNTTP ROIO_GR_LIPS_BADI MANDT T163K Account Assignment Categories in Purchasing Document MANDT
ROIO_GR_LIPS_BADI KNTTP ROIO_GR_LIPS_BADI KNTTP T163K Account Assignment Categories in Purchasing Document KNTTP
ROIO_GR_LIPS_BADI KOKRS ROIO_GR_LIPS_BADI KOKRS TKA01 Controlling Areas KOKRS
ROIO_GR_LIPS_BADI KOKRS ROIO_GR_LIPS_BADI MANDT TKA01 Controlling Areas MANDT
ROIO_GR_LIPS_BADI KOSTL ROIO_GR_LIPS_BADI MANDT CSKS Cost Center Master Data MANDT
ROIO_GR_LIPS_BADI KOSTL ROIO_GR_LIPS_BADI KOKRS CSKS Cost Center Master Data KOKRS
ROIO_GR_LIPS_BADI KOSTL ROIO_GR_LIPS_BADI KOSTL CSKS Cost Center Master Data KOSTL
ROIO_GR_LIPS_BADI KOSTL ROIO_GR_LIPS_BADI AEDAT CSKS Cost Center Master Data DATBI
ROIO_GR_LIPS_BADI KVGR1 ROIO_GR_LIPS_BADI MANDT TVV1 Customer Group 1 MANDT
ROIO_GR_LIPS_BADI KVGR1 ROIO_GR_LIPS_BADI KVGR1 TVV1 Customer Group 1 KVGR1
ROIO_GR_LIPS_BADI KVGR2 ROIO_GR_LIPS_BADI MANDT TVV2 Customer Group 2 MANDT
ROIO_GR_LIPS_BADI KVGR2 ROIO_GR_LIPS_BADI KVGR2 TVV2 Customer Group 2 KVGR2
ROIO_GR_LIPS_BADI KVGR3 ROIO_GR_LIPS_BADI MANDT TVV3 Customer Group 3 MANDT
ROIO_GR_LIPS_BADI KVGR3 ROIO_GR_LIPS_BADI KVGR3 TVV3 Customer Group 3 KVGR3
ROIO_GR_LIPS_BADI KVGR4 ROIO_GR_LIPS_BADI KVGR4 TVV4 Customer Group 4 KVGR4
ROIO_GR_LIPS_BADI KVGR4 ROIO_GR_LIPS_BADI MANDT TVV4 Customer Group 4 MANDT
ROIO_GR_LIPS_BADI KVGR5 ROIO_GR_LIPS_BADI MANDT TVV5 Customer Group 5 MANDT
ROIO_GR_LIPS_BADI KVGR5 ROIO_GR_LIPS_BADI KVGR5 TVV5 Customer Group 5 KVGR5
ROIO_GR_LIPS_BADI LADGR ROIO_GR_LIPS_BADI MANDT TLGR Routes: Loading Groups MANDT
ROIO_GR_LIPS_BADI LADGR ROIO_GR_LIPS_BADI LADGR TLGR Routes: Loading Groups LADGR
ROIO_GR_LIPS_BADI LGNUM ROIO_GR_LIPS_BADI MANDT T300 WM Warehouse Numbers MANDT
ROIO_GR_LIPS_BADI LGNUM ROIO_GR_LIPS_BADI LGNUM T300 WM Warehouse Numbers LGNUM
ROIO_GR_LIPS_BADI LGORT ROIO_GR_LIPS_BADI MANDT T001L Storage Locations MANDT
ROIO_GR_LIPS_BADI LGORT ROIO_GR_LIPS_BADI WERKS T001L Storage Locations WERKS
ROIO_GR_LIPS_BADI LGORT ROIO_GR_LIPS_BADI LGORT T001L Storage Locations LGORT
ROIO_GR_LIPS_BADI LGPLA ROIO_GR_LIPS_BADI MANDT LAGP Storage bins MANDT
ROIO_GR_LIPS_BADI LGPLA ROIO_GR_LIPS_BADI LGNUM LAGP Storage bins LGNUM
ROIO_GR_LIPS_BADI LGPLA ROIO_GR_LIPS_BADI LGTYP LAGP Storage bins LGTYP
ROIO_GR_LIPS_BADI LGPLA ROIO_GR_LIPS_BADI LGPLA LAGP Storage bins LGPLA
ROIO_GR_LIPS_BADI LGTYP ROIO_GR_LIPS_BADI LGNUM T301 WM Storage Types LGNUM
ROIO_GR_LIPS_BADI LGTYP ROIO_GR_LIPS_BADI LGTYP T301 WM Storage Types LGTYP
ROIO_GR_LIPS_BADI LGTYP ROIO_GR_LIPS_BADI MANDT T301 WM Storage Types MANDT
ROIO_GR_LIPS_BADI MANDT ROIO_GR_LIPS_BADI MANDT T000 Clients MANDT
ROIO_GR_LIPS_BADI MATKL ROIO_GR_LIPS_BADI MANDT T023 Material Groups MANDT
ROIO_GR_LIPS_BADI MATKL ROIO_GR_LIPS_BADI MATKL T023 Material Groups MATKL
ROIO_GR_LIPS_BADI MATNR ROIO_GR_LIPS_BADI MANDT MARA General Material Data MANDT
ROIO_GR_LIPS_BADI MATNR ROIO_GR_LIPS_BADI MATNR MARA General Material Data MATNR
ROIO_GR_LIPS_BADI MTART ROIO_GR_LIPS_BADI MANDT T134 Material Types MANDT
ROIO_GR_LIPS_BADI MTART ROIO_GR_LIPS_BADI MTART T134 Material Types MTART
ROIO_GR_LIPS_BADI MVGR1 ROIO_GR_LIPS_BADI MANDT TVM1 Material Pricing Group 1 MANDT
ROIO_GR_LIPS_BADI MVGR1 ROIO_GR_LIPS_BADI MVGR1 TVM1 Material Pricing Group 1 MVGR1
ROIO_GR_LIPS_BADI MVGR2 ROIO_GR_LIPS_BADI MVGR2 TVM2 Material Pricing Group 2 MVGR2
ROIO_GR_LIPS_BADI MVGR2 ROIO_GR_LIPS_BADI MANDT TVM2 Material Pricing Group 2 MANDT
ROIO_GR_LIPS_BADI MVGR3 ROIO_GR_LIPS_BADI MANDT TVM3 Material Pricing Group 3 MANDT
ROIO_GR_LIPS_BADI MVGR3 ROIO_GR_LIPS_BADI MVGR3 TVM3 Material Pricing Group 3 MVGR3
ROIO_GR_LIPS_BADI MVGR4 ROIO_GR_LIPS_BADI MANDT TVM4 Material Pricing Group 4 MANDT
ROIO_GR_LIPS_BADI MVGR4 ROIO_GR_LIPS_BADI MVGR4 TVM4 Material Pricing Group 4 MVGR4
ROIO_GR_LIPS_BADI MVGR5 ROIO_GR_LIPS_BADI MVGR5 TVM5 Material Pricing Group 5 MVGR5
ROIO_GR_LIPS_BADI MVGR5 ROIO_GR_LIPS_BADI MANDT TVM5 Material Pricing Group 5 MANDT
ROIO_GR_LIPS_BADI PRBME ROIO_GR_LIPS_BADI PRBME T006 Units of Measurement MSEHI
ROIO_GR_LIPS_BADI PRBME ROIO_GR_LIPS_BADI MANDT T006 Units of Measurement MANDT
ROIO_GR_LIPS_BADI PRODH ROIO_GR_LIPS_BADI MANDT T179 Materials: Product Hierarchies MANDT
ROIO_GR_LIPS_BADI PRODH ROIO_GR_LIPS_BADI PRODH T179 Materials: Product Hierarchies PRODH
ROIO_GR_LIPS_BADI SPART ROIO_GR_LIPS_BADI MANDT TSPA Organizational Unit: Sales Divisions MANDT
ROIO_GR_LIPS_BADI SPART ROIO_GR_LIPS_BADI SPART TSPA Organizational Unit: Sales Divisions SPART
ROIO_GR_LIPS_BADI TRAGR ROIO_GR_LIPS_BADI TRAGR TTGR Delivery Scheduling: Transportation Groups TRAGR
ROIO_GR_LIPS_BADI TRAGR ROIO_GR_LIPS_BADI MANDT TTGR Delivery Scheduling: Transportation Groups MANDT
ROIO_GR_LIPS_BADI VKBUR ROIO_GR_LIPS_BADI MANDT TVBUR Organizational Unit: Sales Offices MANDT
ROIO_GR_LIPS_BADI VKBUR ROIO_GR_LIPS_BADI VKBUR TVBUR Organizational Unit: Sales Offices VKBUR
ROIO_GR_LIPS_BADI VKGRP ROIO_GR_LIPS_BADI MANDT TVKGR Organizational Unit: Sales Groups MANDT
ROIO_GR_LIPS_BADI VKGRP ROIO_GR_LIPS_BADI VKGRP TVKGR Organizational Unit: Sales Groups VKGRP
ROIO_GR_LIPS_BADI VOLEH ROIO_GR_LIPS_BADI MANDT T006 Units of Measurement MANDT
ROIO_GR_LIPS_BADI VOLEH ROIO_GR_LIPS_BADI VOLEH T006 Units of Measurement MSEHI
ROIO_GR_LIPS_BADI VPMAT ROIO_GR_LIPS_BADI MANDT MARA General Material Data MANDT
ROIO_GR_LIPS_BADI VPMAT ROIO_GR_LIPS_BADI VPMAT MARA General Material Data MATNR
ROIO_GR_LIPS_BADI VPWRK ROIO_GR_LIPS_BADI MANDT T001W Plants/Branches MANDT
ROIO_GR_LIPS_BADI VPWRK ROIO_GR_LIPS_BADI VPWRK T001W Plants/Branches WERKS
ROIO_GR_LIPS_BADI VTWEG ROIO_GR_LIPS_BADI MANDT TVTW Organizational Unit: Distribution Channels MANDT
ROIO_GR_LIPS_BADI VTWEG ROIO_GR_LIPS_BADI VTWEG TVTW Organizational Unit: Distribution Channels VTWEG
ROIO_GR_LIPS_BADI WERKS ROIO_GR_LIPS_BADI MANDT T001W Plants/Branches MANDT
ROIO_GR_LIPS_BADI WERKS ROIO_GR_LIPS_BADI WERKS T001W Plants/Branches WERKS