SHP_KOMK_KEY SAP (Key Fields KOMK for Accesses to KOMK Tables) Structure details

Dictionary Type: Structure
Description: Key Fields KOMK for Accesses to KOMK Tables




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




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

SHP_KOMK_KEY is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Key Fields KOMK for Accesses to KOMK Tables" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_SHP_KOMK_KEY TYPE SHP_KOMK_KEY.

The SHP_KOMK_KEY table consists of various fields, each holding specific information or linking keys about Key Fields KOMK for Accesses to KOMK Tables data available in SAP. These include BELNR (Sales and Distribution Document Number), KNUMV (Number of the document condition), VKORG (Sales Organization), VTWEG (Distribution Channel).. 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:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP SHP_KOMK_KEY structure 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
BELNRSales and Distribution Document Number VBELNCHAR10Assigned to domainALPHAVBELNAUN
KNUMVNumber of the document condition KNUMVCHAR10KNUMV
VKORGSales Organization VKORGCHAR4Assigned to domainVKORGVKOC_VKORG
VTWEGDistribution Channel VTWEGCHAR2Assigned to domainVTWEGVTWC_VTWEG
SPARTDivision SPARTCHAR2Assigned to domainSPARTSPAC_SPART
BZIRKSales district BZIRKCHAR6Assigned to domainBZIRKBZI
VKGRPSales Group VKGRPCHAR3Assigned to domainVKGRPVKG
BRSCHIndustry key BRSCHCHAR4Assigned to domainBRSCH
VKBURSales Office VKBURCHAR4Assigned to domainVKBURVKB
KONDAPrice group (customer) KONDACHAR2Assigned to domainKONDAVKA
KDGRPCustomer group KDGRPCHAR2Assigned to domainKDGRPVKD
PLTYPPrice list type PLTYPCHAR2Assigned to domainPLTYPVPL
ALANDDeparture country (country from which the goods are sent) ALANDCHAR3Assigned to domainLAND1VAL
WKREGRegion in which plant is located WKREGCHAR3Assigned to domainREGIO
WKCOUCounty in which plant is located WKCOUCHAR3CHAR3
WKCTYCity in which plant is located WKCTYCHAR4CHAR4
BUKRSCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
GSBERBusiness Area GSBERCHAR4Assigned to domainGSBERGSB
WERKVResale plant WERKVCHAR4Assigned to domainWERKS
HWAERLocal Currency HWAERCUKY5Assigned to domainWAERS
WAERKSD Document Currency WAERKCUKY5Assigned to domainWAERSFWS
KURSTExchange Rate Type KURSTCHAR4Assigned to domainKURSTKUT
KURRFExchange rate for FI postings KURRFDEC9(5) KURRF
KURRF_DATTranslation Date WWERT_DDATS8DATUM
KUNNRSold-to party KUNAGCHAR10Assigned to domainALPHAKUNNRVAG
KNRZEPayer KUNRGCHAR10Assigned to domainALPHAKUNNR
KUNREBill-to party KUNRECHAR10Assigned to domainALPHAKUNNRKUN
KUNWEShip-to party KUNWECHAR10Assigned to domainALPHAKUNNR
SPDNRForwarding agent SPDNRCHAR10Assigned to domainALPHALIFNR
LIFNRVendor Account Number ELIFNCHAR10Assigned to domainALPHALIFNRLIFKRED_C
VRTNRSales employee VRTNRNUMC8PERNRPREMV
ZTERMTerms of Payment Key DZTERMCHAR4ZTERM
ZBD1PCash Discount Percentage 1 DZBD1PDEC5(3) PRZ23
KAPPLApplication KAPPLCHAR2Assigned to domainKAPPLKAP
KALSMProcedure (Pricing, Output Control, Acct. Det., Costing,...) KALSM_DCHAR6Assigned to domainKALSM
PRSDTDate for pricing and exchange rate PRSDTDATS8DATUM
FBUDADate on which services rendered FBUDADATS8DATUM
FKDATBilling date for billing index and printout FKDATDATS8DATUM
ERDATDate on Which Record Was Created ERDATDATS8DATUM
AUDATDocument Date (Date Received/Sent) AUDATDATS8DATUM
INCO1Incoterms (Part 1) INCO1CHAR3Assigned to domainINCO1
INCO2Incoterms (Part 2) INCO2CHAR28INCO2
LAND1Country of Destination LLANDCHAR3Assigned to domainLAND1VLL
REGIOSTATE (State, Province, County) REGIOCHAR3Assigned to domainREGIO
COUNCCounty Code COUNCCHAR3Assigned to domainCOUNC
CITYCCity Code CITYCCHAR4Assigned to domainCITYC
TXJCDTax Jurisdiction TXJCDCHAR15Assigned to domainTXJCDTXJ
STCEGVAT Registration Number STCEGCHAR20STCEG
TAXK1Tax classification 1 for customer TAXK1CHAR1Assigned to domainTAXKD
TAXK2Tax classification 2 for customer TAXK2CHAR1Assigned to domainTAXKD
TAXK3Tax classification 3 for customer TAXK3CHAR1Assigned to domainTAXKD
TAXK4Tax Classification 4 Customer TAXK4CHAR1Assigned to domainTAXKD
TAXK5Tax classification 5 for customer TAXK5CHAR1Assigned to domainTAXKD
TAXK6Tax classification 6 for customer TAXK6CHAR1Assigned to domainTAXKD
TAXK7Tax classification 7 for customer TAXK7CHAR1Assigned to domainTAXKD
TAXK8Tax classification 8 for customer TAXK8CHAR1Assigned to domainTAXKD
TAXK9Tax classification 9 for customer TAXK9CHAR1Assigned to domainTAXKD
NO_UPDNo update of internal tax memory NO_TAX_UPDCHAR1CHAR1
AUARTOrder Type AUFARTCHAR4Assigned to domainAUFARTAAT
AUTYPOrder category AUFTYPNUMC2AUFTYP
ZSCHLOverhead key AUFZSCHLCHAR6CHAR6
AUFZAOverhead type AUFZACHAR1AUFZAOVERHEAD_TYPE
PRCTRProfit Center PRCTRCHAR10Assigned to domainALPHAPRCTRPRCPRCTR_EMPTY
KOSTVResponsible cost center AUFKOSTVCHAR10Assigned to domainALPHAKOSTL
EKORGPurchasing Organization EKORGCHAR4Assigned to domainEKORGEKO
EKOR1Reference purchasing organization 1 WEKOR1CHAR4Assigned to domainEKORGEKO
EKOR2Reference purchasing organization 2 WEKOR2CHAR4Assigned to domainEKORGEKO
BSTYPPurchasing Document Category BSTYPCHAR1BSTYP
BSARTPurchasing Document Type ESARTCHAR4Assigned to domainBSARTBSA
EGIMPEC import EGIMPCHAR1XFELD
KVORGEvent in condition processing KVORGCHAR2KOVOR
RESWKSupplying (Issuing) Plant in Stock Transport Order RESWKCHAR4Assigned to domainWERKS
REVKOSales organization of supplying plant (Purchasing) WKVKOCHAR4Assigned to domainVKORG
REVTWDistribution channel of supplying plant (Purchasing) WKVTWCHAR2Assigned to domainVTWEG
LIFREDifferent Invoicing Party LIFRECHAR10Assigned to domainALPHALIFNRLRE
LLIEFSupplying Vendor LLIEFCHAR10Assigned to domainALPHALIFNRLLI
VBTYPSD document category VBTYPCHAR1VBTYP
KOKRSControlling Area KOKRSCHAR4Assigned to domainCACCDCAC
KOSTLCost Center KOSTLCHAR10Assigned to domainALPHAKOSTLKOS
KOSARCost Center Category KOSARCHAR1Assigned to domainKOSARPCA_KOSAR
ERKRSOperating concern ERKRSCHAR4Assigned to domainERKRSERB
PROJKWork Breakdown Structure Element (WBS Element) PS_PSP_PNRNUMC8Assigned to domainKONPRPS_POSNR
AUFNROrder Number AUFNRCHAR12Assigned to domainALPHAAUFNRANR
BLARTDocument Type BLARTCHAR2Assigned to domainBLARTBAR
PLIKZPlan/Actual Indicator PLIKZCHAR1PLIKZ
VERSIPlan version (CO-PA) RKEVERSICHAR3Assigned to domainALPHACOVERSIPVS
VERSNVersion VERSNCHAR3Assigned to domainALPHACOVERSIKVS
VRGARRecord Type RKE_VRGARCHAR1Assigned to domainVRGARVGA
FKARTBilling Type FKARTCHAR4Assigned to domainFKART
KNUMAAgreement (various conditions grouped together) KNUMACHAR10Assigned to domainALPHAKNUMAVMBO
VKORGAUSales organization of sales order VKORG_AUFTCHAR4Assigned to domainVKORGVKO
RELIRELRelevant for invoice list RELIRELCHAR1XFELD
BORELRelevant for rebate BORELCHAR1XFELD
MWSKZTax on sales/purchases code MWSKZCHAR2Assigned to domainMWSKZ
TXJCD1Tax Calculation Location - Tax Jurisdiction Code 1 TXJCD1CHAR15Assigned to domainTXJCD
TXJCD2Tax Calculation Location - Tax Jurisdiction Code 2 TXJCD2CHAR15Assigned to domainTXJCD
TXJCD3Tax Calculation Location - Tax Jurisdiction Code 3 TXJCD3CHAR15Assigned to domainTXJCD
HITYP_PRHierarchy type for pricing HITYP_PRCHAR1Assigned to domainHITYP
BOAVORebate processing active in the sales organization BOAVOCHAR1XFELD
BORVFBilling document is relevant for rebate processing BORVFCHAR1XFELD
BOKREIndicator: Customer Is Rebate-Relevant BOKRECHAR1XFELD
FKART_RLInvoice list type FKART_RLCHAR4Assigned to domainFKART
PERRLInvoice list schedule (calendar identification) PERRLCHAR2Assigned to domainWFCID
FKDAT_RLBilling date for the invoice list FKDAT_RLDATS8DATUM
HLANDDelivering country HLANDCHAR3Assigned to domainLAND1VAL
AUSFUExporter for import processing in foreign trade AUSFUCHAR10Assigned to domainALPHALIFNR
BOFKTBilling type for rebate processing BOFKTCHAR1BOFKT
AUART_SDSales Document Type AUARTCHAR4Assigned to domainAUARTAUARTAAT
AUGRUOrder reason (reason for the business transaction) AUGRUCHAR3Assigned to domainAUGRU
TRTYPTransaction type TRTYPCHAR1TRTYP
GZOLXPreference zone GZOLXCHAR4Assigned to domainGZOLX
WERKSPlant WERKS_DCHAR4Assigned to domainWERKSWRKH_T001W_C
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
VBKLTSD document indicator VBKLTCHAR1VBKLT
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
J_1AINDXPInflation Index J_1AINDXPCHAR5Assigned to domainJ_1AINDXP
J_1AIDATEPIndexing base date J_1AIDATESDATS8J_1AUDATEP
RESRCResource CO_RESSOURCECHAR10Assigned to domainALPHACO_RESSOURCERCE
KHINRSet ID SETNRCHAR12SETNRGSE
PABPRFJIT Call Profile PABPRFCHAR4Assigned to domainPABPRF
ABLADUnloading Point ABLADCHAR25TEXT25
DELCOAgreed delivery time DELCOCHAR3DELCO
SHTYPShipment type SHTYPCHAR4TVTKSHTYPTSH
TPLSTTransportation planning point TPLSTCHAR4TTDSTPLSTTDP
ABFERShipment completion type ABFERCHAR1ABFER
ABWSTProcessing control ABWSTCHAR1ABWST
BFARTService Level BFARTCHAR1BFART
VSBEDShipping Conditions VSBEDCHAR2TVSBVSBED
ROUTEShipment route ROUTRCHAR6TVROROUTEVMTR
CONT_DGIndicator: Document contains dangerous goods ADGE_NCDGCHAR1X
ADD01Suppl. 1 VTTK_ADD01CHAR10VTADD01VTTK_ADD01
ADD02Suppl. 2 VTTK_ADD02CHAR10VTADD02VTTK_ADD02
ADD03Suppl. 3 VTTK_ADD03CHAR10VTADD03VTTK_ADD03
ADD04Suppl. 4 VTTK_ADD04CHAR10VTADD04VTTK_ADD04
TDLNR_FACarrier Number VF_TDLNR_FACHAR10LFA1ALPHALIFNRLIFF4_CARRIERS
VSARTShipping type for shipment stage VERSARTSCHAR2T173VERSART
LAUFKLeg indicator for shipment stage LAUFSCHAR1LAUFK
TDLNRNumber of forwarding agent in the shipment stage TDLNRSCHAR10LFA1ALPHALIFNRF4_CARRIERS
TDLNR_LNDCountry of Transportation Service Agent VF_LAND_TDLNRCHAR3T005LAND1LND
SDABWSpecial processing indicator SDABWCHAR4TVSAKSDABW
SLAND1_ATax country departure SLAND1_ACHAR3T005LAND1
SLAND1_ZTax country destination SLAND1_ZCHAR3T005LAND1
KNOTADeparture Point KNOTACHAR10TVKNKNOTN
.INCLU-A 0
LAND1ACountry key for point of departure LAND1ACHAR3T005LAND1LND
PSTLZADeparture postal code PSTLZACHAR10PSTLZ
LZONEADeparture zone LZONEACHAR10TZONEZONE
REGIOADeparture region (federal state, county, province, duchy) REGIOACHAR3T005SREGIO
TRFZNATariff zone of point of departure TRFZNACHAR10TVFTZTRFZN
KNOTZDestination point KNOTZCHAR10TVKNKNOTN
.INCLU-Z 0
LAND1ZCountry key LAND1ZCHAR3T005LAND1LND
PSTLZZTarget postal code PSTLZZCHAR10PSTLZ
LZONEZDestination zone LZONEZCHAR10TZONEZONE
REGIOZDestination region (federal state, county, province duchy) REGIOZCHAR3T005SREGIO
TRFZNZTariff zone of point of destination TRFZNZCHAR10TVFTZTRFZN
GESZTDAActual total time at stage of shipment (in days) AB_GESZTDADEC11TSTRGTSTRDURAG
FAHZTDAActual duration of shipment stage (in hours:minutes) AB_EFFZTDADEC11TSTRNTSTRDURAN
WARZTDACurrent waiting time in shipment stage (in hrs:min) AB_WARZTDADEC11TSTRNTSTRDURAN
VSTELShipping Point/Receiving Point VSTELCHAR4TVSTVSTELVST
LHIENR01Vendor hierarchy 1 LHIENR01CHAR10Assigned to domainALPHALIFNR
LHIENR02Vendor hierarchy 2 LHIENR02CHAR10Assigned to domainALPHALIFNR
LHIENR03Vendor hierarchy 3 LHIENR03CHAR10Assigned to domainALPHALIFNR
LHIENR04Vendor hierarchy 4 LHIENR04CHAR10Assigned to domainALPHALIFNR
LHIENR05Vendor hierarchy 5 LHIENR05CHAR10Assigned to domainALPHALIFNR
LHIENR06Vendor hierarchy 6 LHIENR06CHAR10Assigned to domainALPHALIFNR
LHIENR07Vendor hierarchy 7 LHIENR07CHAR10Assigned to domainALPHALIFNR
LHIENR08Vendor hierarchy 8 LHIENR08CHAR10Assigned to domainALPHALIFNR
LHIENR09Vendor hierarchy 9 LHIENR09CHAR10Assigned to domainALPHALIFNR
LHIENR10Vendor hierarchy 10 LHIENR10CHAR10Assigned to domainALPHALIFNR
LHIENR11Vendor hierarchy 11 LHIENR11CHAR10Assigned to domainALPHALIFNR
LHIENR12Vendor hierarchy 12 LHIENR12CHAR10Assigned to domainALPHALIFNR
LHIENR13Vendor hierarchy 13 LHIENR13CHAR10Assigned to domainALPHALIFNR
LHIENR14Vendor hierarchy 14 LHIENR14CHAR10Assigned to domainALPHALIFNR
LHIENR15Vendor hierarchy 15 LHIENR15CHAR10Assigned to domainALPHALIFNR
LHIEBO01Vendor hierarchy 1 LHIENR01CHAR10Assigned to domainALPHALIFNR
LHIEBO02Vendor hierarchy 2 LHIENR02CHAR10Assigned to domainALPHALIFNR
LHIEBO03Vendor hierarchy 3 LHIENR03CHAR10Assigned to domainALPHALIFNR
LHIEBO04Vendor hierarchy 4 LHIENR04CHAR10Assigned to domainALPHALIFNR
LHIEBO05Vendor hierarchy 5 LHIENR05CHAR10Assigned to domainALPHALIFNR
LHIEBO06Vendor hierarchy 6 LHIENR06CHAR10Assigned to domainALPHALIFNR
LHIEBO07Vendor hierarchy 7 LHIENR07CHAR10Assigned to domainALPHALIFNR
LHIEBO08Vendor hierarchy 8 LHIENR08CHAR10Assigned to domainALPHALIFNR
LHIEBO09Vendor hierarchy 9 LHIENR09CHAR10Assigned to domainALPHALIFNR
LHIEBO10Vendor hierarchy 10 LHIENR10CHAR10Assigned to domainALPHALIFNR
LHIEBO11Vendor hierarchy 11 LHIENR11CHAR10Assigned to domainALPHALIFNR
LHIEBO12Vendor hierarchy 12 LHIENR12CHAR10Assigned to domainALPHALIFNR
LHIEBO13Vendor hierarchy 13 LHIENR13CHAR10Assigned to domainALPHALIFNR
LHIEBO14Vendor hierarchy 14 LHIENR14CHAR10Assigned to domainALPHALIFNR
LHIEBO15Vendor hierarchy 15 LHIENR15CHAR10Assigned to domainALPHALIFNR
KDUMMY_ISDummy function in length 1 DUMMYCHAR1DUMMY
KDUMMY_KEDummy function in length 1 DUMMYCHAR1DUMMY
RKE_KUKLACustomer classification KUKLACHAR2TKUKLKUKLA
RKE_AUGRUOrder reason (reason for the business transaction) AUGRUCHAR3TVAUAUGRU
RKE_HIE01Customer hierarchy Level 1 HIEZU01CHAR10KNA1ALPHAKUNNR
RKE_HIE02Customer hierarchy Level 2 HIEZU02CHAR10KNA1ALPHAKUNNR
RKE_HIE03Customer hierarchy Level 3 HIEZU03CHAR10KNA1ALPHAKUNNR
RKE_PAREGCO-PA special characteristic: (Land, Region) RKE_PAREGCHAR6RKE_PAREG
RKE_KMNIELNielsen ID NIELSCHAR2TNLSNIELS
RKE_KMHI01Customer hierarchy Level 1 HIEZU01CHAR10KNA1ALPHAKUNNR
RKE_KMHI02Customer hierarchy Level 2 HIEZU02CHAR10KNA1ALPHAKUNNR
RKE_KMHI03Customer hierarchy Level 3 HIEZU03CHAR10KNA1ALPHAKUNNR
RKE_KMLANDCountry Key LAND1_GPCHAR3T005LAND1C_LAND1
KDUMMY_BEDummy function in length 1 DUMMYCHAR1DUMMY
KDUMMYDummy function in length 1 DUMMYCHAR1DUMMY
.INCLU--AP 0
TXJCD_SFJurisdiction code 'Ship-from' TXJCD_SFCHAR15Assigned to domainTXJCDTXJ
.INCLU--AP 0
KDUMMY_J0Dummy function in length 1 DUMMYCHAR1DUMMY
KDUMMY_J1Dummy function in length 1 DUMMYCHAR1DUMMY
TKONNTrading Contract: Trading Contract Number TKONNCHAR10Assigned to domainALPHATKONNWKNWBHK
TPOSNTrading Contract: Item Number TPOSNNUMC6TPOSNWKP

Key field Non-key field



How do I retrieve data from SAP structure SHP_KOMK_KEY using ABAP code?

As SHP_KOMK_KEY is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on SHP_KOMK_KEY as there is no data to select.

How to access SAP table SHP_KOMK_KEY

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