SAP Pricing and Conditions Tables
Are you looking for the right table related to SAP Pricing and Conditions 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 Pricing and Conditions (SD-BF-PR) module.
Top 10 tables in Pricing and Conditions
| Table | Description |
|---|---|
| VOFMS_ENH_OPTN_T | Definition of Process Enhancement Options - Texts |
| VFPRCC_VIEW_FCGC | Pricing View - Field Configuration |
| KONV | Conditions (Obsolete - replaced by PRCD_ELEMENTS) |
| VFPRCC_TREE_DTLS | Replace Details Screens in Pricing View |
| KONV_SUPPL_DATA | Data table for supplementary KONV data |
| T683 | Pricing procedures |
| PRCD_ELEMENTS | Pricing Elements |
| VFPRCC_TERMST_AT | Profile-Specific Term Status Attributes |
| VFPRCC_UE_META_S | Meta Data of Pricing User Exits |
| VFPRCC_PERIST_AT | Profile-Specific Term Status Attributes |
List of tables in Pricing and Conditions
| Table | Description |
|---|---|
| VOFMS_ENH_OPTN_T | Definition of Process Enhancement Options - Texts |
| VFPRCC_VIEW_FCGC | Pricing View - Field Configuration |
| KONV | Conditions (Obsolete - replaced by PRCD_ELEMENTS) |
| VFPRCC_TREE_DTLS | Replace Details Screens in Pricing View |
| KONV_SUPPL_DATA | Data table for supplementary KONV data |
| T683 | Pricing procedures |
| PRCD_ELEMENTS | Pricing Elements |
| VFPRCC_TERMST_AT | Profile-Specific Term Status Attributes |
| VFPRCC_UE_META_S | Meta Data of Pricing User Exits |
| VFPRCC_PERIST_AT | Profile-Specific Term Status Attributes |
| T683U | Conditions: Procedure (Text) |
| PIQC_PREP_FLD_S | Pricing prepare: Sources for KOMK/KOMP fields (SAP delivery) |
| VOFMS_ENH_OPTN | Definition of Process Enhancement Options |
| T683T | Pricing Procedures: Texts |
| VFPRCC_UERATTR_S | Relevant attributes of pricing user exits (SAP delivery) |
| PIQC_FIELD_LST_S | Display Standard Fields |
| VFPRCC_UE_META_C | Meta Data of Pricing User Exits |
| VFPRCC_TREE_TXTC | Pricing View - Tree Node Text |
| T683V | Pricing Procedures: Determination in Sales Docs. |
| VFPRCC_CNPRP_M_C | Condition Purposes (Customer) |
| VFPRCC_QTY_REF | Assign Adjusted Quantity and Adjustment Factor |
| VFPRCC_PRCE2VIEW | Pricing Elements to View Mapping |
| VFPRCC_VIEW_TTXT | View Type Texts |
| T683S_VARIANT | Processing Variant Definition of a Procedure (Pricing,...) |
| PIQC_PREP_FLD_C | Define Customer-Specific Sources |
| PIQC_PREP_KEY_S | Pricing prepare: Keys for KOMK/KOMP fields (SAP delivery) |
| TVKV | Document classification for pricing procedure determination |
| VFPRCC_CNPRP_S | Target Fields for Condition Purposes (SAP Delivery) |
| PRC_MIG_PARAMS | Parameters for Pricing migration reports |
| T684S | Condition Exclusion: Procedure Assignment |
| VFPRCC_VIEW_REG | Pricing View Definition |
| VFPRCC_VIEW_TXTC | Pricing View Name Override |
| PRC_MIG_LOG | Pricing Migration Log |
| VFPRCC_UERATTR_C | Relevant attributes of pricing user exits (Customer) |
| PIQC_FIELD_TXT_C | Define Labels of Result Fields |
| KONV_SUPPL_LINK | Link table for supplementary KONV data |
| PIQC_PREP_KEY_C | Pricing prepare: Keys for KOMK/KOMP fields (Customer) |
| VOFMC_RTN_NMBR | Registration of a Formula Number |
| VOFMS_ENH_TASK_T | Definition of Process Enhancement Tasks - Texts |
| VFPRCC_TREE_TXT | Pricing View - Tree Node Text |
| VFPRCC_TREE_DTLP | Profiles for Replacement of Details Screens in Pricing View |
| VOFMC_RTN_NMBR_T | Registration of a Formula Number - Texts |
| PRCD_ELEM_DRAFT | Pricing Elements Draft |
| VFPRCC_CNPRP_S_T | Condition Purposes: Texts (SAP Delivery) |
| PIQC_FLD_TXT2_C | Define Labels of Result Fields (Pricing Procedures Specific) |
| VFPRCC_TREE_NCGC | Pricing View - Tree Node Configuration |
| VFPRCC_VIEW_DET | Pricing View Determination |
| VOFMS_RTN_RANGE | Routine Number Ranges |
| VFPRCC_VIEW_TXT | Pricing View Name |
| VOFMS_ENH_SCOPE | Process Enhancement Option Scope |
| VFPRCC_TREE_WCGC | Pricing View - Tree Width in Percent |
| VOFMS_ENH_TASK | Definition of Process Enhancement Tasks |
| VFPRCC_VIEW_FCG | Pricing View - Field Configuration |
| PIQC_BADIRELATTR | Relevant attributes of pricing user exists (Customer) |
| PIQC_FIELD_TXT_S | Fields for SD Price List : Descriptions |
| VFPRCC_COND2VIEW | Pricing Condition Type to View Mapping |
| VFPRCC_VIEW_TYPE | View Type Values |
| T684G | Condition Exclusion Groups: Condition Types |
| PIQC_FIELD_LST_C | Define Customer-Specific Fields |
| PIQC_DB_ALIAS_C | Define Customer-Specific Table Aliases |
| VFPRCC_CNPRP_C_T | Condition Purposes: Texts (Customer) |
| PIQC_PRICELIST | Settings for SD Price List FTP Upload |
| VFPRCC_FORMST_AT | Profile-Specific Formula Status Attributes |
| VFPRCC_PROFILE | Definition of the Pricing UI Profile |
| PIQC_TABMETADT_S | Display Standard Table Metadata |
| PIQC_API_CALLER | Registration for callers of PriceInquiry API |
| VFPRCC_TREE_NCG | Pricing View - Tree Node Configuration |
| VFPRCC_CNPRP_C | Target Fields for Condition Purposes (Customer) |
| PIQC_DB_ALIAS_S | Display Standard Table Aliases |
| VFPRCC_VIEW_ASGN | Pricing View - Allowed View Assignment |
| T683S | Pricing Procedure: Data |
| TVKD | Customer classification for pricing procedure determination |
| PIQC_TABMETADT_C | Define Customer-Specific Table Relations |
| VFPRCC_CNPRP_M_S | Condition Purposes (SAP Delivery) |
| T684T | Condition exclusion: Texts |
| VFPRCC_PROFILE_T | Pricing UI Profile Text |
| VOFMC_RTN_ASSG | Mapping Table |
| T684 | Condition Exclusion Groups |