SAP Table FIPR_PRODUCT
Product, Master Data
FIPR_PRODUCT (Product, Master Data) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link FIPR_PRODUCT to other SAP tables.
Source: FIPR_PRODUCT (Product, Master Data)
FIPR_PRODUCT table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||
|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||
| PRODINT | Internal Product ID | FIPR_PRODINT | CHAR | 18 | 0 | |||
| PRODEXT | External Product ID | FIPR_PRODEXT | CHAR | 10 | 0 | |||
| PRODAREA | Product Range | FIPR_PRODAREA | TFIPR_PRODAREA | CHAR | 4 | 0 | ||
| PRODTYPE | Product Category | FIPR_PRODTYPE | CHAR | 4 | 0 | |||
| MOTHER | Parent Product | FIPR_MOTHERPR | CHAR | 18 | 0 | |||
| XCANBEMOTHER | Indicator: Can Have Subsidiary Products | FIPR_XCANBEMOTHER | CHAR | 1 | 0 | |||
| XCANBEUSED | Indicator Can Form Instances | FIPR_XCANBEUSED | CHAR | 1 | 0 | |||
| XCANBEPART | Indicator: Can Be Partial Product | FIPR_XCANBEPART | CHAR | 1 | 0 | |||
| BEGRU | Authorization Group | BEGRU | CHAR | 4 | 0 | |||
| PRODUCT_OLD | Old Product Number | FIPR_PRODUCT_OLD | CHAR | 20 | 0 | |||
| PCRUSER | User Who Created Product | FIPR_PCRUSER | CHAR | 12 | 0 | |||
| PCRDATE | Date on Which Product Was Created | FIPR_PCRDATE | DATS | 8 | 0 | |||
| PCRTIME | Time at Which Product Was Created | FIPR_PCRTIME | TIMS | 6 | 0 | |||
FIPR_PRODUCT foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| FIPR_PRODUCT | MANDT | FIPR_PRODUCT | MANDT | T000 | Clients | MANDT |
| FIPR_PRODUCT | PRODAREA | FIPR_PRODUCT | MANDT | TFIPR_PRODAREA | Product Range | MANDT |
| FIPR_PRODUCT | PRODAREA | FIPR_PRODUCT | PRODAREA | TFIPR_PRODAREA | Product Range | PRODAREA |
