| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | RECORDNO | Price protection due list record number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 3 | LOTNO | DRM lot number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 4 | MSBOOKPARTNO | Manufacturer book part number | nvarchar | 18 | 0 | | | | Allow NULL? |
| 5 | MATERIAL | Material Number | nvarchar | 18 | 0 | | | | Allow NULL? |
| 6 | TRACK_PARTNER | Tracking partner | nvarchar | 10 | 0 | | | | Allow NULL? |
| 7 | PARTNER | Business Partner Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 8 | SALES_ORG | Sales Organization | nvarchar | 4 | 0 | | | | Allow NULL? |
| 9 | DIST_CHNL | Distribution Channel | nvarchar | 2 | 0 | | | | Allow NULL? |
| 10 | DIVISION | Division | nvarchar | 2 | 0 | | | | Allow NULL? |
| 11 | PURCH_ORG | Purchasing Organization | nvarchar | 4 | 0 | | | | Allow NULL? |
| 12 | PLANT | Plant | nvarchar | 4 | 0 | | | | Allow NULL? |
| 13 | LOTTYPE | DRM lot type | char | 1 | 0 | | | | Allow NULL? |
| 14 | END_CUST | DRM end customer | nvarchar | 10 | 0 | | | | Allow NULL? |
| 15 | PPCLMQTY | Price protection claim quantity | decimal | 15 | 3 | | | | |
| 16 | QTY_UNIT | Base Unit of Measure | nvarchar | 3 | 0 | | | | Allow NULL? |
| 17 | OLDPRCUNIT | Old price protectable price pricing unit | decimal | 5 | 0 | | | | |
| 18 | OLDCONDRATE | Old price protectable price | decimal | 11 | 2 | | | | |
| 19 | OLDCONDCURR | Old price protectable price currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 20 | OLDCONDNR | Nr for converting old PP condition units to base units | decimal | 5 | 0 | | | | |
| 21 | OLDCONDDR | Dr for converting old PP condition units to base units | decimal | 5 | 0 | | | | |
| 22 | OLDCONDUOM | Pricing unit of measure | nvarchar | 3 | 0 | | | | Allow NULL? |
| 23 | NEWPRCUNIT | New price protectable price pricing unit | decimal | 5 | 0 | | | | |
| 24 | NEWCONDRATE | New price protectable price | decimal | 11 | 2 | | | | |
| 25 | NEWCONDCURR | New price protectable price currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 26 | NEWCONDNR | Nr for converting new PP condition units to base units | decimal | 5 | 0 | | | | |
| 27 | NEWCONDDR | Dr for converting new PP condition units to base units | decimal | 5 | 0 | | | | |
| 28 | NEWCONDUOM | Pricing unit of measure | nvarchar | 3 | 0 | | | | Allow NULL? |
| 29 | OLDPPTYPE | Old Price Protection Type | char | 1 | 0 | | | | Allow NULL? |
| 30 | PPTYPE | New Price Protection Type | char | 1 | 0 | | | | Allow NULL? |
| 31 | PPAMOUNT | Price protection claim amount | decimal | 15 | 2 | | | | |
| 32 | PPAMTCURR | Price protection claim amount currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 33 | PPCLM_STATUS | Price protection claim processing status | char | 1 | 0 | | | | Allow NULL? |
| 34 | PPRVLQTY | Lot quantity eligible for revaluation | decimal | 15 | 3 | | | | |
| 35 | PPRVLAMT | Price protection revaluation amount | decimal | 15 | 2 | | | | |
| 36 | PPRVLAMTCURR | Currency of Revaluation amount | nvarchar | 5 | 0 | | | | Allow NULL? |
| 37 | PPRVL_STATUS | price protection related inventory revaluation status | char | 1 | 0 | | | | Allow NULL? |
| 38 | PPANNO | Price protection announcement number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 39 | PPEFFDATE | Price protection effective date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 40 | PPRUNNO | DRM collective processing number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 41 | PPRUNGRPNO | DRM claim processing group number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 42 | PPRUNDATE | Price protection run date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 43 | PP_SLS_DOCQTY | Price protection qty in the credit/debit memo request | decimal | 15 | 3 | | | | |
| 44 | PP_SLS_DOCAMT | Price protection amount in the credit/debit memo request | decimal | 15 | 2 | | | | |
| 45 | PP_SLS_DOCCURR | Currency of the credit/debit memo request amount | nvarchar | 5 | 0 | | | | Allow NULL? |
| 46 | PP_INV_DOCQTY | Price protection claim invoiced quantity | decimal | 15 | 3 | | | | |
| 47 | PP_INV_DOCAMT | Price protection claim invoiced amount | decimal | 15 | 2 | | | | |
| 48 | PP_INV_DOCCURR | Currency for the price protection claim invoced amount | nvarchar | 5 | 0 | | | | Allow NULL? |
| 49 | LS_PPCLMDOC | Logical system of price protection claim document | nvarchar | 10 | 0 | | | | Allow NULL? |
| 50 | PP_SLS_DOCNO | Price protection credit/ debit memo request number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 51 | PP_SLS_DOCITM | Price protection credit/ debit memo request item number | nvarchar | 6 | 0 | | | | Allow NULL? |
| 52 | ABGRU | Reason for rejection of quotations and sales orders | nvarchar | 2 | 0 | | | | Allow NULL? |
| 53 | PP_INV_DOCNO | Price protection credit/ debit memo number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 54 | PP_INV_DOCITM | Price protection credit/ debit memo item number | nvarchar | 6 | 0 | | | | Allow NULL? |
| 55 | RULE_RUNNO | Price Protection creation run no | nvarchar | 10 | 0 | | | | Allow NULL? |
| 56 | CANCEL_DOCTYP | Cancellation document type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 57 | CANCEL_DOCNO | Cancellation document number | nvarchar | 12 | 0 | | | | Allow NULL? |
| 58 | CANCEL_DOCITM | Cancellation document item number | nvarchar | 6 | 0 | | | | Allow NULL? |
| 59 | CANCEL_DOCDATE | Cancellation document date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 60 | CANCEL_RUN_DATE | Cancellation run date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 61 | CANCEL_IND | Cancellation indicator for audit trail | char | 1 | 0 | | | | Allow NULL? |
| 62 | CANCEL_INVNO | Cancellation invoice number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 63 | CANCEL_INVITM | Cancellation Invoice item number | nvarchar | 6 | 0 | | | | Allow NULL? |
| 64 | CANCEL_INVDATE | Cancellation invoice date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 65 | REJ_REASON | Reason for rejection of quotations and sales orders | nvarchar | 2 | 0 | | | | Allow NULL? |
| 66 | LS_PPRVLDOC | Logical system of price protection revaluation document | nvarchar | 10 | 0 | | | | Allow NULL? |
| 67 | PPRVLDOCNO | Price protection revaluation document number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 68 | PPRVLDOCYR | Document year of Revaluation document | nvarchar | 4 | 0 | | | | Allow NULL? |
| 69 | PPRVLPOST | Posting period of Revaluation document | nvarchar | 3 | 0 | | | | Allow NULL? |
| 70 | LS_REFDOC | Logical system of reference document | nvarchar | 10 | 0 | | | | Allow NULL? |
| 71 | REF_DOC_NO | Reference document number | nvarchar | 12 | 0 | | | | Allow NULL? |
| 72 | REF_DOC_ITM | Reference document item number | nvarchar | 6 | 0 | | | | Allow NULL? |
| 73 | REF_DOC_TYPE | Document type used for price calculation | nvarchar | 4 | 0 | | | | Allow NULL? |
| 74 | UPDTPRC | Price Update Indicator | char | 1 | 0 | | | | Allow NULL? |
| 75 | LOGHANDLE | Application Log: Log Handle | nvarchar | 22 | 0 | | | | Allow NULL? |
| 76 | MS_DR_IND | Indicates manufacturer/supplier or distributor/reseller lot | char | 1 | 0 | | | | Allow NULL? |
| 77 | CREATED_BY | Name of Person who Created the Object | nvarchar | 12 | 0 | | | | Allow NULL? |
| 78 | CREATED_DT | Created on | nvarchar | 8 | 0 | | | | Allow NULL? |
| 79 | CREATED_TM | Time created | nvarchar | 6 | 0 | | | | Allow NULL? |
| 80 | LASTCHGDBY | Last Changed By | nvarchar | 12 | 0 | | | | Allow NULL? |
| 81 | LASTCHGDDT | Changed On | nvarchar | 8 | 0 | | | | Allow NULL? |
| 82 | CHANGED_TM | Last changed at | nvarchar | 6 | 0 | | | | Allow NULL? |
| 83 | DUMMY_1 | Dummy function in length 1 | char | 1 | 0 | | | | Allow NULL? |
