SAP ABAP Table KOMLKGN (IS-PSD: Gen.Settlement Interface - Communication Table)
Hierarchy
IS-M (Software Component) SAP MEDIA
   IS-M (Application Component) SAP Media
     JSD (Package) Appl. dev. R/3 Publishing Sales and Distribution System
Basic Data
Table Category INTTAB    Structure 
Structure KOMLKGN   Table Relationship Diagram
Short Description IS-PSD: Gen.Settlement Interface - Communication Table    
Delivery and Maintenance
Pool/cluster      
Delivery Class      
Data Browser/Table View Maintenance     Display/Maintenance Allowed with Restrictions 
Components
     
Field Key Data Element Domain Data
Type
Length Decimal
Places
Short Description Check
table
1 MANDT MANDT MANDT CLNT 3   0   Client *
2 JVBTYP JVBTYP JVBTYP CHAR 1   0   IS-M: Sales document category  
3 WAERK WAERK WAERS CUKY 5   0   SD document currency *
4 EKORG EKORG EKORG CHAR 4   0   Purchasing organization *
5 KALSM KALSMASD KALSM CHAR 6   0   Sales and Distribution: Pricing Procedure in Pricing *
6 KNUMV KNUMV KNUMV CHAR 10   0   Number of the document condition  
7 ABDAT JABDAT DATUM DATS 8   0   IS-M: Settlement Date  
8 BELNR BELNR_D BELNR CHAR 10   0   Accounting Document Number  
9 GJAHR GJAHR GJAHR NUMC 4   0   Fiscal Year  
10 POPER POPER POPER NUMC 3   0   Posting period  
11 RFBSK RFBSK RFBSK CHAR 1   0   Status for transfer to accounting  
12 KURRF KURRF KURRF DEC 9   5   Exchange rate for FI postings  
13 CPKUR CPKUR CPKUR CHAR 1   0   ID:Exchange rate setting (no new rate determ.in bill.doc.)  
14 VALTG VALTG TAGE2 NUMC 2   0   Additional value days  
15 VALDT VALDT DATUM DATS 8   0   Fixed value date  
16 LAND1 LAND1 LAND1 CHAR 3   0   Country Key *
17 ZTERM DZTERM ZTERM CHAR 4   0   Terms of payment key  
18 BUKRS BUKRS BUKRS CHAR 4   0   Company Code *
19 MWSKZ MWSKZ MWSKZ CHAR 2   0   Tax on sales/purchases code *
20 NETWR NETWR WERTV8 CURR 15   2   Net Value in Document Currency  
21 ZUKRI DZUKRI CHAR40 CHAR 40   0   Combination criteria in the billing document  
22 STWAE STWAE WAERS CUKY 5   0   Statistics currency *
23 STCEG STCEG STCEG CHAR 20   0   VAT Registration Number  
24 AEDAT AEDAT DATUM DATS 8   0   Last Changed On  
25 JSFAKN JSFAKN JVBELN CHAR 10   0   IS-M: Number of Reversed Settlement *
26 KURST KURST KURST CHAR 4   0   Exchange Rate Type *
27 OBJART JOBJART JOBJART CHAR 4   0   IS-M: Object type for document flow  
28 KURSK KURSK KURRF DEC 9   5   Exchange Rate for Pricing and Statistics  
29 JAUART AUART_ISP AUART_ISP CHAR 4   0   IS-M/SD: Sales Document Types *
30 AUARTGRP JAUARTGRP JAUARTGRP CHAR 1   0   IS-M/SD: Sales document type grouping  
31 ABIMG ABIMG MENG13 QUAN 13   3   IS-M: Actual Settlement Quantity  
32 MEINS MEINS MEINS UNIT 3   0   Base Unit of Measure *
33 SMENG SMENG MENG13 QUAN 13   3   Scale quantity in base unit of measure  
34 BEILAGEN JBEILAGEN STMENGE DEC 9   0   IS-M: Number of inserts per issue  
35 MEINHBL JMEINHBL MEINS UNIT 3   0   IS-M: Unit of weight for inserts *
36 BRGEW JBRGEW ISPMNG13 QUAN 13   3   IS-M: Gross weight (issue weight incl.weight of inserts)  
37 NTGEW JNTGEW ISPMNG13 QUAN 13   3   IS-M: Net Weight (Weight of Issue Minus Inserts)  
38 MEINHGW JMEINHGW MEINS UNIT 3   0   IS-M: Unit of weight for total issue weight *
39 GSBER GSBER GSBER CHAR 4   0   Business Area *
40 KREWL KREWL LIFNR CHAR 10   0   IS-M: Supplier of goods *
41 KREZE KREZE LIFNR CHAR 10   0   IS-M: Payee *
42 KRERS KRERS LIFNR CHAR 10   0   IS-M: Invoicing party *
43 KREAN KREAN LIFNR CHAR 10   0   IS-M: Contractor *
44 PRSDT PRSDT DATUM DATS 8   0   Date for pricing and exchange rate  
45 FBUDA FBUDA DATUM DATS 8   0   Date When Services Rendered  
46 VBELV VBELV VBELN CHAR 10   0   Originating document *
47 POSNV POSNV POSNR NUMC 6   0   Originating item *
48 VGBEL VGBEL VBELN CHAR 10   0   Document number of the reference document *
49 VGPOS VGPOS POSNR NUMC 6   0   Item number of the reference item *
50 VGTYP VBTYP VBTYP CHAR 1   0   SD document category  
51 NO_DIENL CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
52 DIENL MATNR MATNR CHAR 18   0   Material Number *
53 ARKTX ARKTX TEXT40 CHAR 40   0   Short text for sales order item  
54 POSAR POSAR POSAR CHAR 1   0   Item type  
55 TAXM1 TAXM1 TAXKM CHAR 1   0   Tax classification material *
56 TAXM2 TAXM2 TAXKM CHAR 1   0   Tax classification material *
57 TAXM3 TAXM3 TAXKM CHAR 1   0   Tax classification material *
58 TAXM4 TAXM4 TAXKM CHAR 1   0   Tax Classification 4 Material *
59 TAXM5 TAXM5 TAXKM CHAR 1   0   Tax classification 5 for material *
60 TAXM6 TAXM6 TAXKM CHAR 1   0   Tax classification 6 for material *
61 TAXM7 TAXM7 TAXKM CHAR 1   0   Tax classification 7 for material *
62 TAXM8 TAXM8 TAXKM CHAR 1   0   Tax Classification 8 Material *
63 TAXM9 TAXM9 TAXKM CHAR 1   0   Tax Classification 9 Material *
64 KOWRR KOWRR KOWRR CHAR 1   0   Statistical values  
65 PRSFD PRSFD PRSFD CHAR 1   0   Carry out pricing  
66 KOSTL KOSTL KOSTL CHAR 10   0   Cost Center *
67 STAFO STAFO STAFO CHAR 6   0   Update group for statistics update *
68 WAVWR WAVWR WERTV7 CURR 13   2   Cost in document currency  
69 KZWI1 KZWI1 WERTV7 CURR 13   2   Subtotal 1 from pricing procedure for condition  
70 KZWI2 KZWI2 WERTV7 CURR 13   2   Subtotal 2 from pricing procedure for condition  
71 KZWI3 KZWI3 WERTV7 CURR 13   2   Subtotal 3 from pricing procedure for condition  
72 KZWI4 KZWI4 WERTV7 CURR 13   2   Subtotal 4 from pricing procedure for condition  
73 KZWI5 KZWI5 WERTV7 CURR 13   2   Subtotal 5 from pricing procedure for condition  
74 KZWI6 KZWI6 WERTV7 CURR 13   2   Subtotal 6 from pricing procedure for condition  
75 STCUR STCUR_AP KURRF DEC 9   5   Exchange rate for statistics (Exch.rate at time of creation)  
76 UVPRS UVPRS XFELD CHAR 1   0   Incomplete with respect to pricing  
77 UVALL UVALL XFELD CHAR 1   0   Generally incomplete  
78 PRCTR PRCTR PRCTR CHAR 10   0   Profit Center *
79 KOKRS KOKRS CACCD CHAR 4   0   Controlling Area *
80 PAOBJNR RKEOBJNR RKEOBJNR NUMC 10   0   Profitability Segment Number (CO-PA)  
81 PS_PSP_PNR PS_PSP_PNR PS_POSNR NUMC 8   0   Work Breakdown Structure Element (WBS Element) *
82 TXJCD TXJCD TXJCD CHAR 15   0   Tax Jurisdiction *
83 XBEZPOS XBEZPOS JXBEZPOS CHAR 1   0   IS-M/SD: Item Type in Service Settlement for Home Delivery  
84 KNDGRUPPE KNDGRUPPE KDGRP CHAR 2   0   IS-M: Customer Group *
85 NACHLFNGNR NACHLFNGNR NUM2 NUMC 2   0   Sequence number of subsequent delivery  
86 LFNGNR LFNGNR LFNGNR NUMC 12   0   IS-M: Sequence Number for Delivery *
87 GP_ERS_ART GP_ERS_ART GP_ERS_ART CHAR 2   0   IS-M: Business Partner Substitution Type *
88 VERSANDDAT VRSNDDATUM DATUM DATS 8   0   IS-M: Shipping Date  
89 TRAGEZ TRAGEZEITK TRAGEZEITK CHAR 2   0   Distribution time category (for home delivery settlement) *
90 BEZTYP BEZUGSTYP_JE_PVA BEZUGSTYP_JE_PVA CHAR 2   0   Mix Type JDTBEZTYP
91 DRUTAT DRERZTAT DRERZ CHAR 8   0   Actual Publication Delivered *
92 DRUART DRUERZART DRUERZART CHAR 1   0   Publication Type *
93 PVATAT PVATAT PVA CHAR 8   0   Actual edition delivered *
94 NORMZG NORMMNGIZG STMENGE DEC 9   0   Actual Qty Standard Units in a Home Del. Company's Delivery  
95 NORMZU NORMMNGIZU STMENGE DEC 9   0   Actual Quantity of Standard Units in a Carrier's Delivery  
96 WRBMZG WRBMNGIZG STMENGE DEC 9   0   Actual Quantity of Prom. Copies in a Del. Company's Delivery  
97 WRBMZU WRBMNGIZU STMENGE DEC 9   0   Actual Quantity of Prom. Copies in a Carrier's Delivery  
98 NORMDZ JDMNGZU JSTMENGE DEC 9   3   IS-M: Average quantity per period in carrier route (EE)  
99 NORMDG JDMNGZG JSTMENGE DEC 9   3   IS-M: Average quantity per period in carrier route (SC)  
100 BEZTAT BEZIRKTAT BEZIRK CHAR 10   0   Actual Carrier Route *
101 BEZRTA BEZRUNDTAT BEZRUNDE CHAR 10   0   Actual Delivery Round *
102 LFATAT LFARTTAT LIEFERART CHAR 2   0   Actual delivery type (usually DT for dist.viability set) *
103 XSCHLGELD XSCHLGELD XFELD CHAR 1   0   IS-M: Key compensation  
104 XWEGGLDNT JXWGGLD_T XFELD CHAR 1   0   IS-M/SD: Path compensation daily  
105 XWEGGLDFG JXWGGLD_T XFELD CHAR 1   0   IS-M/SD: Path compensation daily  
106 XWEGGLDFN JXWGGLD_T XFELD CHAR 1   0   IS-M/SD: Path compensation daily  
107 XWGGELDPA JXWGGLD_M XFELD CHAR 1   0   IS-M/SD: Flat rate path compensation (monthly)  
108 XFARGLDNT JXFAGLD_T XFELD CHAR 1   0   IS-M/SD: Run compensation daily  
109 XFARGLDFG JXFAGLD_T XFELD CHAR 1   0   IS-M/SD: Run compensation daily  
110 XFARGLDFN JXFAGLD_T XFELD CHAR 1   0   IS-M/SD: Run compensation daily  
111 XFAHRGELD XFAHRGELD XFELD CHAR 1   0   IS-M/SD: Run compensation  
112 XBEILZUNT XBEILZU XFELD CHAR 1   0   Insert bonus  
113 XBEILZUFG XBEILZU XFELD CHAR 1   0   Insert bonus  
114 XBEILZUFN XBEILZU XFELD CHAR 1   0   Insert bonus  
115 XGEWIZUNT XGEWIZU XFELD CHAR 1   0   IS-M/SD: Weight surcharge  
116 XGEWIZUFG XGEWIZU XFELD CHAR 1   0   IS-M/SD: Weight surcharge  
117 XGEWIZUFN XGEWIZU XFELD CHAR 1   0   IS-M/SD: Weight surcharge  
118 KTFEIERFG KATFEIER KATFEIER CHAR 2   0   IS-M/SD: Public holiday bonus category *
119 KTFEIERFN KATFEIER KATFEIER CHAR 2   0   IS-M/SD: Public holiday bonus category *
120 KTNACHTNT KATNACHT KATNACHT CHAR 2   0   IS-M/SD: Night bonus category *
121 KTNACHTFG KATNACHT KATNACHT CHAR 2   0   IS-M/SD: Night bonus category *
122 KTNACHTFN KATNACHT KATNACHT CHAR 2   0   IS-M/SD: Night bonus category *
123 KTSONN_NT KATSONN KATSONN CHAR 2   0   IS-M/SD: Sunday bonus category *
124 KTSONN_FG KATSONN KATSONN CHAR 2   0   IS-M/SD: Sunday bonus category *
125 KTSONN_FN KATSONN KATSONN CHAR 2   0   IS-M/SD: Sunday bonus category *
126 KTSLGD SCHLGLDKAT SCHLGLDKAT CHAR 2   0   IS-M: Key compensation category *
127 KTWEGD WEGLANGKAT WEGLANGKAT CHAR 2   0   IS-M: Path length category *
128 KTFAGD FAHRKMKAT FAHRKMKAT CHAR 2   0   Distance Traveled: Category (for Home Delivery Settlement) *
129 KTTOPO TOPOLOGIEK TOPOLOGIEK CHAR 2   0   Topography category (for home delivery settlement) *
130 KTTRAG TRAGEZEITK TRAGEZEITK CHAR 2   0   Distribution time category (for home delivery settlement) *
131 BEZKT1 BEZKATE1 BEZKATE1 CHAR 2   0   Carrier Route Flat Rate Category *
132 BEZKT2 BEZKATE2 BEZKATE2 CHAR 2   0   IS-M: Carrier Route Category 2 *
133 BEZKT3 BEZKATE3 BEZKATE3 CHAR 2   0   IS-M: Carrier Route Category 3 *
134 BEZKT4 BEZKATE4 BEZKATE4 CHAR 2   0   IS-M: Carrier Route Category 4 *
135 BEZKT5 BEZKATE5 BEZKATE5 CHAR 2   0   IS-M: Carrier Route Category 5 *
136 GEWTVA VAGEWICHT ISPMNG9 QUAN 9   3   Calculated Issue Weight  
137 GEWBEI GEWICHTBEI ISPMNG9 QUAN 9   3   Weight of Inserts  
138 GESGEW TVAGEWICHT ISPMNG9 QUAN 9   3   Weight of carrying issue (including inserts)  
139 ANZBEI STCKBEILAG ANZBEILAGE NUMC 3   0   Number of inserts  
140 MEINHG MEINHVAGEW MEINS UNIT 3   0   Unit of weight for issue (calculated weight) *
141 XFEIERTAG FEIERTAGKZ CHAR1 CHAR 1   0   Public holiday flag  
142 WOTAG_N CIND CHAR1 CHAR 1   0   Fatory calendar flag  
143 WOTAG_A JWOTAG TEXT2 CHAR 2   0   IS-M: Abbreviation for weekday  
144 XVERGPVAST XVERGPVAST XFELD CHAR 1   0   IS-M/SD: Remuneration according to editions per day  
145 XVERGPVAPE XVERGPVAPE XFELD CHAR 1   0   IS-M/SD: Remuneration according to edition period average  
146 XVERGPVATD XVERGPVATD XFELD CHAR 1   0   IS-M/SD: Remuneration according to daily edition average  
147 XVERGPVADU XVERGPVADU XFELD CHAR 1   0   IS-M/SD: Remuneration according to edition average  
148 XVERGBEZPA XVERGBEZPA XFELD CHAR 1   0   IS-M/SD: Remuneration by carrier route flat rate  
149 DRERZ DRERZ DRERZ CHAR 8   0   Publication *
150 PVA PVA PVA CHAR 8   0   Edition *
151 BZPERF BEZPERFAKT BEZPER CHAR 5   0   IS-M: Service Type for Billing *
152 WRBART WERBEART WERBEART CHAR 4   0   Sales Source *
153 WRBAKT WERBEAKT WERBEAKT CHAR 8   0   Sales Promotion *
154 MINBEZ MINDBEZ NUMC02 NUMC 2   0   IS-M: Min.length of subscription (NUMC field for pricing)  
155 MINEIN MINDBEZEIN MEINS UNIT 3   0   Time Unit for Minimum Length of Subscription *
156 XWKZ XWKZ XFELD CHAR 1   0   Indicator: Promotion rebate  
157 POART POART_ISP POART_ISP CHAR 2   0   Internal Item Type for Sales Order *
158 XEINML XEINMALPRV XFELD CHAR 1   0   Indicator: One-time commission  
159 XRENDI XRENDITE XFELD CHAR 1   0   Renewal commission  
160 XPATE XPATE XFELD CHAR 1   0   IS-M: Sponsored subscription  
161 XFBLGABR XFBLGABR XFELD CHAR 1   0   IS-M: Follow-on settlement documents  
162 ZLSCH DZLSCH ZLSCH CHAR 1   0   Payment method *
163 VTWEG VTWEG VTWEG CHAR 2   0   Distribution Channel *
164 SPART SPART_AK SPART CHAR 2   0   Division for order header *
165 GPAG GPAG GPNR CHAR 10   0   Business Partner: Sold-to Party *
166 GPRG GPNR_RG GPNR CHAR 10   0   IS-M: Payer Business Partner *
167 BSTDK BSTDK DATUM DATS 8   0   Customer purchase order date  
168 VBELN AVNR AVNR CHAR 10   0   IS-M/SD: Publishing Sales Order *
169 POSNR APNR APNR NUMC 6   0   Sales Order Item *
170 POSEX POSEX_ISP POSEX_ISP NUMC 6   0   External Item Number (Purchase Order Item)  
171 ETENR ETENR ETENR NUMC 4   0   Schedule line *
172 GUELTIGVON JKAPVON DATUM DATS 8   0   Valid-From Date of Sales Order Item  
173 RECHBEGINN RECHBEGINN DATUM DATS 8   0   Billing From  
174 XIMMAT XIMMATRIK XFELD CHAR 1   0   Indicator: Proof of matriculation provided  
175 FXMSG MSGNR MSGNR CHAR 3   0   Message number *
176 JSNABR JSNABR JVBELN CHAR 10   0   IS-M: Number of Reversal in Subsequent Document *
177 FKDAT JFKDAT DATUM DATS 8   0   IS-M: Billing/Settlement Date  
178 FAKVON FAKVON DATUM DATS 8   0   IS-M: Billing Period From  
179 FAKBIS FAKBIS DATUM DATS 8   0   IS-M: Billing Period To  
180 OBJART_V OBJART_V JOBJART CHAR 4   0   IS-M: Previous object type  
181 UEBERLART UEBERLART UEBERLART CHAR 1   0   IS-M: Transfer type  
182 KONDA KONDA KONDA CHAR 2   0   Price Group (Customer) *
183 ABRPOS JLALIND JLALIND CHAR 6   0   IS-M: Internal settlement/delivery index  
184 MONBEW MONBEW MONBEW CHAR 1   0   IS-M/SD: Type of valuation ( - / quantity / qty*price )  
185 SHKZG SHKZG SHKZG CHAR 1   0   Debit/Credit Indicator  
186 ANZMONABRE ANZMONABRE ISPMNG2 QUAN 2   0   IS-M: No.Months for Sett./Retroactive Acctg - One-Time Comm.  
187 XPROVRUECK XPROVRUECK XFELD CHAR 1   0   Indicator: Commission recalculation for order item  
188 PERNR JPERNR2 JPERNR CHAR 20   0   IS-M: Personnel Number  
189 JPROVKDAT JPROVKDAT JPROVKDAT DATS 8   0   IS-M: Due date of deposit retained  
190 ANZET ISPANZET ANZET DEC 5   0   IS-M: Number of Publication Dates  
191 XJSIF XJSIF CHAR1 CHAR 1   0   IS-M: Interface record contains errors  
192 XINDART XINDART XFELD CHAR 1   0   IS-M: Index type  
193 PROVRART PROVRART PROVRART CHAR 1   0   Commission clawback type  
194 .INCLUDE       0   0   IS-PSD: Customer Modification for Comm.Table KOMLKGN  
195 DUMMY DUMMY DUMMY CHAR 1   0   Dummy function in length 1  
196 WERBKZSCHL JWBZWKZSCH JWBZWKZSCH CHAR 1   0   IS-M: WBZ, Promotion Rebate Key *
197 XNEGOP XNEGOPTION XFELD CHAR 1   0   IS-M: Item with Automatic Transformation to Chargeable  
198 FKPER FKPER FKPER CHAR 2   0   Billing Frequency *
199 ZUSTTYP JZUSTTYP JZUSTTYP CHAR 1   0   IS-M: Carrier Type *
200 KTGRD_MA JKTGRD_MA JKTGRD_MA CHAR 2   0   IS-M: Expense Account Assignment Group for SC Employees TJL21
201 KTGRDVSG JKTGRD_VSG JKTGRD_VSG CHAR 2   0   IS-M: Expense Account Assignment Group for SC TJL19
202 WRBMDZ JWRBMDZ JSTMENGE DEC 9   3   IS-M: Average promotion qty per period in carr.route (EE)  
203 WRBMDG JWRBMDG JSTMENGE DEC 9   3   IS-M: Average promotion qty per period in carr.route (SC)  
204 VKORG VKORG VKORG CHAR 4   0   Sales Organization TVKO
205 FAHRKM FAHRKM ISPMNG9 QUAN 9   3   Distance (for Home Delivery Settlement)  
206 EFAHRK EINHFAHRKM MEINS UNIT 3   0   Unit (km/m) T006
207 BBEWRT JZBEWERT NUMC5 NUMC 5   0   IS-M: Valuation of carrier route for home del.settlement  
208 VERKMITART VERKMIT_HR VERKMIT_HR CHAR 2   0   IS-M: Vehicle type TJL55
209 TAET_KLASS TAET_KLASS TAET_KLASS CHAR 2   0   IS-M: Activity classification TJV49
210 VORGAENGER VORGAENGER LAUFNUMMER NUMC 12   0   IS-M: Number of predecessor  
211 NACHFOLGER NACHFOLGER LAUFNUMMER NUMC 12   0   Number of successor  
212 DRERZTRAEG DRERZTRAEG DRERZ CHAR 8   0   Carrying Publication JDTDRER
213 PVATRAEG PVATRAEG PVA CHAR 8   0   Carrying Edition JDTPVA
214 VERTYP VERTYP VERTYP CHAR 2   0   IS-M: Sales Agent Type *
215 VAUSGB VAUSGB VAUSGB CHAR 10   0   Issue JDTVAUSGB
216 PROMNR JPROMNR JPROMNR NUMC 3   0   Sales order introduction *
217 PROVPERCNT PROVPERCNT PROZENT100 NUMC 3   0   IS-M/SD: Percentage rate of commission  
218 EVENT JK_EVENT JK_EVENT CHAR 4   0   IS-M/SD: Event in order processing *
219 XAQUISITION XAQUISITION XFELD CHAR 1   0   IS-M/SD: Indicator - first introduction record  
220 VKONT VKONT_KK VKONT_KK CHAR 12   0   Contract Account Number *
221 MATNR MATNR MATNR CHAR 18   0   Material Number *
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 KOMLKGN BEZTYP JDTBEZTYP BEZTYP    
2 KOMLKGN DRERZTRAEG JDTDRER DRERZ 1 CN
3 KOMLKGN EFAHRK T006 MSEHI    
4 KOMLKGN KTGRDVSG TJL19 JKTGRD_VSG    
5 KOMLKGN KTGRD_MA TJL21 JKTGRD_MA    
6 KOMLKGN PVATRAEG JDTPVA PVA 1 CN
7 KOMLKGN TAET_KLASS TJV49 TAET_KLASS    
8 KOMLKGN VAUSGB JDTVAUSGB VAUSGB 1 CN
9 KOMLKGN VERKMITART TJL55 VERKMITART 1 CN
10 KOMLKGN VKORG TVKO VKORG    
History
Last changed by/on SAP  20130529 
SAP Release Created in