SAP ABAP Table TDS_SALESDOC (Lean Order: Sales Document)
Hierarchy
☛
SAP_APPL (Software Component) Logistics and Accounting
⤷ SD-SLS (Application Component) Sales
⤷ ERP_SALES_O2C_SLS (Package) ERP Sales Order 2 Cash - Sales
⤷ SD-SLS (Application Component) Sales
⤷ ERP_SALES_O2C_SLS (Package) ERP Sales Order 2 Cash - Sales
Basic Data
Table Category | INTTAB | Structure |
Structure | TDS_SALESDOC | Table Relationship Diagram |
Short Description | Lean Order: Sales Document |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | VBELN | VBELN | VBELN | CHAR | 10 | 0 | Sales and Distribution Document Number | * | |
2 | TRVOG | TRVOG_GEN | TRVOG_GEN | CHAR | 1 | 0 | Transaction Group | ||
3 | TRVOG_T | BEZEI20 | TEXT20 | CHAR | 20 | 0 | Description | ||
4 | AUART | AUART | AUART | CHAR | 4 | 0 | Sales Document Type | * | |
5 | AUART_T | BEZEI20 | TEXT20 | CHAR | 20 | 0 | Description | ||
6 | KUNAG | KUNAG | KUNNR | CHAR | 10 | 0 | Sold-to party | * | |
7 | KUNAG_T | AD_NAME1 | TEXT40 | CHAR | 40 | 0 | Name 1 | ||
8 | BSTKD | BSTKD | BSTKD | CHAR | 35 | 0 | Customer purchase order number | ||
9 | ERDAT | ERDAT | DATUM | DATS | 8 | 0 | Date on which the record was created | ||
10 | ERNAM | ERNAM | USNAM | CHAR | 12 | 0 | Name of Person who Created the Object | ||
11 | ZPAVW | PARVW | PARVW | CHAR | 2 | 0 | Partner Role | * | |
12 | ZPERS | DZPERS | PERNR | NUMC | 8 | 0 | Person responsible | ||
13 | VKORG | VKORG | VKORG | CHAR | 4 | 0 | Sales Organization | * | |
14 | VTWEG | VTWEG | VTWEG | CHAR | 2 | 0 | Distribution Channel | * | |
15 | SPART | SPART | SPART | CHAR | 2 | 0 | Division | * | |
16 | VKBUR | VKBUR | VKBUR | CHAR | 4 | 0 | Sales office | * | |
17 | VKGRP | VKGRP | VKGRP | CHAR | 3 | 0 | Sales group | * | |
18 | DATAB | DATAB_VI | DATUM | DATS | 8 | 0 | Quotation or contract valid from | ||
19 | DATBI | DATBI_VI | DATUM | DATS | 8 | 0 | Quotation or contract valid to | ||
20 | WAERK | WAERK | WAERS | CUKY | 5 | 0 | SD document currency | * | |
21 | NETWR | NETWR_AK | WERTV8 | CURR | 15 | 2 | Net Value of the Sales Order in Document Currency | ||
22 | AWAHR | AWAHR_AK | AWAHR | NUMC | 3 | 0 | Sales Probability | ||
23 | PZPERS_T | PZPERS_BEZ | NAME | CHAR | 35 | 0 | Name of Employee Responsible | ||
24 | PARVW_T | PARVW_BEZ | TEXT20 | CHAR | 20 | 0 | Description of partner function | ||
25 | VKORG_T | VKORG_BEZ | TEXT20 | CHAR | 20 | 0 | Description of sales organization | ||
26 | VTWEG_T | VTWEG_BEZ | TEXT20 | CHAR | 20 | 0 | Description of distribution channel | ||
27 | SPART_T | SPART_BEZ | TEXT20 | CHAR | 20 | 0 | Description of division | ||
28 | VKBUR_T | VKBUR_BEZ | TEXT20 | CHAR | 20 | 0 | Description of sales office | ||
29 | VKGRP_T | VKGRP_BEZ | TEXT20 | CHAR | 20 | 0 | Description of Sales Group | ||
30 | SPSTG | SPSTG | STATV | CHAR | 1 | 0 | Overall blocked status | ||
31 | ABSTK | ABSTK | STATV | CHAR | 1 | 0 | Overall rejection status of all sales document items | ||
32 | GBSTK | GBSTK | STATV | CHAR | 1 | 0 | Overall processing status of document | ||
33 | UVALS | UVALL_SU | STATV | CHAR | 1 | 0 | Total incompletion status of all items in general | ||
34 | UVALL | UVALL_UK | STATV | CHAR | 1 | 0 | General incompletion status of the header | ||
35 | UVVLS | UVVLS_SU | STATV | CHAR | 1 | 0 | Total incompletion status of all items: Delivery | ||
36 | UVFAS | UVFAK_SU | STATV | CHAR | 1 | 0 | Total incompletion status of all items: Billing | ||
37 | UVVLK | UVVLK_UK | STATV | CHAR | 1 | 0 | Header incompletion status concerning delivery | ||
38 | UVFAK | UVFAK_UK | STATV | CHAR | 1 | 0 | Header incompletion status with respect to billing | ||
39 | UVPRS | UVPRS_UK | STATV | CHAR | 1 | 0 | Document is incomplete with respect to pricing | ||
40 | CMGST | CMGST | CMGST | CHAR | 1 | 0 | Overall status of credit checks | ||
41 | LFSTK | LFSTK | STATV | CHAR | 1 | 0 | Delivery status | ||
42 | FSSTK | FSSTK | STATV | CHAR | 1 | 0 | Overall billing block status | ||
43 | LSSTK | LSSTK_G | STATV | CHAR | 1 | 0 | Overall delivery block status | ||
44 | AUGRU | AUGRU | AUGRU | CHAR | 3 | 0 | Order reason (reason for the business transaction) | * | |
45 | AUDAT | AUDAT | DATUM | DATS | 8 | 0 | Document Date (Date Received/Sent) | ||
46 | VSBED | VSBED | VSBED | CHAR | 2 | 0 | Shipping conditions | * | |
47 | GUEBG | GUEBG | DATUM | DATS | 8 | 0 | Valid-from date (outline agreements, product proposals) | ||
48 | GUEEN | GUEEN | DATUM | DATS | 8 | 0 | Valid-to date (outline agreements, product proposals) | ||
49 | BSTDK | BSTDK | DATUM | DATS | 8 | 0 | Customer purchase order date | ||
50 | INCO1 | INCO1 | INCO1 | CHAR | 3 | 0 | Incoterms (part 1) | * | |
51 | INCO2 | INCO2 | INCO2 | CHAR | 28 | 0 | Incoterms (part 2) | ||
52 | ZTERM | DZTERM | ZTERM | CHAR | 4 | 0 | Terms of payment key | ||
53 | ZTERM_T | DZTERM_BEZ | TEXT30 | CHAR | 30 | 0 | Description of terms of payment | ||
54 | VBTYP | VBTYP | VBTYP | CHAR | 1 | 0 | SD document category | ||
55 | VBTYP_T | VBTYP_TXT | AS4TEXT | CHAR | 60 | 0 | Description of sales and distribution document category | ||
56 | POSNR | POSNR_VA | POSNR | NUMC | 6 | 0 | Sales Document Item | * | |
57 | MATNR | MATNR | MATNR | CHAR | 18 | 0 | Material Number | * | |
58 | ARKTX | ARKTX | TEXT40 | CHAR | 40 | 0 | Short text for sales order item | ||
59 | KWMENG | KWMENG | MENG15 | QUAN | 15 | 3 | Cumulative order quantity in sales units | ||
60 | VRKME | VRKME | MEINS | UNIT | 3 | 0 | Sales unit | * | |
61 | KBMENG | KBMENG | MENG15 | QUAN | 15 | 3 | Cumulative confirmed quantity in sales unit | ||
62 | KDMAT | MATNR_KU | IDNEX | CHAR | 35 | 0 | Customer Material Number | ||
63 | ABGRU | ABGRU_VA | ABGRU_VA | CHAR | 2 | 0 | Reason for rejection of quotations and sales orders | * | |
64 | ABGRU_T | ABGRU_BEZ | TEXT40 | CHAR | 40 | 0 | Description of reason for rejection | ||
65 | MEINS | MEINS | MEINS | UNIT | 3 | 0 | Base Unit of Measure | * | |
66 | ZMENG | DZMENG | MENG13 | QUAN | 13 | 3 | Target quantity in sales units | ||
67 | ZWERT | DZWERT | WERT7 | CURR | 13 | 2 | Target value for outline agreement in document currency | ||
68 | ZIEME | DZIEME | MEINS | UNIT | 3 | 0 | Target quantity UoM | * | |
69 | NETPR | NETPR | WERTV6 | CURR | 11 | 2 | Net price | ||
70 | WERKS | WERKS_EXT | WERKS | CHAR | 4 | 0 | Plant (Own or External) | * | |
71 | UMZIZ | UMZIZ | UMBSZ | DEC | 5 | 0 | Factor for converting sales units to base units (target qty) | ||
72 | UMZIN | UMZIN | UMBSN | DEC | 5 | 0 | Factor for converting sales units to base units (target qty) | ||
73 | POSEX | POSEX | POSEX | CHAR | 6 | 0 | Item Number of the Underlying Purchase Order | ||
74 | FAKSP | FAKSP_AP | FAKSP | CHAR | 2 | 0 | Billing block for item | * | |
75 | CMPRE | CMPRE | WERTV6 | CURR | 11 | 2 | Item credit price | ||
76 | BEDAE | BEDAE | BEDAE | CHAR | 4 | 0 | Requirements type | * | |
77 | CHARG | CHARG_D | CHARG | CHAR | 10 | 0 | Batch Number | * | |
78 | PSTYV | PSTYV | PSTYV | CHAR | 4 | 0 | Sales document item category | * | |
79 | PSTYV_T | PSTYV_BEZ | TEXT20 | CHAR | 20 | 0 | Description of item category | ||
80 | UMVKZ | UMVKZ | UMBSZ | DEC | 5 | 0 | Numerator (factor) for conversion of sales quantity into SKU | ||
81 | UMVKN | UMVKN | UMBSN | DEC | 5 | 0 | Denominator (divisor) for conversion of sales qty. into SKU | ||
82 | VBELV | VBELV | VBELN | CHAR | 10 | 0 | Originating document | * | |
83 | POSNV | POSNV | POSNR | NUMC | 6 | 0 | Originating item | * | |
84 | VGBEL | VGBEL | VBELN | CHAR | 10 | 0 | Document number of the reference document | * | |
85 | VGPOS | VGPOS | POSNR | NUMC | 6 | 0 | Item number of the reference item | * | |
86 | VGTYP | VBTYP_V | VBTYP | CHAR | 1 | 0 | Document category of preceding SD document | ||
87 | PRCTR | PRCTR | PRCTR | CHAR | 10 | 0 | Profit Center | * | |
88 | OBJNR | OBJPO | J_OBJNR | CHAR | 22 | 0 | Object number at item level | * | |
89 | PS_PSP_PNR | PS_PSP_PNR | PS_POSNR | NUMC | 8 | 0 | Work Breakdown Structure Element (WBS Element) | * | |
90 | POSID | PS_POSID | PS_POSID | CHAR | 24 | 0 | Work Breakdown Structure Element (WBS Element) | ||
91 | POST1 | PS_POST1 | TEXT40 | CHAR | 40 | 0 | PS: Short description (first text line) |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 602 |