SAP /1FE/0Z0101IT Table in S/4 HANA - Items for Class Z010 - Raw Exceptions
/1FE/0Z0101IT is a standard SAP Table which is used to store Items for Class Z010 - Raw Exceptions data and is available within S/4 HANA SAP systems depending on the version and release level. Below is the technical details and the list of fields specifically relevant for an SAP S/4 HANA system
Even using an S/4 Hana system you can still view further information about the SAP /1FE/0Z0101IT table and the data within it using standard SAP GUI transactions such as SE11, SE80 or SE16. Or you can use the ADT (ABAP development tools within eclipse).
Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via SM30: Display/Maintenance Allowed but with Restrictions
Enhancement category: Cannot Be Enhanced
Dictionary Type: Transparent table
Database Table: /1FE/0Z0101IT
/1FE/0Z0101IT table structure field list
Below is the full /1FE/0Z0101IT field list that makes up the SAP database table structure, including key fields, description, data type and other technical details of each field
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP | SHLP Field |
MANDT | Client | MANDT | CLNT | 3(0) | MANDT | |||||
SRCTATYPE | Source Transaction Type | SRCTATYPE_KK | CHAR | 5(0) | SRCTATYPE_KK | |||||
SRCTAID | Source Transaction ID | SRCTAID_KK | CHAR | 22(0) | ALPHA | SRCTAID_KK | ||||
BITPACKUUID | GUID of Package of Billable Items | BITPACKUUID_KK | RAW | 16(0) | GUID16 | |||||
BITPACKCNO | Sequence Number of Billable Item in Package | BITPACKCNO_KK | NUMC | 8(0) | NUMC8 | |||||
SRCTASUBID | Source Transaction Item ID | SRCTASUBID_KK | CHAR | 10(0) | SRCTASUBID_KK | |||||
BITPACKNUM | Number of Billable Main Items of Package | BITPACKNUM_KK | INT4 | 10(0) | INT4_NOS | |||||
BITCAT | Billable Item Class | BITCAT_KK | CHAR | 4(0) | BITCAT_KK | FKK_BIX_BITCAT | BITCAT | |||
BITSTATUS | Status of Billable Item | BITSTATUS_KK | CHAR | 1(0) | BITSTATUS_KK | |||||
SUBPROCESS | Subprocess of Billing | SUB_PROCESS_KK | CHAR | 4(0) | SUB_PROCESS_KK | |||||
BITTYPE | Type of Billable Item | BITTYPE_KK | CHAR | 4(0) | BITTYPE_KK | |||||
PREPAID | Prepaid | PREPAID_KK | CHAR | 1(0) | XFELD | |||||
XPRIMARY | Primary Billable Item | XPRIMARY_KK | CHAR | 1(0) | XFELD | |||||
RELTYPE_PRIMARY | Type of Relationship to Primary Item | RELTYPE_PRIMARY_KK | CHAR | 2(0) | RELTYPE_PRIMARY_KK | |||||
CITCAT | Consumption Item Class | CITCAT_KK | CHAR | 4(0) | CITCAT_KK | FKK_BIX_CITCAT | CITCAT | |||
APPLK | Application Area | APPLK_KK | CHAR | 1(0) | APPLK_KK | |||||
VKONT | Contract Account Number for Billing and Invoicing | VKONT_CI_KK | CHAR | 12(0) | ALPHA | VKONT_KK | KTO | FKKINV_VKONT_CI | VKONT | |
VKONA | Contract account number in legacy system | VKONA_KK | CHAR | 20(0) | CHAR20 | |||||
GPART | Business Partner Number for Billing and Invoicing | GPART_CI_KK | CHAR | 10(0) | ALPHA | BU_PARTNER | BPA | FKKINV_GPART_CI | GPART | |
BPEXT | Business Partner Number in External System | BU_BPEXT | CHAR | 20(0) | CHAR20 | |||||
MDCAT | Type of Master Data for Billing and Invoicing | MDCAT_CI_KK | CHAR | 1(0) | MDCAT_CI_KK | |||||
VTREF | Reference Specifications from Contract | VTREF_KK | CHAR | 20(0) | ALPHA | VTREF_KK | VTZ | |||
VTPOS | Contract: Item Number | VTPOS_KK | NUMC | 6(0) | VTPOS_KK | |||||
SUBAP | Subapplication in Contract Accounts Receivable and Payable | SUBAP_KK | CHAR | 1(0) | SUBAP_KK | 8SA | ||||
PPACC | Prepaid Account | PPACC_KK | CHAR | 12(0) | ALPHA | PPACC_KK | 8PPACC | FKKPREPACC_F4 | PPACC | |
MAKEY | Identification of Master Agreement | MAKEY_KK | CHAR | 10(0) | ALPHA | MAKEY_KK | MAKEY | FKKMA_F4 | MAKEY | |
BILL_BASEDATE | Baseline Date for Period Assignment in Billing | BILL_BASEDATE_KK | DATS | 8(0) | DATS | |||||
BILL_FIRST | Target Date for Billing | BILL_FIRST_KK | DATS | 8(0) | ||||||
BITDATE | Date of Origin of Billable Item | BITDATE_KK | DATS | 8(0) | DATS | |||||
BITTIME | Time of Origin of Billable Item | BITTIME_KK | TIMS | 6(0) | TIMS | |||||
BITDATE_FROM | Start Date of Usage Period | BITPERIODFROM_KK | DATS | 8(0) | DATS | |||||
BITDATE_TO | End Date of Usage Period | BITPERIODTO_KK | DATS | 8(0) | DATS | |||||
BITCRDATE | Created On | BITCRDATE_KK | DATS | 8(0) | DATS | |||||
BITCRTIME | Created At | BITCRTIME_KK | TIMS | 6(0) | TIMS | |||||
BITCRMODE | Mode of Creation of Billable Item | BIT_CRMODE_KK | CHAR | 1(0) | BIT_CRMODE_KK | |||||
BITDATAPACKID | ID of a data package of billable items | BIT_DATAPACKID_KK | RAW | 16(0) | GUID16 | |||||
BIT_AMOUNT | Amount of Billable Item | BIT_AMOUNT_KK | CURR | 13(2) | WRTV7 | |||||
BIT_CURR | Currency of Billable Item | BIT_CURR_KK | CUKY | 5(0) | WAERS | |||||
BIT_QUANTITY | Billing Quantity of Billable Item | BIT_QUANTITY_KK | QUAN | 31(14) | BIT_QUANTITY_KK | |||||
BIT_QTY_UNIT | Unit for the Billing Quantity of Billable Items | BIT_QTY_UNIT_KK | UNIT | 3(0) | CUNIT | MEINS | ||||
KEYPP | Subarea for Parallelization in Mass Processing | KEYPP_KK | NUMC | 3(0) | NUMC3 | |||||
EXCHIST | History Record Exists for Exception | BITEXCHIST_KK | CHAR | 1(0) | XFELD | |||||
CHHIST | History Record Exists for Change | BITCHHIST_KK | CHAR | 1(0) | XFELD | |||||
BITREVERSED | Reversed Billable Item | BITREVERSED_KK | CHAR | 1(0) | XFELD | |||||
POSTREL | Posting-Relevant Line Item | POSTREL_KK | CHAR | 1(0) | XFELD | |||||
PRINTREL | Line Item Is Relevant for Printing | PRINTREL_KK | CHAR | 1(0) | XFELD | |||||
NOT_BPREL | Not Relevant for Business Partner Items | NOT_BPREL_KK | CHAR | 1(0) | XFELD | |||||
PRINT_SUBSTITUTE | Substitute Group for Invoice Printing | PRINT_SUBSTITUTE_KK | CHAR | 4(0) | ||||||
SPART | Division | SPART_KK | CHAR | 2(0) | SPART | SPA | ||||
BUKRS | Company Code | BUKRS | CHAR | 4(0) | BUKRS | BUK | C_T001 | BUKRS | ||
GSBER | Business Area | GSBER | CHAR | 4(0) | GSBER | GSB | ||||
SEGMT | Segment for Segmental Reporting | SEGMT_KK | CHAR | 10(0) | ALPHA | FB_SEGMENT | ||||
PRCTR | Profit Center | PRCTR | CHAR | 10(0) | ALPHA | PRCTR | PRC | PRCTR_EMPTY | PRCTR | |
HVORG | Main Transaction for Line Item | HVORG_KK | CHAR | 4(0) | HVORG_KK | 8HV | ||||
TVORG | Subtransaction for Document Item | TVORG_KK | CHAR | 4(0) | TVORG_KK | |||||
KOFIZ | Account Determination ID | KOFIZ_KK | CHAR | 2(0) | KOFIZ_KK | |||||
SERVICE_TYPE | Service Type for Revenue Accounting | RAI_SERVICE_TYPE_KK | CHAR | 6(0) | RAI_SERVICE_TYPE_KK | |||||
TAX_INCLUDED | Tax Included in Amount | TAX_INCLUDED_KK | CHAR | 1(0) | XFELD | |||||
TAX_DET_TYPE | Type of Tax Calculation | TAX_DET_TYPE_KK | CHAR | 2(0) | TAX_DET_TYPE_KK | |||||
TAX_DATE_TYPE | Type of Tax Date | TAX_DATE_TYPE_KK | CHAR | 2(0) | TAX_DATE_TYPE_KK | |||||
EXT_TAX_DATE | External Tax Date | EXT_TAX_DATE_KK | DATS | 8(0) | ||||||
EXT_TAX_ID | External Tax ID When Adopting Billable Items | BIT_EXT_TAX_ID_KK | CHAR | 12(0) | ||||||
ERMWSKZ | Indicator: Tax Determination Code | ERMWSKZ | CHAR | 2(0) | ERMWSKZ | |||||
MWSKZ | Tax on sales/purchases code | MWSKZ | CHAR | 2(0) | MWSKZ | |||||
STRKZ | Tax Code for Other Taxes | STRKZ_KK | CHAR | 2(0) | STRKZ_KK | |||||
TXJCD | Tax Jurisdiction | TXJCD | CHAR | 15(0) | TXJCD | TXJ | ||||
XANZA | Item is a Down Payment/Down Payment Request | XANZA_KK | CHAR | 1(0) | XFELD | |||||
STAKZ | Type of statistical item | STAKZ_KK | CHAR | 1(0) | STAKZ_KK | |||||
PYMET | Payment Method | PYMET_KK | CHAR | 1(0) | PYMET_KK | |||||
BITREF32 | External Reference of Billable Item (32 Places) | BITREF32_KK | CHAR | 32(0) | BITREF32_KK | |||||
PY_GROUP | Grouping of Payment Data Items | BIT_PY_GROUP_KK | CHAR | 8(0) | ||||||
TAX_GROUP | Grouping of Tax Items | BIT_TAX_GROUP_KK | CHAR | 8(0) | ||||||
TXT_GROUP | Grouping of Text Attachments | BIT_TXT_GROUP_KK | CHAR | 8(0) | ||||||
DEFREV_CAT | Category of Deferred Revenues | DEFREV_CAT_KK | CHAR | 2(0) | DEFREV_CAT_KK | |||||
DEFREV_PDATE | Transfer Posting Date for Delayed Revenues | DATE_KK | DATS | 8(0) | DATUM | |||||
REVREC_TYPE | Accrual/Deferral Posting Type | REVREC_TYPE_KK | CHAR | 4(0) | REVREC_TYPE_KK | |||||
SEPARATE_INV | Control of Billing and Invoicing Unit | SEPARATE_INV_BITPACK_KK | CHAR | 1(0) | SEPARATE_INV_BITPACK_KK | |||||
SIMULATED | Billable Item Is Simulated | BIT_SIMULATED_KK | CHAR | 1(0) | BIT_SIMULATED_KK | |||||
OFFSET_PROC | Offsetting Procedure | INV_OFFSET_PROC_KK | CHAR | 2(0) | INV_OFFSET_PROC_KK | |||||
EXCDATE | Exception Date | BITEXCDATE_KK | DATS | 8(0) | DATS | |||||
EXCTIME | Time of Exception | BITEXCTIME_KK | TIMS | 6(0) | TIMS | |||||
EXCREASON | Exception/Reversal Reason for Billable Items | BITEXCREASON_KK | CHAR | 2(0) | BITEXCREASON_KK | |||||
EXCUSNAM | Name of User Who Excepted the Item | BITEXCUSNAM_KK | CHAR | 12(0) | XUBNAME | |||||
AGRMT | Agreement of Master Agreement | AGRMT_KK | CHAR | 10(0) | ALPHA | AGRMT_KK | ||||
AGRTY | Object of Agreement | AGRTY_KK | CHAR | 2(0) | AGRTY_KK | |||||
BILLREQRSN | Reason for Billing Request | BILLREQRSN_KK | CHAR | 4(0) | BILLREQRSN_KK | |||||
BITPKCNO_PRIMARY | Sequence Number of the Primary Item Package | BITPACKCNO_PRIMARY_KK | NUMC | 8(0) | NUMC8 | |||||
BITPKID_PRIMARY | GUID of the Primary Item Package | BITPACKUUID_PRIMARY_KK | RAW | 16(0) | GUID16 | |||||
BITTEXT50 | Text of Main Billable Item (50 Characters) | BITTEXT50_KK | CHAR | 50(0) | BITTEXT50_KK | |||||
BITTIME_FROM | Time of the Start of the Usage Period | BITTIMEFROM_KK | TIMS | 6(0) | TIMS | |||||
BITTIME_TO | Time of the End of the Usage Period | BITTIMETO_KK | TIMS | 6(0) | TIMS | |||||
CITID | Consumption Item ID | CITID_KK | CHAR | 32(0) | CITID_KK | |||||
CITIDTYPE | Type of Consumption Item ID | CITIDTYPE_KK | CHAR | 5(0) | CITIDTYPE_KK | |||||
CONTRACTITEMID | External GUID of Provider Contract Items (CHAR) | VTPID_C_KK | CHAR | 32(0) | SYSUUID_C | |||||
CRM_ACCTGRP_PROD | Account Assignment Group for Material | KTGRM | CHAR | 2(0) | KTGRM | |||||
CRM_DIS_CHANNEL | Distribution Channel | VTWEG | CHAR | 2(0) | VTWEG | VTW | C_VTWEG | VTWEG | ||
CRM_DIVISION | CRM Division | CRM_SPART_KK | CHAR | 2(0) | SPART | SPA | C_SPART | SPART | ||
CRM_ITEM_TYPE | Item Category | CRMT_ITEM_TYPE_CO | CHAR | 4(0) | CRM_ITEM_TYPE_CO | IAOM_ITEM_TYPE | ITM_TYPE | |||
CRM_SALES_ORG | Sales Organization | VKORG | CHAR | 4(0) | VKORG | VKO | C_VKORG | VKORG | ||
CURREXC_DATE | Translation Date | CURREXC_DATE_KK | DATS | 8(0) | ||||||
CURREXC_RATE | Exchange rate | KURSF | DEC | 9(5) | EXCRT | KURSF | ||||
DEFREV_ACTION | Action Code for Posting Event-Based Deferred Revenues | DEFREV_ACTION_KK | CHAR | 2(0) | DEFREV_ACTION_KK | |||||
DEFREV_ASSKY | Assignment Key | ASSKY_KK | CHAR | 30(0) | CHAR30 | FKK_ASSKY | ASSKY | |||
DEFREV_CTYPE | Cost Type/Revenue Type | CTYPE_KK | CHAR | 4(0) | CTYPE_KK | FKK_CTYPE | CTYPE | |||
DISCKEY | Discount/Charge Key | DISCKEY_KK | CHAR | 8(0) | DISCKEY_KK | |||||
DISCKEY_VERSNO | Version Number of Disccount on Billable Items | DISCKEY_VERSNO_KK | NUMC | 2(0) | ||||||
DISC_BASE_AMT | Base Amount of Discount/Charge Base Item | DISC_BASE_AMOUNT_KK | CURR | 13(2) | WRTV7 | |||||
DISC_BASGR | Grouping of Base Items in Billing Document | DISC_GROUP_KK | NUMC | 4(0) | ||||||
DISC_BIT_NUMBER | Number of Billable Items of a Base Item | DISC_BIT_NUMBER_KK | INT4 | 10(0) | INT4_NOS | |||||
DISC_CALC_REL | Item Relevant for Discount/Charge Calculation | DISC_CALC_REL_KK | CHAR | 1(0) | XFELD | |||||
DISC_COND_REL | Item Relevant for Discount/Charge Condition | DISC_COND_REL_KK | CHAR | 1(0) | XFELD | |||||
DISC_GRNUM | Number of Base Items in Discount/Charge Group | DISC_GRNUM_KK | INT1 | 3(0) | ||||||
DISC_LEVEL | Processing Level for Discount/Charge in Billing | DISC_LEVEL_KK | NUMC | 4(0) | DISC_LEVEL_KK | |||||
DISC_NUM | Number of Base Items in Billing Document | DISC_NUM_KK | INT1 | 3(0) | ||||||
DITRSN | Dependent Item Reason | DITRSN_KK | CHAR | 8(0) | DITRSN_KK | |||||
DITTYPE | Dependent Item Type | DITTYPE_KK | CHAR | 8(0) | DITTYPE_KK | |||||
ERMWSKZ_B2B | Alternative Tax Determination Code for Foreign Deliveries | ERMWSKZ_B2B_KK | CHAR | 2(0) | ERMWSKZ | |||||
GPART_PRIMARY | Business Partner of Primary Item | GPART_PRIMARY_KK | CHAR | 10(0) | ALPHA | BU_PARTNER | ||||
GPART_VT | Business Partner of Contract | GPART_VT_KK | CHAR | 10(0) | ALPHA | BU_PARTNER | ||||
ICO_BUKRS_REQ | Requesting Company Code | ICO_BUKRS_REQ_KK | CHAR | 4(0) | BUKRS | BUK | C_T001 | BUKRS | ||
ICO_BUKRS_SUP | Supplying Company Code | ICO_BUKRS_SUP_KK | CHAR | 4(0) | BUKRS | BUK | C_T001 | BUKRS | ||
ICO_TYPE | Intercompany Clearing Type | ICO_TYPE_KK | CHAR | 4(0) | ICO_TYPE_KK | |||||
MWSKZ_B2B | Alternative Tax Code for Deliveries Abroad | MWSKZ_B2B_KK | CHAR | 2(0) | MWSKZ | |||||
OFFSET_ACTION | Action Code for Offsetting | INV_OFFSET_ACTION_KK | CHAR | 1(0) | INV_OFFSET_ACTION_KK | |||||
OFFSET_CAT | Offsetting Category | INV_OFFSET_CAT_KK | CHAR | 3(0) | INV_OFFSET_CAT_KK | |||||
OFFSET_GROUP | Grouping of Offsetting Items | INV_OFFSET_GROUP_KK | CHAR | 6(0) | ||||||
OFFSET_REFID | Offsetting Reference Key | INV_OFFSET_REFID_KK | CHAR | 20(0) | CHAR20 | |||||
PA8120_POS_ID1 | External Key for Posting Area 8120 | PA8120_POS_ID1_KK | CHAR | 12(0) | CHAR12 | |||||
PA8120_POS_ID2 | Second External Key for Posting Area 8120 | PA8120_POS_ID2_KK | CHAR | 12(0) | CHAR12 | |||||
PA8120_POS_ID3 | Third External Key for Posting Area 8120 | PA8120_POS_ID3_KK | CHAR | 12(0) | CHAR12 | |||||
PA8120_POS_ID4 | Fourth External Key for Posting Area 8120 | PA8120_POS_ID4_KK | CHAR | 12(0) | CHAR12 | |||||
PA8121_POS_ID1 | External Key for Posting Area 8121 | PA8121_POS_ID1_KK | CHAR | 12(0) | CHAR12 | |||||
PA8121_POS_ID2 | Second External Key for Posting Area 8121 | PA8121_POS_ID2_KK | CHAR | 12(0) | CHAR12 | |||||
PA8121_POS_ID3 | Third External Key for Posting Area 8121 | PA8121_POS_ID3_KK | CHAR | 12(0) | CHAR12 | |||||
PA8121_POS_ID4 | Fourth External Key for Posting Area 8121 | PA8121_POS_ID4_KK | CHAR | 12(0) | CHAR12 | |||||
PCARD_GUID32 | Key for Payment Card Supplement (CHAR Format) | CGUID_PC_KK | CHAR | 32(0) | SYSUUID_C32 | |||||
PCARD_XSETT | Billing Status | XSETT_KK | CHAR | 1(0) | XSETT_KK | |||||
PSCAT | Partner Settlement Category | PSCAT_KK | CHAR | 4(0) | PSCAT_KK | |||||
PYREF | Payment Reference | PYREF_KK | CHAR | 30(0) | PYREF_KK | |||||
RAREL | Relevant for Revenue Accounting | RAREL_KK | CHAR | 1(0) | RAREL_KK | |||||
RATINGDATE | Date of Rating | RATINGDATE_KK | DATS | 8(0) | DATS | |||||
RATINGID | Rating ID | RATINGID_KK | NUMC | 20(0) | RATINGID_KK | |||||
RA_ITEM_TYPE | Type of Revenue Accounting Item | RAI_ITEM_TYPE_KK | CHAR | 2(0) | RAI_ITEM_TYPE_KK | |||||
RA_ORIGDOC_ID | Original Item ID | RAI_ORIID_KK | CHAR | 35(0) | TEXT35 | |||||
RA_ORIGDOC_TYPE | Original Item Type | RAI_ORITY_KK | CHAR | 4(0) | RAI_SRCTY_KK | FKKRA_RAI_ORITY | ORIGDOC_TYPE | |||
RA_REFID | Reference ID for Revenue Accounting | RAI_REFID_KK | CHAR | 30(0) | CHAR30 | |||||
RA_REFTYPE | Reference Type for Revenue Accounting | RAI_REFTYPE_KK | CHAR | 3(0) | RAI_REFTYPE_KK | |||||
SRCTAID_PRIMARY | Source Transaction ID of Primary Item | SRCTAID_PRIMARY_KK | CHAR | 22(0) | ALPHA | SRCTAID_KK | ||||
SRCTATY_PRIMARY | Source Transaction Type of Primary Item | SRCTATY_PRIMARY_KK | CHAR | 5(0) | SRCTATYPE_KK | |||||
SUBAP_PRIMARY | Subapplication of Contract of Primary Item | SUBAP_PRIMARY_KK | CHAR | 1(0) | SUBAP_KK | 8SA | ||||
TAX_COUNTRY | Destination Country That Is Relevant for Tax Report | TAX_COUNTRY_KK | CHAR | 3(0) | LAND1 | |||||
VKONT_PRIMARY | Contract Account of the Primary Item | VKONT_PRIMARY_KK | CHAR | 12(0) | ALPHA | VKONT_KK | ||||
VKONT_VT | Contract Account of Contract | VKONT_VT_KK | CHAR | 12(0) | ALPHA | VKONT_KK | ||||
VTREF_PRIMARY | Contract of Primary Item | VTREF_PRIMARY_KK | CHAR | 20(0) | ALPHA | VTREF_KK |
Search for further information about these or an SAP related objects