| 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 | * | MANDT | Allow NULL? |
| 2 | VF_PROTY | Sls Price Calc.: Type for Determining Validity Start Default | char | 1 | 0 | CHAR | (N' ') | Yes | | VALID_FROM_PROPOSAL_TYPE | Allow NULL? |
| 3 | VF_OFFDAYS | SP: Number of Days for Postdating the Validity Start Date | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | VALID_FROM_OFFSET_DAYS | Allow NULL? |
| 4 | VF_WKDAY1 | Sales Price Calculation: Weekday for Validity Start Date | char | 1 | 0 | NUMC | (N'0') | Yes | | VALID_FROM_WEEKDAY | Allow NULL? |
| 5 | VF_WKDAY2 | Sales Price Calculation: Weekday for Validity Start Date | char | 1 | 0 | NUMC | (N'0') | Yes | | VALID_FROM_WEEKDAY | Allow NULL? |
| 6 | VF_MSGTY | SP: Behaviour When Default Validity Start is Exceeded | char | 1 | 0 | CHAR | (N' ') | Yes | | VALID_FROM_MSTYPE | Allow NULL? |
| 7 | EKERV | Default Value for PP Determ. Seq. in Internal Article Maint. | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | PP_DETSEQ_FOR_ARTMASTER | Allow NULL? |
| 8 | VKERV | Default Value for SP Determ. Seq. in Internal Article Maint. | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | SP_DETSEQ_FOR_ARTMASTER | Allow NULL? |
| 9 | REFSITE_PRC | Use Reference Plant Data in Price Determination | char | 1 | 0 | CHAR | (N' ') | Yes | | REFSITE_IN_PRICING_SET | Allow NULL? |
| 10 | MGAME_PO | SP: Minimum Standard Purchase Order Quantity for Pricing | decimal | 13 | 3 | QUAN | ((0)) | Yes | | MINIMUM_PO_QUANTITY | |
| 11 | MGAME_M_INTVEND | SP: Qty in Purch. Price Determination for Internal Vendors | decimal | 13 | 3 | QUAN | ((0)) | Yes | | DEFQUANT_PRICING_M_INT_VENDOR | |
| 12 | MGAME_V_INTVEND | SP: Qty in Sales Price Dtermination for Internal Vendors | decimal | 13 | 3 | QUAN | ((0)) | Yes | | DEFQUANT_PRICING_V_INT_VENDOR | |
| 13 | KALVG | Document schema for determining calculation schema | char | 1 | 0 | CHAR | (N' ') | Yes | TVKV | W_KALVG | Allow NULL? |
| 14 | MULTIPLE_PRICING | Multiple Price Determination in Retail Pricing | char | 1 | 0 | CHAR | (N' ') | Yes | | RETAIL_MULTIPLE_PRICING | Allow NULL? |
| 15 | WRF_PPGAT | Price Point Group Assignment Category | char | 1 | 0 | CHAR | (N' ') | Yes | | WRF_PPGAT | Allow NULL? |