1. Home
  2. Resources
  3. SAP Tables
  4. RVEDSB_DEL_RPT_ITEM - Self-Billing Delivery Report Structure

SAP Table RVEDSB_DEL_RPT_ITEM

Self-Billing Delivery Report Structure

RVEDSB_DEL_RPT_ITEM (Self-Billing Delivery Report Structure) 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 RVEDSB_DEL_RPT_ITEM to other SAP tables.

RVEDSB_DEL_RPT_ITEM table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
TRMNO_INT Transfer Number (Internal) TRMNO_INT TRNSM NUMC 12 0
DOCNUM IDoc number EDI_DOCNUM NUMC 16 0
DOCSPLIT Splitting Counter if IDoc Contains Several Deliveries DOCSPLIT NUMC 4 0
ORGDAT Original Data From the Transfer ORGDATA CHAR 1 0
X Yes
NULL No
ERDAT Date on Which Record Was Created ERDAT DATS 8 0
ERZET Entry time ERZET TIMS 6 0
AEDAT Changed On AEDAT DATS 8 0
AEZET Time last change was made AEZET TIMS 6 0
AENAM Name of Person Who Changed Object AENAM CHAR 12 0
KUNAG_T Transferred Sold-To Party Number KUNAG_T CHAR 17 0
LIFNR_T Vendor number at customer location LIFNR_ED1 CHAR 17 0
KNREF_T Transferred Customer Plant KNREF_T CHAR 17 0
ABLAD_T Customer's Transferred Unloading Point ABLAD_T CHAR 17 0
PRCTYPH_T Transferred Transaction Code PRCTYPH_T CHAR 3 0
005 Credit memo display /ERS method
006 Retroactive price change/clearing invoice
007 Non-Valuated Goods Receipt (No Processing, Display Only)
DELNOQ_T Transferred Category for Delivery Determination DELNOQ_T CHAR 3 0
009 Invoice Number
012 Delivery Note Number (Imply 061 - 063)
061 Internal delivery note number
062 Customer PO no. for consignment issue by ext. service agent
063 External delivery note number
081 Collective Daily Delivery Note
082 Summarized JIT call
DELNO_T Transferred Number for Delivery Determination DELNO_T CHAR 35 0
VBELN Sales and Distribution Document Number VBELN CHAR 10 0
VBTYP 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
KUNAG Sold-to party KUNAG KNA1 CHAR 10 0
KUNRG Payer KUNRG KNA1 CHAR 10 0
VKORG Sales Organization VKORG TVKO CHAR 4 0
BUKRS Company Code BUKRS T001 CHAR 4 0
GSBER Business Area GSBER TGSB CHAR 4 0
MREFSRC Type/Origin of Main Reference MREFSRC CHAR 1 0
A Transfer Number (E1EDK02-BELNR, Qual.: 074)
B Credit Advice Number (E1EDK02-BELNR, Qual.: 073)
C Cheque Number (E1EDK02-BELNR, Qual.: 075)
D BMW: Vendor Posting Number (E1EDK02-BELNR, Qual.: 076)
E Document Number From IDoc Header (E1EDK01-BELNR)
COMNUM Combination Number COMNUM NUMC 6 0
KUNAG_CUST Sold-To Party for Customizing Data KUNAG_CUST KNA1 CHAR 10 0
DELCOM Group Deliveries DELCOM CHAR 1 0
X Group Same Deliveries in the Processing Step
NULL Do not Group Same Deliveries in the Processing Step
PARPAY Subsets Can Be Displayed PARPAY CHAR 1 0
X Credit Advice Displays Planned for Partial Quantities
NULL Credit Advice Displays Not Planned for Partial Quantities
SBTGRP Tolerance group SBTGRP CHAR 4 0
KSCHL Condition Type KSCHL CHAR 4 0
DDELNO Delivery Note Number to Determine Sales Document DDELNO CHAR 1 0
X Yes
NULL No
DXONO External Order Number to Determine Sales Document DXONO CHAR 1 0
X Yes
NULL No
DXDELNO External Delivery Note Number to Determine Sales Document DXDELNO CHAR 1 0
X Yes
NULL No
DBDJIT Billing Doc. for Delivery Confirmation to Determ. Sales Doc. DBDJIT CHAR 1 0
X Yes
NULL No
DXRELNO Ext. Release No. (sumJC) for Determination DXRELNO CHAR 1 0
X Yes
NULL No
MREFNO Main Reference MREFNO1 CHAR 16 0
CURCY SD Document Currency WAERK TCURC CUKY 5 0
CURCY_T Transferred Currency Converted CURCY_T TCURC CUKY 5 0
CURISO_T Transferred Currency (ISO Code) CURISO_T CHAR 3 0
CURCYRL_T Converted Transferred Original Currency CURCYRL_T TCURC CUKY 5 0
ERRCNT No. of Messages in Verification Step (Header and Item Level) ERRCNT NUMC 3 0
ORGREC Original Data Record is Available for Current Record ORGREC CHAR 1 0
X Yes
NULL No
DEACT Deactivation Indicator DEACT CHAR 1 0
NULL Active
A Manually Deactivated (in Verification Step)
B Automatically Deactivated (in Verification Step)
C Manually Deactivated (in Processing Step)
CONEXIST Records Exist for Conditions to Be Transferred CONEXIST CHAR 1 0
X Yes
NULL No
REFEXIST Records available for transferred reference numbers REFEXIST CHAR 1 0
X Yes
NULL No
DATEXIST Transferred Dates Exist for Records DATEXIST CHAR 1 0
X Yes
NULL No
NEW_OI New Open Item Indicator NEW_OI CHAR 1 0
NETWR_T Transferred Net Value NETWR_T CURR 15 2
NETWR Net value of the billing item in document currency NETWR_FP CURR 15 2
NETWROP Open Still Expected Value NERTWR_OP CURR 15 2
MWSBP_T Transferred VAT Amount MWSBP_T CURR 13 2
MWSBP Tax amount in document currency MWSBP CURR 13 2
APSTAT_IND Indicates There Were Problems During Processing VEDSB_APSTAT_IND CHAR 1 0
NULL Undefined Termination
A OK
B Errors Occurred
NET_DIFF Net Value Difference VEDSB_NET_DIFF CURR 15 2
SKTBT Discount amount SKTBT CURR 13 2
SKTBT_T Transferred Discount Amount SKTBT_T CURR 13 2
STEP_INDICATOR Processing Progress RVEDSB_STEP_IND CHAR 1 0
0 By Verification Step
1 By Processing Step
PERED Error in Verification Step Processed PERED CHAR 1 0
X Yes
NULL No
DIFFERENCE_IND Indicates a difference in the transmitted and delivery value RVEDSB_DIFFERENCE_IND CHAR 1 0
A Positive Difference
B Negative Difference
VSBPER_COUNT Number of Messages From Verification Step RVEDSB_VSBPER_COUNT NUMC 5 0
VSBMER_COUNT Number of Messages From Processing Step RVEDSB_VSBMER_COUNT NUMC 5 0
NETWRRL_T Transferred Net Value in Original Currency NETWRRL_T CURR 15 2
MWSBPRL_T Transferred Tax in Original Currency MWSBPRL_T CURR 13 2
SKTBTRL_T Transferred Discount in Original Currency SKTBTRL_T CURR 13 2
BRTWR_T Tranferred Gross Value BRTWR_T CURR 15 2
DIFFREASON Reason for Differences Within Total Delivery RVEDSB_DIFFREASON NUMC 1 0
0 No Differences
1 Only Value Differences
2 Only Quantity/Value Differences
3 Value References and Quantity/Value Differences
POSDIFF Positive Difference in Net Value Occurred RVEDSB_POSDIFF CHAR 7 0
NEGDIFF Negative Difference in Net Value Occurred RVEDSB_NEGDIFF CHAR 7 0

RVEDSB_DEL_RPT_ITEM foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
RVEDSB_DEL_RPT_ITEM BUKRS RVEDSB_DEL_RPT_ITEM BUKRS T001 Company Codes BUKRS
RVEDSB_DEL_RPT_ITEM BUKRS RVEDSB_DEL_RPT_ITEM MANDT T001 Company Codes MANDT
RVEDSB_DEL_RPT_ITEM CURCY RVEDSB_DEL_RPT_ITEM MANDT TCURC Currency Codes MANDT
RVEDSB_DEL_RPT_ITEM CURCY RVEDSB_DEL_RPT_ITEM CURCY TCURC Currency Codes WAERS
RVEDSB_DEL_RPT_ITEM CURCYRL_T RVEDSB_DEL_RPT_ITEM MANDT TCURC Currency Codes MANDT
RVEDSB_DEL_RPT_ITEM CURCYRL_T RVEDSB_DEL_RPT_ITEM CURCYRL_T TCURC Currency Codes WAERS
RVEDSB_DEL_RPT_ITEM CURCY_T RVEDSB_DEL_RPT_ITEM CURCY_T TCURC Currency Codes WAERS
RVEDSB_DEL_RPT_ITEM CURCY_T RVEDSB_DEL_RPT_ITEM MANDT TCURC Currency Codes MANDT
RVEDSB_DEL_RPT_ITEM GSBER RVEDSB_DEL_RPT_ITEM MANDT TGSB Business Areas MANDT
RVEDSB_DEL_RPT_ITEM GSBER RVEDSB_DEL_RPT_ITEM GSBER TGSB Business Areas GSBER
RVEDSB_DEL_RPT_ITEM KUNAG RVEDSB_DEL_RPT_ITEM MANDT KNA1 General Data in Customer Master MANDT
RVEDSB_DEL_RPT_ITEM KUNAG RVEDSB_DEL_RPT_ITEM KUNAG KNA1 General Data in Customer Master KUNNR
RVEDSB_DEL_RPT_ITEM KUNAG_CUST RVEDSB_DEL_RPT_ITEM KUNAG_CUST KNA1 General Data in Customer Master KUNNR
RVEDSB_DEL_RPT_ITEM KUNAG_CUST RVEDSB_DEL_RPT_ITEM MANDT KNA1 General Data in Customer Master MANDT
RVEDSB_DEL_RPT_ITEM KUNRG RVEDSB_DEL_RPT_ITEM MANDT KNA1 General Data in Customer Master MANDT
RVEDSB_DEL_RPT_ITEM KUNRG RVEDSB_DEL_RPT_ITEM KUNRG KNA1 General Data in Customer Master KUNNR
RVEDSB_DEL_RPT_ITEM MANDT RVEDSB_DEL_RPT_ITEM MANDT T000 Clients MANDT
RVEDSB_DEL_RPT_ITEM TRMNO_INT RVEDSB_DEL_RPT_ITEM MANDT TRNSM Data Transfer MANDT
RVEDSB_DEL_RPT_ITEM TRMNO_INT RVEDSB_DEL_RPT_ITEM TRMNO_INT TRNSM Data Transfer TRMNO_INT
RVEDSB_DEL_RPT_ITEM VKORG RVEDSB_DEL_RPT_ITEM MANDT TVKO Organizational Unit: Sales Organizations MANDT
RVEDSB_DEL_RPT_ITEM VKORG RVEDSB_DEL_RPT_ITEM VKORG TVKO Organizational Unit: Sales Organizations VKORG