| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | T000 | MANDT | Allow NULL? |
| 2 | FAMNR | Identification Number for Price Family | nvarchar | 10 | 0 | CHAR | (N' ') | No | WPFAM | WPF_FAMNR | Allow NULL? |
| 3 | GRP01 | Number of a Family Group in a Price Family | nvarchar | 10 | 0 | CHAR | (N' ') | No | | WPF_GROUP | Allow NULL? |
| 4 | RMATN | Price Family: Reference Material of Family Group | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | MARA | WPF_RMATN | Allow NULL? |
| 5 | VRKME | Sales Unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | W_VRKME_VKP | Allow NULL? |
| 6 | MODKZ | Price Family: Indicator for Permitted Price Change | char | 1 | 0 | CHAR | (N' ') | Yes | | WPF_MODKZ | Allow NULL? |
| 7 | GPRKZ | Price Group Rounding Allowed for Family Grp of Price Family | char | 1 | 0 | CHAR | (N' ') | Yes | | WPF_GPRKZ | Allow NULL? |
| 8 | PRELS | Price Family: Indicator for Price Relationship | char | 1 | 0 | CHAR | (N' ') | Yes | | WPF_PRELS | Allow NULL? |
| 9 | KBETR | Amount for the Price Relationship for a Family Group | decimal | 11 | 2 | CURR | ((0)) | Yes | | KBETR_PRELS | |
| 10 | KONWA | Rate unit (currency or percentage) | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | KONWA | Allow NULL? |
| 11 | OLDFL | Different Dist.-Chain-Specific Price Relationship (X = Yes) | char | 1 | 0 | CHAR | (N' ') | Yes | | WPF_OLDFL | Allow NULL? |