SAP ABAP Table U_16199 (Generated Table for View)
Basic Data
Table Category VIEW    General view structure 
General view structure U_16199   Table Relationship Diagram
Short Description Generated Table for View    
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 T000
2 VBELN VBELN_VA VBELN CHAR 10   0   Sales Document VBUK
3 KUNNR KUNAG KUNNR CHAR 10   0   Sold-to party KNA1
4 ERDAT ERDAT DATUM DATS 8   0   Date on which the record was created  
5 ERZET ERZET UZEIT TIMS 6   0   Entry time  
6 ERNAM ERNAM USNAM CHAR 12   0   Name of Person who Created the Object  
7 ANGDT ANGDT_V DATUM DATS 8   0   Quotation/Inquiry is valid from  
8 BNDDT BNDDT DATUM DATS 8   0   Date until which bid/quotation is binding (valid-to date)  
9 AUDAT AUDAT DATUM DATS 8   0   Document Date (Date Received/Sent)  
10 VBTYP VBTYP VBTYP CHAR 1   0   SD document category  
11 TRVOG TRVOG TRVOG CHAR 1   0   Transaction group  
12 AUART AUART AUART CHAR 4   0   Sales Document Type TVAK
13 AUGRU AUGRU AUGRU CHAR 3   0   Order reason (reason for the business transaction) TVAU
14 GWLDT GWLDT DATUM DATS 8   0   Guarantee date  
15 SUBMI SUBMI_SD CHAR10 CHAR 10   0   Collective number (SD)  
16 NETWR NETWR_AK WERTV8 CURR 15   2   Net Value of the Sales Order in Document Currency  
17 WAERK WAERK WAERS CUKY 5   0   SD document currency TCURC
18 VKORG VKORG VKORG CHAR 4   0   Sales Organization TVKO
19 VTWEG VTWEG VTWEG CHAR 2   0   Distribution Channel TVKOV
20 SPART SPART SPART CHAR 2   0   Division TVTA
21 VKGRP VKGRP VKGRP CHAR 3   0   Sales group TVBVK
22 VKBUR VKBUR VKBUR CHAR 4   0   Sales office TVKBZ
23 GSBER GSBER GSBER CHAR 4   0   Business Area TGSB
24 GSKST GSKST GSBER CHAR 4   0   Business area from cost center TGSB
25 KNUMV KNUMV KNUMV CHAR 10   0   Number of the document condition  
26 VDATU EDATU_VBAK DATUM DATS 8   0   Requested delivery date  
27 VPRGR PRGRS_VBAK PRGRS CHAR 1   0   Proposed Period for Date  
28 AUTLF AUTLF XFELD CHAR 1   0   Complete delivery defined for each sales order?  
29 VBKLA VBKLA CHAR9 CHAR 9   0   unused (sales doocument class)  
30 VBKLT VBKLT VBKLT CHAR 1   0   SD document indicator  
31 KALSM KALSMASD KALSM CHAR 6   0   Sales and Distribution: Pricing Procedure in Pricing T683
32 VSBED VSBED VSBED CHAR 2   0   Shipping conditions TVSB
33 FKARA FKARA FKART CHAR 4   0   Proposed billing type for an order-related billing document TVFK
34 AWAHR AWAHR_AK AWAHR NUMC 3   0   Sales Probability  
35 KTEXT KTEXT_V TEXT40 CHAR 40   0   Search term for product proposal  
36 BSTNK BSTNK BSTNK CHAR 20   0   Customer purchase order number  
37 BSARK BSARK BSARK CHAR 4   0   Customer Order Type T176
38 BSTDK BSTDK DATUM DATS 8   0   Customer purchase order date  
39 BSTZD BSTZD BSTZD CHAR 4   0   Customer purchase order number supplement  
40 IHREZ IHREZ TEXT12 CHAR 12   0   Your Reference  
41 BNAME BNAME_V NAME CHAR 35   0   Name of orderer  
42 TELF1 TELF1_VP TELF1 CHAR 16   0   Telephone Number  
43 STAFO STAFO STAFO CHAR 6   0   Update group for statistics update  
44 STWAE STWAE WAERS CUKY 5   0   Statistics currency TCURC
45 AEDAT AEDAT DATUM DATS 8   0   Last Changed On  
46 KVGR1 KVGR1 KVGR1 CHAR 3   0   Customer group 1 TVV1
47 KVGR2 KVGR2 KVGR2 CHAR 3   0   Customer group 2 TVV2
48 KVGR3 KVGR3 KVGR3 CHAR 3   0   Customer group 3 TVV3
49 KVGR4 KVGR4 KVGR4 CHAR 3   0   Customer group 4 TVV4
50 KVGR5 KVGR5 KVGR5 CHAR 3   0   Customer group 5 TVV5
51 KKBER KKBER KKBER CHAR 4   0   Credit control area T014
52 KNKLI KNKLI KUNNR CHAR 10   0   Customer's account number with credit limit reference KNA1
53 KURST KURST KURST CHAR 4   0   Exchange Rate Type TCURV
54 GRUPP GRUPP_CM GRUPP_CM CHAR 4   0   Customer credit group  
55 SBGRP SBGRP_CM SBGRP_CM CHAR 3   0   Credit Representative Group for Credit Management T024B
56 CTLPC CTLPC_CM CTLPC_CM CHAR 3   0   Credit management: Risk category T691A
57 CMWAE WAERS_CM WAERS CUKY 5   0   Currency key of credit control area TCURC
58 CMFRE CMFRE DATUM DATS 8   0   Release date of the document determined by credit management  
59 CMNUP CMNUP DATUM DATS 8   0   Date of next credit check of document  
60 CMNGV CMNGV DATUM DATS 8   0   Next date  
61 AMTBL AMTBL_CM WERTV8 CURR 15   2   Released credit value of the document  
62 HITYP_PR HITYP_PR HITYP CHAR 1   0   Hierarchy type for pricing THIT
63 OBJNR OBJKO J_OBJNR CHAR 22   0   Object number at header level ONR00
64 BUKRS_VF BUKRS_VF BUKRS CHAR 4   0   Company code to be billed T001
65 TAXK1 TAXK1_AK TAXKD CHAR 1   0   Alternative tax classification  
66 TAXK2 TAXK2 TAXKD CHAR 1   0   Tax classification 2 for customer  
67 TAXK3 TAXK3 TAXKD CHAR 1   0   Tax classification 3 for customer  
68 TAXK4 TAXK4 TAXKD CHAR 1   0   Tax classification 4 for customer  
69 TAXK5 TAXK5 TAXKD CHAR 1   0   Tax classification 5 for customer  
70 TAXK6 TAXK6 TAXKD CHAR 1   0   Tax classification 6 for customer  
71 TAXK7 TAXK7 TAXKD CHAR 1   0   Tax classification 7 for customer  
72 TAXK8 TAXK8 TAXKD CHAR 1   0   Tax classification 8 for customer  
73 TAXK9 TAXK9 TAXKD CHAR 1   0   Tax classification 9 for customer  
74 XBLNR XBLNR_V1 XBLNR1 CHAR 16   0   Reference Document Number  
75 ZUONR ORDNR_V ZUONR CHAR 18   0   Assignment Number  
76 VGTYP VBTYP_V VBTYP CHAR 1   0   Document category of preceding SD document  
77 VGBEL VGBEL VBELN CHAR 10   0   Document number of the reference document VBUK
78 KALSM_CH KALSMA_CH KALSM CHAR 6   0   Search procedure for batch determination T683
79 AGRZR AGRZR NUM2 NUMC 2   0   Accrual period for order-related billing docs.to be accrued  
80 KONDA KONDA KONDA CHAR 2   0   Price Group (Customer) T188
81 KDGRP KDGRP KDGRP CHAR 2   0   Customer group T151
82 BZIRK BZIRK BZIRK CHAR 6   0   Sales district T171
83 PLTYP PLTYP PLTYP CHAR 2   0   Price list type T189
84 INCO1 INCO1 INCO1 CHAR 3   0   Incoterms (part 1) TINC
85 INCO2 INCO2 INCO2 CHAR 28   0   Incoterms (part 2)  
86 KZAZU KZAZU_D XFELD CHAR 1   0   Order combination indicator  
87 VALTG VALTG TAGE2 NUMC 2   0   Additional value days  
88 VALDT VALDT DATUM DATS 8   0   Fixed value date  
89 ZTERM DZTERM ZTERM CHAR 4   0   Terms of payment key  
90 ZLSCH SCHZW_BSEG ZLSCH CHAR 1   0   Payment Method T042Z
91 KTGRD KTGRD KTGRD CHAR 2   0   Account assignment group for this customer TVKT
92 KURSK KURSK KURRF DEC 9   5   Exchange Rate for Pricing and Statistics  
93 PRSDT PRSDT DATUM DATS 8   0   Date for pricing and exchange rate  
94 FBUDA FBUDA DATUM DATS 8   0   Date When Services Rendered  
95 GJAHR GJAHR GJAHR NUMC 4   0   Fiscal Year  
96 POPER POPER POPER NUMC 3   0   Posting period  
97 STCUR STCUR KURRF DEC 9   5   Exchange rate for statistics  
98 VLAUFZ VLAUF_VEDA NUM3 NUMC 3   0   Contract Term  
99 VLAUEZ VLAUE_VEDA KDZEH CHAR 1   0   Unit of validity period of contract  
100 VLAUFK VLAUK_VEDA VLAUK_VEDA CHAR 2   0   Validity period category of contract TVLZ
101 VINSDAT VIDAT_VEDA DATUM DATS 8   0   Installation date  
102 VABNDAT VADAT_VEDA DATUM DATS 8   0   Agreement acceptance date  
103 VBEGDAT VBDAT_VEDA DATUM DATS 8   0   Contract start date  
104 VUNTDAT VUDAT_VEDA DATUM DATS 8   0   Date on which contract is signed  
105 VKUESCH VKUES_VEDA VKUES_VEDA CHAR 4   0   Assignment cancellation procedure/cancellation rule TVKS
106 VAKTSCH VASCH_VEDA AKTVT CHAR 4   0   Activity at end of contract TVAS
107 VBEGREG VBREG_VEDA VDREG_VEDA CHAR 2   0   Rule for calculating contract start date TVRG
108 VDEMDAT VDDAT_VEDA DATUM DATS 8   0   Dismantling date  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 U_16199 AUART TVAK AUART REF 1 CN
2 U_16199 AUGRU TVAU AUGRU REF C CN
3 U_16199 BSARK T176 BSARK REF C CN
4 U_16199 BUKRS_VF T001 BUKRS REF C CN
5 U_16199 BZIRK T171 BZIRK REF C CN
6 U_16199 CMWAE TCURC WAERS REF C CN
7 U_16199 CTLPC T691A CTLPC REF C CN
8 U_16199 FKARA TVFK FKART REF C CN
9 U_16199 GSBER TGSB GSBER REF C CN
10 U_16199 GSKST TGSB GSBER REF C CN
11 U_16199 HITYP_PR THIT HITYP REF C CN
12 U_16199 INCO1 TINC INCO1 REF C CN
13 U_16199 KALSM T683 KALSM REF C CN
14 U_16199 KALSM_CH T683 KALSM REF C CN
15 U_16199 KDGRP T151 KDGRP REF C CN
16 U_16199 KKBER T014 KKBER REF C CN
17 U_16199 KNKLI KNA1 KUNNR REF C CN
18 U_16199 KONDA T188 KONDA REF C CN
19 U_16199 KTGRD TVKT KTGRD REF C CN
20 U_16199 KUNNR KNA1 KUNNR REF C CN
21 U_16199 KURST TCURV KURST REF C CN
22 U_16199 KVGR1 TVV1 KVGR1 REF C CN
23 U_16199 KVGR2 TVV2 KVGR2 REF C CN
24 U_16199 KVGR3 TVV3 KVGR3 REF C CN
25 U_16199 KVGR4 TVV4 KVGR4 REF C CN
26 U_16199 KVGR5 TVV5 KVGR5 REF C CN
27 U_16199 MANDT T000 MANDT KEY 1 CN
28 U_16199 OBJNR ONR00 OBJNR REF C CN
29 U_16199 PLTYP T189 PLTYP REF C CN
30 U_16199 SBGRP T024B SBGRP REF C CN
31 U_16199 SPART TVTA SPART REF 1 CN
32 U_16199 STWAE TCURC WAERS REF C CN
33 U_16199 VAKTSCH TVAS AKTVT REF C CN
34 U_16199 VBEGREG TVRG REGEL REF C CN
35 U_16199 VBELN VBUK VBELN KEY 1 C
36 U_16199 VGBEL VBUK VBELN REF C CN
37 U_16199 VKBUR TVKBZ VKBUR REF C CN
38 U_16199 VKGRP TVBVK VKGRP REF C CN
39 U_16199 VKORG TVKO VKORG REF 1 CN
40 U_16199 VKUESCH TVKS VKUESCH REF C CN
41 U_16199 VLAUFK TVLZ VLAUFK REF C CN
42 U_16199 VSBED TVSB VSBED REF C CN
43 U_16199 VTWEG TVKOV VTWEG REF 1 CN
44 U_16199 WAERK TCURC WAERS REF C CN
45 U_16199 ZLSCH T042Z ZLSCH REF C CN
History
Last changed by/on SAP  20131127 
SAP Release Created in