SAP table J_3GBELK (Document File - Header Data)

SAP table J_3GBELK has 2 primary key fields being MANDT,J_3GBELNRI.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
J_3GBELNRI Document Number CHAR 10 0 J_3GBELNRI
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
ERZET Entry time TIMS 6 0 ERZET
ERDAT Date on which the record was created DATS 8 0 ERDAT
UNAME Name of Person Who Changed Object CHAR 12 0 AENAM
AEZET Time last change was made TIMS 6 0 AEZET
AEDTM Last Changed On DATS 8 0 AEDAT
J_3GABSEND Sender CHAR 10 0 KNA1 J_3GABSEND
J_3GABSREF Reference Type Sender CHAR 2 0 J_3GABSREF
J_3GABSPSP WBS Element Sender NUMC 8 0 PRPS J_3GABSPSP
J_3GABSPRO Project Number Sender NUMC 8 0 PROJ J_3GABSPRO
J_3GABSKOS Cost Center Sender CHAR 10 0 CSKS J_3GABSKOS
J_3GABSKOK Controlling Area Sender CHAR 4 0 TKA01 J_3GABSKOK
J_3GABSACO Sender of CO Order CHAR 12 0 AUFK J_3GABSACO
J_3GABSAPM Sender of PM Order CHAR 12 0 AUFK J_3GABSAPM
J_3GABSWRK Plant Sender CHAR 4 0 T001W J_3GABSWRK
J_3GABSLAG Storage Location/Warehouse Sender CHAR 4 0 T001L J_3GABSLAG
J_3GABSEXT External Ship-to Party - Sender CHAR 10 0 KNA1 J_3GABSEXT
J_3GABSDEB Debtor of Sender CHAR 10 0 KNA1 J_3GABSDEB
J_3GEMPFAE Recipient CHAR 10 0 KNA1 J_3GEMPFAE
J_3GEMPREF Receiving Reference Type CHAR 2 0 J_3GEMPREF
J_3GEMPPSP Receiving WBS Element NUMC 8 0 PRPS J_3GEMPPSP
J_3GEMPPRO Receiving Project Number NUMC 8 0 PROJ J_3GEMPPRO
J_3GEMPKOS Receiving Cost Center CHAR 10 0 CSKS J_3GEMPKOS
J_3GEMPKOK Receiving Controlling Area CHAR 4 0 TKA01 J_3GEMPKOK
J_3GEMPACO CO Order Recipient CHAR 12 0 AUFK J_3GEMPACO
J_3GEMPAPM PM Order Recipient CHAR 12 0 AUFK J_3GEMPAPM
J_3GEMPWRK Receiving Plant CHAR 4 0 T001W J_3GEMPWRK
J_3GEMPLAG Receiving Storage Location CHAR 4 0 T001L J_3GEMPLAG
J_3GEMPEXT External Ship-To Party - Recipient CHAR 10 0 KNA1 J_3GEMPEXT
J_3GEMPDEB Debtor of Recipient CHAR 10 0 KNA1 J_3GEMPDEB
J_3GMITTLE Intermediate Recipient CHAR 10 0 KNA1 J_3GMITTLE
J_3GMITREF Reference Type - Intermediate Recipient CHAR 2 0 J_3GMITREF
J_3GMITPSP WBS Element - Intermediate Recipient NUMC 8 0 PRPS J_3GMITPSP
J_3GMITPRO Project Number - Intermediate Recipient NUMC 8 0 PROJ J_3GMITPRO
J_3GMITKOS Cost Center - Intermediate Recipient CHAR 10 0 CSKS J_3GMITKOS
J_3GMITKOK Controlling Area - Intermediate Recipient CHAR 4 0 TKA01 J_3GMITKOK
J_3GMITACO CO Order - Intermediate Recipient CHAR 12 0 AUFK J_3GMITACO
J_3GMITAPM PM Order Recipient CHAR 12 0 AUFK J_3GMITAPM
J_3GMITWRK Plant - Intermediate Recipient CHAR 4 0 T001W J_3GMITWRK
J_3GMITLAG Storage Location - Intermediate Recipient CHAR 4 0 T001L J_3GMITLAG
J_3GFREMDP Indicator for External Employees CHAR 1 0 J_3GFREMDP
PERNR Personal Number NUMC 8 0 * J_3GPERNR
NACHN Last Name CHAR 25 0 NACHN
J_3GEMPPER Receiving Cost Center for Personnel CHAR 10 0 KNA1 J_3GEMPPER
J_3GBELSTA Internal Document Status CHAR 1 0 J_3GBELSTA
1 Normal
2 SD Partial Order Created
3 SD Order Created
4 Deleted
5 Cancelled
7 Parked
9 Withdrawal Processed
A No SD Order Created
S Location Setup Completed
J_3GPIABS Document Flat Rate Indicator (Internal) - Sender CHAR 1 0 J_3GPIABS
J_3GPEABS Document Flat Rate Indicator (External) - Sender CHAR 1 0 J_3GPEABS
J_3GPIEMPF Document Flat Rate Indicator (Internal) - Recipient CHAR 1 0 J_3GPIEMPS
J_3GPEEMPS Document Flat Rate Indicator (External) - Recipient CHAR 1 0 J_3GPEEMPS
J_3GBETR1 Internal Flat Rate - Sender CURR 15 2 J_3GBETR1
J_3GBETR2 External Flat Rate - Sender CURR 15 2 J_3GBETR2
J_3GBETR3 Internal Flat Rate - Recipient CURR 15 2 J_3GBETR3
J_3GBETR4 External Flat Rate - Recipient CURR 15 2 J_3GBETR4
J_3GWAERS1 Currency Flat Rate Amount (Internal) - Sender CUKY 5 0 TCURC J_3GWAERS1
J_3GWAERS2 Currency Flat Rate Amount (External) - Sender CUKY 5 0 TCURC J_3GWAERS2
J_3GWAERS3 Currency Flat Rate Amount (Internal) - Recipient CUKY 5 0 TCURC J_3GWAERS3
J_3GWAERS4 Currency Flat Rate Amount (External) - Recipient CUKY 5 0 TCURC J_3GWAERS4
J_3GFAKTAB Billing Indicator - Sender CHAR 1 0 J_3GFAKTAB
J_3GFAKTEM Billing Indicator - Recipient CHAR 1 0 J_3GFAKTEM
EQUNR Equipment Number CHAR 18 0 EQUI EQUNR
J_3GTPLKZ Catalog Code CHAR 5 0 J_3GT370S J_3GTPLKZ
J_3GKATNRC Number in Catalog CHAR 30 0 J_3GKATAL J_3GKATNRC
LFDNR Sequence Number NUMC 4 0 J_3GLFDNR4
J_3GDOMLMB Pricing Dominancy (Provider/Intermediate Recipient/Debtor) CHAR 1 0 J_3GDOMLMB
1 Sender (provider of service)
2 Intermediate recipient
3 Recipient (recipient of service)
J_3GDOMMB Pricing Dominancy (Intermediate Recipient/Debtor) CHAR 1 0 J_3GDOMMB
J_3GBELNR External Document Number CHAR 10 0 J_3GBELNR
J_3GBLART Document Type CHAR 4 0 J_3GBELART J_3GBLART
J_3GBLTYP CEM Document Category CHAR 1 0 J_3GBLTYP
1 PBE document
2 Shipping document
J_3GBELDAT CEM Document Date DATS 8 0 J_3GBELDAT
VKORG Sales Organization, but Obsolete CHAR 4 0 TVKO /SAPCEM/VKORG
VTWEG Distribution Channel, but Obsolete CHAR 2 0 TVTW /SAPCEM/VTWEG
SPART Division, but Obsolete CHAR 2 0 TSPA /SAPCEM/SPART
INCO1 Incoterms (Part 1) CHAR 3 0 TINC INCO1
J_3GBEWEG Internal Indicator for Transaction Type CHAR 1 0 J_3GBEWEG
No shipping document
1 Acquisition
2 Retirement
3 Change of activity type
4 Shipping
J_3GBELSTE External Document Status CHAR 1 0 J_3GBELSTE
SLWID Key word ID for user-defined fields CHAR 7 0 TCN00 SLWID
USR00 User field with 20 characters CHAR 20 0 USRCHAR20
USR01 User field with 20 characters CHAR 20 0 USRCHAR20
USR02 User Field with 10 Characters CHAR 10 0 USRCHAR10
USR03 User Field with 10 Characters CHAR 10 0 USRCHAR10
USR04 User field for quantity (length 10.3) QUAN 13 3 USRQUAN13
USE04 User field: Unit for quantity fields UNIT 3 0 T006 USRUNIT
USR05 User field for quantity (length 10.3) QUAN 13 3 USRQUAN13
USE05 User field: Unit for quantity fields UNIT 3 0 T006 USRUNIT
USR06 User-defined field for values (length 10,3) CURR 13 3 USRCURR13
USE06 User field: Unit for value fields CUKY 5 0 TCURC USRCUKY
USR07 User-defined field for values (length 10,3) CURR 13 3 USRCURR13
USE07 User field: Unit for value fields CUKY 5 0 TCURC USRCUKY
USR08 User field for date DATS 8 0 USRDATE
USR09 User field for date DATS 8 0 USRDATE
USR10 User-defined field: Indicator for reports CHAR 1 0 USRFLAG
USR11 User-defined field: Indicator for reports CHAR 1 0 USRFLAG
VNAME Joint venture CHAR 6 0 T8JV JV_NAME
RECID Recovery Indicator CHAR 2 0 T8JJ JV_RECIND
ETYPE Equity type CHAR 3 0 T8JG JV_ETYPE
JV_OTYPE Joint Venture Object Type CHAR 4 0 JV_OTYPE
JV_JIBCL JIB/JIBE Class CHAR 3 0 T8J6A JV_JIBCL
JV_JIBSA JIB/JIBE Subclass A CHAR 5 0 T8J6C JV_JIBSA
JV_OCO JV original cost object CHAR 1 0 JV_OR_CO
DUMMY_AFVU_INCL_EEW_PS Custom Fields: Dummy for Use in Extension Includes CHAR 1 0 CFD_DUMMY
SPARAMETER1 Scheduling Parameters for External Scheduling CHAR 4 0 SPARAMETER
SPARAMETER2 Scheduling Parameters for External Scheduling CHAR 4 0 SPARAMETER
SPARAMETER3 Scheduling Parameters for External Scheduling CHAR 4 0 SPARAMETER
ILART_OP Maintenance activity type CHAR 3 0 ILA
FERC_IND Regulatory indicator CHAR 4 0 FERC_C7 FE_IND
J_3GVVCOM1 Comment CHAR 40 0 J_3GVVCOM
J_3GVVCOM2 Comment CHAR 40 0 J_3GVVCOM
GSGEW Total Weight QUAN 15 3 GSGEW
GEWEI Weight Unit UNIT 3 0 GEWEI
J_3GABS_BUKRS Company Code CHAR 4 0 BUKRS
J_3GABS_GSBER Business Area CHAR 4 0 GSBER
MBLNR Number of Material Document CHAR 10 0 MBLNR
MJAHR Material Document Year NUMC 4 0 MJAHR
J_3GEMP_BUKRS Company Code CHAR 4 0 BUKRS
J_3GEMP_GSBER Business Area CHAR 4 0 GSBER
J_3GABSNPLNR Network Number for Account Assignment CHAR 12 0 NPLNR
J_3GABSVORNR Operation/Activity Number CHAR 4 0 VORNR
J_3GEMPNPLNR Network Number for Account Assignment CHAR 12 0 NPLNR
J_3GEMPVORNR Operation/Activity Number CHAR 4 0 VORNR

J_3GBELK foreign key relationships

Table Field Check Table Check Field
0 J_3GBELK EQUNR EQUI Equipment master data MANDT
1 J_3GBELK ETYPE T8JG Valid Investment Group MANDT
1 J_3GBELK ETYPE T8JG Valid Investment Group BUKRS
1 J_3GBELK ETYPE T8JG Valid Investment Group VNAME
1 J_3GBELK ETYPE T8JG Valid Investment Group FDATE
0 J_3GBELK FERC_IND FERC_C7 Regulatory indicators MANDT
0 J_3GBELK FERC_IND FERC_C7 Regulatory indicators IND
1 J_3GBELK INCO1 TINC Customers: Incoterms INCO1
0 J_3GBELK JV_JIBCL T8J6A JIB/JIBE Class MANDT
0 J_3GBELK JV_JIBCL T8J6A JIB/JIBE Class BUKRS
0 J_3GBELK JV_JIBCL T8J6A JIB/JIBE Class CLASS
1 J_3GBELK JV_JIBSA T8J6C JIB/JIBE Subclass MANDT
1 J_3GBELK JV_JIBSA T8J6C JIB/JIBE Subclass BUKRS
0 J_3GBELK J_3GABSACO AUFK Order master data AUFNR
1 J_3GBELK J_3GABSAPM AUFK Order master data AUFNR
0 J_3GBELK J_3GABSDEB KNA1 General Data in Customer Master MANDT
0 J_3GBELK J_3GABSDEB KNA1 General Data in Customer Master KUNNR
1 J_3GBELK J_3GABSEND KNA1 General Data in Customer Master MANDT
1 J_3GBELK J_3GABSEND KNA1 General Data in Customer Master KUNNR
0 J_3GBELK J_3GABSEXT KNA1 General Data in Customer Master MANDT
0 J_3GBELK J_3GABSEXT KNA1 General Data in Customer Master KUNNR
1 J_3GBELK J_3GABSKOK TKA01 Controlling Areas MANDT
0 J_3GBELK J_3GABSKOS CSKS Cost Center Master Record MANDT
0 J_3GBELK J_3GABSKOS CSKS Cost Center Master Record KOKRS
0 J_3GBELK J_3GABSKOS CSKS Cost Center Master Record KOSTL
0 J_3GBELK J_3GABSKOS CSKS Cost Center Master Record DATBI
1 J_3GBELK J_3GABSLAG T001L Storage Locations MANDT
1 J_3GBELK J_3GABSLAG T001L Storage Locations WERKS
0 J_3GBELK J_3GABSPRO PROJ Project definition MANDT
0 J_3GBELK J_3GABSPRO PROJ Project definition PSPNR
1 J_3GBELK J_3GABSPSP PRPS WBS (Work Breakdown Structure) Element Master Data MANDT
1 J_3GBELK J_3GABSPSP PRPS WBS (Work Breakdown Structure) Element Master Data PSPNR
0 J_3GBELK J_3GABSWRK T001W Plants/Branches MANDT
0 J_3GBELK J_3GABSWRK T001W Plants/Branches WERKS
1 J_3GBELK J_3GEMPACO AUFK Order master data AUFNR
0 J_3GBELK J_3GEMPAPM AUFK Order master data AUFNR
1 J_3GBELK J_3GEMPDEB KNA1 General Data in Customer Master MANDT
1 J_3GBELK J_3GEMPDEB KNA1 General Data in Customer Master KUNNR
0 J_3GBELK J_3GEMPEXT KNA1 General Data in Customer Master MANDT
0 J_3GBELK J_3GEMPEXT KNA1 General Data in Customer Master KUNNR
1 J_3GBELK J_3GEMPFAE KNA1 General Data in Customer Master MANDT
1 J_3GBELK J_3GEMPFAE KNA1 General Data in Customer Master KUNNR
0 J_3GBELK J_3GEMPKOK TKA01 Controlling Areas MANDT
1 J_3GBELK J_3GEMPKOS CSKS Cost Center Master Record MANDT
1 J_3GBELK J_3GEMPKOS CSKS Cost Center Master Record KOKRS
1 J_3GBELK J_3GEMPKOS CSKS Cost Center Master Record DATBI
0 J_3GBELK J_3GEMPLAG T001L Storage Locations MANDT
0 J_3GBELK J_3GEMPLAG T001L Storage Locations WERKS
1 J_3GBELK J_3GEMPPER KNA1 General Data in Customer Master MANDT
1 J_3GBELK J_3GEMPPER KNA1 General Data in Customer Master KUNNR
0 J_3GBELK J_3GEMPPRO PROJ Project definition MANDT
0 J_3GBELK J_3GEMPPRO PROJ Project definition PSPNR
1 J_3GBELK J_3GEMPPSP PRPS WBS (Work Breakdown Structure) Element Master Data MANDT
1 J_3GBELK J_3GEMPPSP PRPS WBS (Work Breakdown Structure) Element Master Data PSPNR
0 J_3GBELK J_3GEMPWRK T001W Plants/Branches WERKS
1 J_3GBELK J_3GKATNRC J_3GKATAL Catalog J_3GKATNRC
0 J_3GBELK J_3GMITACO AUFK Order master data AUFNR
1 J_3GBELK J_3GMITAPM AUFK Order master data AUFNR
0 J_3GBELK J_3GMITKOK TKA01 Controlling Areas MANDT
1 J_3GBELK J_3GMITKOS CSKS Cost Center Master Record MANDT
1 J_3GBELK J_3GMITKOS CSKS Cost Center Master Record KOKRS
1 J_3GBELK J_3GMITKOS CSKS Cost Center Master Record KOSTL
1 J_3GBELK J_3GMITKOS CSKS Cost Center Master Record DATBI
0 J_3GBELK J_3GMITLAG T001L Storage Locations MANDT
0 J_3GBELK J_3GMITLAG T001L Storage Locations WERKS
1 J_3GBELK J_3GMITPRO PROJ Project definition MANDT
1 J_3GBELK J_3GMITPRO PROJ Project definition PSPNR
0 J_3GBELK J_3GMITPSP PRPS WBS (Work Breakdown Structure) Element Master Data MANDT
0 J_3GBELK J_3GMITPSP PRPS WBS (Work Breakdown Structure) Element Master Data PSPNR
1 J_3GBELK J_3GMITTLE KNA1 General Data in Customer Master MANDT
1 J_3GBELK J_3GMITTLE KNA1 General Data in Customer Master KUNNR
0 J_3GBELK J_3GMITWRK T001W Plants/Branches WERKS
1 J_3GBELK J_3GTPLKZ J_3GT370S Structure Indicator for Catalog J_3GTPLKZ
0 J_3GBELK J_3GWAERS1 TCURC Currency Codes MANDT
0 J_3GBELK J_3GWAERS1 TCURC Currency Codes WAERS
1 J_3GBELK J_3GWAERS2 TCURC Currency Codes MANDT
1 J_3GBELK J_3GWAERS2 TCURC Currency Codes WAERS
0 J_3GBELK J_3GWAERS3 TCURC Currency Codes MANDT
0 J_3GBELK J_3GWAERS3 TCURC Currency Codes WAERS
1 J_3GBELK J_3GWAERS4 TCURC Currency Codes MANDT
1 J_3GBELK J_3GWAERS4 TCURC Currency Codes WAERS
0 J_3GBELK MANDT T000 Clients MANDT
1 J_3GBELK RECID T8JJ Recovery Indicator MANDT
1 J_3GBELK RECID T8JJ Recovery Indicator BUKRS
0 J_3GBELK SLWID TCN00 Key Word ID for PS User Fields MANDT
1 J_3GBELK SPART TSPA Organizational Unit: Sales Divisions MANDT
1 J_3GBELK SPART TSPA Organizational Unit: Sales Divisions SPART
0 J_3GBELK USE04 T006 Units of Measurement MANDT
1 J_3GBELK USE05 T006 Units of Measurement MANDT
0 J_3GBELK USE06 TCURC Currency Codes MANDT
0 J_3GBELK USE06 TCURC Currency Codes WAERS
1 J_3GBELK USE07 TCURC Currency Codes MANDT
1 J_3GBELK USE07 TCURC Currency Codes WAERS
0 J_3GBELK VKORG TVKO Organizational Unit: Sales Organizations MANDT
0 J_3GBELK VKORG TVKO Organizational Unit: Sales Organizations VKORG
1 J_3GBELK VNAME T8JV Joint Venture MANDT
1 J_3GBELK VNAME T8JV Joint Venture BUKRS
1 J_3GBELK VNAME T8JV Joint Venture VNAME
0 J_3GBELK VTWEG TVTW Organizational Unit: Distribution Channels MANDT
0 J_3GBELK VTWEG TVTW Organizational Unit: Distribution Channels VTWEG