SAP ABAP Table PIQ_US_DFKKOP_1098T (Interested information of the BP Items)
Hierarchy
☛
IS-PS-CA (Software Component) IS-PUBLIC SECTOR CONTRACT ACCOUNTING
⤷ IS-HER-CM-US (Application Component) USA
⤷ PMIQ_US (Package) Campus Management USA
⤷ IS-HER-CM-US (Application Component) USA
⤷ PMIQ_US (Package) Campus Management USA
Basic Data
Table Category | INTTAB | Structure |
Structure | PIQ_US_DFKKOP_1098T | Table Relationship Diagram |
Short Description | Interested information of the BP Items |
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 | GPART | GPART_KK | BU_PARTNER | CHAR | 10 | 0 | Business Partner Number | * | |
2 | OPBEL | OPBEL_KK | OPBEL_KK | CHAR | 12 | 0 | Number of Contract Accts Rec. & Payable Doc. | * | |
3 | PLVAR | PLVAR | PLVAR | CHAR | 2 | 0 | Plan Version | * | |
4 | TATYP | TATYP_KK | TATYP_KK | CHAR | 1 | 0 | Transaction Class of Document | ||
5 | AUGBL | AUGBL_KK | AUGBL_KK | CHAR | 12 | 0 | Clearing Document or Printed Document | ||
6 | ORG_OBJID | PIQOOBJID | HROBJID | NUMC | 8 | 0 | Object ID of Organizational Unit | * | |
7 | OPUPK | OPUPK_KK | OPUPK_KK | NUMC | 4 | 0 | Item number in contract account document | ||
8 | OPUPZ | OPUPZ_KK | OPUPZ_KK | NUMC | 3 | 0 | Subitem for a Partial Clearing in Document | ||
9 | OPUPW | OPUPW_KK | OPUPW_KK | NUMC | 3 | 0 | Repetition Item in Contract Account Document | ||
10 | HERKF | HERKF_KK | HERKF_KK | CHAR | 2 | 0 | Document Origin Key | * | |
11 | BUDAT | BUDAT_KK | DATUM | DATS | 8 | 0 | Posting Date in the Document | ||
12 | BLART | BLART_KK | BLART_KK | CHAR | 2 | 0 | Document Type | * | |
13 | APPLK | APPLK_KK | APPLK_KK | CHAR | 1 | 0 | Application area | ||
14 | COTG | CMAC_COOBGRP | CMAC_COOBGRP | CHAR | 6 | 0 | Contract Object Type Grouping (COT Grouping) | * | |
15 | GJAHR | PIQ_US_RYEAR | PIQ_US_RYEAR | NUMC | 4 | 0 | 1098T: Reporting Year | ||
16 | RES_STATUS | PIQRESIDSTATUS | RESIS | CHAR | 1 | 0 | Resident Status | * | |
17 | RESIDENT_ALIEN | PIQ_US_RESDSTATUS | CHECKBOX | CHAR | 1 | 0 | IPEDS Resident Alien | ||
18 | GRADUATE | PIQ_US_TYPE_OF_TRNG | PIQ_US_TYPE_OF_TRNG | NUMC | 1 | 0 | Type of Training | ||
19 | HALF_TIME | PIQ_US_TRNG_TIME | PIQ_US_TRNG_TIME | NUMC | 1 | 0 | Training Time for Courses | ||
20 | FID_NO | PIQ_US_FID | PIQ_US_FID | CHAR | 48 | 0 | 1098T: Federal Identification Number | ||
21 | STUD_OBJID | PIQSTUDENT | HROBJID | NUMC | 8 | 0 | Object ID of Student | * | |
22 | STUD_NO | PIQSTUDENT12 | PIQSTUDENT12 | CHAR | 12 | 0 | Student Number | ||
23 | STUD_NAME1 | PAD_NACHN | PAD_NACHN | CHAR | 40 | 0 | Last Name | ||
24 | STUD_NAME2 | PAD_VORNA | PAD_VORNM | CHAR | 40 | 0 | First Name | ||
25 | STUD_NAME3 | PAD_MIDNM | PAD_VORNM | CHAR | 40 | 0 | Middle Name | ||
26 | VETERAN_NR | PIQVETERAN_NR | CHAR | 20 | 0 | Veteran Administration Number | |||
27 | SSN | PIQ_US_SSN | CHAR20 | CHAR | 20 | 0 | 1098T: Social Security Number | ||
28 | STUD_STREET | STRAS_GP30 | TEXT30 | CHAR | 30 | 0 | Street | ||
29 | STUD_HOUSE | HOUSE_GP | TEXT10 | CHAR | 10 | 0 | House number | ||
30 | STUD_CITY | ORT01_GP | TEXT35 | CHAR | 35 | 0 | City | ||
31 | STUD_REGIO | REGIO | REGIO | CHAR | 3 | 0 | Region (State, Province, County) | * | |
32 | STUD_PSTLZ | PSTLZ | PSTLZ | CHAR | 10 | 0 | Postal Code | ||
33 | STUD_LAND1 | LAND1 | LAND1 | CHAR | 3 | 0 | Country Key | * | |
34 | STUD_PFACH | PFACH | PFACH | CHAR | 10 | 0 | PO Box | ||
35 | STUD_PSTL2 | PSTL2 | PSTLZ | CHAR | 10 | 0 | P.O. Box Postal Code | ||
36 | FEE_TYPE | PIQ_US_1098T_DERIV | PIQ_US_1098T | CHAR | 1 | 0 | 1098t: Tuition fees and grant derivation | ||
37 | AMNT_BOX2 | PIQ_US_1098T_AMNT2 | WERT8 | CURR | 15 | 2 | 1098T: Tuition Fee for This Year | ||
38 | AMNT_BOX3 | PIQ_US_1098T_AMNT3 | WERT8 | CURR | 15 | 2 | 1098T: Adjustment for Tuition Fee for Previous Year | ||
39 | AMNT_BOX4 | PIQ_US_1098T_AMNT4 | WERT8 | CURR | 15 | 2 | 1098T: Grants for This Year | ||
40 | AMNT_BOX5 | PIQ_US_1098T_AMNT5 | WERT8 | CURR | 15 | 2 | 1098T: Adjustment for Grants for Previous Year | ||
41 | BOX6 | PIQ_US_1098T_BOX6 | PIQ_US_1098T_BOX6 | NUMC | 1 | 0 | 1098t: Include Amounts Relating to Next Year | ||
42 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | * | |
43 | AUGST | AUGST_KK | AUGST_KK | CHAR | 1 | 0 | Clearing status | ||
44 | VTREF | VTREF_KK | VTREF_KK | CHAR | 20 | 0 | Reference Specifications from Contract | ||
45 | VKONT | VKONT_KK | VKONT_KK | CHAR | 12 | 0 | Contract Account Number | * | |
46 | HVORG | HVORG_KK | HVORG_KK | CHAR | 4 | 0 | Main Transaction for Line Item | * | |
47 | TVORG | TVORG_KK | TVORG_KK | CHAR | 4 | 0 | Subtransaction for Document Item | * | |
48 | WAERS | BLWAE_KK | WAERS | CUKY | 5 | 0 | Transaction Currency | * | |
49 | BETRH | BETRH_KK | WRTV7 | CURR | 13 | 2 | Amount In Local Currency With +/- Signs | ||
50 | BETRW | BETRW_KK | WRTV7 | CURR | 13 | 2 | Amount in Transaction Currency with +/- Sign | ||
51 | PERSL | PERSL_KK | PERSL_KK | CHAR | 4 | 0 | Key for Period Assignment | * | |
52 | VKTYP_PS | VKTYP_KK | VKTYP_KK | CHAR | 2 | 0 | Contract Account Category | * | |
53 | PSOBTYP | PSOBTYP_PS | PSOBTYP_PS | CHAR | 4 | 0 | Contract Object Type | * | |
54 | TEST_FILE | PIQ_US_TEST_FILE | XFELD | CHAR | 1 | 0 | 1098T: Test File Indicator | ||
55 | MAG_FILE | PIQ_US_MAG_FILE | XFELD | CHAR | 1 | 0 | 1098T: Magnetic File Indicator | ||
56 | CORR_FILE | PIQ_US_CORR_FILE | XFELD | CHAR | 1 | 0 | 1098T: Correction File Indicator | ||
57 | TRANS_TIN | PIQ_US_TRANS_TIN | CHAR11 | CHAR | 11 | 0 | 1098T: Transmitter TIN | ||
58 | GRANT_NBR | GM_GRANT_NBR | GM_GRANT_NBR | CHAR | 20 | 0 | Grant | ||
59 | FILERS_NAME | PIQ_US_FILERS_NAME1 | TEXT30 | CHAR | 30 | 0 | 1098T: Filer's Name 1 | ||
60 | FILERS_NAME2 | PIQ_US_FILERS_NAME2 | TEXT30 | CHAR | 30 | 0 | 1098T: Filer's Name 2 | ||
61 | FILERS_TELE | PIQ_US_FILERS_TELE | CHAR12 | CHAR | 12 | 0 | 1098T: Filer's Telephone Number | ||
62 | ACCT_NO | PIQ_US_ACC_NO | PIQSTUDENT12 | CHAR | 12 | 0 | 1098T: Service Provider/Acct_No | ||
63 | .INCLUDE | 0 | 0 | US country specific additional information | |||||
64 | US_INFO_1042_00 | SCRTEXT_L | SCRTEXT_L | CHAR | 40 | 0 | Long Field Label | ||
65 | US_REPORT_YEAR | GJAHR | GJAHR | NUMC | 4 | 0 | Fiscal Year | ||
66 | US_INFO_1042_10 | SCRTEXT_L | SCRTEXT_L | CHAR | 40 | 0 | Long Field Label | ||
67 | US_CONT_NAME | NAME1 | TEXT30 | CHAR | 30 | 0 | Name | ||
68 | US_CONT_TELNO | TELE | CHAR12 | CHAR | 12 | 0 | Phone number of person responsible for company area | ||
69 | US_INFO_1042_20 | SCRTEXT_L | SCRTEXT_L | CHAR | 40 | 0 | Long Field Label | ||
70 | US_PAYER_NAME | NAME1 | TEXT30 | CHAR | 30 | 0 | Name | ||
71 | US_PAYER_TAXNO | STCD1 | STCD1 | CHAR | 16 | 0 | Tax Number 1 | ||
72 | US_INFO_1042_30 | SCRTEXT_L | SCRTEXT_L | CHAR | 40 | 0 | Long Field Label | ||
73 | US_TRANS_TEST | WT_TEST_FILE | WT_US_TEST_FILE | CHAR | 4 | 0 | File type indicator | ||
74 | US_TRANS_AGENT | WT_EIN_IND | WT_US_EIN_IND | NUMC | 1 | 0 | Withholding Agent's EIN indicator | ||
75 | US_TRANS_NAME | NAME1 | TEXT30 | CHAR | 30 | 0 | Name | ||
76 | US_TRANS_STRAS | STRAS_GP | TEXT35 | CHAR | 35 | 0 | House number and street | ||
77 | US_TRANS_CITY | CITY | CITY | CHAR | 25 | 0 | City | ||
78 | US_TRANS_REGIO | REGIO | REGIO | CHAR | 3 | 0 | Region (State, Province, County) | * | |
79 | US_TRANS_PSTLZ | PSTLZ | PSTLZ | CHAR | 10 | 0 | Postal Code | ||
80 | US_TRANS_TAXNO | STCD1 | STCD1 | CHAR | 16 | 0 | Tax Number 1 | ||
81 | US_TCC | WT_T_CTRL | CHAR5 | CHAR | 5 | 0 | Transmitter Control | ||
82 | US_INFO_1099_10 | SCRTEXT_L | SCRTEXT_L | CHAR | 40 | 0 | Long Field Label | ||
83 | US_VENDOR_STCD1 | STCD1 | STCD1 | CHAR | 16 | 0 | Tax Number 1 | ||
84 | US_VENDOR_STCD2 | STCD2 | STCD2 | CHAR | 11 | 0 | Tax Number 2 | ||
85 | US_VENDOR_REGIO | REGIO | REGIO | CHAR | 3 | 0 | Region (State, Province, County) | * | |
86 | US_INFO_1099_20 | SCRTEXT_L | SCRTEXT_L | CHAR | 40 | 0 | Long Field Label | ||
87 | US_HWAER | WT_HWAER | WAERS | CUKY | 5 | 0 | Reporting currency ( local or alternative ) | * | |
88 | US_MIN_FED | WT_MINTAX | WERT7 | CURR | 13 | 2 | Minimum Amount Federal Tax | ||
89 | US_MIN_ROYAL | WT_MBASE2 | WERT7 | CURR | 13 | 2 | Minimum Base Amount - Royalties | ||
90 | US_MIN_DIVID | WT_MBASE8 | WERT7 | CURR | 13 | 2 | Minimum Base Amount - Dividends | ||
91 | US_MIN_DIRECT | WT_MBASE9 | WERT7 | CURR | 13 | 2 | Minimum Base Amount - Direct Sales | ||
92 | US_MIN_INT_GEN | WT_MBASE1J | WERT7 | CURR | 13 | 2 | Minimum Base Amount - Interest income | ||
93 | US_MIN_INT_BUS | WT_MBASE1I | WERT7 | CURR | 13 | 2 | Minimum Base Amount - Interest income for trade and business | ||
94 | US_MIN_G_UNEMPLOY | WT_MBASE1G | WERT7 | CURR | 13 | 2 | Minimum Base Amount - Unemployment | ||
95 | US_MIN_G_TAX_REFUND | WT_MBASE2G | WERT7 | CURR | 13 | 2 | Minimum Base Amount - State and Local Tax Refund | ||
96 | US_MIN_G_OTH_GRANT | WT_MBASE5G | WERT7 | CURR | 13 | 2 | Minimum Base Amount - Other Taxable Grant | ||
97 | US_MIN_G_ATAA_PYMNT | WT_MBASE5G | WERT7 | CURR | 13 | 2 | Minimum Base Amount - Other Taxable Grant | ||
98 | US_INFO_1099_30 | SCRTEXT_L | SCRTEXT_L | CHAR | 40 | 0 | Long Field Label | ||
99 | US_TRANS_NAME1 | WT_NAME1 | CHAR40 | CHAR | 40 | 0 | Name 1 | ||
100 | US_TRANS_NAME2 | WT_NAME2 | CHAR40 | CHAR | 40 | 0 | Name 2 | ||
101 | US_TRANS_TCC | WT_T_CTRL | CHAR5 | CHAR | 5 | 0 | Transmitter Control | ||
102 | US_TRANS_TIN | CHAR11 | CHAR11 | CHAR | 11 | 0 | Character Length 11 | ||
103 | US_CONTACT_PERS | NAME1 | TEXT30 | CHAR | 30 | 0 | Name | ||
104 | US_CONTACT_TELNO | TELE | CHAR12 | CHAR | 12 | 0 | Phone number of person responsible for company area | ||
105 | US_CONTACT_EMAIL | WT_EMAIL | CHAR35 | CHAR | 35 | 0 | E-mail address | ||
106 | US_COMP_NAME1 | WT_NAME1 | CHAR40 | CHAR | 40 | 0 | Name 1 | ||
107 | US_COMP_NAME2 | WT_NAME2 | CHAR40 | CHAR | 40 | 0 | Name 2 | ||
108 | US_COMP_STRAS | STRAS_GP | TEXT35 | CHAR | 35 | 0 | House number and street | ||
109 | US_COMP_CITY | ORT01 | TEXT25 | CHAR | 25 | 0 | City | ||
110 | US_COMP_STATE | REGIO | REGIO | CHAR | 3 | 0 | Region (State, Province, County) | * | |
111 | US_TRANS_POST | PSTLZ | PSTLZ | CHAR | 10 | 0 | Postal Code | ||
112 | US_INFO_1099_40 | SCRTEXT_L | SCRTEXT_L | CHAR | 40 | 0 | Long Field Label | ||
113 | US_PAYER_AGENT | WT_US_PAYER_AGENT | WT_US_AGENT_OR_PAYER | CHAR | 1 | 0 | Payer (P) / Transfer Agent (A) | ||
114 | US_PAYER_NAME1 | WT_NAME1 | CHAR40 | CHAR | 40 | 0 | Name 1 | ||
115 | US_PAYER_NAME2 | WT_NAME2 | CHAR40 | CHAR | 40 | 0 | Name 2 | ||
116 | US_PAYER_CTRL | WT_P_CTRL | CHAR4 | CHAR | 4 | 0 | Payer Name Control | ||
117 | US_PAYER_STRAS | STRAS_GP | TEXT35 | CHAR | 35 | 0 | House number and street | ||
118 | US_PAYER_CITY | ORT01 | TEXT25 | CHAR | 25 | 0 | City | ||
119 | US_PAYER_REGIO | REGIO | REGIO | CHAR | 3 | 0 | Region (State, Province, County) | * | |
120 | US_PAYER_POST | PSTLZ | PSTLZ | CHAR | 10 | 0 | Postal Code | ||
121 | US_PAYER_TELNO | TELE | CHAR12 | CHAR | 12 | 0 | Phone number of person responsible for company area | ||
122 | US_PAYER_TIN | CHAR11 | CHAR11 | CHAR | 11 | 0 | Character Length 11 | ||
123 | US_INFO_1099_50 | SCRTEXT_L | SCRTEXT_L | CHAR | 40 | 0 | Long Field Label | ||
124 | US_FILE_COMBINE | XFELD | XFELD | CHAR | 1 | 0 | Checkbox | ||
125 | US_FILE_TEST | XFELD | XFELD | CHAR | 1 | 0 | Checkbox | ||
126 | US_FILE_TAPE | XFELD | XFELD | CHAR | 1 | 0 | Checkbox | ||
127 | US_FILE_CORR_IND | WT_CORR_IND | WT_CORR_IND | CHAR | 1 | 0 | Correction File Indicator | ||
128 | US_FILE_TM_NO | WT_TM_NO | CHAR6 | CHAR | 6 | 0 | Transmitter Media Number | ||
129 | US_ALPHA_REPLACE | WT_F_ALPHA | CHAR02 | CHAR | 2 | 0 | Alpha Replacement Co | ||
130 | US_IRS_FNAME | WT_F_EFILE | CHAR15 | CHAR | 15 | 0 | IRS File Name | ||
131 | US_APPL_FILE | XFELD | XFELD | CHAR | 1 | 0 | Checkbox | ||
132 | US_APPL_FNAME | CHAR40 | CHAR40 | CHAR | 40 | 0 | Character field of length 40 | ||
133 | US_LOCAL_FILE | XFELD | XFELD | CHAR | 1 | 0 | Checkbox | ||
134 | US_LOCAL_FNAME | CHAR40 | CHAR40 | CHAR | 40 | 0 | Character field of length 40 | ||
135 | US_AGENT_NAME | US_1042_AGENT_NAME | CHAR45 | CHAR | 45 | 0 | Withholding Tax Agent Contact Name | ||
136 | US_DEPT_TITLE | US_1042_DEPT_NAME | CHAR45 | CHAR | 45 | 0 | Withholding Agent's Department Title | ||
137 | US_INFO_MULTI | SCRTEXT_L | SCRTEXT_L | CHAR | 40 | 0 | Long Field Label | ||
138 | US_CONT_MULTI | XFELD_US | XFELD | CHAR | 1 | 0 | Check Box | ||
139 | US_CONT_COMPANY | BUKRS_US | BUKRS | CHAR | 4 | 0 | Company Code | * | |
140 | US_REC_TRUNC | XFELD | XFELD | CHAR | 1 | 0 | Checkbox | ||
141 | US_MIN_CHECK | XFELD | XFELD | CHAR | 1 | 0 | Checkbox | ||
142 | US_INFO_FILLER | SCRTEXT_L | SCRTEXT_L | CHAR | 40 | 0 | Long Field Label | ||
143 | US_FILLER_PSE | US_FILER_PSE | XFELD | CHAR | 1 | 0 | Payment Settlement Entity | ||
144 | US_FILLER_EPF | US_FILER_EPF | XFELD | CHAR | 1 | 0 | Electronic Payment Facilitator | ||
145 | US_FILLER_TPP | US_FILER_TPP | XFELD | CHAR | 1 | 0 | Indicator to check if Filer is TPP | ||
146 | US_PSE_NAME | US_PSE_NAME | TEXT30 | CHAR | 30 | 0 | Name of the PSE | ||
147 | US_PSE_PHONE | US_PSE_PHONE | CHAR12 | CHAR | 12 | 0 | Telephone Number of the PSE | ||
148 | US_MIN_TRANS | US_MIN_TRANS | US_MIN_TRANS | NUMC | 3 | 0 | Minimum Number of Transactions | ||
149 | US_MIN_AMT | US_MIN_AMT | US_MIN_AMT | CURR | 13 | 2 | Minimum Amount | ||
150 | US_POS_PERIOD | US_POS_PERIOD | NUMC | 2 | 0 | Posting period | |||
151 | US_TRANS_PAYMT | US_TRANS_PAYMT | XFELD | CHAR | 1 | 0 | Check whether transaction type is payment card | ||
152 | US_TRANS_TPN | US_TRANS_TPN | XFELD | CHAR | 1 | 0 | Check whether transaction is third party network |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 472 |