SAP Provisioning Tables
Are you looking for the right table related to SAP Provisioning Tables to query in an ABAP Program, Class, Function Module and OData API?
There are number of standard tables in SAP S/4HANA system. The data of an application is distributed across several database fields. Finding the right table is important, in this post we'll look at list of all the tables in Provisioning (IS-AD-SPC-PR) module.
Top 10 tables in Provisioning
| Table | Description |
|---|---|
| SPCIPSTAT_PART | SPEC2000: Parts |
| SPCIPSTAT_END | SPEC 2000: End Item |
| SPCIPCSN | Locations |
| SPCIPCLS | Class for aircraft parts |
| SPCIPOSDS | Optional Suppliers and Distributors |
| SPCIPSWITCH | IP Browser Switch |
| SPCIPMFR | Classification table of manufacturers |
| SPCIPOSC_D | SPEC2000: Stores deleted entries for SPCIPOSC |
| SPCIPPROFILES | Profiles for creating master data from IP |
| SPCIPPROFKEYS | Key fields and values of IP profiles |
List of tables in Provisioning
| Table | Description |
|---|---|
| SPCIPSTAT_PART | SPEC2000: Parts |
| SPCIPSTAT_END | SPEC 2000: End Item |
| SPCIPCSN | Locations |
| SPCIPCLS | Class for aircraft parts |
| SPCIPOSDS | Optional Suppliers and Distributors |
| SPCIPSWITCH | IP Browser Switch |
| SPCIPMFR | Classification table of manufacturers |
| SPCIPOSC_D | SPEC2000: Stores deleted entries for SPCIPOSC |
| SPCIPPROFILES | Profiles for creating master data from IP |
| SPCIPPROFKEYS | Key fields and values of IP profiles |
| SPCIPOSC | SPEC2000: Stores optional suppliers for the subject SPL |
| SPCIPINTERFACE | Interface IP Data - Master Data |
| SPCIPGLOBAL | Technical Settings for IP |
| SPCIPEFF | Effectivity Range |
| SPCIPRPDE | Replacing Parts / Replaced Parts |
| SPCIPPROFILEKEYS | Profile Keys for IP |
| SPCIPHDR | Stores header information for IP data |
| SPCIPHDRT | Texts for SPCIPHDR - for every SQNBR |
| SPCIPCSNT | Texts for CSN |
| SPCIPSPLMNT | SPEC2000: Stores Additional/Long/MultipleOccurance fields |
| SPCIPFIELDLIST | Display-fields for creating material master from IP |
| SPCIPOCH | Other Charges - Code & Amount |
| SPCIPSTAT | SPEC2000 : User Status Profiles for an Object Type |
| ADS2KIPBRO_CMD | SPEC 2000 IP: Key fields for master data creation |
| SPCIPPROFVALUES | Profile values of fields in master data |
| SPCIPSTAT_LOC | SPEC2000: User Status Profiles for the Object - Locations |
| SPCIPSTAT_SUPP | SPEC 2000: User Status Profiles for the Object - Suppliers |
| SPCIPPDS | SPEC2000: Procurement Data Segment |
| SPCIPPDR | Spare parts / End items |
| SPCIPCLSIF | Interface IP Data - Master Data |
| SPCIPUOA | Used On Assemblies |
| SPCIPPQA | Price Break - Quantity & Amount |
| SPCIPPROFILEST | Descriptions of profiles for creating master data from IP |
| SPCIPPARTS | Other parts that can be used |