SAP Product definition Tables
Are you looking for the right table related to SAP Product definition 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 Product definition (IS-B-BCA-MD-PR) module.
Top 10 tables in Product definition
| Table | Description |
|---|---|
| TBKKH1 | Permitted Products per Bank Area |
| TBKKG1T | Text Table for Media |
| TBKKG3T | Text Table for Transaction Types |
| TBKKG2 | Features |
| FIPR_VA_FLDVAL | Version Attribute Category Field: Value Restriction |
| TBKKG4 | Functionality Group |
| TBKKG7 | Assignment Blocking Reason - Medium, Transaction Type |
| TBKKG2_DATE | Settings for Date Calculation for Periodic Feature |
| TBKKG4T | Texts for Functions Groups |
| TFIPR_ATTRTYPE | Attribute Category |
List of tables in Product definition
| Table | Description |
|---|---|
| TBKKH1 | Permitted Products per Bank Area |
| TBKKG1T | Text Table for Media |
| TBKKG3T | Text Table for Transaction Types |
| TBKKG2 | Features |
| FIPR_VA_FLDVAL | Version Attribute Category Field: Value Restriction |
| TBKKG4 | Functionality Group |
| TBKKG7 | Assignment Blocking Reason - Medium, Transaction Type |
| TBKKG2_DATE | Settings for Date Calculation for Periodic Feature |
| TBKKG4T | Texts for Functions Groups |
| TFIPR_ATTRTYPE | Attribute Category |
| FIPR_PRODUCT | Product, Master Data |
| TBKKG1_TCODEPM | Assignment Transaction to Payment Method |
| FIPR_VA_VALUE | Version Attribute Category List |
| TFIPR_PRODTYPE | Product Category |
| TFIPR_PRODAREA | Product Range |
| TBKKG31 | Return Reason, Assigned Transaction Types |
| FIPR_PARTPROD | Assignment Version Partial Product |
| FIPR_PRODV | Version of a Prodcut, Master Data |
| TBKK_PAYNT_TYP_T | Text Table for Payment Notes Categories |
| TBKKG8 | Old: Assignment Product -> Functionality Groups |
| FIPR_VA | Version Attribute |
| TBKKG52 | Assignment Functions Group -> Functions |
| TBKKG9 | Formats for Application of Funds |
| TFIPR_ATTRFUNCT | Attribute: Feature |
| TBKKG9T | Text Table Formats Payment Notes |
| TBKKG31T | Return Reason |
| FIPR_VA_FLD | Version Attribute Category Field |
| TBKKG6T | Texts for Blocking Reasons |
| TFIPR_ATTRIBUTE | Attribute |
| FIPR_PRODUCTT | Product Description |
| FIPR_VA_FLDM | Version Attribute Category Field: Multiple Value Fields |
| TBKKG34 | Transaction Types: Payment Notes for Returns |
| TBKKG1_TCODE | Assignment Transaction to Medium |
| TBKKG32 | Transaction Type Offsetting Posting Inter. Initiated PT |
| TBKKG3_TCODE | Assignment Activity to Transaction Type |
| TBKKG5 | Assignment Functions Group - Medium, Transaction Type |
| TFIPR_ATTRTREE | Attribute Hierarchy |
| TBKKG6 | Locking Reasons |
| FIPR_VA_VALUE2 | Version Attribute Category Matrix |
| TBKKG72 | Assignment Blocking Reason -> Functions |
| TBKKG1 | Media |
| TBKKG3 | Transaction types |
| TBKK48 | Old: Permitted Products per Bank Area |
| TBKKG34P | Payment Notes for Returns, Text Symbols for SAPscript |
| TBKKG34W | Display of Currency for Returns |
| TFIPR_ATTRVALUE | Attribute: List |
| TBKKG2T | Text Table for Features |
| TBKKG33 | Transaction Types: Notification of Returns |
| TFIPR_ATTRIBUTET | Description Attribute |
| TBKKG34K | Transaction Types: Payment Notes for Returns W/o Sequ.No. |
| TFIPR_KEYPREFIX | Prefix for Attributes and Products |
| TBKK_PAYNT_TYP | Table for Payment Notes Categories |
| TFIPR_ATTRFIELD | Attribute: Field |
| TFIPR_PRODAREAT | Description Product Range |
| TFIPR_ATTRTYPET | Description Attribute Category |
| TFIPR_ATTRVALUE2 | Attribute: Matrix |
| TFIPR_PRODTYPET | Description Product Category |