Select data from sap tables P18_
Display SAP table details
P1800 - InfoType 1800: Industry
P1800_AF - Additional Fields: Query
P1801 - InfoType 1801: Account Assignment
P1801_AF - Additional Fields: Query
P1802 - InfoType 1802: Relevance
P1802_AF - Additional Fields: Query
P1803 - InfoType 1803: Roles
P1803_AF - Additional Fields: Query
P1804 - InfoType 1804: Details
P1804_AF - Additional Fields: Query
P1805 - InfoType 1805: Control Objective Category
P1805_AF - Additional Fields: Query
P1806 - InfoType 1806: Details
P1806_AF - Additional Fields: Query
P1810 - Infotype 1810: Risk Control Type
P1810_AF - Additional Fields: Query
P1811 - Infotype 1811: Settings: Process
P1811_AF - Additional Fields: Query
P1812 - Infotype 1812: Settings: Process Group
P1812_AF - Additional Fields: Query
P1813 - Infotype 1813: Settings: Org Unit
P1813_AF - Additional Fields: Query
P1814 - InfoType 1814: Testers
P1814_AF - Additional Fields: Query
P1815 - Infotype 1815: Settings: Local Management Control
P1815_AF - Additional Fields: Query
P1816 - Infotype 1816: Financial Statement Assertion
P1816_AF - Additional Fields: Query
P1817 - Infotype 1817: Account Group: Significance
P1817_AF - Additional Fields: Query
P1818 - Infotype 1818: Threshold Value
P1818_AF - Additional Fields: Query
P1819 - Infotype 1819: Transaction Type
P1819_AF - Additional Fields: Query
P1820 - Infotype 1820
P1820_AF - Additional Fields: Query
P1820_EXP - Infotype 1820 Expanded Structure
P1821 - Infotype 1821: Risk Impact
P1821_AF - Additional Fields: Query
P1822 - Infotype 1822: Chart of Accounts
P1822_AF - Additional Fields: Query
P1823 - Infotype 1823
P1823_AF - Additional Fields: Query
P1823_EXP - Infotype 1823 Expanded Structure
P1824 - Infotype 1824: AIS Reports
P1824_AF - Additional Fields: Query
P1880 - Infotype 1880
P1880_AF - Additional Fields for Query
P1880_EXP - Infotype 1880 Expanded Structure
P1881 - Infotype 1881: Type of Instruction
P1881_AF - Additional Fields for Query
P1882 - Infotype 1882: Description
P1882_AF - Additional Fields for Query
P1883 - Infotype 1883: Test
P1883_AF - Additional Fields for Query
P1884 - Infotype 1884: Examination
P1884_AF - Additional Fields for Query
P1885 - Infotype 1885: Didactic Schedule
P1885_AF - Additional Fields for Query
P1886 - Infotype 1886
P1886_AF - Additional Fields for Query
P1886_EXP - Infotype 1886 Expanded Structure
P1887 - Infotype 1887: Days Without Instruction
P1887_AF - Additional Fields for Query
P1888 - Infotype 1888: Exam Defaults
P1888_AF - Additional Fields for Query
P1889 - Infotype 1889
P1889_AF - Additional Fields for Query
P1889_EXP - Infotype 1889 Expanded Structure
P1890 - Infotype 1890: Payment Details - NL
P1890_AF - Additional Query Fields
P1890_EXP - Infotype 1891 expanded structures
P1891 - Infotype 1891
P1891_AF - Additional Query Fields
P1891_EXP - Infotype 1891 expanded structures
P1892 - Infotype 1892
P1892_AF - Additional Query Fields
P1892_EXP - Infotype 1892 expanded structures
P1893 - Infotype 1893
P1893_AF - Additional Query Fields
P1893_EXP - Infotype 1893 expanded structures
P1894 - Infotype 1894
P1894_AF - Additional Query Fields
P1894_EXP - Infotype 1894 expanded structures
P1896 - Infotype 1896
P1896_AF - Additional Query Fields
P1896_EXP - Infotype 1896 expanded structures
P18_01 - RGDIR with ID of period (for reports)
P18_02 - Structure for function of EE registration states
P18_03 - Cost distribution C1
P18_04 - Structure of table 2RT (copy of PC207)
P18_05 - Structure for error messages in CZMSG
P18_06 - Table for transfer - PPD coefficient calculation in 2001
P18_07 - HRCZ - structure for definition previous ER ( IT244 )
P18_AB - Structure of ABAUS - Paid illnesses
P18_ALV_PENSAV_B - Pension savings - normal/correction message - ALV log
P18_ALV_PENSAV_B_OP - ALV structure f. overpayments detail - by participant PS No.
P18_ALV_PENSAV_B_OP_PERNR - ALV structure for overpayments detail - by personnel number
P18_ALV_PENSAV_B_PERNR - Pension savings - normal/correction message - ALV log
P18_ALV_PENSAV_N - Pension savings - follow-up message - ALV log
P18_ALV_PENSAV_N_PERNR - Pension savings - follow-up message - ALV log
P18_ALV_PENSAV_OPAY_B - Pension savings - normal/correct.message overpaym. - ALV log
P18_BH - Structure table for challenge
P18_CHILD_DISPLAY - Children listing in the statement for tax relief entitlement
P18_CINSU_PERPERIOD_LINE - Conditional insurance per period
P18_DATE_PERIOD - Time period (start date - end date)
P18_DDOSSZ_DL_S - Statutory deductions - base for OSSZ (PDF form)
P18_DDOSSZ_DO_S - Other deductions - base for OSSZ (PDF form)
P18_DDOSSZ_S - Wage deductions - base for OSSZ
P18_DOSSZ_F_DET_S - Footer for PDF print - base for OSSZ
P18_DOSSZ_H_DET_S - Header for PDF print - base for OSSZ
P18_DOSSZ_I_DET_S - Items for PDF print - base for OSSZ
P18_ELDP_LINE_PERIODINFO - ELDP time period (start date - end date)
P18_ELDP_PENS_INSUR_DATUM - Pension insurance information for one day
P18_ELDP_PENS_INSUR_INFO - Pension insurance information
P18_ELDP_PENS_INSUR_PERIOD - Pension insurance information for period
P18_HZUPN_0100_ENTRY_DATA - HZUPN data record
P18_HZUPN_0100_WRKDAYS_S - Work in days
P18_HZUPN_2020 - HZUPN record (header and data)
P18_HZUPN_2020_BATCH_INFO - HZUPNi output batch info
P18_HZUPN_2020_DATA - HZUPN data record
P18_HZUPN_2020_DOCUMENT - Document data
P18_HZUPN_2020_EMPLOYER - Employment
P18_HZUPN_2020_ER_CERTIFICATE - Employer certificate
P18_HZUPN_2020_INSURED - Insured person
P18_HZUPN_2020_KEY - HZUPN cluster record (key, header and data)
P18_HZUPN_2020_WRK_IN_DAYS - Work in days
P18_HZUPN_CL - HZUPN cluster header
P18_HZUPN_CL_DATA - Data of HZUPN cluster header
P18_HZUPN_CL_DATA_KEY - Key of HZUPN cluster
P18_HZUPN_CL_XML_KEY - Key of HZUPN cluster
P18_HZUPN_INTERVAL_S - Work in days - structure
P18_HZUPN_S - HZUPN data record
P18_NEMPRI_2011 - NEMPRI record (header and data)
P18_NEMPRI_2011_APPENDIX - Attachment - second page
P18_NEMPRI_2011_BATCH_INFO - Nempri output batch info
P18_NEMPRI_2011_CONFIRMATION - Employer certificate
P18_NEMPRI_2011_DATA - NEMPRI data record
P18_NEMPRI_2011_DOCUMENT - Document data
P18_NEMPRI_2011_EMPLOYER - Employment
P18_NEMPRI_2011_INSURED - Insured person
P18_NEMPRI_2011_ITEM - Determination period item
P18_NEMPRI_2011_KEY - NEMPRI cluster record (key, header and data)
P18_NEMPRI_2011_PERIOD - Determination period
P18_NEMPRI_2011_PRINTINGONLY - Data only for print
P18_NEMPRI_2011_SCREEN - Structure for screen format NEMPRI
P18_NEMPRI_2020_ADDRESS - Payment details type Address
P18_NEMPRI_2020_BANK_CZ - Payment details type Bank account in CR
P18_NEMPRI_2020_BANK_FOREIGN - Payment details type Bank account outside of CR
P18_NEMPRI_2020_PAYMENT_METHOD - Payment details
P18_NEMPRI_CL - NEMPRI cluster header
P18_NEMPRI_CL_DATA - NEMPRI cluster header data
P18_NEMPRI_CL_DATA_KEY - NEMPRI cluster key
P18_NEMPRI_CL_XML_KEY - NEMPRI cluster key
P18_NEMPRI_S - Structure for PDF print (NEMPRI)
P18_ONZ_PROJECTION - Projection of ONZ documents
P18_OSVC_CRT_AD_S - OSVC confirmation - contact data (issued by)
P18_OSVC_CRT_DC_S - OSVC confirmation - document
P18_OSVC_CRT_EE_S - OSVC confirmation - employee
P18_OSVC_CRT_ER_S - OSVC confirmation - employer
P18_OSVC_CRT_HI - OSVC data - health insurance
P18_OSVC_CRT_MS_S - OSVC confirmation - social insurance course (since 2016)
P18_OSVC_CRT_PS_S - OSVC confirmation - social insurance course
P18_OSVC_CRT_S - Data for confirmation soc. and health insurance - OSVC
P18_P0093 - HR master data infotype 0093 (previous employer D)
P18_PENSAV_B - Data stated by individual payers - ordinary/amend. report
P18_PENSAV_B_01 - Data stated by individual payers - ordinary/amend. report
P18_PENSAV_B_02 - Data stated by individual payers - ordinary/amend. report
P18_PENSAV_B_03 - Data stated by individual payers - ordinary/amend. report
P18_PENSAV_B_XML - Data stated by individual payers - ordinary/amend. report
P18_PENSAV_B_XML_01 - Data stated by individual payers - ordinary/amend. report
P18_PENSAV_B_XML_02 - Data stated by individual payers - ordinary/amend. report
P18_PENSAV_ITEMS - Data stated by individual payers - ordinary/amend. report
P18_PENSAV_ITEMS_YS - Data acc. to individual payers - annual reporting
P18_PENSAV_I_01 - Data stated by individual payers - ordinary/amend. report
P18_PENSAV_I_02 - Data stated by individual payers - ordinary/amend. report
P18_PENSAV_I_03 - Data stated by individual payers - ordinary/amend. report
P18_PENSAV_N - Data stated by individual payers - subsequent report
P18_PENSAV_N_01 - Data stated by individual payers - subsequent report
P18_PENSAV_N_02 - Data stated by individual payers - subsequent report
P18_PENSAV_N_XML - Data stated by individual payers - subsequent report
P18_PENSAV_N_XML_01 - Data stated by individual payers - subsequent report
P18_PENSAV_N_XML_02 - Data stated by individual payers - subsequent report
P18_PENSAV_SCB_S - Overpayment breakdown for ordinary and amend.report - struc.
P18_PENSAV_TR_DATA - Structure for pension savings
P18_PS0093 - HR Master Record: Infotype 0093 (Previous Employers - D)
P18_PS_S0730 - Time entry structure
P18_PS_S0731 - Time entry structure
P18_PTK09 - Path additional information
P18_PVS - PVS - sending status
P18_PVS_STATUS - NEMPRI cluster key
P18_RPCPSDT0_0100 - Input data for run creation
P18_TAXNR_FOOT_S - Tax non-residents - items
P18_TAXNR_HEADER_S - Tax non-residents - header
P18_TAXNR_ITEM_S - Tax non-residents - items
P18_TAXNR_S - Tax non-residents - PDF output
P18_TERUP_INSPE - Insured periods
P18_TERUP_S - PDF print structure (TERUP)
P18_T_HZUPN_0100_ENTRY_DATA - HZUPN data record
Return Table index