SAP Table J_3RT1_HEAD
Goods issue-transportation note header
J_3RT1_HEAD (Goods issue-transportation note header) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link J_3RT1_HEAD to other SAP tables.
J_3RT1_HEAD table fields
Field | Data element | Checktable | Datatype | Length | Decimals | |||
---|---|---|---|---|---|---|---|---|
TKNUM | Goods issue - transportation note number | J_3RTKNUM | CHAR | 20 | 0 | |||
ERDAT | Date on Which Record Was Created | ERDAT | DATS | 8 | 0 | |||
P_DAY | Version Number Component | CHAR2 | CHAR | 2 | 0 | |||
P_MONTH | Version Number Component | CHAR2 | CHAR | 2 | 0 | |||
P_GJAHR | Fiscal Year | GJAHR | NUMC | 4 | 0 | |||
VKORG | Sales Organization | VKORG | CHAR | 4 | 0 | |||
GONAM | Char255 | CHAR255 | CHAR | 255 | 0 | |||
GOBANK | Text field length 200 | CHAR200 | CHAR | 200 | 0 | |||
GOOKPO | Character Field Length = 10 | CHAR10 | CHAR | 10 | 0 | |||
GPNUM | Ship-to party | KUNWE | CHAR | 10 | 0 | |||
GPNAM | Char255 | CHAR255 | CHAR | 255 | 0 | |||
GPBANK | Text field length 200 | CHAR200 | CHAR | 200 | 0 | |||
GPOKPO | Character Field Length = 10 | CHAR10 | CHAR | 10 | 0 | |||
PLNAM | Char255 | CHAR255 | CHAR | 255 | 0 | |||
PLBANK | Text field length 200 | CHAR200 | CHAR | 200 | 0 | |||
PLOKPO | Character Field Length = 10 | CHAR10 | CHAR | 10 | 0 | |||
EKNAM | Char255 | CHAR255 | CHAR | 255 | 0 | |||
EKBANK | Text field length 200 | CHAR200 | CHAR | 200 | 0 | |||
PONAM | char120 | CHAR120 | CHAR | 120 | 0 | |||
PRNAM | char120 | CHAR120 | CHAR | 120 | 0 | |||
BRGEW | Gross Weight | BRGEW | QUAN | 13 | 3 | |||
BRGEW_W | Character field length 50 | CHAR_50 | CHAR | 50 | 0 | |||
NTGEW | Net Weight | NTGEW | QUAN | 13 | 3 | |||
NTGEW_W | Character field length 50 | CHAR_50 | CHAR | 50 | 0 | |||
GEWEI | Weight Unit | GEWEI | T006 | UNIT | 3 | 0 | ||
TOTNAM | Character field length 50 | CHAR_50 | CHAR | 50 | 0 | |||
TOTPLC | Character field length 50 | CHAR_50 | CHAR | 50 | 0 | |||
TOTLIN | Character field length 50 | CHAR_50 | CHAR | 50 | 0 | |||
TOTSUM | Character field, length 70 | CHAR70 | CHAR | 70 | 0 | |||
NETWR | Net Value in Document Currency | NETWR | CURR | 15 | 2 | |||
WAERS | Currency Key | WAERS | TCURC | CUKY | 5 | 0 | ||
NAME1 | Name of user within the company | XUNAME1 | CHAR | 30 | 0 | |||
NAME2 | Name of user within the company | XUNAME1 | CHAR | 30 | 0 | |||
TELNR | Telephone number (work) | XUTELNR | CHAR | 16 | 0 | |||
CHIEF_ACC | 30 Characters | CHAR30 | CHAR | 30 | 0 | |||
REG_NUM | Char 15 | CHAR15 | CHAR | 15 | 0 | |||
SERIA | Char 15 | CHAR15 | CHAR | 15 | 0 | |||
NUM | Char 15 | CHAR15 | CHAR | 15 | 0 | |||
SROK_DOCT | Date | DATUM | DATS | 8 | 0 | |||
CAR_MAKE | Char 15 | CHAR15 | CHAR | 15 | 0 | |||
CAR_NUM | Char 15 | CHAR15 | CHAR | 15 | 0 | |||
CUSTOMER | Char255 | CHAR255 | CHAR | 255 | 0 | |||
DRIVER | Character field length 50 | CHAR_50 | CHAR | 50 | 0 | |||
CERTIF | 30 Characters | CHAR30 | CHAR | 30 | 0 | |||
LICENSE_TYPE | Character field length 50 | CHAR_50 | CHAR | 50 | 0 | |||
LICENSE_REGN | Char 15 | CHAR15 | CHAR | 15 | 0 | |||
LICENSE_SER | Char 15 | CHAR15 | CHAR | 15 | 0 | |||
LICENSE_NUM | Char 15 | CHAR15 | CHAR | 15 | 0 | |||
TRANSP_TYPE | Character field length 50 | CHAR_50 | CHAR | 50 | 0 | |||
TRANSP_CODE | Char 15 | CHAR15 | CHAR | 15 | 0 | |||
ROUTE | Character Field Length = 10 | CHAR10 | CHAR | 10 | 0 | |||
READDR | char120 | CHAR120 | CHAR | 120 | 0 | |||
TRAILER_1 | Char 15 | CHAR15 | CHAR | 15 | 0 | |||
TRAILER_NUM_1 | Char 15 | CHAR15 | CHAR | 15 | 0 | |||
GARAGE_1 | Char 15 | CHAR15 | CHAR | 15 | 0 | |||
TRAILER_2 | Char 15 | CHAR15 | CHAR | 15 | 0 | |||
TRAILER_NUM_2 | Char 15 | CHAR15 | CHAR | 15 | 0 | |||
GARAGE_2 | Char 15 | CHAR15 | CHAR | 15 | 0 | |||
POGRN | Character String 60 | CHAR_60 | CHAR | 60 | 0 | |||
DELIV_ALLOW_POS | 30 Characters | CHAR30 | CHAR | 30 | 0 | |||
DELIV_ALLOW_NAME | 30 Characters | CHAR30 | CHAR | 30 | 0 | |||
BRGEW_W_TO_DELIV | 30 Characters | CHAR30 | CHAR | 30 | 0 | |||
PLCN_W_TO_DELIV | 30 Characters | CHAR30 | CHAR | 30 | 0 |
J_3RT1_HEAD foreign key relationships
Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
---|---|---|---|---|---|---|
J_3RT1_HEAD | GEWEI | SYST | MANDT | T006 | Units of Measurement | MANDT |
J_3RT1_HEAD | GEWEI | J_3RT1_HEAD | GEWEI | T006 | Units of Measurement | MSEHI |
J_3RT1_HEAD | WAERS | J_3RT1_HEAD | WAERS | TCURC | Currency Codes | WAERS |
J_3RT1_HEAD | WAERS | SYST | MANDT | TCURC | Currency Codes | MANDT |