TVKOS is a standard Account Determination Transparent Table in SAP SD application, which stores Organizational Unit: Divisions per Sales Organization 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 TVKOS. You can use the transaction code SE16 to view the data in this table, and SE11 TCode for the table structure and definition.
TVKOS — Meta Data
Description: | Organizational Unit: Divisions per Sales Organization |
Main Category: | SD |
Sub Category: | Account Determination |
Table type: | Transparent Table (TRANSP) |
TVKOS — Table Structure, Fields(Columns) and Definitions
Position | Column Name | Description | Primary Key | Data Type | Length | Check Table |
---|---|---|---|---|---|---|
1 | MANDT | Client | X | CLNT | 3 | T000 |
2 | VKORG | Sales Org. | X | CHAR | 4 | TVKO |
3 | SPART | Division | X | CHAR | 2 | TSPA |
4 | .INCLUDE | 0 | ||||
5 | SPAKU | Reference division for customers | CHAR | 2 | TSPA | |
6 | SPAKO | Reference division for conditions | CHAR | 2 | TSPA | |
7 | SPAAU | Reference division for document types (by sales area) | CHAR | 2 | TSPA |
SAP Help, Wiki Resources, and Forum Discussions on TVKOS
-
How to download sales bundling data tables SMOTVKOS and SMOTVKOV
Do any of you know how to download sales bundling data tables SMOTVKOS and SMOTVKOV? Is there a report that can be run to bring the data from R/3 tables TVKOS and TVKOV or do I need to download a customizing object?
http://scn.sap.com/message/1991079
Related Tables
TABLE | Description | Functional Area |
---|---|---|
TVKO | Organizational Unit: Sales Organizations | SD - Account Determination |
TVKOV | Org. Unit: Distribution Channels per Sales Organization | SD - Account Determination |
T001W | Plants/Branches | Logistics - Plant Master |
TVTA | Organizational Unit: Sales Area(s) | SD - Account Determination |
T001L | Storage Locations | Logistics - Material Master |
KONP | Conditions (Item) | SD - Conditions |
T001 | Company Codes | FI - Financial Accounting |
Transaction Codes for SAP Table TVKOS
TCODE | Description | Functional Area |
---|---|---|
AFAB | Post depreciation | FI - Basic Functions |
MCHB | RIS: Till Receipt - Selection | Logistics - Retail Information System (RIS) |
MCHA | RIS: Till Receipt/Matl - Selection | Logistics - Retail Information System (RIS) |
SPRO | Customizing - Edit Project | Basis - Customizing Project Management (IMG) |
KALO | Export Reconcil. Ledger (Rollup) | CO - Cost Element Accounting |
MIRO | Enter Incoming Invoice | MM - Invoice Verification |
ME21N | Create Purchase Order | MM - Purchasing |
KEPH | Segment-Specific Events | CO - Profitability Analysis |
FMs for SAP Table TVKOS
FM | Description | Functional Area |
---|---|---|
BAPI_PO_CREATE1 | Create Purchase Order | MM - Purchasing |
BAPI_SALESORDER_CREATEFROMDAT2 | Sales order: Create Sales Order | SD - Basic Functions |
CONVERSION_EXIT_ABPSN_OUTPUT | Format > With Edition (Project Number / WBS Element Number) | Cross Application - Cross-Application Objects in Project System |
CACS_GET_TABLE_FIELDS | Ermitteln der Felder einer DB-Tabelle | ICM - Incentive and Commission Management (ICM) |
SET_PF_STATUS | Setzen Pf-Status | Basis - ABAP Editor |
CRM_BUPA_FRG0140_SAVE | CRM GP Organisationsdaten, Fortschreibungsbaustein | CRM - Business Partners |
CUSTOMER_DUE_DATE_ANALYSIS | Offene Posten eines Debitoren nach Verzugstagen rastern | FI - Financial Accounting |
TB_LIMIT_WS_FILENAME_GET | Call File Selector | IS - Default Risk and Limit System |
ABAP Reports for SAP Table TVKOS
ABAP REPORT | Description | Functional Area |
---|---|---|
MV45AF0F_FCODE_SICH | MAP_INTERNAL_TO_EXTERNAL | SD - Sales |
MV45AF0B_BELEG_SICHERN | Include LV05DFBF | SD - Sales |
RSPARAM | Display SAP Profile Parameters | Basis - Workbench Tools: Editors, Painters, Modelers |
CL_GM_OPEN_ITEM_MGR===========CP | Create Financial Product | |
LV61BF0K | Include LV50LF15 | |
SAPLKKBL | Dynamic List Display | |
RSEOUT00 | Process All Selected IDocs (EDI) | Basis - ALE Integration Technology |
RV80HGEN | Requirements and Formulas - Completely Generated for TFRM (online) | SD - Account Determination |
Authorization Objects for SAP Table TVKOS
AUTHORIZATION OBJECT | Description | Functional Area |
---|---|---|
S_BTCH_ADM | Background Processing: Background Administrator | |
S_BDC_MONI | Batch Input Authorizations | |
S_SPO_ACT | Spool: Actions | |
S_EDITOR | ABAP: Editor Checks | |
S_PROGRAM | ABAP: Program Flow Checks | |
S_SPO_DEV | Spool: Device authorizations | |
S_ADMI_FCD | System Authorizations | |
I_QMEL | PM/QM: Notification Types |
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