SAP table RVEDSB_DEL_RPT_ITEM (Self-Billing Delivery Report Structure)

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
TRMNO_INT Transfer Number (Internal) NUMC 12 0 TRNSM TRMNO_INT
DOCNUM IDoc number NUMC 16 0 EDI_DOCNUM
DOCSPLIT Splitting Counter if IDoc Contains Several Deliveries NUMC 4 0 DOCSPLIT
ORGDAT Original Data From the Transfer CHAR 1 0 ORGDATA
ERDAT Date on which the record was created DATS 8 0 ERDAT
ERZET Entry time TIMS 6 0 ERZET
AEDAT Last Changed On DATS 8 0 AEDAT
AEZET Time last change was made TIMS 6 0 AEZET
AENAM Name of Person Who Changed Object CHAR 12 0 AENAM
KUNAG_T Transferred Sold-To Party Number CHAR 17 0 KUNAG_T
LIFNR_T Supplier Number at Customer Location CHAR 17 0 LIFNR_ED1
KNREF_T Transferred Customer Plant CHAR 17 0 KNREF_T
ABLAD_T Customer's Transferred Unloading Point CHAR 17 0 ABLAD_T
PRCTYPH_T Transferred Transaction Code CHAR 3 0 PRCTYPH_T
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 CHAR 3 0 DELNOQ_T
DELNO_T Transferred Number for Delivery Determination CHAR 35 0 DELNO_T
VBELN Sales and Distribution Document Number CHAR 10 0 * VBELN
VBTYP SD Document Category CHAR 4 0 VBTYPL
# Revenue Recognition (Temporary)
$ (AFS)
& Warehouse Document
* Pick Order
+ Journal Entry (Temporary)
, Shipment Document
- Journal Entry (Temporary)
. Service Notification
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
: Service Order
A Inquiry
a Shipment Costs
b CRM Opportunity
B Quotation
BOS Service Entry Sheet
C Order
c Unverified Delivery
CEM ETM Shipping Document
CMMA Customer Management Master Agreement
CSCO Customer Management Service Confirmation
CSCT Customer Management Service Contract
CSVO Customer Management Service Order
D Item Proposal
d Trading Contract
e Allocation Table
E Scheduling Agreement
EBDR Billing Document Request
F Scheduling Agreement with External Service Agent
f001 Period-End Invoice
f002 Period-End Credit Memo
f003 Period-End Invoice (Intercompany Billing)
f004 Period-End Credit Memo (Intercompany Billing)
G Contract
g Rough Goods Receipt (only IS-Retail)
GBRQ Grants Management Billing Request
h Cancel Goods Issue
H Returns
i Goods Receipt
I Order Without Charge
J Delivery
j JIT Call
K Credit Memo Request
k Settlement Management Document
L Debit Memo Request
M Invoice
N Invoice Cancellation
n Reserved
O Credit Memo
o Reserved
P Debit Memo
p Goods Movement (Documentation)
PBD Preliminary Billing Document
PBDR Billing Document Request for Prof. Serv.
PBRQ Project Billing Request
q Reserved
Q WMS Transfer Order
R Goods Movement
r TD Transport (Only IS-Oil)
S Credit Memo Cancellation
s Load Confirmation, Reposting (Only IS-Oil)
SBRQ Subscription Billing Request
SOLO Solution Order
t Gain / Loss (Only IS-Oil)
T Returns Delivery for Order
TMFO Freight Order
TMFU Freight Unit
U Pro Forma Invoice
u Reentry into Storage (Only IS-Oil)
v Data Collation (Only IS-Oil)
V Purchase Order
W Independent Reqts Plan
w Reservation (Only IS-Oil)
X Handling Unit
x Load Confirmation, Goods Receipt (Only IS-Oil)
Y Rebate Agreement
^ Reserved
| Reserved
~ Revenue Cancellation (Temporary)
ยง Revenue Recognition/New View (Temporary)
KUNAG Sold-to Party CHAR 10 0 KNA1 KUNAG
KUNRG Payer CHAR 10 0 KNA1 KUNRG
VKORG Sales Organization CHAR 4 0 TVKO VKORG
BUKRS Company Code CHAR 4 0 T001 BUKRS
GSBER Business Area CHAR 4 0 TGSB GSBER
MREFSRC Type/Origin of Main Reference CHAR 1 0 MREFSRC
A Transfer Number (E1EDK02-BELNR, Qual.: 074)
B Credit Advice Number (E1EDK02-BELNR, Qual.: 073)
C Cheque Number (E1EDK02-BELNR, Qual.: 075)
D BMW: Supplier Posting Number (E1EDK02-BELNR, Qual.: 076)
E Document Number From IDoc Header (E1EDK01-BELNR)
COMNUM Combination Number NUMC 6 0 COMNUM
KUNAG_CUST Sold-To Party for Customizing Data CHAR 10 0 KNA1 KUNAG_CUST
DELCOM Group Deliveries CHAR 1 0 DELCOM
Do not Group Same Deliveries in the Processing Step
X Group Same Deliveries in the Processing Step
PARPAY Subsets Can Be Displayed CHAR 1 0 PARPAY
Credit Advice Displays Not Planned for Partial Quantities
X Credit Advice Displays Planned for Partial Quantities
SBTGRP Tolerance group CHAR 4 0 SBTGRP
KSCHL Condition Type CHAR 4 0 * KSCHL
DDELNO Delivery Note Number to Determine Sales Document CHAR 1 0 DDELNO
DXONO External Order Number to Determine Sales Document CHAR 1 0 DXONO
DXDELNO External Delivery Note Number to Determine Sales Document CHAR 1 0 DXDELNO
DBDJIT Billing Doc. for Delivery Confirmation to Determ. Sales Doc. CHAR 1 0 DBDJIT
DXRELNO Ext. Release No. (sumJC) for Determination CHAR 1 0 DXRELNO
MREFNO Main Reference CHAR 16 0 MREFNO1
CURCY SD Document Currency CUKY 5 0 TCURC WAERK
CURCY_T Transferred Currency Converted CUKY 5 0 TCURC CURCY_T
CURISO_T Transferred Currency (ISO Code) CHAR 3 0 CURISO_T
CURCYRL_T Converted Transferred Original Currency CUKY 5 0 TCURC CURCYRL_T
ERRCNT No. of Messages in Verification Step (Header and Item Level) NUMC 3 0 ERRCNT
ORGREC Original Data Record is Available for Current Record CHAR 1 0 ORGREC
DEACT Deactivation Indicator CHAR 1 0 DEACT
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 CHAR 1 0 CONEXIST
REFEXIST Records available for transferred reference numbers CHAR 1 0 REFEXIST
DATEXIST Transferred Dates Exist for Records CHAR 1 0 DATEXIST
NEW_OI New Open Item Indicator CHAR 1 0 NEW_OI
NETWR_T Transferred Net Value CURR 15 2 NETWR_T
NETWR Net Value of Billing item in Document Currency CURR 15 2 NETWR_FP
NETWROP Open Still Expected Value CURR 15 2 NERTWR_OP
MWSBP_T Transferred VAT Amount CURR 13 2 MWSBP_T
MWSBP Tax Amount in Document Currency CURR 13 2 MWSBP
APSTAT_IND Indicates There Were Problems During Processing CHAR 1 0 VEDSB_APSTAT_IND
NET_DIFF Net Value Difference CURR 15 2 VEDSB_NET_DIFF
SKTBT Discount amount CURR 13 2 SKTBT
SKTBT_T Transferred Discount Amount CURR 13 2 SKTBT_T
STEP_INDICATOR Processing Progress CHAR 1 0 RVEDSB_STEP_IND
0 By Verification Step
1 By Processing Step
PERED Error in Verification Step Processed CHAR 1 0 PERED
DIFFERENCE_IND Indicates a difference in the transmitted and delivery value CHAR 1 0 RVEDSB_DIFFERENCE_IND
A Positive Difference
B Negative Difference
VSBPER_COUNT Number of Messages From Verification Step NUMC 5 0 RVEDSB_VSBPER_COUNT
VSBMER_COUNT Number of Messages From Processing Step NUMC 5 0 RVEDSB_VSBMER_COUNT
NETWRRL_T Transferred Net Value in Original Currency CURR 15 2 NETWRRL_T
MWSBPRL_T Transferred Tax in Original Currency CURR 13 2 MWSBPRL_T
SKTBTRL_T Transferred Discount in Original Currency CURR 13 2 SKTBTRL_T
BRTWR_T Tranferred Gross Value CURR 15 2 BRTWR_T
DIFFREASON Reason for Differences Within Total Delivery NUMC 1 0 RVEDSB_DIFFREASON
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 CHAR 7 0 RVEDSB_POSDIFF
NEGDIFF Negative Difference in Net Value Occurred CHAR 7 0 RVEDSB_NEGDIFF

RVEDSB_DEL_RPT_ITEM foreign key relationships

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