VSVBKD_CN SAP (Version: Sales document - commercial data) Table details

Dictionary Type: Table
Description: Version: Sales document - commercial data




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




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

VSVBKD_CN is a standard SAP Table which is used to store Version: Sales document - commercial data data and is available within R/3 SAP systems depending on the version and release level.

The VSVBKD_CN table consists of various fields, each holding specific information or linking keys about Version: Sales document - commercial data data available in SAP. These include VSNMR (Number or description of a version), VBELN (Sales and Distribution Document Number), POSNR (Item number of the SD document), KONDA (Price group (customer)).. 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: Can be enhanced (character-type or numeric)


SAP VSVBKD_CN 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 MANDTCLNT3Assigned to domainMANDT
VSNMRNumber or description of a version VSNMRCHAR12VSNMRVS2
VBELNSales and Distribution Document Number VBELNCHAR10Assigned to domainALPHAVBELNAUN
POSNRItem number of the SD document POSNRNUMC6Assigned to domainPOSNR
KONDAPrice group (customer) KONDACHAR2Assigned to domainKONDAVKA
KDGRPCustomer group KDGRPCHAR2Assigned to domainKDGRPVKD
BZIRKSales district BZIRKCHAR6Assigned to domainBZIRKBZI
PLTYPPrice list type PLTYPCHAR2Assigned to domainPLTYPVPL
INCO1Incoterms (Part 1) INCO1CHAR3Assigned to domainINCO1
INCO2Incoterms (Part 2) INCO2CHAR28INCO2
KZAZUOrder Combination Indicator KZAZU_DCHAR1XFELD
PERFKInvoice dates (calendar identification) PERFKCHAR2Assigned to domainWFCID
PERRLInvoice list schedule (calendar identification) PERRLCHAR2Assigned to domainWFCID
MRNKZManual invoice maintenance MRNKZCHAR1XFELD
KURRFExchange rate for FI postings KURRFDEC9(5) KURRF
VALTGAdditional value days VALTGNUMC2TAGE2
VALDTFixed value date VALDTDATS8DATUM
ZTERMTerms of Payment Key DZTERMCHAR4ZTERM
ZLSCHPayment Method SCHZW_BSEGCHAR1Assigned to domainZLSCH
KTGRDAccount assignment group for this customer KTGRDCHAR2Assigned to domainKTGRD
KURSKExchange Rate for Price Determination KURSKDEC9(5) EXCRTKURRF
PRSDTDate for pricing and exchange rate PRSDTDATS8DATUM
FKDATBilling date for billing index and printout FKDATDATS8DATUM
FBUDADate on which services rendered FBUDADATS8DATUM
GJAHRFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
POPERPosting period POPERNUMC3POPERPOPR
STCURExchange rate for statistics STCURDEC9(5) EXCRTKURRF
MSCHLDunning key MSCHLCHAR1Assigned to domainMSCHL
MANSPDunning block MANSPCHAR1Assigned to domainMANSP
FPLNRBilling plan number / invoicing plan number FPLNRCHAR10Assigned to domainFPLNR
WAKTIONCOUPON WAKTIONCHAR10Assigned to domainALPHAWAKTIONWAK
ABSSCPayment guarantee procedure ABSSCHE_CMCHAR6ABSSCHE_CM
LCNUMFinancial doc. processing: Internal financial doc. number LCNUMCHAR10Assigned to domainALPHALCNUMAKN
J_1AFITPTax type J_1AFITP_DCHAR2Assigned to domainJ_1AFITP
J_1ARFZReason for zero VAT J_1ARFZVATCHAR1Assigned to domainJ_1ARFZVAT
J_1AREGIOSTATE (State, Province, County) REGIOCHAR3Assigned to domainREGIO
J_1AGICDActivity Code for Gross Income Tax J_1AGICD_DCHAR2Assigned to domainJ_1AGICD2
J_1ADTYPDistribution Type for Employment Tax J_1ADTYP_DCHAR2Assigned to domainJ_1ADTYP
J_1ATXRELTax relevant classification J_1ATXREL_CHAR10Assigned to domainJ_1ATXREL
ABTNRDepartment number ABTNRCHAR4Assigned to domainABTNR
EMPSTReceiving point EMPSTCHAR25TEXT25
BSTKDCustomer purchase order number BSTKDCHAR35BSTKD
BSTDKCustomer purchase order date BSTDKDATS8DATUM
BSARKCustomer purchase order type BSARKCHAR4Assigned to domainBSARK
IHREZYour Reference IHREZCHAR12TEXT12
BSTKD_EShip-to Party's Purchase Order Number BSTKD_ECHAR35BSTKD
BSTDK_EShip-to party's PO date BSTDK_EDATS8DATUM
BSARK_EShip-to party purchase order type BSARK_ECHAR4Assigned to domainBSARK
IHREZ_EShip-to party character IHREZ_ECHAR12TEXT12
POSEX_EItem Number of the Underlying Purchase Order POSEX_ECHAR6ALPHAPOSEX
KURSK_DATTranslation Date WWERT_DDATS8DATUM
KURRF_DATTranslation Date WWERT_DDATS8DATUM
KDKG1Customer condition group 1 KDKG1CHAR2Assigned to domainKDKGR
KDKG2Customer condition group 2 KDKG2CHAR2Assigned to domainKDKGR
KDKG3Customer condition group 3 KDKG3CHAR2Assigned to domainKDKGR
KDKG4Customer condition group 4 KDKG4CHAR2Assigned to domainKDKGR
KDKG5Customer condition group 5 KDKG5CHAR2Assigned to domainKDKGR
WKWAEValue contract currency WKWAECUKY5Assigned to domainWAERS
WKKURExchange rate in value contract currency WKKURDEC9(5) KURRF
AKWAECurrency key for letter-of-credit procg in foreign trade AKWAECUKY5Assigned to domainWAERSFWS
AKKURExchange rate for letter-of-credit procg in foreign trade AKKURDEC9(5) KURRF
AKPRZDepreciation percentage for financial document processing AKPRZDEC5(2) PRZ32
J_1AINDXPInflation Index J_1AINDXPCHAR5Assigned to domainJ_1AINDXP
J_1AIDATEPIndexing base date J_1AIDATESDATS8J_1AUDATEP
BSTKD_MCustomer PO number as matchcode field BSTKD_MCHAR35CHAR35
DELCOAgreed delivery time DELCOCHAR3DELCO
FFPRFDynamic Item Processor Profile AD01PROFNRCHAR8Assigned to domainAD01PROFNRAD0DIP_PROFILE
BEMOTAccounting Indicator BEMOTCHAR2Assigned to domainBEMOT
FAKTFBilling form FAKTFCHAR2FAKTF
RRRELRevenue recognition category RR_RELTYPCHAR1RR_RELTYP
ACDATVProposed start date for accrual period RR_ACDATVCHAR1RR_ACDATV
VSARTShipping type VSARTTRCHAR2T173VERSART
TRATYMeans-of-Transport Type TRATYCHAR4TVTYTRATY
TRMTYPMeans of Transport TRMTYPCHAR18MARAMATN1MATNR
SDABWSpecial processing indicator SDABWCHAR4TVSAKSDABW
WMINRProduct catalog number WMINRCHAR10WWMIWMINRWMIWPC1
FKBERFunctional Area FKBERCHAR16TFKBFKBERFBE
PODKZRelevant for POD processing PODKZCHAR1XFELD
CAMPAIGNGeneric project planning: GUID from external R/3 system CGPL_GUID16_R3RAW16SYSUUID
VKONTCharacter Field of Length 12 CHAR12CHAR12CHAR12
.INCLU--AP 0
STCODELST CST applicability code J_1ISTCODECHAR3Assigned to domainJ_1ISTCODE
FORMC1Form Type J_1IFORTYPCHAR3Assigned to domainJ_1IFORTYP
FORMC2Form Type J_1IFORTYPCHAR3Assigned to domainJ_1IFORTYP
STEUCControl code for consumption taxes in foreign trade STEUCCHAR16Assigned to domainSTEUC

Key field Non-key field



How do I retrieve data from SAP table VSVBKD_CN using ABAP code

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

SELECT SINGLE *
FROM VSVBKD_CN
INTO CORRESPONDING FIELDS OF WA_VSVBKD_CN
WHERE...

How to access SAP table VSVBKD_CN

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