/BEV1/TSZKK SAP (Cyclical Customer Sales Activities for Telephone Sales) Table details

Dictionary Type: Table
Description: Cyclical Customer Sales Activities for Telephone Sales




ABAP Code to SELECT data from /BEV1/TSZKK
Related tables to /BEV1/TSZKK
Access table /BEV1/TSZKK




Table field list including key, data, relationships and ABAP select examples

/BEV1/TSZKK is a standard SAP Table which is used to store Cyclical Customer Sales Activities for Telephone Sales data and is available within R/3 SAP systems depending on the version and release level.

The /BEV1/TSZKK table consists of various fields, each holding specific information or linking keys about Cyclical Customer Sales Activities for Telephone Sales data available in SAP. These include KUNNR (Customer Numbers), VKORG (Sales Organization), VTWEG (Distribution Channel), SPART (Division).. 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: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced


SAP /BEV1/TSZKK 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
KUNNRCustomer Numbers KUNNRCHAR10KNA1ALPHAKUNNRKUNC_KUNNR
VKORGSales Organization VKORGCHAR4TVKOVKORGVKOC_VKORG
VTWEGDistribution Channel VTWEGCHAR2TVTWVTWEGVTWC_VTWEG
SPARTDivision SPARTCHAR2TSPASPARTSPAC_SPART
ANWBERApplication Area /BEV1/TSABER___DCHAR10/BEV1/TSABERTV_V/BEV1/TSABER
PARNRNumber of contact person PARNRNUMC10KNVKPARNRVPA
SAISONSeason Indicator /BEV1/TSSAISONCHAR5/BEV1/TSSAIDEF/BEV1/TSSAISON
ANWGRPApplication Group /BEV1/TSAGRP___DCHAR7/BEV1/TSAGRP/BEV1/TSAGRP/BEV1/TS_AGRP
GUELTVValid from /BEV1/TSGDTVDATS8DATUM
GUELTBValid to /BEV1/TSGDTBDATS8DATUM
AUSZVExclusion Time from /BEV1/TSAUSVDATS8DATUM
AUSZBTime Suspended to /BEV1/TSAUSBDATS8DATUM
KONTSPRTemporary Sales Activity Block /BEV1/TSKONTSPRCHAR1CHAR1
RHYTHMSFrequency /BEV1/TSRHYTHMSCHAR4/BEV1/TSZYKBRYTH
VERKMETSales Method /BEV1/TSVERKMETCHAR3/BEV1/TSVM/BEV1/TSVERKMET
ANRUFShift Call /BEV1/TSANRUCHAR1CHAR1
LIEFERDelivery Shift /BEV1/TSLIEFCHAR1CHAR1
FOLGESequence of Application Group /BEV1/TSFOLGNUMC8/BEV1/TSFOLG
ANRKALPhone Call Calendar /BEV1/TSANRKALCHAR2TFACDWFCID
LIEFKALDelivery Calendar /BEV1/TSLIEFKALCHAR2TFACDWFCID
LIEFMODelivery - Monday /BEV1/TSLIEFMOCHAR1CHAR1
LIEFDIDelivery - Tuesday /BEV1/TSLIEFDICHAR1CHAR1
LIEFMIDelivery - Wednesday /BEV1/TSLIEFMICHAR1CHAR1
LIEFDODelivery - Thursday /BEV1/TSLIEFDOCHAR1CHAR1
LIEFFRDelivery - Friday /BEV1/TSLIEFFRCHAR1CHAR1
LIEFSADelivery - Saturday /BEV1/TSLIEFSACHAR1CHAR1
LIEFSODelivery - Sunday /BEV1/TSLIEFSOCHAR1CHAR1
KONTBEGStart of Sales Activity /BEV1/TSBDATDATS8DATUM
STDSTARTStart Status /BEV1/TSSTATCHAR1CHAR1
ANRALTAlternative Phone Call Date /BEV1/TSANRADATS8DATUM
SORTMNGAssortment Quantities /BEV1/TSSMNGCHAR1CHAR1
SORTCHGChange of Assortment /BEV1/TSSCHGCHAR1CHAR1
BEMERK1Comment1 /BEV1/TSBEM1CHAR40TEXT40
BEMERK2Comment2 /BEV1/TSBEM2CHAR40TEXT40
AUARTSales Document Type AUARTCHAR4TVAKAUARTAUARTAAT
KZ1Indicator1 /BEV1/TSKZ1CHAR4CHAR4
KZ2Indicator2 /BEV1/TSKZ2CHAR4CHAR4
KZ3Indicator3 /BEV1/TSKZ3CHAR4CHAR4
AENAMName of Person Who Changed Object AENAMCHAR12USNAM
AEDATChanged On AEDATDATS8DATUM
AEZETTime last change was made AEZETTIMS6UZEIT
DELAYNumber of Days /BEV1/TSDELAYNUMC2/BEV1/TSDAYS

Key field Non-key field



How do I retrieve data from SAP table /BEV1/TSZKK using ABAP code

The following ABAP code Example will allow you to do a basic selection on /BEV1/TSZKK to SELECT all data from the table
DATA: WA_/BEV1/TSZKK TYPE /BEV1/TSZKK.

SELECT SINGLE *
FROM /BEV1/TSZKK
INTO CORRESPONDING FIELDS OF WA_/BEV1/TSZKK
WHERE...

How to access SAP table /BEV1/TSZKK

Within an ECC or HANA version of SAP you can also view further information about /BEV1/TSZKK 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!