TVAK SAP (Sales Document Types) Table details
Dictionary Type: Table
Description: Sales Document Types
Description: Sales Document Types
Table field list including key, data, relationships and ABAP select examples
TVAK is a standard SAP Table which is used to store Sales Document Types data and is available within R/3 SAP systems depending on the version and release level.
The TVAK table consists of various fields, each holding specific information or linking keys about Sales Document Types data available in SAP. These include AUART (Sales Document Type), KOPGR (Screen sequence group for document header & item), LFARV (Default delivery type), FKARV (Proposed billing type for a delivery-related billing doc.).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: G - Customising table which is protected against SAP UpdateDisplay/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
Text table = TVAKT
SAP TVAK table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
AUART | Sales Document Type | AUART | CHAR | 4 | AUART | AUART | AAT | ||
KOPGR | Screen sequence group for document header & item | BIFGR | CHAR | 4 | TVHB | BIFGR | |||
LFARV | Default delivery type | LFARV | CHAR | 4 | TVLK | LFART | |||
FKARV | Proposed billing type for a delivery-related billing doc. | FKARV | CHAR | 4 | TVFK | FKART | |||
FKARA | Proposed billing type for an order-related billing document | FKARA | CHAR | 4 | TVFK | FKART | |||
NUMKI | Number range in the case of internal number assignment | NUMKI | CHAR | 2 | NUMKR | ||||
NUMKE | Number range in the case of external number assignment | NUMKE | CHAR | 2 | NUMKR | ||||
INCPO | Increment of item number in the SD document | INCPO | NUMC | 6 | NUM6 | ||||
UEVOR | F-code default for overview screen | UEVOR_VA | CHAR | 20 | UEVOR_VA | ||||
AUGRP | Version Number Component | CHAR2 | CHAR | 2 | CHAR2 | ||||
UMFNG | Display Range | UMFNG | CHAR | 20 | UMFNG | ||||
DABAR | Default release type | DABAR | CHAR | 1 | ABART | ||||
PARGR | Partner Determination Procedure | PARGR | CHAR | 4 | TVPG | PARGR | |||
FAKSK | Block | FAKSP | CHAR | 2 | TVFS | FAKSP | |||
LIFSK | Delivery block (document header) | LIFSK | CHAR | 2 | TVLS | LIFSP | |||
TRVOG | Transaction group | TRVOG_VA | CHAR | 1 | TRVOG_VA | VTV | |||
SPAPO | Division in sales order item comes from the material | SPAPO | CHAR | 1 | SPAPO | ||||
SPAPR | Check division | SPAPR | CHAR | 1 | SPAPR | ||||
VSTRM | Activate delivery scheduling | VSTRM | CHAR | 1 | VSTRM | ||||
TRTRM | Activate transportation scheduling | TRTRM | CHAR | 1 | XFELD | ||||
TXN08 | Number of the standard text | TXN08 | CHAR | 8 | TXN08 | ||||
DIAFE | Dialog message for incompletion | DIAUV | CHAR | 1 | XFELD | ||||
FELDK | Field selection group for document header | FELDK | CHAR | 4 | TVHF | FAWGR | |||
DATVO | Propose current date as requested delivery date | DATVO_VAK | CHAR | 1 | XFELD | ||||
AWAHR | Sales probability | AWAHR_AK | NUMC | 3 | AWAHR | ||||
VBTYP | SD document category | VBTYP | CHAR | 1 | VBTYP | ||||
VSBED | Shipping conditions | VSBED_VAK | CHAR | 2 | TVSB | VSBED | |||
BEZOB | Reference mandatory | BEZOB | CHAR | 1 | BEZOB | ||||
TXTGR | Text determination procedure | TXTGR | CHAR | 2 | TTXG | TXTGR | |||
KALVG | Document procedure (for determining pricing procedure) | KALVG | CHAR | 1 | TVKV | KALVG | |||
ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | USNAM | ||||
FEHGR | Incompletion procedure for sales document | FEHGR | CHAR | 2 | TVUV | FEHGR | |||
INFLS | Read customer-material info record ? | INFLS | CHAR | 1 | XFELD | ||||
KUNN0 | Customer number ZERO (0) allowed | KUNN0 | CHAR | 1 | XFELD | ||||
KLIMP | Check credit limit | KLIMP | CHAR | 1 | KLIMP | ||||
KALSM | Output determination procedure | KALSMB | CHAR | 6 | T683 | KALSM | |||
KAPPL | Application for output conditions | NA_KAPPL | CHAR | 2 | T681A | KAPPL | NA_KAPPL | ||
KSCHL | Output Type | NA_KSCHL | CHAR | 4 | Assigned to domain | KSCHL | NAC | CSH_NA_KSCHL | |
SPERR | Sales document block | SPEVB | CHAR | 1 | SPEVB | ||||
STGAK | Statistics group for sales document type | STGAK | CHAR | 2 | TVSF | ALPHA | STGVB | ||
KALSU | Procedure for material determination | KALSU | CHAR | 6 | T683 | KALSM | |||
KALLI | Procedure for material listing | KALLI | CHAR | 6 | T683 | KALSM | |||
KALAU | Procedure for material exclusion | KALAU | CHAR | 6 | T683 | KALSM | |||
FKAIV | Billing type for intercompany billing | FKAIV | CHAR | 4 | TVFK | FKART | |||
CMGRA | Credit group sales order | CMGRA | CHAR | 2 | T691D | CRMGR_CM | |||
OBJART_HIN | Archiving document type when you create a document | SDOBJARTH | CHAR | 10 | TOADV | SADC10_DV | |||
OBJART_VER | Archiving document type used when you change a document | SDOBJARTV | CHAR | 10 | TOADV | SADC10_DV | |||
HITYP_PR | Hierarchy type for pricing | HITYP_PR | CHAR | 1 | THIT | HITYP | |||
ABRVW | Usage Indicator | ABRVW | CHAR | 3 | TVLV | ABRVW | |||
ABDIS | MRP for delivery schedule types | ABDIS | CHAR | 1 | ABRAB | ||||
KPRGBZ | Date type (day, week, month, interval) | PRGRS | CHAR | 1 | PRGRS | ||||
PRDATV | Proposed pricing date based on the requested dlv.date | PRDATV | CHAR | 1 | PRDATV | ||||
VLAUF | Lead Time in Days | VLAUF | DEC | 2 | DEC2 | ||||
GUEBGV | Proposed valid-from date | GUEBGV | CHAR | 1 | GUEBGV | ||||
VTERL | Contract data allowed for sales order type | VTERL | CHAR | 1 | VCOPY | ||||
HNWAG | On/off switch for messages about quotations | HNWAG | CHAR | 1 | HNWAG | ||||
HNWKM | On/off switch for messages about outline agreements | HNWKM | CHAR | 1 | HNWKM | ||||
STSMA | Status Profile | J_STSMA | CHAR | 8 | TJ20 | J_STSMA | |||
LISOF | Create delivery immediately | LISOF | CHAR | 1 | LISOF | ||||
AUARA | Proposal for order type for the subsequent function | AUARA | CHAR | 4 | TVAK | AUART | AUART | ||
KORLI | Delivery type for correction deliveries | KORLI | CHAR | 4 | TVLK | LFART | |||
VPROF | Profile with default values for contract data | VPROF | CHAR | 4 | TVVD | VPROF | |||
AUFAK | Order type for request for billing | AUFAK | CHAR | 4 | TVAK | AUART | AUART | ||
DIAPA | Dialog message for product attribute | DIAPA | CHAR | 1 | DIAPA | ||||
FPART | Billing/Invoicing Plan Type | FPART | CHAR | 2 | TFPLA | FPART | |||
KSCHL_KO | Condition type for copying costs from line items | KSCHL_KO | CHAR | 4 | T685 | KSCHL | |||
EXCOK | Carry out legal control for sales document type | EXCOK | CHAR | 1 | EXCOK | ||||
EXMOD | Time interval for legal control | EXMOD | CHAR | 1 | EXMOD | ||||
KSKPF | Pricing procedure for contract conditions at header level | KSKPF | CHAR | 6 | T683 | KALSM | |||
KSPOS | Pricing procedure for contract conditions at item level | KSPOS | CHAR | 6 | T683 | KALSM | |||
LIFSM | Delivery block | LIFSM | CHAR | 2 | TVLS | LIFSP | |||
FKTKT | Activity type for the actions procedure | FKTKT | CHAR | 4 | TVKK | KTAAR | |||
EXDIA | Automatic dialog in document for legal control | EXDIA | CHAR | 1 | XFELD | ||||
ABGRU_IN | Reason for rejection, internally assigned by system | ABGRU_IN | CHAR | 2 | TVAG | ABGRU_VA | |||
PRBST | Check purchase order number | PRBST | CHAR | 1 | PRBST | ||||
SCHEME_GRP | Referencing requirement: Procedure | SCHEME_GRP | CHAR | 4 | TVGRPS | SCHEME_GRP | |||
HNWGK | On/off switch for master contract messages | HNWGK | CHAR | 1 | HNWGK | ||||
PUSH_GRP | Update lower level contract - on/off | PUSH_GRP | CHAR | 1 | XFELD | ||||
ABRUF_PART | Check partner authorizations | ABRUF_PART | CHAR | 1 | ABRUF_PART | ||||
RPART | Payment card plan type | RPART | CHAR | 2 | TFPLA | FPART | |||
AKTFI | Promo determination | AKTFI | CHAR | 1 | XFELD | ||||
VBKLT | Sales document indicator (for display in TVAK only) | VBKLT_VA | CHAR | 1 | VBKLT_VA | ||||
J_1BNFTYPE | Nota Fiscal Type | J_1BNFTYPE | CHAR | 2 | J_1BAA | J_1BNFTYPE | |||
INCUP | Increment of sub-item number in sales document | INCUP | NUMC | 6 | NUM6 | ||||
BABSS | Document payment guarantee procedure | BABSSCH_CM | CHAR | 2 | T691R | BABSSCH_CM | |||
EMPFI | Receiving point determination | EMPFI | CHAR | 1 | XFELD | ||||
DELCF | Commitment dates switch for calculation rule | DELCF | CHAR | 1 | DELCF | ||||
CCPGR | Payment cards: Checking group - Sales document | CCPGA | CHAR | 2 | TVCAA | CCPGA | |||
EXCBC | Boycott list check of standard partners f.Foreign Trade - On | EXCBC | CHAR | 1 | DIAEX | ||||
EXCEM | Embargo check of standard partners for Foreign Trade - On | EXCEM | CHAR | 1 | DIAEX | ||||
EXCLG | Indicator: Save legal control log | EXCLG | CHAR | 1 | EXCLG | ||||
HNWK2 | Add ref. to all contracts partner is authorized to release | HNWK2 | CHAR | 1 | HNWK2 | ||||
EXTNR_RMA | Use document number to enter external PO number | RMA_EXTNR | CHAR | 1 | XFELD | ||||
TDID | Text ID | TDID | CHAR | 4 | Assigned to domain | TDID | |||
AAUART1 | Alternative sales document type | AAUART | CHAR | 4 | Assigned to domain | AUART | AUART | ||
AAUART2 | Alternative sales document type | AAUART | CHAR | 4 | Assigned to domain | AUART | AUART | ||
RFPA_SW | Route schedule switch for order types | RFPA_SW | CHAR | 1 | XFELD | ||||
VARIANT | Transaction variant | TCVARIANT | CHAR | 30 | SHDTVCIU | UTCVARIANT | STV | ||
ATPGM | Type of group calls for the availability check | ATPGM | CHAR | 1 | ATPGM | ||||
VERLI | Procedure for material listing | VERLI | CHAR | 1 | VERLI | ||||
TENUR | Carry out backwards delivery scheduling only | TENUR | CHAR | 1 | XFELD | ||||
J_1AFCTYPE | Category of Credit Memo Billing Document | J_1AFCTYP | CHAR | 2 | J_1AFCTYP | ||||
FAUPR | Shipment Cost Information Profile | FAUPR | CHAR | 14 | TVFAP | FAUPR | |||
PVBSM | Document procedure for determining product proposal proced. | PVBSM | CHAR | 2 | TPVV | PVBSM | |||
BPROC | ATP: Business Transaction for ATP | BPROC | CHAR | 4 | TVBPROC | BPROC | |||
ERMAT | Material entry control | ERMAT | CHAR | 1 | ERMAT | ||||
BSTVO | Propose current date as purchase order date | BSTVO | CHAR | 1 | XFELD | ||||
EXTCONT | Advanced Order Processing and Billing | /CBAD/EXTCONT | CHAR | 1 | XFELD | ||||
KSCHL_BUDGET | Condition Budget | /CBAD/KSCHL_BUDGET | CHAR | 4 | Assigned to domain | KSCHL | |||
KSCHL_CAPS | Condition Caps | /CBAD/KSCHL_CAPS | CHAR | 4 | Assigned to domain | KSCHL | |||
MSR_ACTIVE | Advanced Returns Management Active | MSR_ACTIVE | CHAR | 1 | MSR_ACTIVE | ||||
MSR_NEXT_NUMBER | Determination of Returns Order Number | MSR_GET_NEXT_NUMBER | CHAR | 1 | MSR_GET_NEXT_NUMBER | ||||
MSR_AUARA | Default Credit Memo Request Order Type | MSR_AUARA | CHAR | 4 | TVAK | AUART | AUART | ||
MSR_BILLING_BLK | Billing Block | MSR_BILLING_BLOCK | CHAR | 2 | TVFS | FAKSP | |||
MSR_CM_IMMEDIATE | Create Credit Memo Automatically | MSR_CM_IMMEDIATELY | CHAR | 1 | XFELD | ||||
MSR_LFART | Default Delivery Type for Send Back to Customer | MSR_LFART | CHAR | 4 | TVLK | LFART | H_TVLK | ||
FCS_ACTIVE | Full Text Search for Sold-To Party Active | FCS_ACTIVE | CHAR | 1 | XFELD | ||||
MSR_DELIVERY_BLK | Delivery Block | MSR_DELIVERY_BLOCK | CHAR | 2 | TVLS | LIFSP | |||
MSR_SDF_AUART | Sales Document Type for Subsequent Delivery Free of Charge | MSR_REPLACEMENT_AUART | CHAR | 4 | TVAK | AUART | AUART | ||
RDP_PROFILE | Risk Distribution Plan Profile | LOGTRM_RDP_PROFILE | CHAR | 8 | L2TC_RDP_PROFILE | LOGTRM_RDP_PROFILE | |||
FKART_MEV_POST | Billing Type for Period-End Posting | FKART_MEV_POST | CHAR | 4 | TVFK | FKART | |||
FKART_MEV_POST_IB | Billing Type for Period-End Posting (ICB) | FKART_MEV_POST_IB | CHAR | 4 | TVFK | FKART | |||
.INCLU--AP | 0 | ||||||||
VCLASSIFIC | Contract classification SD customizing | /SAPHT/SW_CONTRCLASS | CHAR | 1 | /SAPHT/SW_CONTRCLASS | ||||
KALPG | Product List eligibility: Procedure for product lists | /SAPHT/SW_KALPG | CHAR | 6 | Assigned to domain | KALSM | |||
KALVL | Procedure for material listing | /SAPHT/SW_KALVL | CHAR | 6 | Assigned to domain | KALSM | |||
.INCLU--AP | 0 | ||||||||
/SAPMP/PDACT | Activate Inheritance | /SAPMP/PDACT | CHAR | 1 | /SAPMP/PDACT | ||||
/SAPMP/PPROT | Log of Characteristic Value Inheritance | /SAPMP/PPROT | CHAR | 1 | /SAPMP/PPROT | ||||
/SAPMP/PUSER | Inheritance: Overwrite User Values | /SAPMP/PUSER | CHAR | 1 | /SAPMP/PUSER | ||||
/SAPMP/PAUSW | Inheritance of Characteristics Selection List | /SAPMP/PAUSW | CHAR | 1 | /SAPMP/PAUSW | ||||
/SAPMP/GAUF | Global/Local Group May Be Undone | /SAPMP/GAUF | CHAR | 1 | /SAPMP/GAUF | ||||
.INCLU--AP | 0 | ||||||||
AD01AURET | Order type billing request for retroactive billing | AD01AURET | CHAR | 4 | TVAK | AUART | AUART | ||
.INCLU--AP | 0 | ||||||||
AD04NUMFLG | Document type relevant for numbering | AD04NUMFLG | CHAR | 1 | XFELD | ||||
.INCLU--AP | 0 | ||||||||
KALGT | Procedure for GTIN Mapping | KALGT | CHAR | 6 | T683 | KALSM | |||
.INCLU--AP | 0 | ||||||||
UNITSALE | Unit Sales | HB_UNTSALE | CHAR | 1 | XFELD | ||||
CPFREE | Suppress Copy Control | HB_CPFREE | CHAR | 1 | XFELD | ||||
NO_BUTTON | Number of Generate Button in Browser | NO_BUTTON | NUMC | 1 | NO_BUTTON | ||||
.INCLU--AP | 0 | ||||||||
XZEROORDER | IS-M: Generate Order with Quantity 0 | ISM_ZEROORDER | CHAR | 1 | XFELD | ||||
XASSORTMENT | IS-M: Allowed Contract Type for Assortments (Retail) | XASSORTMENT | CHAR | 1 | XASSORTMENT | ||||
ISM_CONTRACT | IS-M: Contract Usage | ISM_CONTRACT | CHAR | 2 | ISM_CONTRACT | ||||
ISM_WERKSDET | Plant Determination Type in Order | ISM_WERKSDET | CHAR | 1 | ISM_WERKSDET | ||||
.INCLU--AP | 0 | ||||||||
J_3GKBAUL | ETM-Relevant Indicator | J_3GKBAUL | CHAR | 1 | J_3GKBAUL | ||||
.INCLU--AP | 0 | ||||||||
MILL_SE_ATNAM | Characteristic name | MILL_SE_ATNAM1 | CHAR | 30 | ATNAM | FEA | MERK | ||
.INCLU--AP | 0 | ||||||||
OIPIPEVAL | Validation indicator for pipeline fields (X=ON, blank=OFF) | OID_PIPEV | CHAR | 1 | X | ||||
OIISOILPD | IS-Oil plant determination indicator: x=yes blank=no | OID_BYPASS | CHAR | 1 | OI0_SELKZ | ||||
OICSEGI | Quantity schedule creation permitted | OIA_CSEGI | CHAR | 1 | OIA_CSEGI | ||||
OIMSG_PRD | Message type for product with contract restrictions | OIDMSG_PRD | CHAR | 1 | OIDMSG_PRD | ||||
OIMSG_SHP | Message type for contract restrictions ship-to party | OIDMSG_SHP | CHAR | 1 | OIDMSG_PRD | ||||
OIMSG_QTY | Message type for contract restrictions quantity | OIDMSG_QTY | CHAR | 1 | OIDMSG_PRD | ||||
OIMSG_TRM | Message type for contract restrictions payment terms | OIDMSG_TRM | CHAR | 1 | OIDMSG_PRD | ||||
OIMSG_DAT | Message type for contract restrictions validity period | OIDMSG_DAT | CHAR | 1 | OIDMSG_PRD | ||||
OIMSG_UOM | Message type for contract restrictions unit of measure | OIDMSG_UOM | CHAR | 1 | OIDMSG_PRD | ||||
OIPRTFNC | Partner function | OID_PTRFNC | CHAR | 2 | TPAR | PARVW | PARVW | ||
OIFCONTI | IS-Oil MRN indicator for additional contract data | OIF_CONTI | CHAR | 1 | OIF_CONTI | ||||
OICFKARTDI | Differential invoice billing type proposal | OICFKARTDI | CHAR | 4 | TVFK | FKART | |||
OIPARVW1 | Partner Function | PARVW | CHAR | 2 | TPAR | PARVW | PARVW | PAR | |
OIPARVW2 | Partner Function | PARVW | CHAR | 2 | TPAR | PARVW | PARVW | PAR | |
OIPARVW3 | Partner Function | PARVW | CHAR | 2 | TPAR | PARVW | PARVW | PAR | |
OIPARVW4 | Partner Function | PARVW | CHAR | 2 | TPAR | PARVW | PARVW | PAR | |
OIPARVW5 | Partner Function | PARVW | CHAR | 2 | TPAR | PARVW | PARVW | PAR | |
OIPARVW6 | Partner Function | PARVW | CHAR | 2 | TPAR | PARVW | PARVW | PAR | |
OIPARVW7 | Partner Function | PARVW | CHAR | 2 | TPAR | PARVW | PARVW | PAR | |
OIPARVW8 | Partner Function | PARVW | CHAR | 2 | TPAR | PARVW | PARVW | PAR | |
OIPARVW9 | Partner Function | PARVW | CHAR | 2 | TPAR | PARVW | PARVW | PAR | |
OISUBHEAD | Subscreen number (header) | OID_SSCRHD | CHAR | 4 | DYNNR | ||||
OISUBITEM | Subscreen number (item level) | OID_SSCRIT | CHAR | 4 | DYNNR | ||||
OIUSEREXIT | Number of the routine used for copying | GRPNO | NUMC | 3 | Assigned to domain | GRPNO | |||
.INCLU--AP | 0 | ||||||||
OIU_FKARA | PRA Order related billing type | OIU_FKARA | CHAR | 4 | TVFK | FKART |
Key field | Non-key field |
How do I retrieve data from SAP table TVAK using ABAP code
The following ABAP code Example will allow you to do a basic selection on TVAK to SELECT all data from the tableDATA: WA_TVAK TYPE TVAK.
SELECT SINGLE *
FROM TVAK
INTO CORRESPONDING FIELDS OF WA_TVAK
WHERE...
How to access SAP table TVAK
Within an ECC or HANA version of SAP you can also view further information about TVAK and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects