SAP /1FE/20Z0100IT Table in S/4 HANA - Generated Table for View
/1FE/20Z0100IT is a standard SAP Table which is used to store Generated Table for View 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/20Z0100IT 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:
Display/Maintenance via SM30: Display/Maintenance Allowed but with Restrictions
Enhancement category: Not classified
Dictionary Type: Table view
Database Table: /1FE/20Z0100IT
/1FE/20Z0100IT table structure field list
Below is the full /1FE/20Z0100IT 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 |
| CLIENT | Client | MANDT | CLNT | 3(0) | MANDT | |||||
| BITPACKCNO | Sequence Number of Billable Item in Package | BITPACKCNO_KK | NUMC | 8(0) | NUMC8 | |||||
| BITPACKUUID | GUID of Package of Billable Items | BITPACKUUID_KK | RAW | 16(0) | GUID16 | |||||
| SRCTAID | Source Transaction ID | SRCTAID_KK | CHAR | 22(0) | ALPHA | SRCTAID_KK | ||||
| SRCTATYPE | Source Transaction Type | SRCTATYPE_KK | CHAR | 5(0) | SRCTATYPE_KK | |||||
| VKONT | Contract Account Number for Billing and Invoicing | VKONT_CI_KK | CHAR | 12(0) | ALPHA | VKONT_KK | KTO | FKKINV_VKONT_CI | VKONT | |
| AGRMT | Agreement of Master Agreement | AGRMT_KK | CHAR | 10(0) | ALPHA | AGRMT_KK | ||||
| AGRTY | Object of Agreement | AGRTY_KK | CHAR | 2(0) | AGRTY_KK | |||||
| APPLK | Application Area | APPLK_KK | CHAR | 1(0) | APPLK_KK | |||||
| BILLREQRSN | Reason for Billing Request | BILLREQRSN_KK | CHAR | 4(0) | BILLREQRSN_KK | |||||
| 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) | ||||||
| BITCAT | Billable Item Class | BITCAT_KK | CHAR | 4(0) | BITCAT_KK | FKK_BIX_BITCAT | BITCAT | |||
| BITCRDATE | Created On | BITCRDATE_KK | DATS | 8(0) | DATS | |||||
| BITCRMODE | Mode of Creation of Billable Item | BIT_CRMODE_KK | CHAR | 1(0) | BIT_CRMODE_KK | |||||
| BITCRTIME | Created At | BITCRTIME_KK | TIMS | 6(0) | TIMS | |||||
| BITDATAPACKID | ID of a data package of billable items | BIT_DATAPACKID_KK | RAW | 16(0) | GUID16 | |||||
| BITDATE | Date of Origin of Billable Item | BITDATE_KK | DATS | 8(0) | DATS | |||||
| 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 | |||||
| BITPACKNUM | Number of Billable Main Items of Package | BITPACKNUM_KK | INT4 | 10(0) | INT4_NOS | |||||
| 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 | |||||
| BITREF32 | External Reference of Billable Item (32 Places) | BITREF32_KK | CHAR | 32(0) | BITREF32_KK | |||||
| BITREVERSED | Reversed Billable Item | BITREVERSED_KK | CHAR | 1(0) | XFELD | |||||
| BITSTATUS | Status of Billable Item | BITSTATUS_KK | CHAR | 1(0) | BITSTATUS_KK | |||||
| BITTEXT50 | Text of Main Billable Item (50 Characters) | BITTEXT50_KK | CHAR | 50(0) | BITTEXT50_KK | |||||
| BITTIME | Time of Origin of Billable Item | BITTIME_KK | TIMS | 6(0) | TIMS | |||||
| 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 | |||||
| BITTYPE | Type of Billable Item | BITTYPE_KK | CHAR | 4(0) | BITTYPE_KK | |||||
| 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_QTY_UNIT | Unit for the Billing Quantity of Billable Items | BIT_QTY_UNIT_KK | UNIT | 3(0) | CUNIT | MEINS | ||||
| BIT_QUANTITY | Billing Quantity of Billable Item | BIT_QUANTITY_KK | QUAN | 31(14) | BIT_QUANTITY_KK | |||||
| BPEXT | Business Partner Number in External System | BU_BPEXT | CHAR | 20(0) | CHAR20 | |||||
| BUKRS | Company Code | BUKRS | CHAR | 4(0) | BUKRS | BUK | C_T001 | BUKRS | ||
| CHHIST | History Record Exists for Change | BITCHHIST_KK | CHAR | 1(0) | XFELD | |||||
| CITCAT | Consumption Item Class | CITCAT_KK | CHAR | 4(0) | CITCAT_KK | FKK_BIX_CITCAT | CITCAT | |||
| 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_CAT | Category of Deferred Revenues | DEFREV_CAT_KK | CHAR | 2(0) | DEFREV_CAT_KK | |||||
| DEFREV_CTYPE | Cost Type/Revenue Type | CTYPE_KK | CHAR | 4(0) | CTYPE_KK | FKK_CTYPE | CTYPE | |||
| DEFREV_PDATE | Transfer Posting Date for Delayed Revenues | DATE_KK | DATS | 8(0) | DATUM | |||||
| 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 | Indicator: Tax Determination Code | ERMWSKZ | CHAR | 2(0) | ERMWSKZ | |||||
| ERMWSKZ_B2B | Alternative Tax Determination Code for Foreign Deliveries | ERMWSKZ_B2B_KK | CHAR | 2(0) | ERMWSKZ | |||||
| EXCHIST | History Record Exists for Exception | BITEXCHIST_KK | CHAR | 1(0) | XFELD | |||||
| 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) | ||||||
| GPART | Business Partner Number for Billing and Invoicing | GPART_CI_KK | CHAR | 10(0) | ALPHA | BU_PARTNER | BPA | FKKINV_GPART_CI | GPART | |
| 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 | ||||
| GSBER | Business Area | GSBER | CHAR | 4(0) | GSBER | GSB | ||||
| HVORG | Main Transaction for Line Item | HVORG_KK | CHAR | 4(0) | HVORG_KK | 8HV | ||||
| 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 | |||||
| KEYPP | Subarea for Parallelization in Mass Processing | KEYPP_KK | NUMC | 3(0) | NUMC3 | |||||
| KOFIZ | Account Determination ID | KOFIZ_KK | CHAR | 2(0) | KOFIZ_KK | |||||
| MAKEY | Identification of Master Agreement | MAKEY_KK | CHAR | 10(0) | ALPHA | MAKEY_KK | MAKEY | FKKMA_F4 | MAKEY | |
| MANDT | Client | MANDT | CLNT | 3(0) | MANDT | |||||
| MDCAT | Type of Master Data for Billing and Invoicing | MDCAT_CI_KK | CHAR | 1(0) | MDCAT_CI_KK | |||||
| MWSKZ | Tax on sales/purchases code | MWSKZ | CHAR | 2(0) | MWSKZ | |||||
| MWSKZ_B2B | Alternative Tax Code for Deliveries Abroad | MWSKZ_B2B_KK | CHAR | 2(0) | MWSKZ | |||||
| NOT_BPREL | Not Relevant for Business Partner Items | NOT_BPREL_KK | CHAR | 1(0) | XFELD | |||||
| 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_PROC | Offsetting Procedure | INV_OFFSET_PROC_KK | CHAR | 2(0) | INV_OFFSET_PROC_KK | |||||
| 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 | |||||
| POSTREL | Posting-Relevant Line Item | POSTREL_KK | CHAR | 1(0) | XFELD | |||||
| PPACC | Prepaid Account | PPACC_KK | CHAR | 12(0) | ALPHA | PPACC_KK | 8PPACC | FKKPREPACC_F4 | PPACC | |
| PRCTR | Profit Center | PRCTR | CHAR | 10(0) | ALPHA | PRCTR | PRC | PRCTR_EMPTY | PRCTR | |
| PREPAID | Prepaid | PREPAID_KK | CHAR | 1(0) | XFELD | |||||
| PRINTREL | Line Item Is Relevant for Printing | PRINTREL_KK | CHAR | 1(0) | XFELD | |||||
| PRINT_SUBSTITUTE | Substitute Group for Invoice Printing | PRINT_SUBSTITUTE_KK | CHAR | 4(0) | ||||||
| PSCAT | Partner Settlement Category | PSCAT_KK | CHAR | 4(0) | PSCAT_KK | |||||
| PYMET | Payment Method | PYMET_KK | CHAR | 1(0) | PYMET_KK | |||||
| PYREF | Payment Reference | PYREF_KK | CHAR | 30(0) | PYREF_KK | |||||
| PY_GROUP | Grouping of Payment Data Items | BIT_PY_GROUP_KK | CHAR | 8(0) | ||||||
| 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 | |||||
| RELTYPE_PRIMARY | Type of Relationship to Primary Item | RELTYPE_PRIMARY_KK | CHAR | 2(0) | RELTYPE_PRIMARY_KK | |||||
| REVREC_TYPE | Accrual/Deferral Posting Type | REVREC_TYPE_KK | CHAR | 4(0) | REVREC_TYPE_KK | |||||
| SEGMT | Segment for Segmental Reporting | SEGMT_KK | CHAR | 10(0) | ALPHA | FB_SEGMENT | ||||
| SEPARATE_INV | Control of Billing and Invoicing Unit | SEPARATE_INV_BITPACK_KK | CHAR | 1(0) | SEPARATE_INV_BITPACK_KK | |||||
| SERVICE_TYPE | Service Type for Revenue Accounting | RAI_SERVICE_TYPE_KK | CHAR | 6(0) | RAI_SERVICE_TYPE_KK | |||||
| SIMULATED | Billable Item Is Simulated | BIT_SIMULATED_KK | CHAR | 1(0) | BIT_SIMULATED_KK | |||||
| SPART | Division | SPART_KK | CHAR | 2(0) | SPART | SPA | ||||
| SRCTAID_PRIMARY | Source Transaction ID of Primary Item | SRCTAID_PRIMARY_KK | CHAR | 22(0) | ALPHA | SRCTAID_KK | ||||
| SRCTASUBID | Source Transaction Item ID | SRCTASUBID_KK | CHAR | 10(0) | SRCTASUBID_KK | |||||
| SRCTATY_PRIMARY | Source Transaction Type of Primary Item | SRCTATY_PRIMARY_KK | CHAR | 5(0) | SRCTATYPE_KK | |||||
| STAKZ | Type of statistical item | STAKZ_KK | CHAR | 1(0) | STAKZ_KK | |||||
| STRKZ | Tax Code for Other Taxes | STRKZ_KK | CHAR | 2(0) | STRKZ_KK | |||||
| SUBAP | Subapplication in Contract Accounts Receivable and Payable | SUBAP_KK | CHAR | 1(0) | SUBAP_KK | 8SA | ||||
| SUBAP_PRIMARY | Subapplication of Contract of Primary Item | SUBAP_PRIMARY_KK | CHAR | 1(0) | SUBAP_KK | 8SA | ||||
| SUBPROCESS | Subprocess of Billing | SUB_PROCESS_KK | CHAR | 4(0) | SUB_PROCESS_KK | |||||
| TAX_COUNTRY | Destination Country That Is Relevant for Tax Report | TAX_COUNTRY_KK | CHAR | 3(0) | LAND1 | |||||
| TAX_DATE_TYPE | Type of Tax Date | TAX_DATE_TYPE_KK | CHAR | 2(0) | TAX_DATE_TYPE_KK | |||||
| TAX_DET_TYPE | Type of Tax Calculation | TAX_DET_TYPE_KK | CHAR | 2(0) | TAX_DET_TYPE_KK | |||||
| TAX_GROUP | Grouping of Tax Items | BIT_TAX_GROUP_KK | CHAR | 8(0) | ||||||
| TAX_INCLUDED | Tax Included in Amount | TAX_INCLUDED_KK | CHAR | 1(0) | XFELD | |||||
| TVORG | Subtransaction for Document Item | TVORG_KK | CHAR | 4(0) | TVORG_KK | |||||
| TXJCD | Tax Jurisdiction | TXJCD | CHAR | 15(0) | TXJCD | TXJ | ||||
| TXT_GROUP | Grouping of Text Attachments | BIT_TXT_GROUP_KK | CHAR | 8(0) | ||||||
| VKONA | Contract account number in legacy system | VKONA_KK | CHAR | 20(0) | CHAR20 | |||||
| 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 | ||||
| VTPOS | Contract: Item Number | VTPOS_KK | NUMC | 6(0) | VTPOS_KK | |||||
| VTREF | Reference Specifications from Contract | VTREF_KK | CHAR | 20(0) | ALPHA | VTREF_KK | VTZ | |||
| VTREF_PRIMARY | Contract of Primary Item | VTREF_PRIMARY_KK | CHAR | 20(0) | ALPHA | VTREF_KK | ||||
| XANZA | Item is a Down Payment/Down Payment Request | XANZA_KK | CHAR | 1(0) | XFELD | |||||
| XPRIMARY | Primary Billable Item | XPRIMARY_KK | CHAR | 1(0) | XFELD | |||||
| BIT_DBTAB | CHAR | 16(0) |
Search for further information about these or an SAP related objects