SAP ABAP Table A147 (Customer Hierarchy (Sales Deal))
Hierarchy
☛ BBPCRM (Software Component) BBPCRM
   ⤷ AP-PRC-PR (Application Component) Pricing
     ⤷ VF (Package) Application development R/3 invoice
Basic Data
Table Category TRANSP    Transparent table 
Transparent table A147   Table Relationship Diagram
Short Description Customer Hierarchy (Sales Deal)    
Delivery and Maintenance
Pool/cluster      
Delivery Class A   Application Table (Master- and Transaction Data) 
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 KAPPL KAPPL KAPPL CHAR 2   0   Application T681A
3 KSCHL KSCHA KSCHL CHAR 4   0   Condition Type T685
4 VKORG VKORG VKORG CHAR 4   0   Sales Organization TVKO
5 VTWEG VTWEG VTWEG CHAR 2   0   Distribution Channel TVTW
6 SPART SPART SPART CHAR 2   0   Division TSPA
7 VKBUR VKBUR VKBUR CHAR 4   0   Sales office TVBUR
8 VKGRP VKGRP VKGRP CHAR 3   0   Sales group TVKGR
9 KDGRP KDGRP KDGRP CHAR 2   0   Customer group T151
10 KUNRG KUNRG KUNNR CHAR 10   0   Payer KNA1
11 KUNAG KUNAG KUNNR CHAR 10   0   Sold-to party KNA1
12 KUNWE KUNWE KUNNR CHAR 10   0   Ship-to party KNA1
13 KNUMA_AG KNUMA_AG KNUMA CHAR 10   0   Sales deal KONA
14 DATBI KODATBI DATUM DATS 8   0   Validity end date of the condition record  
15 DATAB KODATAB DATUM DATS 8   0   Validity start date of the condition record  
16 KEXCL_D KEXCL XFELD CHAR 1   0   Indicator condition exclusive  
17 KNUMH KNUMH KNUMB CHAR 10   0   Condition record number  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 A147 KAPPL T681A KAPPL KEY    
2 A147 KDGRP T151 KDGRP KEY    
3 A147 KNUMA_AG KONA KNUMA KEY    
4 A147 KSCHL T685 KSCHL KEY    
5 A147 KUNAG KNA1 KUNNR KEY    
6 A147 KUNRG KNA1 KUNNR KEY    
7 A147 KUNWE KNA1 KUNNR KEY    
8 A147 MANDT T000 MANDT KEY    
9 A147 SPART TSPA SPART KEY    
10 A147 VKBUR TVBUR VKBUR KEY    
11 A147 VKGRP TVKGR VKGRP KEY    
12 A147 VKORG TVKO VKORG KEY    
13 A147 VTWEG TVTW VTWEG KEY    
History
Last changed by/on SAP  19980525 
SAP Release Created in