| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | PACKNO | Package number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 3 | PLN_PACKNO | Source package number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 4 | SUMLIMIT | Overall Limit | decimal | 13 | 2 | | | | |
| 5 | SUMNOLIM | No Limit | char | 1 | 0 | | | | Allow NULL? |
| 6 | COMMITMENT | Expected Value of Overall Limit | decimal | 13 | 2 | | | | |
| 7 | ACTVALUE | Total Value of Unplanned Entered Services | decimal | 13 | 2 | | | | |
| 8 | ST_EXIT | Limits exist for service types | char | 1 | 0 | | | | Allow NULL? |
| 9 | VC_EXIST | Limit on contract items exists | char | 1 | 0 | | | | Allow NULL? |
| 10 | PK_EXIST | Limit on service packages exists | char | 1 | 0 | | | | Allow NULL? |
| 11 | PRS_CHG | Price Change in Entry Sheet | char | 1 | 0 | | | | Allow NULL? |
| 12 | RESTLIMIT | Free limit | decimal | 13 | 2 | | | | |
| 13 | RESTNOLIM | No Limit | char | 1 | 0 | | | | Allow NULL? |
| 14 | RESTACT | Actual value (from other sources) | decimal | 13 | 2 | | | | |
| 15 | WAERS | Currency Key | nvarchar | 5 | 0 | | | | Allow NULL? |
| 16 | LBNUM | Key to Service Type | nvarchar | 3 | 0 | | | | Allow NULL? |
| 17 | AUSGB | Edition of Service Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 18 | LBLIMIT | Value limits on service types | decimal | 11 | 2 | | | | |
| 19 | LBNOLIM | No limit on standard service type | char | 1 | 0 | | | | Allow NULL? |
| 20 | ACTLBLIM | "Actual" value on service type limit | decimal | 11 | 2 | | | | |
| 21 | PRS_CHG_LB | Price Change in Entry Sheet | char | 1 | 0 | | | | Allow NULL? |
| 22 | SPEC_NO | Number of a Set of Model Service Specifications | nvarchar | 10 | 0 | | | | Allow NULL? |
| 23 | SPECLIMIT | Limit on Model Service Specifications | decimal | 11 | 2 | | | | |
| 24 | PRS_CHG_MU | Price Change in Entry Sheet | char | 1 | 0 | | | | Allow NULL? |
| 25 | TMP_PROZ | Percentage for Price Determination | decimal | 3 | 1 | | | | |
| 26 | LB_PROZ | Percentage for price determination | decimal | 3 | 1 | | | | |
| 27 | CONT_PROZ | Percentage for price determination | decimal | 3 | 1 | | | | |
| 28 | SPECNOLIM | No Limit on Model Specifications | char | 1 | 0 | | | | Allow NULL? |
| 29 | ACTSPLIM | "Actual" Value on Model Specifications Limits | decimal | 11 | 2 | | | | |
| 30 | MWSKZ | Tax on sales/purchases code | nvarchar | 2 | 0 | | | | Allow NULL? |
| 31 | TXJCD | Tax Jurisdiction | nvarchar | 15 | 0 | | | | Allow NULL? |
| 32 | NAVNW | Non-deductible input tax | decimal | 13 | 2 | | | | |
| 33 | KSTAR | Cost Element | nvarchar | 10 | 0 | | | | Allow NULL? |