SAP ABAP Table DFKK1099_E (1099 Statutory Reporting Data - Extract Structure)
Hierarchy
FI-CA (Software Component) FI-CA
   FI-CA (Application Component) Contract Accounts Receivable and Payable
     FKKB (Package) Contract A/R & A/P: Central Objects
Basic Data
Table Category INTTAB    Structure 
Structure DFKK1099_E   Table Relationship Diagram
Short Description 1099 Statutory Reporting Data - Extract Structure    
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 OPBEL OPBEL_KK OPBEL_KK CHAR 12   0   Number of Contract Accts Rec. & Payable Doc. *
3 WAERS WAERS WAERS CUKY 5   0   Currency Key *
4 CURRDEC CURRDEC_N NUMC03 NUMC 3   0   Number of Decimal Places  
5 NAUGH_C NAUGH_C CHAR15 CHAR 15   0   Net Clearing Amount in Local Currency  
6 AQSBH_C AQSBH_C CHAR15 CHAR 15   0   Proportional Withholding Tax Amount In Local Currency  
7 QSSKZ QSSKZ QSSKZ CHAR 2   0   Withholding Tax Code *
8 HVORG HVORG_KK HVORG_KK CHAR 4   0   Main Transaction for Line Item *
9 TVORG TVORG_KK TVORG_KK CHAR 4   0   Subtransaction for Document Item *
10 TAX_TYPE BPTAXTYPE BPTAXTYPE CHAR 4   0   Tax Number Category  
11 TAX_NUMBER BPTAXNUM BPTAXNUM CHAR 20   0   Business Partner Tax Number  
12 .INCLUDE       0   0   CBP: General data (independent of partner cat.)  
13 .INCLUDE       0   0   CBP: General Data (not dep. on Part. Cat.), Initial Screen  
14 TYPE BU_TYPE BU_TYPE CHAR 1   0   Business partner category  
15 BPKIND BU_BPKIND BU_KIND CHAR 4   0   Business Partner Type TB004
16 BU_GROUP BU_GROUP BU_GROUP CHAR 4   0   Business Partner Grouping TB001
17 BPEXT BU_BPEXT CHAR20 CHAR 20   0   Business Partner Number in External System  
18 .INCLUDE       0   0   CBP: General Data (not dep. on Part. Cat.), Data Screens  
19 BU_SORT1 BU_SORT1 BU_SORT1 CHAR 20   0   Search term 1 for business partner  
20 BU_SORT2 BU_SORT2 BU_SORT1 CHAR 20   0   Search term 2 for business partner  
21 SOURCE BU_SOURCE BU_SOURCE CHAR 4   0   Data Origin Types TB005
22 TITLE AD_TITLE AD_TITLE CHAR 4   0   Form-of-Address Key TSAD3
23 XDELE BU_XDELE XFELD CHAR 1   0   Central Archiving Flag  
24 XBLCK BU_XBLCK XFELD CHAR 1   0   Central Block for Business Partner  
25 AUGRP BU_AUGRP BU_AUGRP CHAR 4   0   Authorization Group *
26 TITLE_LET BU_TITLE_LET TEXT50 CHAR 50   0   Salutation  
27 BU_LOGSYS LOGSYS LOGSYS CHAR 10   0   Logical system TBDLS
28 CONTACT BU_CONTACT BU_CONTACT CHAR 1   0   Business Partner: Contact Permission  
29 NOT_RELEASED BU_XNOT_RELEASED XFELD CHAR 1   0   Indicator: Not Released  
30 NOT_LG_COMPETENT BU_NOT_LEG_COMPETENT BOOLE CHAR 1   0   Indicator: Not Legally Competent  
31 PRINT_MODE BU_PRINT_MODE BU_PRINT_MODE CHAR 1   0   Business Partner Print Format  
32 .INCLUDE       0   0   EEW Extension of BUT000 (Contains CI)  
33 BP_EEW_DUMMY DUMMY DUMMY CHAR 1   0   Dummy function in length 1  
34 .INCLUDE       0   0    
35 .INCLU--AP       0   0   Cost/Revenue Type in Resource Role  
36 RATE DPR_TV_RATE DPR_RATE_TYPE CHAR 15   0   Cost Rate/Revenue Rate for Project Costing DPR_RATES
37 .INCLUDE       0   0   CBP: General Data, Organization (CHAR Fields)  
38 NAME_ORG1 BU_NAMEOR1 BU_NAME CHAR 40   0   Name 1 of organization  
39 NAME_ORG2 BU_NAMEOR2 BU_NAME CHAR 40   0   Name 2 of organization  
40 NAME_ORG3 BU_NAMEOR3 BU_NAME CHAR 40   0   Name 3 of organization  
41 NAME_ORG4 BU_NAMEOR4 BU_NAME CHAR 40   0   Name 4 of organization  
42 LEGAL_ENTY BU_LEGENTY BU_LEGENTY CHAR 2   0   BP: Legal form of organization TB019
43 IND_SECTOR BU_INDSECT BU_INDSECT CHAR 10   0   Industry sector TB023
44 LEGAL_ORG BU_LEGAL_ORG BU_LEGAL_ORG CHAR 2   0   Legal Entity of Organization TB032
45 .INCLUDE       0   0   CBP: General Data, Person (CHAR Fields)  
46 NAME_LAST BU_NAMEP_L BU_NAME CHAR 40   0   Last name of business partner (person)  
47 NAME_FIRST BU_NAMEP_F BU_NAME CHAR 40   0   First name of business partner (person)  
48 NAME_LST2 BU_NAMEPL2 BU_NAME CHAR 40   0   Other Last Name of a Person  
49 NAME_LAST2 BU_BIRTHNM BU_NAME CHAR 40   0   Name at birth of business partner  
50 NAMEMIDDLE BU_NAMEMID BU_NAME CHAR 40   0   Middle name or second forename of a person  
51 TITLE_ACA1 AD_TITLE1 AD_TITLE1 CHAR 4   0   Academic Title: Key TSAD2
52 TITLE_ACA2 AD_TITLE2 AD_TITLE1 CHAR 4   0   Second academic title (key) TSAD2
53 TITLE_ROYL AD_TITLES AD_TITLES CHAR 4   0   Name supplement, e.g. noble title (key) TSAD5
54 PREFIX1 AD_PREFIX AD_PREFIX CHAR 4   0   Name Prefix (Key) TSAD4
55 PREFIX2 AD_PREFIX2 AD_PREFIX CHAR 4   0   2nd name prefix (key) TSAD4
56 NAME1_TEXT BU_NAME1TX TEXT80 CHAR 80   0   Full Name  
57 NICKNAME BU_NICKNAM BU_NAME CHAR 40   0   Nickname of Business Partner (Person)  
58 INITIALS AD_INITS CHAR10 CHAR 10   0   "Middle Initial" or personal initials  
59 NAMEFORMAT AD_FORMAT AD_NAMFORM CHAR 2   0   Name format T005N
60 NAMCOUNTRY AD_NAMCTRY LAND1 CHAR 3   0   Country for name format rule T005
61 LANGU_CORR BU_LANGU_CORR SPRAS LANG 1   0   Business Partner: Correspondence Language T002
62 XSEXM BU_XSEXM XFELD CHAR 1   0   Selection: Business partner is male  
63 XSEXF BU_XSEXF XFELD CHAR 1   0   Selection: Business partner is female  
64 BIRTHPL BU_BIRTHPL TEXT40 CHAR 40   0   Birthplace of business partner  
65 MARST BU_MARST BU_MARST CHAR 1   0   Marital Status of Business Partner TB027
66 EMPLO BU_EMPLO BU_EMPLO CHAR 35   0   Name of Employer of a Natural Person  
67 JOBGR BU_JOBGR BU_JOBGR CHAR 4   0   Occupation/group TB028
68 NATIO BU_NATIO LAND1 CHAR 3   0   Nationality T005
69 CNTAX BU_CNTAX LAND1 CHAR 3   0   Obsolete Field *
70 CNDSC BU_CNDSC LAND1 CHAR 3   0   Ctry of Origin: Non-Res. Companies T005
71 PERSNUMBER AD_PERSNUM AD_PERSNUM CHAR 10   0   Person number *
72 XSEXU BU_XSEXU XFELD CHAR 1   0   Selection: Sex of business partner is not known  
73 XUBNAME BU_XUBNAME XUBNAME CHAR 12   0   Obsolete Field USR02
74 BU_LANGU BU_LANGU SPRAS LANG 1   0   Business partner: Language T002
75 .INCLUDE       0   0   CBP: General data (group of people)  
76 PARTGRPTYP BU_GRPTYP BU_GRPTYP CHAR 4   0   Group type TB025
77 NAME_GRP1 BU_NAMEGR1 BU_NAME CHAR 40   0   Name 1 (group)  
78 NAME_GRP2 BU_NAMEGR2 BU_NAME CHAR 40   0   Name 2 (group)  
79 .INCLUDE       0   0   BP: General data II  
80 .INCLUDE       0   0   BP: General Data II (CHAR Fields)  
81 LGTYP BU_LGTYP BU_LGTYP CHAR 4   0   Legitimation Type TB029
82 LGNUM BU_LGNUM BU_LGNUM CHAR 16   0   Identification number of legitimation document  
83 INFCT BU_INFCT BU_INFCT CHAR 30   0   Responsible local court  
84 COMRG BU_COMRG CHAR30 CHAR 30   0   Entry in commercial register  
85 CLBRG BU_CLBRG CHAR30 CHAR 30   0   BP: Entry in register of associations  
86 COPRG BU_COPRG CHAR30 CHAR 30   0   Entry in Register of Cooperatives  
87 .INCLUDE       0   0   BP: General Data II (Non CHAR Fields)  
88 COMREG_DAT BU_COMREG_DAT DATUM DATS 8   0   Date of entry in trade register  
89 .INCLUDE       0   0   CBP: Name fields combined (lower case)  
90 NAME1 BU_NAME1 BU_NAME CHAR 40   0   Name field 1 (name1/last name)  
91 NAME2 BU_NAME2 BU_NAME CHAR 40   0   Name field 2 (name2/first name)  
92 .INCLUDE       0   0   BP: Address Data (Read)  
93 .INCLUDE       0   0   Include structure with ADRC attributes without name fields  
94 NAME_CO AD_NAME_CO TEXT40 CHAR 40   0   c/o name  
95 CITY1 AD_CITY1 TEXT40 CHAR 40   0   City  
96 CITY2 AD_CITY2 TEXT40 CHAR 40   0   District  
97 CITY_CODE AD_CITYNUM CITY_CODE CHAR 12   0   City code for city/street file ADRCITY
98 CITYP_CODE AD_CITYPNM CITYP_CODE CHAR 8   0   District code for City and Street file ADRCITYPRT
99 HOME_CITY AD_CITY3 TEXT40 CHAR 40   0   City (different from postal city)  
100 CITYH_CODE AD_CITYHNM CITY_CODE CHAR 12   0   Different city for city/street file ADRCITY
101 CHCKSTATUS AD_CHECKST AD_CHECKST CHAR 1   0   City file test status  
102 REGIOGROUP REGIOGROUP REGIOGROUP CHAR 8   0   Regional structure grouping ADRREGGRP
103 POST_CODE1 AD_PSTCD1 CHAR10 CHAR 10   0   City postal code  
104 POST_CODE2 AD_PSTCD2 CHAR10 CHAR 10   0   PO Box postal code  
105 POST_CODE3 AD_PSTCD3 CHAR10 CHAR 10   0   Company postal code (for large customers)  
106 PCODE1_EXT AD_PST1XT CHAR10 CHAR 10   0   (Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code  
107 PCODE2_EXT AD_PST2XT CHAR10 CHAR 10   0   (Not Supported) PO Box Postal Code Extension  
108 PCODE3_EXT AD_PST3XT CHAR10 CHAR 10   0   (Not Supported) Major Customer Postal Code Extension  
109 PO_BOX AD_POBX CHAR10 CHAR 10   0   PO Box  
110 DONT_USE_P AD_NO_USEP AD_NO_USE CHAR 4   0   PO Box Address Undeliverable Flag TSAD12
111 PO_BOX_NUM AD_POBXNUM XFELD CHAR 1   0   Flag: PO Box without number  
112 PO_BOX_LOC AD_POBXLOC TEXT40 CHAR 40   0   PO Box city  
113 CITY_CODE2 AD_CIT2NUM CITY_CODE CHAR 12   0   City PO box code (City file) ADRCITY
114 PO_BOX_REG AD_POBXREG REGIO CHAR 3   0   Region for PO Box (Country, State, Province, ...) T005S
115 PO_BOX_CTY AD_POBXCTY LAND1 CHAR 3   0   PO box country T005
116 POSTALAREA AD_PSTLAR TEXT15 CHAR 15   0   (Not Supported) Post Delivery District  
117 TRANSPZONE LZONE ZONE CHAR 10   0   Transportation zone to or from which the goods are delivered TZONE
118 STREET AD_STREET TEXT60 CHAR 60   0   Street  
119 DONT_USE_S AD_NO_USES AD_NO_USE CHAR 4   0   Street Address Undeliverable Flag TSAD12
120 STREETCODE AD_STRNUM STRT_CODE CHAR 12   0   Street Number for City/Street File ADRSTREET
121 STREETABBR AD_STRABBR STRTYPEAB CHAR 2   0   (Not Supported) Abbreviation of Street Name ADRSTRTYPE
122 HOUSE_NUM1 AD_HSNM1 TEXT10 CHAR 10   0   House Number  
123 HOUSE_NUM2 AD_HSNM2 TEXT10 CHAR 10   0   House number supplement  
124 HOUSE_NUM3 AD_HSNM3 TEXT10 CHAR 10   0   (Not supported) House Number Range  
125 STR_SUPPL1 AD_STRSPP1 TEXT40 CHAR 40   0   Street 2  
126 STR_SUPPL2 AD_STRSPP2 TEXT40 CHAR 40   0   Street 3  
127 STR_SUPPL3 AD_STRSPP3 TEXT40 CHAR 40   0   Street 4  
128 LOCATION AD_LCTN TEXT40 CHAR 40   0   Street 5  
129 BUILDING AD_BLDNG TEXT20 CHAR 20   0   Building (Number or Code)  
130 FLOOR AD_FLOOR TEXT10 CHAR 10   0   Floor in building  
131 ROOMNUMBER AD_ROOMNUM TEXT10 CHAR 10   0   Room or Appartment Number  
132 COUNTRY LAND1 LAND1 CHAR 3   0   Country Key T005
133 LANGU SPRAS SPRAS LANG 1   0   Language Key T002
134 REGION REGIO REGIO CHAR 3   0   Region (State, Province, County) T005S
135 SORT1 AD_SORT1UL TEXT20 CHAR 20   0   Search Term 1  
136 SORT2 AD_SORT2UL TEXT20 CHAR 20   0   Search Term 2  
137 SORT_PHN AD_SRTPHN CHAR20 CHAR 20   0   (Not Supported) Phonetic Search Sort Field  
138 ADDRORIGIN AD_ORIGINA AD_ORIGIN CHAR 4   0   (Not Supported) Address Data Source (Key) TSAD6
139 EXTENSION1 AD_EXTENS1 TEXT40 CHAR 40   0   Extension (only for data conversion) (e.g. data line)  
140 EXTENSION2 AD_EXTENS2 TEXT40 CHAR 40   0   Extension (only for data conversion) (e.g. telebox)  
141 TIME_ZONE AD_TZONE TZNZONE CHAR 6   0   Address time zone TTZZ
142 TAXJURCODE AD_TXJCD AD_TXJCD CHAR 15   0   Tax Jurisdiction  
143 ADDRESS_ID AD_ADDR_ID AD_ADDR_ID CHAR 10   0   (Not supported) Physical address ID  
144 REMARK AD_REMARK1 TEXT50 CHAR 50   0   Address notes  
145 LANGU_CREA AD_LANGUCR SPRAS LANG 1   0   Address record creation original language T002
146 PO_BOX_LOBBY AD_PO_BOX_LBY TEXT40 CHAR 40   0   PO Box Lobby  
147 DELI_SERV_TYPE AD_DELIVERY_SERVICE_TYPE AD_DELIVERY_SERVICE_TYPE CHAR 4   0   Type of Delivery Service ADDRC_DELI_SERV
148 DELI_SERV_NUMBER AD_DELIVERY_SERVICE_NUMBER CHAR10 CHAR 10   0   Number of Delivery Service  
149 COUNTY_CODE AD_CNTYNUM CNTY_CODE CHAR 8   0   County code for county ADRCOUNTY
150 COUNTY AD_COUNTY TEXT40 CHAR 40   0   County  
151 TOWNSHIP_CODE AD_TWSHPNUM TWSHP_CODE CHAR 8   0   Township code for Township ADRTOWNSHIP
152 TOWNSHIP AD_TOWNSHIP TEXT40 CHAR 40   0   Township  
153 DEFLT_COMM AD_DFLTCMM AD_COMTYPE CHAR 3   0   Standard communication type TSADC
154 TEL_NUMBER AD_TLNMBR CHAR30 CHAR 30   0   Telephone no.: dialling code+number  
155 TEL_EXTENS AD_TLXTNS CHAR10 CHAR 10   0   Telephone no.: Extension  
156 FAX_NUMBER AD_FXNMBR CHAR30 CHAR 30   0   Fax number: dialling code+number  
157 FAX_EXTENS AD_FXXTNS CHAR10 CHAR 10   0   Fax no.: Extension  
158 VALID_FROM BU_VALID_FROM_DATS DATUM DATS 8   0   Valid From  
159 VALID_TO BU_VALID_TO_DATS DATUM DATS 8   0   Valid To  
160 .INCLUDE       0   0   BP: Tax Numbers: General Data  
161 NATPERS BU_NATURAL_PERSON BU_NATURAL_PERSON CHAR 1   0   Business Partner Is a Natural Person Under the Tax Laws  
162 BIRTHDT BU_BIRTHDT DATUM DATS 8   0   Date of Birth of Business Partner  
163 GEATHDT BU_DEATHDT DATUM DATS 8   0   Date of death of business partner  
164 PERNO BU_PERNO PERSONID NUMC 8   0   Personnel Number  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 DFKK1099_E ADDRORIGIN TSAD6 ORIGIN REF C CN
2 DFKK1099_E BPKIND TB004 BPKIND REF 1 CN
3 DFKK1099_E BU_GROUP TB001 BU_GROUP REF 1 CN
4 DFKK1099_E BU_LANGU T002 SPRAS REF 1 CN
5 DFKK1099_E BU_LOGSYS TBDLS LOGSYS 1 CN
6 DFKK1099_E CITYH_CODE ADRCITY CITY_CODE REF C CN
7 DFKK1099_E CITYP_CODE ADRCITYPRT CITYP_CODE REF C CN
8 DFKK1099_E CITY_CODE ADRCITY CITY_CODE REF C CN
9 DFKK1099_E CITY_CODE2 ADRCITY CITY_CODE REF C CN
10 DFKK1099_E CNDSC T005 LAND1 REF 1 CN
11 DFKK1099_E COUNTRY T005 LAND1    
12 DFKK1099_E COUNTY_CODE ADRCOUNTY COUNTY_CODE REF C CN
13 DFKK1099_E DEFLT_COMM TSADC COMINT REF C CN
14 DFKK1099_E DELI_SERV_TYPE ADDRC_DELI_SERV DELI_SERV_TYPE 1 CN
15 DFKK1099_E DONT_USE_P TSAD12 UNDELIVER KEY C CN
16 DFKK1099_E DONT_USE_S TSAD12 UNDELIVER KEY C CN
17 DFKK1099_E IND_SECTOR TB023 IND_SECTOR REF 1 CN
18 DFKK1099_E JOBGR TB028 JOBGR REF 1 CN
19 DFKK1099_E LANGU T002 SPRAS KEY 1 CN
20 DFKK1099_E LANGU_CORR T002 SPRAS REF C CN
21 DFKK1099_E LANGU_CREA T002 SPRAS REF C CN
22 DFKK1099_E LEGAL_ENTY TB019 LEGAL_ENTY KEY 1 CN
23 DFKK1099_E LEGAL_ORG TB032 LEGAL_ORG REF 1 CN
24 DFKK1099_E LGTYP TB029 LGTYP    
25 DFKK1099_E MARST TB027 MARST REF 1 CN
26 DFKK1099_E NAMCOUNTRY T005 LAND1 REF C CN
27 DFKK1099_E NAMEFORMAT T005N NAMEFORMAT REF C CN
28 DFKK1099_E NATIO T005 LAND1 1 CN
29 DFKK1099_E PARTGRPTYP TB025 PARTGRPTYP KEY 1 CN
30 DFKK1099_E PO_BOX_CTY T005 LAND1 REF C CN
31 DFKK1099_E PO_BOX_REG T005S BLAND REF C CN
32 DFKK1099_E PREFIX1 TSAD4 PREFIX_KEY KEY 1 CN
33 DFKK1099_E PREFIX2 TSAD4 PREFIX_KEY KEY 1 CN
34 DFKK1099_E RATE DPR_RATES RATE KEY    
35 DFKK1099_E REGIOGROUP ADRREGGRP REGIOGROUP REF C CN
36 DFKK1099_E REGION T005S BLAND REF C CN
37 DFKK1099_E SOURCE TB005 SOURCE KEY 1 CN
38 DFKK1099_E STREETABBR ADRSTRTYPE STRTYPEAB REF C CN
39 DFKK1099_E STREETCODE ADRSTREET STRT_CODE REF C CN
40 DFKK1099_E TIME_ZONE TTZZ TZONE REF C CN
41 DFKK1099_E TITLE TSAD3 TITLE KEY 1 CN
42 DFKK1099_E TITLE_ACA1 TSAD2 TITLE_KEY KEY 1 CN
43 DFKK1099_E TITLE_ACA2 TSAD2 TITLE_KEY KEY 1 CN
44 DFKK1099_E TITLE_ROYL TSAD5 TITLE_KEY KEY 1 CN
45 DFKK1099_E TOWNSHIP_CODE ADRTOWNSHIP TOWNSHIP_CODE REF C CN
46 DFKK1099_E TRANSPZONE TZONE ZONE1 REF C CN
47 DFKK1099_E XUBNAME USR02 BNAME KEY 1 CN
History
Last changed by/on SAP  20141109 
SAP Release Created in 463