SAP ABAP Table IDCN_S_DOCALV (Accounting Document at Segment Level)
Hierarchy
☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ FI-LOC (Application Component) Localization
     ⤷ ID-FI-CN (Package) Localization (China)
Basic Data
Table Category INTTAB    Structure 
Structure IDCN_S_DOCALV   Table Relationship Diagram
Short Description Accounting Document at Segment Level    
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 BUKRS BUKRS_ALV BUKRS CHAR 4   0   Company Code *
3 BELNR BELNR_D BELNR CHAR 10   0   Accounting Document Number  
4 GJAHR GJAHR GJAHR NUMC 4   0   Fiscal Year  
5 BUZEI BUZEI BUZEI NUMC 3   0   Number of Line Item Within Accounting Document  
6 DOCLN DOCLNALV DOCLN6 CHAR 6   0   DOCLN for ALV Grid Control  
7 AUGBL AUGBL BELNR CHAR 10   0   Document Number of the Clearing Document  
8 BSCHL BSCHL BSCHL CHAR 2   0   Posting Key TBSL
9 HKONT HKONT SAKNR CHAR 10   0   General Ledger Account *
10 KUNNR KUNNR KUNNR CHAR 10   0   Customer Number *
11 LIFNR LIFNR LIFNR CHAR 10   0   Account Number of Vendor or Creditor *
12 KOART KOART KOART CHAR 1   0   Account type  
13 UMSKZ UMSKZ UMSKZ CHAR 1   0   Special G/L Indicator T074U
14 SHKZG SHKZG SHKZG CHAR 1   0   Debit/Credit Indicator  
15 GSBER GSBER GSBER CHAR 4   0   Business Area TGSB
16 PARGB PARGB GSBER CHAR 4   0   Trading partner's business area TGSB
17 MWSKZ MWSKZ MWSKZ CHAR 2   0   Tax on sales/purchases code T007A
18 QSSKZ QSSKZ QSSKZ CHAR 2   0   Withholding Tax Code T059Q
19 TXJCD TXJCD TXJCD CHAR 15   0   Tax Jurisdiction *
20 DMBTR DMBTR WERT7 CURR 13   2   Amount in local currency  
21 VALUT VALUT DATUM DATS 8   0   Fixed Value Date  
22 ZUONR DZUONR ZUONR CHAR 18   0   Assignment number  
23 SGTXT SGTXT TEXT50 CHAR 50   0   Item Text  
24 VBUND RASSC RCOMP CHAR 6   0   Company ID of trading partner T880
25 KOKRS KOKRS CACCD CHAR 4   0   Controlling Area *
26 KOSTL KOSTL KOSTL CHAR 10   0   Cost Center *
27 AUFNR AUFNR AUFNR CHAR 12   0   Order Number AUFK
28 VBELN VBELN_VF VBELN CHAR 10   0   Billing document VBUK
29 VBEL2 VBELN_VA VBELN CHAR 10   0   Sales Document VBUK
30 POSN2 POSNR_VA POSNR NUMC 6   0   Sales Document Item VBUP
31 ETEN2 ETENR ETENR NUMC 4   0   Schedule line VBEP
32 XSKRL XSKRL XFELD CHAR 1   0   Indicator: Line item not liable to cash discount?  
33 XZAHL XZAHL XFELD CHAR 1   0   Indicator: Is Posting Key Used in a Payment Transaction?  
34 SAKNR SAKNR SAKNR CHAR 10   0   G/L Account Number SKB1
35 FILKD FILKD MAXKK CHAR 10   0   Account Number of the Branch  
36 ZTERM DZTERM ZTERM CHAR 4   0   Terms of payment key  
37 ZFBDT DZFBDT DATUM DATS 8   0   Baseline date for due date calculation  
38 ZBD1T DZBD1T ZBDXT DEC 3   0   Cash discount days 1  
39 ZBD2T DZBD2T ZBDXT DEC 3   0   Cash discount days 2  
40 ZBD3T DZBD3T ZBDXT DEC 3   0   Net Payment Terms Period  
41 ZBD1P DZBD1P PRZ23 DEC 5   3   Cash discount percentage 1  
42 ZBD2P DZBD2P PRZ23 DEC 5   3   Cash Discount Percentage 2  
43 ZLSCH SCHZW_BSEG ZLSCH CHAR 1   0   Payment Method T042Z
44 ZLSPR DZLSPR ZAHLS CHAR 1   0   Payment Block Key T008
45 ZBFIX DZBFIX ZBFIX CHAR 1   0   Fixed Payment Terms  
46 REBZG REBZG BELNR CHAR 10   0   Number of the Invoice the Transaction Belongs to  
47 REBZJ REBZJ GJAHR NUMC 4   0   Fiscal Year of the Relevant Invoice (for Credit Memo)  
48 REBZZ REBZZ BUZEI NUMC 3   0   Line Item in the Relevant Invoice  
49 SAMNR SAMNR SAMNR NUMC 8   0   Invoice List Number  
50 ANFBN ANFBN BELNR CHAR 10   0   Document Number of the Bill of Exchange Payment Request  
51 MSCHL MSCHL MSCHL CHAR 1   0   Dunning key T040
52 MANSP MANSP MANSP CHAR 1   0   Dunning block T040S
53 MANST MAHNS_D MAHNS NUMC 1   0   Dunning Level  
54 MABER MABER MABER CHAR 2   0   Dunning Area *
55 WERKS WERKS_D WERKS CHAR 4   0   Plant T001W
56 EBELN EBELN EBELN CHAR 10   0   Purchasing Document Number EKKO
57 EBELP EBELP EBELP NUMC 5   0   Item Number of Purchasing Document EKPO
58 SPGRP SPGRP XFELD CHAR 1   0   Blocking Reason: Price  
59 SPGRM SPGRM XFELD CHAR 1   0   Blocking Reason: Quantity  
60 SPGRT SPGRT XFELD CHAR 1   0   Blocking Reason: Date  
61 SPGRG SPGRG XFELD CHAR 1   0   Blocking Reason: Order Price Quantity  
62 SPGRV SPGRV XFELD CHAR 1   0   Blocking Reason: Project Budget  
63 SPGRQ SPGRQ XFELD CHAR 1   0   Manual Blocking Reason  
64 RSTGR RSTGR RSTGR CHAR 3   0   Reason Code for Payments T053R
65 PRCTR PRCTR PRCTR CHAR 10   0   Profit Center *
66 VNAME JV_NAME JV_NAME CHAR 6   0   Joint venture *
67 EGRUP JV_EGROUP JV_EGROUP CHAR 3   0   Equity group *
68 BTYPE JV_BILIND JV_BILIND CHAR 2   0   Payroll Type *
69 RECID JV_RECIND JV_RECIND CHAR 2   0   Recovery Indicator *
70 VPTNR JV_PART KUNNR CHAR 10   0   Partner account number *
71 VERTT RANTYP RANTYP CHAR 1   0   Contract Type  
72 VERTN RANL RANL CHAR 13   0   Contract Number  
73 IMKEY IMKEY IMKEY CHAR 8   0   Internal Key for Real Estate Object  
74 DABRZ DABRBEZ DDAT DATS 8   0   Reference date for settlement  
75 FIPOS FIPOS FIPOS CHAR 14   0   Commitment Item *
76 NPLNR NPLNR AUFNR CHAR 12   0   Network Number for Account Assignment *
77 AUFPL AUFPL_CH AUFPL NUMC 10   0   Task List Number for Operations in Order  
78 APLZL APLZL_CH CO_APLZL NUMC 8   0   General Counter for Order *
79 UZAWE UZAWE UZAWE CHAR 2   0   Payment method supplement T042F
80 FISTL FISTL FISTL CHAR 16   0   Funds Center *
81 GEBER BP_GEBER BP_GEBER CHAR 10   0   Fund *
82 STBUK STBUK BUKRS CHAR 4   0   Tax Company Code *
83 XREF1 XREF1 CHAR12 CHAR 12   0   Business partner reference key  
84 XREF2 XREF2 CHAR12 CHAR 12   0   Business partner reference key  
85 EMPFB EMPFB MAXKK CHAR 10   0   Payee/Payer  
86 XREF3 XREF3 CHAR20 CHAR 20   0   Reference key for line item  
87 PYCUR PYCUR WAERS CUKY 5   0   Currency for Automatic Payment TCURC
88 PYAMT PYAMT WERT7 CURR 13   2   Amount in Payment Currency  
89 BUPLA BUPLA J_1BBRANCH CHAR 4   0   Business Place J_1BBRANCH
90 SECCO SECCO SECCO CHAR 4   0   Section Code SECCODE
91 KKBER KKBER KKBER CHAR 4   0   Credit control area *
92 GRANT_NBR GM_GRANT_NBR GM_GRANT_NBR CHAR 20   0   Grant  
93 KBLNR KBLNR_FI KBLNR CHAR 10   0   Document number for earmarked funds *
94 KBLPOS KBLPOS KBLPOS NUMC 3   0   Earmarked Funds: Document Item *
95 PPRCT PPRCTR PRCTR CHAR 10   0   Partner Profit Center *
96 BEWAR RMVCT RMVCT CHAR 3   0   Transaction type *
97 FDLEV FDLEV FDLEV CHAR 2   0   Planning Level *
98 FDGRP FDGRP FDGRP CHAR 10   0   Planning Group *
99 ANBWA ANBWA BWASL CHAR 3   0   Asset Transaction Type *
100 BZDAT BZDAT DATUM DATS 8   0   Asset Value Date  
101 PERNR PERNR_D PERNR NUMC 8   0   Personnel Number  
102 XINVE XINVE XFELD CHAR 1   0   Indicator: Capital Goods Affected?  
103 HZUON HZUON ZUONR CHAR 18   0   Assignment Number for Special G/L Accounts  
104 SKFBT SKFBT WERT7 CURR 13   2   Amount Eligible for Cash Discount in Document Currency  
105 HBKID HBKID HBKID CHAR 5   0   Short key for a house bank *
106 BVTYP BVTYP BVTYP CHAR 4   0   Partner bank type  
107 LZBKZ LZBKZ LZBKZ CHAR 3   0   State central bank indicator *
108 LANDL LANDL LAND1 CHAR 3   0   Supplying Country *
109 ABPER ABPER_RF BUPER ACCP 6   0   Settlement period  
110 VRSKZ VRSKZ CHAR1 CHAR 1   0   Insurance Indicator  
111 VRSDT VRSDT DATUM DATS 8   0   Insurance Date  
112 ESRNR ESRNR ESRNR CHAR 11   0   POR subscriber number  
113 ESRRE ESRRE ESRRE CHAR 27   0   POR reference number  
114 ESRPZ ESRPZ CHAR2 CHAR 2   0   POR check digit  
115 QSZNR QSZNR CHAR10 CHAR 10   0   Certificate Number of the Withholding Tax Exemption  
116 QBSHB QBSHB WERT7 CURR 13   2   Withholding Tax Amount (in Document Currency)  
117 QSFBT QSFBT WERT7 CURR 13   2   Withholding Tax-Exempt Amount (in Document Currency)  
118 MATNR MATNR MATNR CHAR 18   0   Material Number *
119 MENGE MENGE_D MENG13 QUAN 13   3   Quantity  
120 MEINS MEINS MEINS UNIT 3   0   Base Unit of Measure *
121 STCEG STCEG STCEG CHAR 20   0   VAT Registration Number  
122 EGBLD EGBLD LAND1 CHAR 3   0   Country of Destination for Delivery of Goods *
123 EGLLD EGLLD LAND1 CHAR 3   0   Supplying Country for Delivery of Goods *
124 VBEWA SBEWART SBEWART CHAR 4   0   Flow Type *
125 XNEGP XNEGP XFELD CHAR 1   0   Indicator: Negative posting  
126 GRICD J_1AGICD_D J_1AGICD2 CHAR 2   0   Activity Code for Gross Income Tax *
127 GRIRG REGIO REGIO CHAR 3   0   Region (State, Province, County) *
128 GITYP J_1ADTYP_D J_1ADTYP CHAR 2   0   Distribution Type for Employment Tax *
129 KIDNO KIDNO CHAR30 CHAR 30   0   Payment Reference  
130 FKBER_LONG FKBER FKBER CHAR 16   0   Functional Area *
131 HWAER HWAER WAERS CUKY 5   0   Local Currency *
132 WAERS WAERS WAERS CUKY 5   0   Currency Key *
133 RF05A_UBAZW AZWAE WAERS CUKY 5   0   Currency Key *
134 KOBEZ KOBEZ TEXT30 CHAR 30   0   Account Description  
135 KTONR KTONR_AV KTONR CHAR 10   0   Account Number  
136 AZBET AZBET_F05A WERTV9 CURR 17   2   Display Amount  
137 AZSTE AZSTE_F05A WRTV8 CURR 15   2   Display Tax Amount  
138 HKBEZ HKBEZ TEXT20 CHAR 20   0   Name of the General Ledger Account  
139 VORNR VORNR VORNR CHAR 4   0   Operation/Activity Number  
140 XCORR XCORR BOOLEAN CHAR 1   0   Indicator: Correct Item?  
141 PSWBT PSWBT WERT7 CURR 13   2   Amount for Updating in General Ledger  
142 PSWSL PSWSL WAERS CUKY 5   0   Update Currency for General Ledger Transaction Figures *
143 LOKKT ALTKT_SKB1 SAKNR CHAR 10   0   Alternative Account Number in Company Code *
144 DISBN DISBN BELNR CHAR 10   0   Number of Bill of Exchange Usage Document (Discount Doc.)  
145 FASTPAY FMFG_FASTPAY_FLG XFELD CHAR 1   0   PPA Fast Pay Indicator  
146 PPA_EX_IND EXCLUDE_FLG XFELD CHAR 1   0   PPA Exclude Indicator  
147 PEROP_BEG FM_PEROP_FI_LOW DATUM DATS 8   0   Billing Period of Performance Start Date  
148 PEROP_END FM_PEROP_FI_HIGH DATUM DATS 8   0   Billing Period of Performance End Date  
149 MARKED_ALV MARKED_ALV MARKED_ALV CHAR 1   0   Marking of Position to Be Corrected  
150 PROJK_EXT PROJK_EXT CHAR24 CHAR 24   0   Individual Structural Element (WBS Element) in Ext. Format  
151 SEGMENT FB_SEGMENT FB_SEGMENT CHAR 10   0   Segment for Segmental Reporting *
152 PSEGMENT FB_PSEGMENT FB_SEGMENT CHAR 10   0   Partner Segment for Segmental Reporting *
153 PFKBER SFKBER FKBER CHAR 16   0   Partner Functional Area *
154 PGEBER FM_PFUND BP_GEBER CHAR 10   0   Partner Fund *
155 PGRANT_NBR GM_PGRANT_NBR GM_GRANT_NBR CHAR 20   0   Partner Grant  
156 MEASURE FM_MEASURE FM_MEASURE CHAR 24   0   Funded Program *
157 KTOSL KTOSL CHAR3 CHAR 3   0   Transaction Key  
158 XAUTO XAUTO XFELD CHAR 1   0   Indicator: Line item automatically created  
159 PKOSTL SKOST KOSTL CHAR 10   0   Sender cost center *
160 BUDGET_PD FM_BUDGET_PERIOD FM_BUDGET_PERIOD CHAR 10   0   FM: Budget Period *
161 PBUDGET_PD FM_PBUDGET_PERIOD FM_BUDGET_PERIOD CHAR 10   0   FM: Partner Budget Period *
162 DMBE2 DMBE2 WERT7 CURR 13   2   Amount in Second Local Currency  
163 HWAE2 HWAE2 WAERS CUKY 5   0   Currency Key of Second Local Currency *
164 DMBE3 DMBE3 WERT7 CURR 13   2   Amount in Third Local Currency  
165 HWAE3 HWAE3 WAERS CUKY 5   0   Currency Key of Third Local Currency *
166 TAXPS TAX_POSNR NUM6 NUMC 6   0   Tax document item number  
167 FLACC IDCN_FLACC CHAR4 CHAR 4   0   First Level Account  
168 DEBIT DMBTR WERT7 CURR 13   2   Amount in local currency  
169 CREDIT DMBTR WERT7 CURR 13   2   Amount in local currency  
170 PRCTR_KTEXT KTEXT TEXT20 CHAR 20   0   General Name  
171 KOSTL_KTEXT KTEXT TEXT20 CHAR 20   0   General Name  
172 KUNNR_NAME1 NAME1_GP NAME CHAR 35   0   Name 1  
173 LIFNR_NAME1 NAME1_GP NAME CHAR 35   0   Name 1  
174 RSTGR_TXT20 TXT20_053 TXT20 CHAR 20   0   Reason Code Short Text  
175 OLDGLACC IDCN_GL_ACCOUNT_OLD SAKNR CHAR 10   0   Old G/L Account Number *
176 OLDGLACC_TXT30 IDCN_GL_ACCOUNT_OLD_TXT30 TEXT30 CHAR 30   0   Old G/L Account Description  
177 LOKKT_TXT30 IDCN_ALTKT_TXT30 TEXT30 CHAR 30   0   Alternative Account Description  
178 AFLACC IDCN_FLACC CHAR4 CHAR 4   0   First Level Account  
179 FLACC_DESC IDCN_ALGACCGROUPDESC IDCN_ALGACCGROUPDESC CHAR 128   0   Account Level Description  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 IDCN_S_DOCALV AUFNR AUFK AUFNR REF C CN
2 IDCN_S_DOCALV BSCHL TBSL BSCHL REF 1 CN
3 IDCN_S_DOCALV BUPLA J_1BBRANCH BRANCH KEY 1 CN
4 IDCN_S_DOCALV EBELN EKKO EBELN REF C CN
5 IDCN_S_DOCALV EBELP EKPO EBELP REF C CN
6 IDCN_S_DOCALV ETEN2 VBEP ETENR REF C CN
7 IDCN_S_DOCALV GSBER TGSB GSBER REF C CN
8 IDCN_S_DOCALV MANDT T000 MANDT KEY 1 CN
9 IDCN_S_DOCALV MANSP T040S MANSP REF C CN
10 IDCN_S_DOCALV MSCHL T040 MSCHL REF C CN
11 IDCN_S_DOCALV MWSKZ T007A MWSKZ REF C CN
12 IDCN_S_DOCALV PARGB TGSB GSBER REF C CN
13 IDCN_S_DOCALV POSN2 VBUP POSNR REF C CN
14 IDCN_S_DOCALV PYCUR TCURC WAERS 1 CN
15 IDCN_S_DOCALV QSSKZ T059Q QSSKZ REF C CN
16 IDCN_S_DOCALV RSTGR T053R RSTGR REF C CN
17 IDCN_S_DOCALV SAKNR SKB1 SAKNR KEY 1 CN
18 IDCN_S_DOCALV SECCO SECCODE SECCODE KEY 1 CN
19 IDCN_S_DOCALV UMSKZ T074U UMSKZ REF C CN
20 IDCN_S_DOCALV UZAWE T042F UZAWE REF C CN
21 IDCN_S_DOCALV VBEL2 VBUK VBELN REF C CN
22 IDCN_S_DOCALV VBELN VBUK VBELN REF C CN
23 IDCN_S_DOCALV VBUND T880 RCOMP REF C CN
24 IDCN_S_DOCALV WERKS T001W WERKS REF C CN
25 IDCN_S_DOCALV ZLSCH T042Z ZLSCH REF C CN
26 IDCN_S_DOCALV ZLSPR T008 ZAHLS REF C CN
History
Last changed by/on SAP  20130529 
SAP Release Created in 605