TVKO SAP table for – Organizational Unit: Sales Organizations

Here we would like to draw your attention to TVKO table in SAP. As we know it is being mainly used with the SAP SD-BF (Basic Functions in SD) component which is coming under SD module (Sales & Distribution). TVKO is a SAP standard transparent table used for storing Organizational Unit: Sales Organizations related data in SAP. It comes under the package VZ0CCORE.

SAP TVKO table

Table TVKO technical data

TableTVKO
Data storingOrganizational Unit: Sales Organizations
ModuleSD
ComponentSD-BF
SAP PackageVZ0CCORE
Delivery ClassC – Customer table, data is only maintained by the customer
Table CategoryTRANSPARENT

SAP TVKO Table Fields

Here is the details of each fields in this table.You can find the discription, data type and assigned lenth of each of the fields in TVKO table.

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • TXNAM_GRU
    Its data type is C (Character String) with field length 16
  • VKOAU
    Its data type is C (Character String) with field length 4
  • KUNNR : Customer number
    Its data type is C (Character String) with field length 10
  • BOAVO
    Its data type is C (Character String) with field length 1
  • VKOKL
    Its data type is C (Character String) with field length 2
  • EKORG : Purchasing organization
    Its data type is C (Character String) with field length 4
  • EKGRP : Purchasing group for external processing
    Its data type is C (Character String) with field length 3
  • LIFNR : Vendor’s account number
    Its data type is C (Character String) with field length 10
  • WERKS : Plant
    Its data type is C (Character String) with field length 4
  • BSART
    Its data type is C (Character String) with field length 4
  • VKORG : Sales Organization
    Its a key field. Its data type is C (Character String) with field length 4
  • BSTYP
    Its data type is C (Character String) with field length 1
  • BWART : Movement type (inventory management)
    Its data type is C (Character String) with field length 3
  • LGORT : Storage location
    Its data type is C (Character String) with field length 4
  • TXNAM_SDB
    Its data type is C (Character String) with field length 16
  • MWSKZ : Tax on sales/purchases code
    Its data type is C (Character String) with field length 2
  • XSTCEG
    Its data type is C (Character String) with field length 1
  • J_1ANUTIME
    Its data type is C (Character String) with field length 1
  • MAXBI
    Its data type is N (Character String with Digits Only) with field length 3
  • .INCLU–AP : Extension for Joint Venture Accounting
    Its include structure/component is is /SAPHT/SW_TVKO_SD
  • PLAUFZ
    Its data type is N (Character String with Digits Only) with field length 3
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
    Its include structure/component is is SI_TVKO
  • PLAUEZ
    Its data type is C (Character String) with field length 1
  • WAERS : Currency Key
    Its data type is C (Character String) with field length 5
  • BUKRS : Company Code
    Its data type is C (Character String) with field length 4
  • ADRNR : Addresses: Address Number
    Its data type is C (Character String) with field length 10
  • TXNAM_ADR
    Its data type is C (Character String) with field length 16
  • TXNAM_KOP
    Its data type is C (Character String) with field length 16
  • TXNAM_FUS
    Its data type is C (Character String) with field length 16