SAP ABAP Table U_16175 (Generated Table for View)
Basic Data
Table Category VIEW    General view structure 
General view structure U_16175   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 AUDAT AUDAT DATUM DATS 8   0   Document Date (Date Received/Sent)  
8 VBTYP VBTYP VBTYP CHAR 1   0   SD document category  
9 TRVOG TRVOG TRVOG CHAR 1   0   Transaction group  
10 AUART AUART AUART CHAR 4   0   Sales Document Type TVAK
11 AUGRU AUGRU AUGRU CHAR 3   0   Order reason (reason for the business transaction) TVAU
12 GWLDT GWLDT DATUM DATS 8   0   Guarantee date  
13 LIFSK LIFSK LIFSP CHAR 2   0   Delivery block (document header) TVLS
14 FAKSK FAKSK FAKSP CHAR 2   0   Billing block in SD document TVFS
15 NETWR NETWR_AK WERTV8 CURR 15   2   Net Value of the Sales Order in Document Currency  
16 WAERK WAERK WAERS CUKY 5   0   SD document currency TCURC
17 VKORG VKORG VKORG CHAR 4   0   Sales Organization TVKO
18 VTWEG VTWEG VTWEG CHAR 2   0   Distribution Channel TVKOV
19 SPART SPART SPART CHAR 2   0   Division TVTA
20 VKGRP VKGRP VKGRP CHAR 3   0   Sales group TVBVK
21 VKBUR VKBUR VKBUR CHAR 4   0   Sales office TVKBZ
22 GSBER GSBER GSBER CHAR 4   0   Business Area TGSB
23 GSKST GSKST GSBER CHAR 4   0   Business area from cost center TGSB
24 KNUMV KNUMV KNUMV CHAR 10   0   Number of the document condition  
25 VDATU EDATU_VBAK DATUM DATS 8   0   Requested delivery date  
26 VPRGR PRGRS_VBAK PRGRS CHAR 1   0   Proposed Period for Date  
27 AUTLF AUTLF XFELD CHAR 1   0   Complete delivery defined for each sales order?  
28 VBKLA VBKLA CHAR9 CHAR 9   0   unused (sales doocument class)  
29 VBKLT VBKLT VBKLT CHAR 1   0   SD document indicator  
30 KALSM KALSMASD KALSM CHAR 6   0   Sales and Distribution: Pricing Procedure in Pricing T683
31 VSBED VSBED VSBED CHAR 2   0   Shipping conditions TVSB
32 FKARA FKARA FKART CHAR 4   0   Proposed billing type for an order-related billing document TVFK
33 BSTNK BSTNK BSTNK CHAR 20   0   Customer purchase order number  
34 BSARK BSARK BSARK CHAR 4   0   Customer Order Type T176
35 BSTDK BSTDK DATUM DATS 8   0   Customer purchase order date  
36 BSTZD BSTZD BSTZD CHAR 4   0   Customer purchase order number supplement  
37 IHREZ IHREZ TEXT12 CHAR 12   0   Your Reference  
38 BNAME BNAME_V NAME CHAR 35   0   Name of orderer  
39 TELF1 TELF1_VP TELF1 CHAR 16   0   Telephone Number  
40 MAHZA MAHZA PACK2 DEC 3   0   Number of reminder notices, reminders for delivery purchase  
41 MAHDT MAHDT DATUM DATS 8   0   Last Delivery Reminder Notice  
42 STAFO STAFO STAFO CHAR 6   0   Update group for statistics update  
43 STWAE STWAE WAERS CUKY 5   0   Statistics currency TCURC
44 AEDAT AEDAT DATUM DATS 8   0   Last Changed On  
45 KVGR1 KVGR1 KVGR1 CHAR 3   0   Customer group 1 TVV1
46 KVGR2 KVGR2 KVGR2 CHAR 3   0   Customer group 2 TVV2
47 KVGR3 KVGR3 KVGR3 CHAR 3   0   Customer group 3 TVV3
48 KVGR4 KVGR4 KVGR4 CHAR 3   0   Customer group 4 TVV4
49 KVGR5 KVGR5 KVGR5 CHAR 3   0   Customer group 5 TVV5
50 KKBER KKBER KKBER CHAR 4   0   Credit control area T014
51 KNKLI KNKLI KUNNR CHAR 10   0   Customer's account number with credit limit reference KNA1
52 KURST KURST KURST CHAR 4   0   Exchange Rate Type TCURV
53 GRUPP GRUPP_CM GRUPP_CM CHAR 4   0   Customer credit group  
54 SBGRP SBGRP_CM SBGRP_CM CHAR 3   0   Credit Representative Group for Credit Management T024B
55 CTLPC CTLPC_CM CTLPC_CM CHAR 3   0   Credit management: Risk category T691A
56 CMWAE WAERS_CM WAERS CUKY 5   0   Currency key of credit control area TCURC
57 CMFRE CMFRE DATUM DATS 8   0   Release date of the document determined by credit management  
58 CMNUP CMNUP DATUM DATS 8   0   Date of next credit check of document  
59 CMNGV CMNGV DATUM DATS 8   0   Next date  
60 AMTBL AMTBL_CM WERTV8 CURR 15   2   Released credit value of the document  
61 HITYP_PR HITYP_PR HITYP CHAR 1   0   Hierarchy type for pricing THIT
62 OBJNR OBJKO J_OBJNR CHAR 22   0   Object number at header level ONR00
63 BUKRS_VF BUKRS_VF BUKRS CHAR 4   0   Company code to be billed T001
64 TAXK1 TAXK1_AK TAXKD CHAR 1   0   Alternative tax classification  
65 TAXK2 TAXK2 TAXKD CHAR 1   0   Tax classification 2 for customer  
66 TAXK3 TAXK3 TAXKD CHAR 1   0   Tax classification 3 for customer  
67 TAXK4 TAXK4 TAXKD CHAR 1   0   Tax classification 4 for customer  
68 TAXK5 TAXK5 TAXKD CHAR 1   0   Tax classification 5 for customer  
69 TAXK6 TAXK6 TAXKD CHAR 1   0   Tax classification 6 for customer  
70 TAXK7 TAXK7 TAXKD CHAR 1   0   Tax classification 7 for customer  
71 TAXK8 TAXK8 TAXKD CHAR 1   0   Tax classification 8 for customer  
72 TAXK9 TAXK9 TAXKD CHAR 1   0   Tax classification 9 for customer  
73 XBLNR XBLNR_V1 XBLNR1 CHAR 16   0   Reference Document Number  
74 ZUONR ORDNR_V ZUONR CHAR 18   0   Assignment Number  
75 VGTYP VBTYP_V VBTYP CHAR 1   0   Document category of preceding SD document  
76 VGBEL VGBEL VBELN CHAR 10   0   Document number of the reference document VBUK
77 KALSM_CH KALSMA_CH KALSM CHAR 6   0   Search procedure for batch determination T683
78 AGRZR AGRZR NUM2 NUMC 2   0   Accrual period for order-related billing docs.to be accrued  
79 KONDA KONDA KONDA CHAR 2   0   Price Group (Customer) T188
80 KDGRP KDGRP KDGRP CHAR 2   0   Customer group T151
81 BZIRK BZIRK BZIRK CHAR 6   0   Sales district T171
82 PLTYP PLTYP PLTYP CHAR 2   0   Price list type T189
83 INCO1 INCO1 INCO1 CHAR 3   0   Incoterms (part 1) TINC
84 INCO2 INCO2 INCO2 CHAR 28   0   Incoterms (part 2)  
85 KZAZU KZAZU_D XFELD CHAR 1   0   Order combination indicator  
86 PERFK PERFK WFCID CHAR 2   0   Invoice dates (calendar identification) TFACD
87 PERRL PERRL WFCID CHAR 2   0   Invoice list schedule (calendar identification) TFACD
88 MRNKZ MRNKZ XFELD CHAR 1   0   Manual invoice maintenance  
89 KURRF KURRF KURRF DEC 9   5   Exchange rate for FI postings  
90 VALTG VALTG TAGE2 NUMC 2   0   Additional value days  
91 VALDT VALDT DATUM DATS 8   0   Fixed value date  
92 ZTERM DZTERM ZTERM CHAR 4   0   Terms of payment key  
93 ZLSCH SCHZW_BSEG ZLSCH CHAR 1   0   Payment Method T042Z
94 KTGRD KTGRD KTGRD CHAR 2   0   Account assignment group for this customer TVKT
95 KURSK KURSK KURRF DEC 9   5   Exchange Rate for Pricing and Statistics  
96 PRSDT PRSDT DATUM DATS 8   0   Date for pricing and exchange rate  
97 FKDAT FKDAT DATUM DATS 8   0   Billing date for billing index and printout  
98 FBUDA FBUDA DATUM DATS 8   0   Date When Services Rendered  
99 GJAHR GJAHR GJAHR NUMC 4   0   Fiscal Year  
100 POPER POPER POPER NUMC 3   0   Posting period  
101 STCUR STCUR KURRF DEC 9   5   Exchange rate for statistics  
102 MSCHL MSCHL MSCHL CHAR 1   0   Dunning key T040
103 MANSP MANSP MANSP CHAR 1   0   Dunning block T040S
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 U_16175 AUART TVAK AUART REF 1 CN
2 U_16175 AUGRU TVAU AUGRU REF C CN
3 U_16175 BSARK T176 BSARK REF C CN
4 U_16175 BUKRS_VF T001 BUKRS REF C CN
5 U_16175 BZIRK T171 BZIRK REF C CN
6 U_16175 CMWAE TCURC WAERS REF C CN
7 U_16175 CTLPC T691A CTLPC REF C CN
8 U_16175 FAKSK TVFS FAKSP REF C CN
9 U_16175 FKARA TVFK FKART REF C CN
10 U_16175 GSBER TGSB GSBER REF C CN
11 U_16175 GSKST TGSB GSBER REF C CN
12 U_16175 HITYP_PR THIT HITYP REF C CN
13 U_16175 INCO1 TINC INCO1 REF C CN
14 U_16175 KALSM T683 KALSM REF C CN
15 U_16175 KALSM_CH T683 KALSM REF C CN
16 U_16175 KDGRP T151 KDGRP REF C CN
17 U_16175 KKBER T014 KKBER REF C CN
18 U_16175 KNKLI KNA1 KUNNR REF C CN
19 U_16175 KONDA T188 KONDA REF C CN
20 U_16175 KTGRD TVKT KTGRD REF C CN
21 U_16175 KUNNR KNA1 KUNNR REF C CN
22 U_16175 KURST TCURV KURST REF C CN
23 U_16175 KVGR1 TVV1 KVGR1 REF C CN
24 U_16175 KVGR2 TVV2 KVGR2 REF C CN
25 U_16175 KVGR3 TVV3 KVGR3 REF C CN
26 U_16175 KVGR4 TVV4 KVGR4 REF C CN
27 U_16175 KVGR5 TVV5 KVGR5 REF C CN
28 U_16175 LIFSK TVLS LIFSP REF C CN
29 U_16175 MANDT T000 MANDT KEY 1 CN
30 U_16175 MANSP T040S MANSP REF C CN
31 U_16175 MSCHL T040 MSCHL REF C CN
32 U_16175 OBJNR ONR00 OBJNR REF C CN
33 U_16175 PERFK TFACD IDENT REF C CN
34 U_16175 PERRL TFACD IDENT REF C CN
35 U_16175 PLTYP T189 PLTYP REF C CN
36 U_16175 SBGRP T024B SBGRP REF C CN
37 U_16175 SPART TVTA SPART REF 1 CN
38 U_16175 STWAE TCURC WAERS REF C CN
39 U_16175 VBELN VBUK VBELN KEY 1 C
40 U_16175 VGBEL VBUK VBELN REF C CN
41 U_16175 VKBUR TVKBZ VKBUR REF C CN
42 U_16175 VKGRP TVBVK VKGRP REF C CN
43 U_16175 VKORG TVKO VKORG REF 1 CN
44 U_16175 VSBED TVSB VSBED REF C CN
45 U_16175 VTWEG TVKOV VTWEG REF 1 CN
46 U_16175 WAERK TCURC WAERS REF C CN
47 U_16175 ZLSCH T042Z ZLSCH REF C CN
History
Last changed by/on SAP  20131127 
SAP Release Created in