SAP Table TDS_BILLDUE

Billing Due List

TDS_BILLDUE (Billing Due List) 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 TDS_BILLDUE to other SAP tables.

TDS_BILLDUE table fields

Field Data element Checktable Datatype Length Decimals
FKTYP Billing category FKTYP CHAR 1 0
A Order-related billing document
B Order-related billing document for rebate settlement
C Order-related billing document for partial rebate settlement
D Periodic billing document
E Periodic billing with active invoice accrual
F Accrual
I Delivery-related billing document for inter-company billing
K Order-related billing document for rebate correction
L Delivery-related billing document
P Down payment request
R Invoice list
U Billing request
W POS billing document
X Billing using general interface
S CRM Billing Document
N Provisional or Differential Billing Document
O Final Billing Document
VKORG Sales Organization VKORG CHAR 4 0
FKDAT Billing date for billing index and printout FKDAT DATS 8 0
KUNNR Sold-to party KUNAG CHAR 10 0
FKART Billing Type FKART CHAR 4 0
LLAND Country of Destination LLAND CHAR 3 0
VBELN Sales and Distribution Document Number VBELN CHAR 10 0
VTWEG Distribution Channel VTWEG CHAR 2 0
SPART Division SPART CHAR 2 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
ADRNR Address ADRNR CHAR 10 0
NAME1 Name of the sold-to party NAME_AG CHAR 35 0
ORT01 Location of the sold-to party ORT01_AG CHAR 35 0
SORTKRI Sort Criterion SORTKRI CHAR 20 0
KZPOS Relevant items have been read for this index record KZPOS CHAR 1 0
X Yes
NULL No
ZAEHL Counter with 7 Digits DZAEHL7 NUMC 7 0
VSTEL Shipping Point/Receiving Point VSTEL CHAR 4 0
PDSTK POD status on header level PDSTK CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
NETWR Net Value in Document Currency NETWR CURR 15 2
WAERK SD Document Currency WAERK CUKY 5 0
V_FKDAT Billing date for billing index and printout FKDAT DATS 8 0
V_FKART Billing Type FKART CHAR 4 0
STATF Processing status of documents in billing due list STATF CHAR 4 0
SAMMG Group SAMMG CHAR 10 0
TEXT_FKTYP Short Text for Fixed Values VAL_TEXT CHAR 60 0
TEXT_VKORG Name VTXTK CHAR 20 0
TEXT_FKART Description BEZEI20 CHAR 20 0
TEXT_LLAND Country Name (Max. 50 Characters) LANDX50 CHAR 50 0
TEXT_VTWEG Name VTXTK CHAR 20 0
TEXT_SPART Name VTXTK CHAR 20 0
TEXT_VBTYP Short Text for Fixed Values VAL_TEXT CHAR 60 0
TEXT_STRAS House number and street STRAS_GP CHAR 35 0
TEXT_VSTEL Description BEZEI30 CHAR 30 0
TEXT_WAERK Long Text LTEXT CHAR 40 0