SAP ABAP Table DFKKREV06 (Report for Tax on Sales/Purchases (bill. time or triggered))
Hierarchy
☛
FI-CA (Software Component) FI-CA
⤷ FI-CA (Application Component) Contract Accounts Receivable and Payable
⤷ EEREV_REP (Package) Sales Tax Reporting
⤷ FI-CA (Application Component) Contract Accounts Receivable and Payable
⤷ EEREV_REP (Package) Sales Tax Reporting
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | DFKKREV06 | Table Relationship Diagram |
Short Description | Report for Tax on Sales/Purchases (bill. time or triggered) |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | A | Application Table (Master- and Transaction Data) |
Data Browser/Table View Maintenance | X | Display/Maintenance Allowed |
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 | OPBEL | OPBEL_KK | OPBEL_KK | CHAR | 12 | 0 | Number of Contract Accts Rec. & Payable Doc. | DFKKKO | |
3 | OPUPK | OPUPK_KK | OPUPK_KK | NUMC | 4 | 0 | Item number in contract account document | ||
4 | GPART | GPART_KK | BU_PARTNER | CHAR | 10 | 0 | Business Partner Number | BUT000 | |
5 | VINFO | VINFO_KK | CHAR20 | CHAR | 20 | 0 | Detailing Assignment In Tax Report | ||
6 | MZPKT | MZPKT_KK | MZPKT_KK | NUMC | 2 | 0 | Report Time For Sales/Purchase Tax | ||
7 | MUMFA | MUMFA_KK | MUMFA_KK | NUMC | 1 | 0 | Scope Of Data For Sales/Purchase Tax Explanation | ||
8 | TZAHL | TZAHL_KK | NUM3 | NUMC | 3 | 0 | Counter For Identifying Respective Partial Payment Item | ||
9 | APPLK | APPLK_KK | APPLK_KK | CHAR | 1 | 0 | Application area | ||
10 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | T001 | |
11 | HKONT | HKONT_KK | SAKNR | CHAR | 10 | 0 | General ledger account | SKA1 | |
12 | BETRH | BETRH_KK | WRTV7 | CURR | 13 | 2 | Amount In Local Currency With +/- Signs | ||
13 | BETRW | BETRW_KK | WRTV7 | CURR | 13 | 2 | Amount in Transaction Currency with +/- Sign | ||
14 | HWAER | HWAER_KK | WAERS | CUKY | 5 | 0 | Local Currency Key | * | |
15 | TWAER | TWAER | WAERS | CUKY | 5 | 0 | Transaction Currency | TCURC | |
16 | UBDAT | UBDAT_KK | DATUM | DATS | 8 | 0 | Posting Date Original Document | ||
17 | ULDAT | ULDAT_KK | DATUM | DATS | 8 | 0 | Original Document Date | ||
18 | FAEDN | FAEDN_KK | DATUM | DATS | 8 | 0 | Due date for net payment | ||
19 | VMDAT | VMDAT_KK | DATUM | DATS | 8 | 0 | Planned Report Date For Tax Item | ||
20 | SDATA | SDATA_KK | CHAR140 | CHAR | 140 | 0 | Additional Data For Tax Report | ||
21 | XBLNR | EXBEL_KK | EXBEL_KK | CHAR | 16 | 0 | Official Document Number | ||
22 | REGIO | REGIO | REGIO | CHAR | 3 | 0 | Region (State, Province, County) | T005S | |
23 | COUNC | COUNC | COUNC | CHAR | 3 | 0 | County Code | T005E | |
24 | GRICD | J_1AGICD_D | J_1AGICD2 | CHAR | 2 | 0 | Activity Code for Gross Income Tax | J_1AGICD | |
25 | GITYP | J_1ADTYP_D | J_1ADTYP | CHAR | 2 | 0 | Distribution Type for Employment Tax | J_1ADTYP | |
26 | REPCLS | REPCLS_KK | REPCLS_KK | CHAR | 2 | 0 | Report Classification | TFK_EXTDOC_AR2 | |
27 | AUBEL | AUBEL_KK | OPBEL_KK | CHAR | 12 | 0 | Document Number Of Document To Be Triggered | DFKKKO | |
28 | XNABE | XNABE_KK | XNABE_KK | CHAR | 1 | 0 | Special Entry in Tax Reporting Table | ||
29 | REFNR | OPBEL_KK | OPBEL_KK | CHAR | 12 | 0 | Number of Contract Accts Rec. & Payable Doc. | DFKKKO | |
30 | XSTOR | XSTOR_KK | XFELD | CHAR | 1 | 0 | Document Has Been Reversed | ||
31 | EXBEL_BETRH | EXBEL_BETRH | WRTV7 | CURR | 13 | 2 | Total amount for an official document in local currency | ||
32 | EXBEL_BETRW | EXBEL_BETRW | WRTV7 | CURR | 13 | 2 | Total amount of an official document in transaction currency | ||
33 | .INCLUDE | 0 | 0 | ||||||
34 | .INCLUDE | 0 | 0 | ||||||
35 | .INCLUDE | 0 | 0 | ||||||
36 | .INCLUDE | 0 | 0 |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | DFKKREV06 | AUBEL | DFKKKO | OPBEL | REF | C | CN |
2 | DFKKREV06 | BUKRS | T001 | BUKRS | REF | 1 | CN |
3 | DFKKREV06 | COUNC | T005E | COUNC | REF | 1 | CN |
4 | DFKKREV06 | GITYP | J_1ADTYP | J_1ADTYP | REF | C | CN |
5 | DFKKREV06 | GPART | BUT000 | PARTNER | |||
6 | DFKKREV06 | GRICD | J_1AGICD | J_1AGICD | REF | 1 | CN |
7 | DFKKREV06 | HKONT | SKA1 | SAKNR | REF | C | CN |
8 | DFKKREV06 | MANDT | T000 | MANDT | KEY | 1 | CN |
9 | DFKKREV06 | OPBEL | DFKKKO | OPBEL | |||
10 | DFKKREV06 | REFNR | DFKKKO | OPBEL | REF | C | CN |
11 | DFKKREV06 | REGIO | T005S | BLAND | |||
12 | DFKKREV06 | REPCLS | TFK_EXTDOC_AR2 | REPCLS | REF | C | CN |
13 | DFKKREV06 | TWAER | TCURC | WAERS | REF | C | CN |
History
Last changed by/on | SAP | 20110901 |
SAP Release Created in |