TVKO is a standard Account Determination Transparent Table in SAP SD application, which stores Organizational Unit: Sales Organizations data. Below you can view the Table Structure, columns(fields), SAP Wiki pages, discussion threads, related TCodes, FMs, ABAP Reports, BW Datasources, and Authorization Objects for TVKO. You can use the transaction code SE16 to view the data in this table, and SE11 TCode for the table structure and definition.
TVKO — Meta Data
Description: | Organizational Unit: Sales Organizations |
Main Category: | SD |
Sub Category: | Account Determination |
Table type: | Transparent Table (TRANSP) |
TVKO — Table Structure, Fields(Columns) and Definitions
Position | Column Name | Description | Primary Key | Data Type | Length | Check Table |
---|---|---|---|---|---|---|
1 | MANDT | Client | X | CLNT | 3 | |
2 | VKORG | Sales Org. | X | CHAR | 4 | |
3 | .INCLUDE | 0 | ||||
4 | WAERS | Currency | CUKY | 5 | TCURC | |
5 | BUKRS | Company Code | CHAR | 4 | T001 | |
6 | ADRNR | Address | CHAR | 10 | * | |
7 | TXNAM_ADR | Text name for form text module short address | CHAR | 16 | ||
8 | TXNAM_KOP | Text name for form text module letter header | CHAR | 16 | ||
9 | TXNAM_FUS | Text name for formula text module footer lines | CHAR | 16 | ||
10 | TXNAM_GRU | Text name for form text module: Greeting | CHAR | 16 | ||
11 | VKOAU | Reference sales org.for sales doc.types (by sales area) | CHAR | 4 | TVKO | |
12 | KUNNR | Customer | CHAR | 10 | KNA1 | |
13 | BOAVO | Rebate processing active in the sales organization | CHAR | 1 | ||
14 | VKOKL | Sales organization calendar | CHAR | 2 | TFACD | |
15 | EKORG | Purchasing Org. | CHAR | 4 | T024E | |
16 | EKGRP | Purch. Group | CHAR | 3 | T024 | |
17 | LIFNR | Vendor | CHAR | 10 | LFA1 | |
18 | WERKS | Plant | CHAR | 4 | T001W | |
19 | BSART | Document Type | CHAR | 4 | T161 | |
20 | BSTYP | Doc. Category | CHAR | 1 | ||
21 | BWART | Movement Type (Inventory Management) | CHAR | 3 | T156 | |
22 | LGORT | Stor. Location | CHAR | 4 | T001L | |
23 | TXNAM_SDB | Text names for layout-set module SDS sender | CHAR | 16 | ||
24 | MWSKZ | Tax code | CHAR | 2 | T007A | |
25 | XSTCEG | Determining the VAT registration number | CHAR | 1 | ||
26 | J_1ANUTIME | Time of numbering for deliveries | CHAR | 1 | ||
27 | MAXBI | Maximum Number of Items in Billing Document | NUMC | 3 |
SAP Help, Wiki Resources, and Forum Discussions on TVKO
-
Get the data from TVKO n VBAK tables | SCN
Based on the selection screen i have to retrieve the data for VKORG and SPART.
http://scn.sap.com/message/3947247
-
Sales organization with more than one company code, VBAK-BUKRS_VF , TVKO
Skip to Content We're sorry, but you're attempting to access SCN content that was not migrated to the new SAP Community experience. ...
http://scn.sap.com/thread/3201276
Related Tables
TABLE | Description | Functional Area |
---|---|---|
VBAK | Sales Document: Header Data | SD - Sales |
MARA | General Material Data | Logistics - Material Master |
T001 | Company Codes | FI - Financial Accounting |
T001W | Plants/Branches | Logistics - Plant Master |
TVTA | Organizational Unit: Sales Area(s) | SD - Account Determination |
VBRK | Billing Document: Header Data | SD - Billing |
TVTW | Organizational Unit: Distribution Channels | SD - Account Determination |
Transaction Codes for SAP Table TVKO
TCODE | Description | Functional Area |
---|---|---|
SPRO | Customizing - Edit Project | Basis - Customizing Project Management (IMG) |
SLIS | FI-SL Spec.Purpose Ledg. Info.System | FI - Information System |
VA01 | Create Sales Order | SD - Sales |
AFAB | Post depreciation | FI - Basic Functions |
SE11 | ABAP Dictionary Maintenance | Basis - Dictionary Maintenance |
MCHB | RIS: Till Receipt - Selection | Logistics - Retail Information System (RIS) |
MCHA | RIS: Till Receipt/Matl - Selection | Logistics - Retail Information System (RIS) |
MIGO | Goods Movement | MM - Inventory Management |
FMs for SAP Table TVKO
FM | Description | Functional Area |
---|---|---|
REUSE_ALV_GRID_DISPLAY | Output of a simple list (single-line) | Basis - SAP List Viewer |
REUSE_ALV_COMMENTARY_WRITE | List body comment block output | BC - SAP List Viewer |
REUSE_ALV_EVENTS_GET | Returns table of possible events for a list type | BC - SAP List Viewer |
F4_FILENAME | F4 for filename / Filemanager support to locate file in a directory | PM - Plant Maintenance |
ADDR_GET | Read an address without dialog | Basis - Address Management/Business Address |
BAPI_COMPANYCODE_GET_PERIOD | For Company Code: Posting Date -> Period, Fiscal Year | FI - Financial Accounting |
REUSE_ALV_FIELDCATALOG_MERGE | Create field catalog from dictionary structure or internal table | BC - SAP List Viewer |
F4IF_INT_TABLE_VALUE_REQUEST | F4 help also returning the value to be displayed in internal table | Basis - F4 Help |
ABAP Reports for SAP Table TVKO
ABAP REPORT | Description | Functional Area |
---|---|---|
RVADTABL | INCLUDE for General Table Descriptions for Print Programs | SD - Output Determination |
SAPMV45A | Sales Order Processing | SD - Sales |
RVDIREKT | Direct Values | SD - Sales |
RVADOR01 | Print Program for Sales Documents | SD - Basic Functions |
RVADOPFO | INCLUDE for OPEN_FORM for SD Print Programs | SD - Word Processing |
SAPMV13A | Condition Maintenance | SD - Conditions |
LISTDATA | Data part, allocation table index | |
SAPLMGMM | Material Master: Central Main Program |
BW Datasources for SAP Table TVKO
BW DATASOURCE | Description | Functional Area |
---|---|---|
2LIS_01_S001 | Customer | SD - Sales and Distribution |
0CO_OM_NWA_2 | Delta extraction: Netw. Activity Actual Costs | CO - Overhead Projects |
0MATERIAL_TEXT | Material Number | Logistics - Logistics - General |
0CO_OM_NWA_1 | Network Activity: Costs | CO - Overhead Projects |
0MATERIAL_ATTR | Material Number | Logistics - Logistics - General |
0SALESORG_ATTR | Sales organization | SD - Sales and Distribution |
Authorization Objects for SAP Table TVKO
AUTHORIZATION OBJECT | Description | Functional Area |
---|---|---|
V_VBAK_VKO | Sales Document: Authorization for Sales Areas | |
C_VKORG | Transfer of Sales Organization Data | |
E_GRID | Authorization Object for Grid | |
V_VBRK_VKO | Billing: Authorization for Sales Organizations | |
F_BKPF_BUK | Accounting Document: Authorization for Company Codes | |
S_BDC_MONI | Batch Input Authorizations | |
S_SPO_ACT | Spool: Actions | |
S_USER_AUT | User Master Maintenance: Authorizations |
Most searched SAP Sales and Distribution Tables
- Sales Order Tables
- Plant Tables
- Document Type Tables
- Delivery Tables
- Pricing Tables
- Billing Document Tables
- Sales Organization Tables
- Outbound Delivery Tables
- Pricing Conditions Tables
- Contract Tables
- Internal Order Tables
- Item Category Tables
- Pricing Procedure Tables
- Condition Types Tables
- Billing Tables
- Output Type Tables
- Customer Group Tables
- Price List Tables
- Condition Record Tables
- Order Type Tables
- Sales Order Type Tables
- Info Record Tables