SAP ABAP Table SI_TVKO (Organizational Unit: Sales Organizations)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BTX-BF-IF (Application Component) R/3 Interface for Business Transactions
     ⤷ VZ0C (Package) Customizing R/3 RV central functions

Basic Data

Table Category	INTTAB	Structure
Structure	SI_TVKO	Table Relationship Diagram
Short Description	Organizational Unit: Sales Organizations

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	WAERS	☐	WAERS_V	WAERS	CUKY	5	0	Statistics currency	TCURC
2	BUKRS	☐	VKBUK	BUKRS	CHAR	4	0	Company code of the sales organization	T001
3	ADRNR	☐	ADRNR	ADRNR	CHAR	10	0	Address	*
4	TXNAM_ADR	☐	TXNAM_ADR	TXNAM16	CHAR	16	0	Text name for form text module short address
5	TXNAM_KOP	☐	TXNAM_KOP	TXNAM16	CHAR	16	0	Text name for form text module letter header
6	TXNAM_FUS	☐	TXNAM_FUS	TXNAM16	CHAR	16	0	Text name for formula text module footer lines
7	TXNAM_GRU	☐	TXNAM_GRU	TXNAM16	CHAR	16	0	Text name for form text module: Greeting
8	VKOAU	☐	VKOAU	VKORG	CHAR	4	0	Reference sales org.for sales doc.types (by sales area)	TVKO
9	KUNNR	☐	KUNIV	KUNNR	CHAR	10	0	Customer number for intercompany billing	KNA1
10	BOAVO	☐	BOAVO	XFELD	CHAR	1	0	Rebate processing active in the sales organization
11	VKOKL	☐	VKOKL	WFCID	CHAR	2	0	Sales organization calendar	TFACD
12	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
13	EKGRP	☐	EKGRP	EKGRP	CHAR	3	0	Purchasing group	T024
14	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
15	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
16	BSART	☐	BSART	BSART	CHAR	4	0	Order Type (Purchasing)	T161
17	BSTYP	☐	BSTYP	BSTYP	CHAR	1	0	Purchasing document category
18	BWART	☐	BWARTWE	BWART	CHAR	3	0	Movement type (inventory management)	T156
19	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
20	TXNAM_SDB	☐	TXNAM_SDB	TXNAM16	CHAR	16	0	Text names for layout-set module SDS sender
21	MWSKZ	☐	J_1AMWSKZ	MWSKZ	CHAR	2	0	Tax code for SD documents	T007A
22	XSTCEG	☐	XSTCEG	XSTCEG	CHAR	1	0	Determining the VAT registration number
23	J_1ANUTIME	☐	J_1ANUTIME	J_1ANUTIME	CHAR	1	0	Time of numbering for deliveries
24	MAXBI	☐	MAXBI	NUM03	NUMC	3	0	Maximum Number of Items in Billing Document

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	SI_TVKO	BSART	T161	BSART
2	SI_TVKO	BUKRS	T001	BUKRS	REF	1	CN
3	SI_TVKO	BWART	T156	BWART
4	SI_TVKO	EKGRP	T024	EKGRP
5	SI_TVKO	EKORG	T024E	EKORG
6	SI_TVKO	KUNNR	KNA1	KUNNR	REF	C	CN
7	SI_TVKO	LGORT	T001L	LGORT
8	SI_TVKO	LIFNR	LFA1	LIFNR
9	SI_TVKO	MWSKZ	T007A	MWSKZ		1	CN
10	SI_TVKO	VKOAU	TVKO	VKORG	REF	C	CN
11	SI_TVKO	VKOKL	TFACD	IDENT	REF	1	CN
12	SI_TVKO	WAERS	TCURC	WAERS	REF	1	CN
13	SI_TVKO	WERKS	T001W	WERKS

History

Last changed by/on	SAP	20110901
SAP Release Created in