TVAK SAP (Sales Document Types) Table details

Dictionary Type: Table
Description: Sales Document Types




ABAP Code to SELECT data from TVAK
Related tables to TVAK
Access table TVAK




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 Update
Display/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
MANDTClient MANDTCLNT3T000MANDT
AUARTSales Document Type AUARTCHAR4AUARTAUARTAAT
KOPGRScreen sequence group for document header & item BIFGRCHAR4TVHBBIFGR
LFARVDefault delivery type LFARVCHAR4TVLKLFART
FKARVProposed billing type for a delivery-related billing doc. FKARVCHAR4TVFKFKART
FKARAProposed billing type for an order-related billing document FKARACHAR4TVFKFKART
NUMKINumber range in the case of internal number assignment NUMKICHAR2NUMKR
NUMKENumber range in the case of external number assignment NUMKECHAR2NUMKR
INCPOIncrement of item number in the SD document INCPONUMC6NUM6
UEVORF-code default for overview screen UEVOR_VACHAR20UEVOR_VA
AUGRPVersion Number Component CHAR2CHAR2CHAR2
UMFNGDisplay Range UMFNGCHAR20UMFNG
DABARDefault release type DABARCHAR1ABART
PARGRPartner Determination Procedure PARGRCHAR4TVPGPARGR
FAKSKBlock FAKSPCHAR2TVFSFAKSP
LIFSKDelivery block (document header) LIFSKCHAR2TVLSLIFSP
TRVOGTransaction group TRVOG_VACHAR1TRVOG_VAVTV
SPAPODivision in sales order item comes from the material SPAPOCHAR1SPAPO
SPAPRCheck division SPAPRCHAR1SPAPR
VSTRMActivate delivery scheduling VSTRMCHAR1VSTRM
TRTRMActivate transportation scheduling TRTRMCHAR1XFELD
TXN08Number of the standard text TXN08CHAR8TXN08
DIAFEDialog message for incompletion DIAUVCHAR1XFELD
FELDKField selection group for document header FELDKCHAR4TVHFFAWGR
DATVOPropose current date as requested delivery date DATVO_VAKCHAR1XFELD
AWAHRSales probability AWAHR_AKNUMC3AWAHR
VBTYPSD document category VBTYPCHAR1VBTYP
VSBEDShipping conditions VSBED_VAKCHAR2TVSBVSBED
BEZOBReference mandatory BEZOBCHAR1BEZOB
TXTGRText determination procedure TXTGRCHAR2TTXGTXTGR
KALVGDocument procedure (for determining pricing procedure) KALVGCHAR1TVKVKALVG
ERNAMName of Person who Created the Object ERNAMCHAR12USNAM
FEHGRIncompletion procedure for sales document FEHGRCHAR2TVUVFEHGR
INFLSRead customer-material info record ? INFLSCHAR1XFELD
KUNN0Customer number ZERO (0) allowed KUNN0CHAR1XFELD
KLIMPCheck credit limit KLIMPCHAR1KLIMP
KALSMOutput determination procedure KALSMBCHAR6T683KALSM
KAPPLApplication for output conditions NA_KAPPLCHAR2T681AKAPPLNA_KAPPL
KSCHLOutput Type NA_KSCHLCHAR4Assigned to domainKSCHLNACCSH_NA_KSCHL
SPERRSales document block SPEVBCHAR1SPEVB
STGAKStatistics group for sales document type STGAKCHAR2TVSFALPHASTGVB
KALSUProcedure for material determination KALSUCHAR6T683KALSM
KALLIProcedure for material listing KALLICHAR6T683KALSM
KALAUProcedure for material exclusion KALAUCHAR6T683KALSM
FKAIVBilling type for intercompany billing FKAIVCHAR4TVFKFKART
CMGRACredit group sales order CMGRACHAR2T691DCRMGR_CM
OBJART_HINArchiving document type when you create a document SDOBJARTHCHAR10TOADVSADC10_DV
OBJART_VERArchiving document type used when you change a document SDOBJARTVCHAR10TOADVSADC10_DV
HITYP_PRHierarchy type for pricing HITYP_PRCHAR1THITHITYP
ABRVWUsage Indicator ABRVWCHAR3TVLVABRVW
ABDISMRP for delivery schedule types ABDISCHAR1ABRAB
KPRGBZDate type (day, week, month, interval) PRGRSCHAR1PRGRS
PRDATVProposed pricing date based on the requested dlv.date PRDATVCHAR1PRDATV
VLAUFLead Time in Days VLAUFDEC2DEC2
GUEBGVProposed valid-from date GUEBGVCHAR1GUEBGV
VTERLContract data allowed for sales order type VTERLCHAR1VCOPY
HNWAGOn/off switch for messages about quotations HNWAGCHAR1HNWAG
HNWKMOn/off switch for messages about outline agreements HNWKMCHAR1HNWKM
STSMAStatus Profile J_STSMACHAR8TJ20J_STSMA
LISOFCreate delivery immediately LISOFCHAR1LISOF
AUARAProposal for order type for the subsequent function AUARACHAR4TVAKAUARTAUART
KORLIDelivery type for correction deliveries KORLICHAR4TVLKLFART
VPROFProfile with default values for contract data VPROFCHAR4TVVDVPROF
AUFAKOrder type for request for billing AUFAKCHAR4TVAKAUARTAUART
DIAPADialog message for product attribute DIAPACHAR1DIAPA
FPARTBilling/Invoicing Plan Type FPARTCHAR2TFPLAFPART
KSCHL_KOCondition type for copying costs from line items KSCHL_KOCHAR4T685KSCHL
EXCOKCarry out legal control for sales document type EXCOKCHAR1EXCOK
EXMODTime interval for legal control EXMODCHAR1EXMOD
KSKPFPricing procedure for contract conditions at header level KSKPFCHAR6T683KALSM
KSPOSPricing procedure for contract conditions at item level KSPOSCHAR6T683KALSM
LIFSMDelivery block LIFSMCHAR2TVLSLIFSP
FKTKTActivity type for the actions procedure FKTKTCHAR4TVKKKTAAR
EXDIAAutomatic dialog in document for legal control EXDIACHAR1XFELD
ABGRU_INReason for rejection, internally assigned by system ABGRU_INCHAR2TVAGABGRU_VA
PRBSTCheck purchase order number PRBSTCHAR1PRBST
SCHEME_GRPReferencing requirement: Procedure SCHEME_GRPCHAR4TVGRPSSCHEME_GRP
HNWGKOn/off switch for master contract messages HNWGKCHAR1HNWGK
PUSH_GRPUpdate lower level contract - on/off PUSH_GRPCHAR1XFELD
ABRUF_PARTCheck partner authorizations ABRUF_PARTCHAR1ABRUF_PART
RPARTPayment card plan type RPARTCHAR2TFPLAFPART
AKTFIPromo determination AKTFICHAR1XFELD
VBKLTSales document indicator (for display in TVAK only) VBKLT_VACHAR1VBKLT_VA
J_1BNFTYPENota Fiscal Type J_1BNFTYPECHAR2J_1BAAJ_1BNFTYPE
INCUPIncrement of sub-item number in sales document INCUPNUMC6NUM6
BABSSDocument payment guarantee procedure BABSSCH_CMCHAR2T691RBABSSCH_CM
EMPFIReceiving point determination EMPFICHAR1XFELD
DELCFCommitment dates switch for calculation rule DELCFCHAR1DELCF
CCPGRPayment cards: Checking group - Sales document CCPGACHAR2TVCAACCPGA
EXCBCBoycott list check of standard partners f.Foreign Trade - On EXCBCCHAR1DIAEX
EXCEMEmbargo check of standard partners for Foreign Trade - On EXCEMCHAR1DIAEX
EXCLGIndicator: Save legal control log EXCLGCHAR1EXCLG
HNWK2Add ref. to all contracts partner is authorized to release HNWK2CHAR1HNWK2
EXTNR_RMAUse document number to enter external PO number RMA_EXTNRCHAR1XFELD
TDIDText ID TDIDCHAR4Assigned to domainTDID
AAUART1Alternative sales document type AAUARTCHAR4Assigned to domainAUARTAUART
AAUART2Alternative sales document type AAUARTCHAR4Assigned to domainAUARTAUART
RFPA_SWRoute schedule switch for order types RFPA_SWCHAR1XFELD
VARIANTTransaction variant TCVARIANTCHAR30SHDTVCIUUTCVARIANTSTV
ATPGMType of group calls for the availability check ATPGMCHAR1ATPGM
VERLIProcedure for material listing VERLICHAR1VERLI
TENURCarry out backwards delivery scheduling only TENURCHAR1XFELD
J_1AFCTYPECategory of Credit Memo Billing Document J_1AFCTYPCHAR2J_1AFCTYP
FAUPRShipment Cost Information Profile FAUPRCHAR14TVFAPFAUPR
PVBSMDocument procedure for determining product proposal proced. PVBSMCHAR2TPVVPVBSM
BPROCATP: Business Transaction for ATP BPROCCHAR4TVBPROCBPROC
ERMATMaterial entry control ERMATCHAR1ERMAT
BSTVOPropose current date as purchase order date BSTVOCHAR1XFELD
EXTCONTAdvanced Order Processing and Billing /CBAD/EXTCONTCHAR1XFELD
KSCHL_BUDGETCondition Budget /CBAD/KSCHL_BUDGETCHAR4Assigned to domainKSCHL
KSCHL_CAPSCondition Caps /CBAD/KSCHL_CAPSCHAR4Assigned to domainKSCHL
MSR_ACTIVEAdvanced Returns Management Active MSR_ACTIVECHAR1MSR_ACTIVE
MSR_NEXT_NUMBERDetermination of Returns Order Number MSR_GET_NEXT_NUMBERCHAR1MSR_GET_NEXT_NUMBER
MSR_AUARADefault Credit Memo Request Order Type MSR_AUARACHAR4TVAKAUARTAUART
MSR_BILLING_BLKBilling Block MSR_BILLING_BLOCKCHAR2TVFSFAKSP
MSR_CM_IMMEDIATECreate Credit Memo Automatically MSR_CM_IMMEDIATELYCHAR1XFELD
MSR_LFARTDefault Delivery Type for Send Back to Customer MSR_LFARTCHAR4TVLKLFARTH_TVLK
FCS_ACTIVEFull Text Search for Sold-To Party Active FCS_ACTIVECHAR1XFELD
MSR_DELIVERY_BLKDelivery Block MSR_DELIVERY_BLOCKCHAR2TVLSLIFSP
MSR_SDF_AUARTSales Document Type for Subsequent Delivery Free of Charge MSR_REPLACEMENT_AUARTCHAR4TVAKAUARTAUART
RDP_PROFILERisk Distribution Plan Profile LOGTRM_RDP_PROFILECHAR8L2TC_RDP_PROFILELOGTRM_RDP_PROFILE
FKART_MEV_POSTBilling Type for Period-End Posting FKART_MEV_POSTCHAR4TVFKFKART
FKART_MEV_POST_IBBilling Type for Period-End Posting (ICB) FKART_MEV_POST_IBCHAR4TVFKFKART
.INCLU--AP 0
VCLASSIFICContract classification SD customizing /SAPHT/SW_CONTRCLASSCHAR1/SAPHT/SW_CONTRCLASS
KALPGProduct List eligibility: Procedure for product lists /SAPHT/SW_KALPGCHAR6Assigned to domainKALSM
KALVLProcedure for material listing /SAPHT/SW_KALVLCHAR6Assigned to domainKALSM
.INCLU--AP 0
/SAPMP/PDACTActivate Inheritance /SAPMP/PDACTCHAR1/SAPMP/PDACT
/SAPMP/PPROTLog of Characteristic Value Inheritance /SAPMP/PPROTCHAR1/SAPMP/PPROT
/SAPMP/PUSERInheritance: Overwrite User Values /SAPMP/PUSERCHAR1/SAPMP/PUSER
/SAPMP/PAUSWInheritance of Characteristics Selection List /SAPMP/PAUSWCHAR1/SAPMP/PAUSW
/SAPMP/GAUFGlobal/Local Group May Be Undone /SAPMP/GAUFCHAR1/SAPMP/GAUF
.INCLU--AP 0
AD01AURETOrder type billing request for retroactive billing AD01AURETCHAR4TVAKAUARTAUART
.INCLU--AP 0
AD04NUMFLGDocument type relevant for numbering AD04NUMFLGCHAR1XFELD
.INCLU--AP 0
KALGTProcedure for GTIN Mapping KALGTCHAR6T683KALSM
.INCLU--AP 0
UNITSALEUnit Sales HB_UNTSALECHAR1XFELD
CPFREESuppress Copy Control HB_CPFREECHAR1XFELD
NO_BUTTONNumber of Generate Button in Browser NO_BUTTONNUMC1NO_BUTTON
.INCLU--AP 0
XZEROORDERIS-M: Generate Order with Quantity 0 ISM_ZEROORDERCHAR1XFELD
XASSORTMENTIS-M: Allowed Contract Type for Assortments (Retail) XASSORTMENTCHAR1XASSORTMENT
ISM_CONTRACTIS-M: Contract Usage ISM_CONTRACTCHAR2ISM_CONTRACT
ISM_WERKSDETPlant Determination Type in Order ISM_WERKSDETCHAR1ISM_WERKSDET
.INCLU--AP 0
J_3GKBAULETM-Relevant Indicator J_3GKBAULCHAR1J_3GKBAUL
.INCLU--AP 0
MILL_SE_ATNAMCharacteristic name MILL_SE_ATNAM1CHAR30ATNAMFEAMERK
.INCLU--AP 0
OIPIPEVALValidation indicator for pipeline fields (X=ON, blank=OFF) OID_PIPEVCHAR1X
OIISOILPDIS-Oil plant determination indicator: x=yes blank=no OID_BYPASSCHAR1OI0_SELKZ
OICSEGIQuantity schedule creation permitted OIA_CSEGICHAR1OIA_CSEGI
OIMSG_PRDMessage type for product with contract restrictions OIDMSG_PRDCHAR1OIDMSG_PRD
OIMSG_SHPMessage type for contract restrictions ship-to party OIDMSG_SHPCHAR1OIDMSG_PRD
OIMSG_QTYMessage type for contract restrictions quantity OIDMSG_QTYCHAR1OIDMSG_PRD
OIMSG_TRMMessage type for contract restrictions payment terms OIDMSG_TRMCHAR1OIDMSG_PRD
OIMSG_DATMessage type for contract restrictions validity period OIDMSG_DATCHAR1OIDMSG_PRD
OIMSG_UOMMessage type for contract restrictions unit of measure OIDMSG_UOMCHAR1OIDMSG_PRD
OIPRTFNCPartner function OID_PTRFNCCHAR2TPARPARVWPARVW
OIFCONTIIS-Oil MRN indicator for additional contract data OIF_CONTICHAR1OIF_CONTI
OICFKARTDIDifferential invoice billing type proposal OICFKARTDICHAR4TVFKFKART
OIPARVW1Partner Function PARVWCHAR2TPARPARVWPARVWPAR
OIPARVW2Partner Function PARVWCHAR2TPARPARVWPARVWPAR
OIPARVW3Partner Function PARVWCHAR2TPARPARVWPARVWPAR
OIPARVW4Partner Function PARVWCHAR2TPARPARVWPARVWPAR
OIPARVW5Partner Function PARVWCHAR2TPARPARVWPARVWPAR
OIPARVW6Partner Function PARVWCHAR2TPARPARVWPARVWPAR
OIPARVW7Partner Function PARVWCHAR2TPARPARVWPARVWPAR
OIPARVW8Partner Function PARVWCHAR2TPARPARVWPARVWPAR
OIPARVW9Partner Function PARVWCHAR2TPARPARVWPARVWPAR
OISUBHEADSubscreen number (header) OID_SSCRHDCHAR4DYNNR
OISUBITEMSubscreen number (item level) OID_SSCRITCHAR4DYNNR
OIUSEREXITNumber of the routine used for copying GRPNONUMC3Assigned to domainGRPNO
.INCLU--AP 0
OIU_FKARAPRA Order related billing type OIU_FKARACHAR4TVFKFKART

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 table
DATA: 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 as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!