1. Home
  2. Resources
  3. SAP Tables
  4. TDS_BLOCKEDDOC - Blocked SD Documents (Delivery, Billing Document)

SAP Table TDS_BLOCKEDDOC

Blocked SD Documents (Delivery, Billing Document)

TDS_BLOCKEDDOC (Blocked SD Documents (Delivery, Billing Document)) 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_BLOCKEDDOC to other SAP tables.

TDS_BLOCKEDDOC table fields

Field Data element Checktable Datatype Length Decimals
VBELN Sales and Distribution Document Number VBELN CHAR 10 0
TRVOG Transaction Group TRVOG_GEN CHAR 1 0
0 Order
1 Inquiry
2 Offer
3 Scheduling Agreement
4 Contract
TRVOGT Description BEZEI20 CHAR 20 0
AUART Sales Document Type AUART CHAR 4 0
AUARTT Description BEZEI20 CHAR 20 0
KUNNR Sold-to party KUNAG KNA1 CHAR 10 0
ERDAT Date on Which Record Was Created ERDAT DATS 8 0
ZPAVW Partner Function PARVW CHAR 2 0
ZPERS Person responsible DZPERS NUMC 8 0
ERNAM Name of Person who Created the Object ERNAM CHAR 12 0
VKORG Sales Organization VKORG TVKO CHAR 4 0
VTWEG Distribution Channel VTWEG TVTW CHAR 2 0
SPART Division SPART TSPA CHAR 2 0
VKBUR Sales Office VKBUR TVBUR CHAR 4 0
VKGRP Sales Group VKGRP TVKGR CHAR 3 0
WAERK SD Document Currency WAERK CUKY 5 0
NETWR Net Value of the Sales Order in Document Currency NETWR_AK CURR 15 2
AWAHR Sales probability AWAHR_AK NUMC 3 0
000 Sales order probability
LIFSK Delivery block (document header) LIFSK TVLS CHAR 2 0
LIFSKT Description BEZEI20 CHAR 20 0
FAKSK Billing block in SD document FAKSK TVFS CHAR 2 0
FAKSKT Description BEZEI20 CHAR 20 0
KS Single-Character Indicator CHAR1 CHAR 1 0
PS Single-Character Indicator CHAR1 CHAR 1 0
AS Single-Character Indicator CHAR1 CHAR 1 0
KR Single-Character Indicator CHAR1 CHAR 1 0
PF Indicator Billing Block Item PF CHAR 1 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
KUNNR_T Employee's last name NAME CHAR 35 0
PZPERS_T Name of Employee Responsible PZPERS_BEZ CHAR 35 0
PARVW_T Description of partner function PARVW_BEZ CHAR 20 0
VKORG_T Description of sales organization VKORG_BEZ CHAR 20 0
VTWEG_T Description of distribution channel VTWEG_BEZ CHAR 20 0
SPART_T Description of division SPART_BEZ CHAR 20 0
VKBUR_T Description of sales office VKBUR_BEZ CHAR 20 0
VKGRP_T Description of Sales Group VKGRP_BEZ CHAR 20 0
VBTYP_T Description of sales and distribution document category VBTYP_TXT CHAR 60 0

TDS_BLOCKEDDOC foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
TDS_BLOCKEDDOC FAKSK SYST MANDT TVFS Billing: Reasons for Blocking MANDT
TDS_BLOCKEDDOC FAKSK TDS_BLOCKEDDOC FAKSK TVFS Billing: Reasons for Blocking FAKSP
TDS_BLOCKEDDOC KUNNR SYST MANDT KNA1 General Data in Customer Master MANDT
TDS_BLOCKEDDOC KUNNR TDS_BLOCKEDDOC KUNNR KNA1 General Data in Customer Master KUNNR
TDS_BLOCKEDDOC LIFSK SYST MANDT TVLS Deliveries: Blocking Reasons/Criteria MANDT
TDS_BLOCKEDDOC LIFSK TDS_BLOCKEDDOC LIFSK TVLS Deliveries: Blocking Reasons/Criteria LIFSP
TDS_BLOCKEDDOC SPART SYST MANDT TSPA Organizational Unit: Sales Divisions MANDT
TDS_BLOCKEDDOC SPART TDS_BLOCKEDDOC SPART TSPA Organizational Unit: Sales Divisions SPART
TDS_BLOCKEDDOC VKBUR SYST MANDT TVBUR Organizational Unit: Sales Offices MANDT
TDS_BLOCKEDDOC VKBUR TDS_BLOCKEDDOC VKBUR TVBUR Organizational Unit: Sales Offices VKBUR
TDS_BLOCKEDDOC VKGRP SYST MANDT TVKGR Organizational Unit: Sales Groups MANDT
TDS_BLOCKEDDOC VKGRP TDS_BLOCKEDDOC VKGRP TVKGR Organizational Unit: Sales Groups VKGRP
TDS_BLOCKEDDOC VKORG TDS_BLOCKEDDOC VKORG TVKO Organizational Unit: Sales Organizations VKORG
TDS_BLOCKEDDOC VKORG SYST MANDT TVKO Organizational Unit: Sales Organizations MANDT
TDS_BLOCKEDDOC VTWEG SYST MANDT TVTW Organizational Unit: Distribution Channels MANDT
TDS_BLOCKEDDOC VTWEG TDS_BLOCKEDDOC VTWEG TVTW Organizational Unit: Distribution Channels VTWEG