| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | ENTNR | Recycling Partner | nvarchar | 10 | 0 | | | | Allow NULL? |
| 3 | LAND1 | Country Key | nvarchar | 3 | 0 | | | | Allow NULL? |
| 4 | VFLKL | Volume/Area Class | nvarchar | 6 | 0 | | | | Allow NULL? |
| 5 | PLTYP | Price List Item Category | char | 1 | 0 | | | | Allow NULL? |
| 6 | VFL_AB | Volume/Area from (Scale Volume/Area Class REA) | decimal | 17 | 6 | | | | |
| 7 | VFL_BIS | Volume/Area to (Scale Volume/Area Class REA) | decimal | 17 | 6 | | | | |
| 8 | VFL_ME | Condition unit | nvarchar | 3 | 0 | | | | Allow NULL? |
| 9 | GRENZGE | Weight Limit for Item-Dep.Measurement of Smallest Pack. | decimal | 13 | 3 | | | | |
| 10 | GEWEI | Weight Unit | nvarchar | 3 | 0 | | | | Allow NULL? |
| 11 | KZKLGR | Weight Limit Less / Greater / Equal | nvarchar | 2 | 0 | | | | Allow NULL? |
| 12 | PORTST | Number of Pieces in Portion Packaging (REA Vol./Area Class) | decimal | 17 | 6 | | | | |
| 13 | MEINS | Base Unit of Measure | nvarchar | 3 | 0 | | | | Allow NULL? |
| 14 | KZPORTION | Portion Packaging Indicator | char | 1 | 0 | | | | Allow NULL? |
| 15 | KZADD | Indicator for Volume/Area Class, Additive | char | 1 | 0 | | | | Allow NULL? |
| 16 | KZDIFF | Indicator for Differentiation of Volume/Area Class | char | 1 | 0 | | | | Allow NULL? |
| 17 | MATNR | Assigned Material Number | nvarchar | 18 | 0 | | | | Allow NULL? |
| 18 | SOKOA | Special Condition Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 19 | FORMEL | Formula for Fee Calculation | nvarchar | 4 | 0 | | | | Allow NULL? |
| 20 | STOFF | Partner Fraction | nvarchar | 6 | 0 | | | | Allow NULL? |
| 21 | KZ_DEFAULT | Indicator: Default Value for Creation of Master Data | char | 1 | 0 | | | | Allow NULL? |
| 22 | DATABADM | Valid-From Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 23 | DATBIADM | Valid To Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 24 | ERSDAADM | Created On | nvarchar | 8 | 0 | | | | Allow NULL? |
| 25 | ERZETADM | Time Created | nvarchar | 6 | 0 | | | | Allow NULL? |
| 26 | ERNAMADM | Name of Person who Created the Object | nvarchar | 12 | 0 | | | | Allow NULL? |
| 27 | LAEDAADM | Date of Last Change | nvarchar | 8 | 0 | | | | Allow NULL? |
| 28 | AEZETADM | Time Last Change Was Made | nvarchar | 6 | 0 | | | | Allow NULL? |
| 29 | AENAMADM | Name of Person Who Changed Object | nvarchar | 12 | 0 | | | | Allow NULL? |
| 30 | LVORMADM | Deletion Indicator | char | 1 | 0 | | | | Allow NULL? |