SAP ABAP Table DTFIGL_4 (Extract Structure: General Ledger Line Items to BW)
Hierarchy
☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ FI (Application Component) Financial Accounting
     ⤷ BWFI (Package) BW: Delta Process for Data Extraction in FI
Basic Data
Table Category INTTAB    Structure 
Structure DTFIGL_4   Table Relationship Diagram
Short Description Extract Structure: General Ledger Line Items to BW    
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 BUKRS BUKRS BUKRS CHAR 4   0   Company Code *
2 FISCPER RSFISCPER RSFISCPER NUMC 7   0   Fiscal year / period  
3 BELNR BELNR_BIW BELNR CHAR 10   0   Accounting Document Number  
4 BUZEI BUZEI BUZEI NUMC 3   0   Number of Line Item Within Accounting Document  
5 STATUSPS STATUSPS STATUSPS CHAR 1   0   Status of FI Item  
6 KTOPL KTOPL KTOPL CHAR 4   0   Chart of Accounts *
7 HKONT HKONT SAKNR CHAR 10   0   General Ledger Account *
8 KOART KOART KOART CHAR 1   0   Account type  
9 UMSKZ UMSKZ UMSKZ CHAR 1   0   Special G/L Indicator *
10 BLART BLART BLART CHAR 2   0   Document type *
11 BSCHL BSCHL BSCHL CHAR 2   0   Posting Key *
12 FISCVAR RSFISCVAR RSFISCVAR CHAR 2   0   Fiscal year variant  
13 BLDAT BLDAT DATUM DATS 8   0   Document Date in Document  
14 BUDAT BUDAT DATUM DATS 8   0   Posting Date in the Document  
15 CPUDT CPUDT DATUM DATS 8   0   Accounting document entry date  
16 VALUT VALUT DATUM DATS 8   0   Fixed Value Date  
17 AUGDT AUGDT DATUM DATS 8   0   Clearing Date  
18 AUGBL AUGBL BELNR CHAR 10   0   Document Number of the Clearing Document  
19 KOKRS KOKRS CACCD CHAR 4   0   Controlling Area *
20 KOSTL KOSTL KOSTL CHAR 10   0   Cost Center *
21 PRCTR PRCTR PRCTR CHAR 10   0   Profit Center *
22 AUFNR AUFNR AUFNR CHAR 12   0   Order Number *
23 PROJK PS_PSP_PNR PS_POSNR NUMC 8   0   Work Breakdown Structure Element (WBS Element) *
24 WERKS WERKS_D WERKS CHAR 4   0   Plant *
25 GSBER GSBER GSBER CHAR 4   0   Business Area *
26 FKBER FKBER FKBER CHAR 16   0   Functional Area *
27 PPRCT PPRCTR PRCTR CHAR 10   0   Partner Profit Center *
28 PARGB PARGB GSBER CHAR 4   0   Trading partner's business area *
29 VBUND RASSC RCOMP CHAR 6   0   Company ID of trading partner *
30 LCURR LCURR WAERS CUKY 5   0   Currency key of the local currency *
31 DMSOL DMSOL WERT7 CURR 13   2   Debit Amount in Local Currency  
32 DMHAB DMHAB WERT7 CURR 13   2   Credit Amount in Local Currency  
33 DMSHB DMSHB WRTV7 CURR 13   2   Amount in Local Currency with +/- Signs  
34 WAERS WAERS WAERS CUKY 5   0   Currency Key *
35 WRSOL WRSOL WERT7 CURR 13   2   Debit Amount in Document Currency  
36 WRHAB WRHAB WERT7 CURR 13   2   Credit Amount in Document Currency  
37 WRSHB WRSHB WRTV7 CURR 13   2   Foreign Currency Amount with Signs (+/-)  
38 CURT2 CURT2 CURTP CHAR 2   0   Currency Type of Second Local Currency  
39 HWAE2 HWAE2 WAERS CUKY 5   0   Currency Key of Second Local Currency *
40 DMSO2 DMSO2 WERT7 CURR 13   2   Debit Amount in Second Local Currency  
41 DMHA2 DMHA2 WERT7 CURR 13   2   Credit Amount in Second Local Currency  
42 DMSH2 DMSH2 WRTV7 CURR 13   2   Amount in Second Local Currency with +/- Sign  
43 CURT3 CURT3 CURTP CHAR 2   0   Currency Type of Third Local Currency  
44 HWAE3 HWAE3 WAERS CUKY 5   0   Currency Key of Third Local Currency *
45 DMSO3 DMSO3 WERT7 CURR 13   2   Debit Amount in Third Local Currency  
46 DMHA3 DMHA3 WERT7 CURR 13   2   Credit Amount in Third Local Currency  
47 DMSH3 DMSH3 WRTV7 CURR 13   2   Amount in Third Local Currency with +/- Sign  
48 XBLNR XBLNR XBLNR CHAR 16   0   Reference Document Number  
49 XREF3 XREF3 CHAR20 CHAR 20   0   Reference key for line item  
50 AWREF AWREF AWREF CHAR 10   0   Reference document number  
51 AWGJA BWFI_AWGJA GJAHR NUMC 4   0   Document Year for Reference Document Number  
52 AWBUK BWFI_AWBUK BUKRS CHAR 4   0   Company Code for Reference Document Number *
53 AWKOK BWFI_AWKOK CACCD CHAR 4   0   Controlling Area for Reference Document Number *
54 SGTXT SGTXT TEXT50 CHAR 50   0   Item Text  
55 XNEGP XNEGP XFELD CHAR 1   0   Indicator: Negative posting  
56 UPDMOD RODMUPDMOD RODMUPDMOD CHAR 1   0   BW Delta Process: Record Mode  
57 PS_POSID PS_POSID PS_POSID CHAR 24   0   Work Breakdown Structure Element (WBS Element)  
58 ZUONR DZUONR_AO ZUONR CHAR 18   0   Assignment number  
59 .INCLUDE       0   0   Extraction Structure: GL Work Fields  
60 AWTYP AWTYP AWTYP CHAR 5   0   Reference procedure *
61 AWKEY AWKEY AWKEY CHAR 20   0   Object key  
62 BSTAT BSTAT_D BSTAT CHAR 1   0   Document Status  
63 DMBTR DMBTR WERT7 CURR 13   2   Amount in local currency  
64 DMBE2 DMBE2 WERT7 CURR 13   2   Amount in Second Local Currency  
65 DMBE3 DMBE3 WERT7 CURR 13   2   Amount in Third Local Currency  
66 GJAHR GJAHR GJAHR NUMC 4   0   Fiscal Year  
67 MANDT MANDT MANDT CLNT 3   0   Client *
68 MONAT MONAT MONAT NUMC 2   0   Fiscal period  
69 SHKZG SHKZG SHKZG CHAR 1   0   Debit/Credit Indicator  
70 WRBTR WRBTR WERT7 CURR 13   2   Amount in document currency  
71 .INCLUDE       0   0    
72 BKTXT BKTXT TEXT25 CHAR 25   0   Document Header Text  
73 GLVOR GLVOR CHAR4 CHAR 4   0   Business Transaction  
74 PERNR PERNR_D PERNR NUMC 8   0   Personnel Number  
75 FISTL FISTL FISTL CHAR 16   0   Funds Center *
76 GEBER BP_GEBER BP_GEBER CHAR 10   0   Fund *
77 KTOSL KTOSL CHAR3 CHAR 3   0   Transaction Key  
78 BUDGET_PD FM_BUDGET_PERIOD FM_BUDGET_PERIOD CHAR 10   0   FM: Budget Period *
79 MWSKZ MWSKZ MWSKZ CHAR 2   0   Tax on sales/purchases code *
History
Last changed by/on SAP  20130529 
SAP Release Created in