SAP Table BAPIOBDLVITEMRFO

Outbound Delivery Item Order Reference Data

BAPIOBDLVITEMRFO (Outbound Delivery Item Order Reference Data) 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 BAPIOBDLVITEMRFO to other SAP tables.

BAPIOBDLVITEMRFO table fields

Field Data element Checktable Datatype Length Decimals
DELIV_NUMB Delivery VBELN_VL VBUK CHAR 10 0
ITM_NUMBER Item number of the SD document POSNR VBUP NUMC 6 0
DOC_NUMBER Sales Document VBELN_VA VBUK CHAR 10 0
ITM_NUMBER_REF Sales Document Item POSNR_VA VBUP NUMC 6 0
SD_DOC_CAT 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
DOC_DATE Document Date (Date Received/Sent) AUDAT DATS 8 0
PURCH_NO_C Customer purchase order number BSTKD CHAR 35 0
PURCH_DATE Customer purchase order date BSTDK DATS 8 0
PO_METHOD Customer purchase order type BSARK T176 CHAR 4 0
REF_1 Your Reference IHREZ CHAR 12 0
PO_ITM_NO Item Number of the Underlying Purchase Order POSEX CHAR 6 0
PURCH_NO_S Ship-to Party's Purchase Order Number BSTKD_E CHAR 35 0
PO_DAT_S Ship-to party's PO date BSTDK_E DATS 8 0
PO_METH_S Ship-to party purchase order type BSARK_E T176 CHAR 4 0
REF_1_S Ship-to party character IHREZ_E CHAR 12 0
PO_ITM_NO_S Item Number of the Underlying Purchase Order POSEX_E CHAR 6 0
CONSUMPPNT Customer point of consumption VBRST CHAR 14 0
USR01 Additional data field 1 for delivery schedules USR01_D CHAR 35 0
USR02 Additional data field 2 for delivery schedules USR02_D CHAR 35 0
USR03 Additional data field 3 for delivery schedules USR03_D CHAR 35 0
USR04 Additional data field 4 for delivery schedules USR04_D CHAR 10 0
USR05 Additional data field 5 for delivery schedules USR05_D CHAR 10 0
DLVSCHEDNO Customer number for forecast / JIT dlv. sched. LABNK CHAR 17 0
DLVSCHEDDATE Delivery Schedule Date ABRDT DATS 8 0
DLVSCHEDUSE Usage Indicator ABRVW TVLV CHAR 3 0
CUSTCHNGSTATUS Customer Engineering Change Status AESKD CHAR 17 0
SUBSTREASON Reason for material substitution SUGRD TVSU CHAR 4 0

BAPIOBDLVITEMRFO foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
BAPIOBDLVITEMRFO DELIV_NUMB * VBUK Sales Document: Header Status and Administrative Data MANDT
BAPIOBDLVITEMRFO DELIV_NUMB BAPIOBDLVITEMRFO DELIV_NUMB VBUK Sales Document: Header Status and Administrative Data VBELN
BAPIOBDLVITEMRFO DLVSCHEDUSE * TVLV Check table for release orders: Usage ID MANDT
BAPIOBDLVITEMRFO DLVSCHEDUSE BAPIOBDLVITEMRFO DLVSCHEDUSE TVLV Check table for release orders: Usage ID ABRVW
BAPIOBDLVITEMRFO DOC_NUMBER * VBUK Sales Document: Header Status and Administrative Data MANDT
BAPIOBDLVITEMRFO DOC_NUMBER BAPIOBDLVITEMRFO DOC_NUMBER VBUK Sales Document: Header Status and Administrative Data VBELN
BAPIOBDLVITEMRFO ITM_NUMBER BAPIOBDLVITEMRFO ITM_NUMBER VBUP Sales Document: Item Status POSNR
BAPIOBDLVITEMRFO ITM_NUMBER * VBUP Sales Document: Item Status MANDT
BAPIOBDLVITEMRFO ITM_NUMBER BAPIOBDLVITEMRFO DELIV_NUMB VBUP Sales Document: Item Status VBELN
BAPIOBDLVITEMRFO ITM_NUMBER_REF * VBUP Sales Document: Item Status MANDT
BAPIOBDLVITEMRFO ITM_NUMBER_REF BAPIOBDLVITEMRFO DELIV_NUMB VBUP Sales Document: Item Status VBELN
BAPIOBDLVITEMRFO ITM_NUMBER_REF BAPIOBDLVITEMRFO ITM_NUMBER_REF VBUP Sales Document: Item Status POSNR
BAPIOBDLVITEMRFO PO_METHOD * T176 Sales Documents: Customer Order Types MANDT
BAPIOBDLVITEMRFO PO_METHOD BAPIOBDLVITEMRFO PO_METHOD T176 Sales Documents: Customer Order Types BSARK
BAPIOBDLVITEMRFO PO_METH_S BAPIOBDLVITEMRFO PO_METH_S T176 Sales Documents: Customer Order Types BSARK
BAPIOBDLVITEMRFO PO_METH_S * T176 Sales Documents: Customer Order Types MANDT
BAPIOBDLVITEMRFO SUBSTREASON * TVSU Material Substitution: Reasons MANDT
BAPIOBDLVITEMRFO SUBSTREASON BAPIOBDLVITEMRFO SUBSTREASON TVSU Material Substitution: Reasons SUGRD