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

P1844 - Infotype 1844: KRI template attributes

P1844_AF - Additional Query Fields

P1845 - Infotype 1845: OU Currency & Risk Appt

P1845_AF - Additional Query Fields

P1846 - Infotype 1846

P1846_AF - Additional Query Fields

P1846_EXP - Infotype 1846 expanded structures

P1847 - Infotype 1847: Activity Category Attributes

P1847_AF - Additional Query Fields

P1848 - Infotype 1848: Underlying Risk

P1848_AF - Additional Query Fields

P1849 - Infotype 1849: KRI Implementation Attr

P1849_AF - Additional Query Fields

P1850 - Infotype 1850: KRI Instance attr

P1850_AF - Additional Query Fields

P1851 - Infotype 1851: KRI Selection Attr

P1851_AF - Additional Query Fields

P1852 - Infotype 1852: Role Assignment

P1852_AF - Additional Query Fields

P1853 - Infotype 1853: Risk Attributes

P1853_AF - Additional Query Fields

P1855 - Infotype 1855

P1855_AF - Additional Query Fields

P1855_EXP - Infotype 1855 expanded structures

P1856 - Infotype 1856

P1856_AF - Additional Query Fields

P1856_EXP - Infotype 1856 expanded structures

P1857 - Infotype 1857: Risk Correlation

P1857_AF - Additional Query Fields

P1858 - Infotype 1858: Incident and Loss Attr

P1858_AF - Additional Query Fields

P1859 - Infotype 1859: Risk Classification Attr

P1859_AF - Additional Query Fields

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

P1897 - Infotype 1897: Context

P1897_AF - Additional Query Fields

P1898 - Infotype 1898: KRI Business Rule Attr

P1898_AF - Additional Query Fields

P1899 - Infotype 1899: KRI Business Rule Mapping

P1899_AF - Additional Query Fields

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