| 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 | RESDB | Issuing MRP Area | nvarchar | 10 | 0 | CHAR | (N' ') | No | MDLG | MDRD_RESDB | Allow NULL? |
| 3 | MATKL | Material Group | nvarchar | 9 | 0 | CHAR | (N' ') | No | T023 | MATKL | Allow NULL? |
| 4 | MATNR | Material Number | nvarchar | 18 | 0 | CHAR | (N' ') | No | MARA | MATNR | Allow NULL? |
| 5 | RTYPE | Delivery Relationship: Type of Goods Recipient | char | 1 | 0 | CHAR | (N' ') | No | | MDRD_RTYPE | Allow NULL? |
| 6 | CDATE | Delivery Relationship: Creation Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | MDRD_CDATE | Allow NULL? |
| 7 | DDATE | Delivery Relationship: Determination Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | MDRD_DDATE | Allow NULL? |
| 8 | METHD_M | Method for Determining Supplied MRP Areas | char | 1 | 0 | CHAR | (N' ') | Yes | | MDRD_METHD_M | Allow NULL? |
| 9 | LEVEL_M | Level for Determining Supplied MRP Areas | char | 1 | 0 | NUMC | (N'0') | Yes | | MDRD_LEVEL_M | Allow NULL? |
| 10 | HORIZ_M | Delivery Relationship: Horizon for MRP Areas Document Search | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | MDRD_HORIZ_M | Allow NULL? |
| 11 | DOCTP_M | Delivery Relationship: Doc. Categs for MRP Areas Doc. Srch | char | 1 | 0 | CHAR | (N' ') | Yes | | MDRD_DOCTP_M | Allow NULL? |
| 12 | CHK_DISMM | Delivery Relationship: MRP Type Check | char | 1 | 0 | CHAR | (N' ') | Yes | | MDRD_CHK_DISMM | Allow NULL? |
| 13 | CHK_BWSCL | Delivery Relationship: Source of Supply Check | char | 1 | 0 | CHAR | (N' ') | Yes | | MDRD_CHK_BWSCL | Allow NULL? |
| 14 | NUMBR | | nvarchar | 5 | 0 | | (N'00000') | Yes | | | Allow NULL? |
| 15 | RECIPIENTS | | ntext | 1073741823 | 0 | | | Yes | | | |
