| 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 | RESWK | Supplying (Issuing) Plant in Stock Transport Order | nvarchar | 4 | 0 | CHAR | (N' ') | No | T001W | RESWK | Allow NULL? |
| 3 | EXTWG | External Material Group | nvarchar | 18 | 0 | CHAR | (N' ') | No | TWEW | EXTWG | 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 | | WDRD_RTYPE | Allow NULL? |
| 6 | CDATE | Delivery Relationship: Creation Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | WDRD_CDATE | Allow NULL? |
| 7 | DDATE | Delivery Relationship: Determination Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | WDRD_DDATE | Allow NULL? |
| 8 | METHD_S | Method for Determining Receiving Plants | char | 1 | 0 | CHAR | (N' ') | Yes | | WDRD_METHD_S | Allow NULL? |
| 9 | LEVEL_S | Level for Determining the Receiving Plants | char | 1 | 0 | NUMC | (N'0') | Yes | | WDRD_LEVEL_S | Allow NULL? |
| 10 | METHD_C | Method for Determining Receiving Customers | char | 1 | 0 | CHAR | (N' ') | Yes | | WDRD_METHD_C | Allow NULL? |
| 11 | LEVEL_C | Level for Determining Receiving Customers | char | 1 | 0 | NUMC | (N'0') | Yes | | WDRD_LEVEL_C | Allow NULL? |
| 12 | HORIZ_S | Delivery Relationship: Horizon for Document Search by Plants | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | WDRD_HORIZ_S | Allow NULL? |
| 13 | DOCTP_S | Delivery Relationship: Document Cats for Doc. Search Plants | char | 1 | 0 | CHAR | (N' ') | Yes | | WDRD_DOCTP_S | Allow NULL? |
| 14 | CHK_WRF3 | Delivery Relationship: Supplying Plant Check | char | 1 | 0 | CHAR | (N' ') | Yes | | WDRD_CHK_WRF3 | Allow NULL? |
| 15 | CHK_EORD | Delivery Relationship: Source List Check | char | 1 | 0 | CHAR | (N' ') | Yes | | WDRD_CHK_EORD | Allow NULL? |
| 16 | CHK_FRESW | Delivery Relationship: Fixed Supply Source Check | char | 1 | 0 | CHAR | (N' ') | Yes | | WDRD_CHK_FRESW | Allow NULL? |
| 17 | CHK_KORDB | Delivery Relationship: Source List Requirement Check | char | 1 | 0 | CHAR | (N' ') | Yes | | WDRD_CHK_KORDB | Allow NULL? |
| 18 | CHK_VLFKZ | Delivery Relationship: Plant Category Check | char | 1 | 0 | CHAR | (N' ') | Yes | | WDRD_CHK_VLFKZ | Allow NULL? |
| 19 | CHK_SOT | Delivery Relationship: Opening Hours Check | char | 1 | 0 | CHAR | (N' ') | Yes | | WDRD_CHK_SOT | Allow NULL? |
| 20 | CHK_WLK1 | Delivery Relationship: Listing Check | char | 1 | 0 | CHAR | (N' ') | Yes | | WDRD_CHK_WLK1 | Allow NULL? |
| 21 | CHK_BWSCL | Delivery Relationship: Source of Supply Check | char | 1 | 0 | CHAR | (N' ') | Yes | | WDRD_CHK_BWSCL | Allow NULL? |
| 22 | CHK_DISMM | Delivery Relationship: MRP Type Check | char | 1 | 0 | CHAR | (N' ') | Yes | | WDRD_CHK_DISMM | Allow NULL? |
| 23 | CHK_MMSTA | Delivery Relationship: Plant-Specific Material Status Check | char | 1 | 0 | CHAR | (N' ') | Yes | | WDRD_CHK_MMSTA | Allow NULL? |
| 24 | HORIZ_C | Delivery Relationship: Horizon for Document Search Customers | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | WDRD_HORIZ_C | Allow NULL? |
| 25 | CHK_WRSZ | Delivery Relationship: Customer Listing Check | char | 1 | 0 | CHAR | (N' ') | Yes | | WDRD_CHK_WRSZ | Allow NULL? |
| 26 | NUMBR | | nvarchar | 5 | 0 | | (N'00000') | Yes | | | Allow NULL? |
| 27 | RECIPIENTS | | ntext | 1073741823 | 0 | | | Yes | | | |