J_3GBELK

Transparent Table Application Table
121 Fields 7 CDS Views

Document File - Header Data

J_3GBELK is an SAP database table in S/4HANA. Document File - Header Data. It contains 121 fields. 7 CDS views read from this table.

CDS Views using this table (7)

ViewTypeJoinVDMDescription
/SAPCEM/SHSM_J_3GBELK view from CDS view for search help J_3GBB
/SAPCEM/SHSM_J_3GV_J3GBE view from CDS view for search help J_3GBE
/SAPCEM/SHSM_J_3GV_J3GBM view from CDS view for search help J_3GBM
/SAPCEM/SHSM_J_3GV_J3GBV view from CDS view for search help J_3GBV
/SAPCEM/SHSM_J_3GV_J3GBV1 view from CDS view for search help J_3GV_J3GBV1
/SAPCEM/SHSM_J_3GV_J3GBW view from CDS view for search help J_3GBW
/SAPCEM/SHSM_VS2 view from CDS view for search help for /SAPCEM/VS2

Fields (121)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY j_3gbelnri J_3GBELNRI Document number
ernam ERNAM Created By
erzet ERZET Time
erdat ERDAT Created On
uname AENAM Changed By
aezet AEZET Time of change
aedtm AEDAT Changed On
j_3gabsend J_3GABSEND Sender
j_3gabsref J_3GABSREF Reference type
j_3gabspsp J_3GABSPSP WBS element
j_3gabspro J_3GABSPRO Project number
j_3gabskos J_3GABSKOS Cost center
j_3gabskok J_3GABSKOK Controllng area
j_3gabsaco J_3GABSACO Order
j_3gabsapm J_3GABSAPM Order
j_3gabswrk J_3GABSWRK Plant
j_3gabslag J_3GABSLAG StorageLocation
j_3gabsext J_3GABSEXT Ext. stp send.
j_3gabsdeb J_3GABSDEB Debtor-sender
j_3gempfae J_3GEMPFAE Recipient
j_3gempref J_3GEMPREF Reference type
j_3gemppsp J_3GEMPPSP WBS element
j_3gemppro J_3GEMPPRO Project number
j_3gempkos J_3GEMPKOS Cost center
j_3gempkok J_3GEMPKOK Controllng area
j_3gempaco J_3GEMPACO Order
j_3gempapm J_3GEMPAPM Order
j_3gempwrk J_3GEMPWRK Plant
j_3gemplag J_3GEMPLAG StorageLocation
j_3gempext J_3GEMPEXT Ext.rcpnt-rcpnt
j_3gempdeb J_3GEMPDEB Debtor-rcpnt
j_3gmittle J_3GMITTLE Intermdte rcpnt
j_3gmitref J_3GMITREF Reference type
j_3gmitpsp J_3GMITPSP WBS element
j_3gmitpro J_3GMITPRO Project number
j_3gmitkos J_3GMITKOS Cost center
j_3gmitkok J_3GMITKOK Controllng area
j_3gmitaco J_3GMITACO Order
j_3gmitapm J_3GMITAPM Order
j_3gmitwrk J_3GMITWRK Plant
j_3gmitlag J_3GMITLAG StorageLocation
j_3gfremdp J_3GFREMDP Ext. employees
pernr J_3GPERNR Personnel no.
nachn NACHN Last Name
j_3gempper J_3GEMPPER CostCtr - pers.
j_3gbelsta J_3GBELSTA Int. doc. sts
j_3gpiabs J_3GPIABS FlatRateIntSndr
j_3gpeabs J_3GPEABS FlatRateExtSndr
j_3gpiempf J_3GPIEMPS FlatRateIntRcpt
j_3gpeemps J_3GPEEMPS FlatRateExtRcpt
j_3gbetr1 J_3GBETR1 IntFltRateSndr
j_3gbetr2 J_3GBETR2 ExtFltRateSndr
j_3gbetr3 J_3GBETR3 IntFlRt - rcpnt
j_3gbetr4 J_3GBETR4 ExtFlRt - rcpnt
j_3gwaers1 J_3GWAERS1 Document curr.
j_3gwaers2 J_3GWAERS2 Document curr.
j_3gwaers3 J_3GWAERS3 Document curr.
j_3gwaers4 J_3GWAERS4 Document curr.
j_3gfaktab J_3GFAKTAB BillInd-sender
j_3gfaktem J_3GFAKTEM BillInd - rcpnt
equnr EQUNR Equipment
j_3gtplkz J_3GTPLKZ Catalog
j_3gkatnrc J_3GKATNRC No. in catalog
lfdnr J_3GLFDNR4 Sequence no.
j_3gdomlmb J_3GDOMLMB PrcgDom. P/I/D
j_3gdommb J_3GDOMMB PrcgDom. I/D
j_3gbelnr J_3GBELNR Ext. doc. no.
j_3gblart J_3GBLART Document type
j_3gbltyp J_3GBLTYP Document cat.
j_3gbeldat J_3GBELDAT Document date
vkorg /SAPCEM/VKORG Obsolete
vtweg /SAPCEM/VTWEG Obsolete
spart /SAPCEM/SPART Obsolete
inco1 INCO1 Incoterms
j_3gbeweg J_3GBEWEG Transctn type
j_3gbelste J_3GBELSTE Ext. doc. sts
slwid SLWID Field key
usr00 USRCHAR20 User field 20
usr01 USRCHAR20 User field 20
usr02 USRCHAR10 User-Def. Field
usr03 USRCHAR10 User-Def. Field
usr04 USRQUAN13 User field qty.
use04 USRUNIT User field unit
usr05 USRQUAN13 User field qty.
use05 USRUNIT User field unit
usr06 USRCURR13 User field valu
use06 USRCUKY User field unit
usr07 USRCURR13 User field valu
use07 USRCUKY User field unit
usr08 USRDATE User field date
usr09 USRDATE User field date
usr10 USRFLAG User field ind.
usr11 USRFLAG User field ind.
vname JV_NAME Joint venture
recid JV_RECIND Recovery Ind.
etype JV_ETYPE Equity Type
jv_otype JV_OTYPE JV Object Type
jv_jibcl JV_JIBCL JIB/JIBE Class
jv_jibsa JV_JIBSA JIB/JIBE SbClsA
jv_oco JV_OR_CO Or. Cost Obj.
dummy_afvu_incl_eew_ps CFD_DUMMY Dummy
sparameter1 SPARAMETER Sched. parameters
sparameter2 SPARAMETER Sched. parameters
sparameter3 SPARAMETER Sched. parameters
ilart_op ILA MaintActivType
ferc_ind FE_IND Reg. indicator
j_3gvvcom1 J_3GVVCOM Comment
j_3gvvcom2 J_3GVVCOM Comment
gsgew GSGEW Total Weight
gewei GEWEI Unit of Weight
j_3gabs_bukrs BUKRS Company Code
j_3gabs_gsber GSBER Business Area
mblnr MBLNR Material Doc.
mjahr MJAHR Mat. Doc. Year
j_3gemp_bukrs BUKRS Company Code
j_3gemp_gsber GSBER Business Area
j_3gabsnplnr NPLNR Network
j_3gabsvornr VORNR Activity
j_3gempnplnr NPLNR Network
j_3gempvornr VORNR Activity

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Document File - Header Data
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE J_3GBELK (
    MANDT,                   -- Client [MANDT]
    J_3GBELNRI,              -- Document number [J_3GBELNRI]
    ERNAM,                   -- Created By [ERNAM]
    ERZET,                   -- Time [ERZET]
    ERDAT,                   -- Created On [ERDAT]
    UNAME,                   -- Changed By [AENAM]
    AEZET,                   -- Time of change [AEZET]
    AEDTM,                   -- Changed On [AEDAT]
    J_3GABSEND,              -- Sender [J_3GABSEND]
    J_3GABSREF,              -- Reference type [J_3GABSREF]
    J_3GABSPSP,              -- WBS element [J_3GABSPSP]
    J_3GABSPRO,              -- Project number [J_3GABSPRO]
    J_3GABSKOS,              -- Cost center [J_3GABSKOS]
    J_3GABSKOK,              -- Controllng area [J_3GABSKOK]
    J_3GABSACO,              -- Order [J_3GABSACO]
    J_3GABSAPM,              -- Order [J_3GABSAPM]
    J_3GABSWRK,              -- Plant [J_3GABSWRK]
    J_3GABSLAG,              -- StorageLocation [J_3GABSLAG]
    J_3GABSEXT,              -- Ext. stp send. [J_3GABSEXT]
    J_3GABSDEB,              -- Debtor-sender [J_3GABSDEB]
    J_3GEMPFAE,              -- Recipient [J_3GEMPFAE]
    J_3GEMPREF,              -- Reference type [J_3GEMPREF]
    J_3GEMPPSP,              -- WBS element [J_3GEMPPSP]
    J_3GEMPPRO,              -- Project number [J_3GEMPPRO]
    J_3GEMPKOS,              -- Cost center [J_3GEMPKOS]
    J_3GEMPKOK,              -- Controllng area [J_3GEMPKOK]
    J_3GEMPACO,              -- Order [J_3GEMPACO]
    J_3GEMPAPM,              -- Order [J_3GEMPAPM]
    J_3GEMPWRK,              -- Plant [J_3GEMPWRK]
    J_3GEMPLAG,              -- StorageLocation [J_3GEMPLAG]
    J_3GEMPEXT,              -- Ext.rcpnt-rcpnt [J_3GEMPEXT]
    J_3GEMPDEB,              -- Debtor-rcpnt [J_3GEMPDEB]
    J_3GMITTLE,              -- Intermdte rcpnt [J_3GMITTLE]
    J_3GMITREF,              -- Reference type [J_3GMITREF]
    J_3GMITPSP,              -- WBS element [J_3GMITPSP]
    J_3GMITPRO,              -- Project number [J_3GMITPRO]
    J_3GMITKOS,              -- Cost center [J_3GMITKOS]
    J_3GMITKOK,              -- Controllng area [J_3GMITKOK]
    J_3GMITACO,              -- Order [J_3GMITACO]
    J_3GMITAPM,              -- Order [J_3GMITAPM]
    J_3GMITWRK,              -- Plant [J_3GMITWRK]
    J_3GMITLAG,              -- StorageLocation [J_3GMITLAG]
    J_3GFREMDP,              -- Ext. employees [J_3GFREMDP]
    PERNR,                   -- Personnel no. [J_3GPERNR]
    NACHN,                   -- Last Name [NACHN]
    J_3GEMPPER,              -- CostCtr - pers. [J_3GEMPPER]
    J_3GBELSTA,              -- Int. doc. sts [J_3GBELSTA]
    J_3GPIABS,               -- FlatRateIntSndr [J_3GPIABS]
    J_3GPEABS,               -- FlatRateExtSndr [J_3GPEABS]
    J_3GPIEMPF,              -- FlatRateIntRcpt [J_3GPIEMPS]
    J_3GPEEMPS,              -- FlatRateExtRcpt [J_3GPEEMPS]
    J_3GBETR1,               -- IntFltRateSndr [J_3GBETR1]
    J_3GBETR2,               -- ExtFltRateSndr [J_3GBETR2]
    J_3GBETR3,               -- IntFlRt - rcpnt [J_3GBETR3]
    J_3GBETR4,               -- ExtFlRt - rcpnt [J_3GBETR4]
    J_3GWAERS1,              -- Document curr. [J_3GWAERS1]
    J_3GWAERS2,              -- Document curr. [J_3GWAERS2]
    J_3GWAERS3,              -- Document curr. [J_3GWAERS3]
    J_3GWAERS4,              -- Document curr. [J_3GWAERS4]
    J_3GFAKTAB,              -- BillInd-sender [J_3GFAKTAB]
    J_3GFAKTEM,              -- BillInd - rcpnt [J_3GFAKTEM]
    EQUNR,                   -- Equipment [EQUNR]
    J_3GTPLKZ,               -- Catalog [J_3GTPLKZ]
    J_3GKATNRC,              -- No. in catalog [J_3GKATNRC]
    LFDNR,                   -- Sequence no. [J_3GLFDNR4]
    J_3GDOMLMB,              -- PrcgDom. P/I/D [J_3GDOMLMB]
    J_3GDOMMB,               -- PrcgDom. I/D [J_3GDOMMB]
    J_3GBELNR,               -- Ext. doc. no. [J_3GBELNR]
    J_3GBLART,               -- Document type [J_3GBLART]
    J_3GBLTYP,               -- Document cat. [J_3GBLTYP]
    J_3GBELDAT,              -- Document date [J_3GBELDAT]
    VKORG,                   -- Obsolete [/SAPCEM/VKORG]
    VTWEG,                   -- Obsolete [/SAPCEM/VTWEG]
    SPART,                   -- Obsolete [/SAPCEM/SPART]
    INCO1,                   -- Incoterms [INCO1]
    J_3GBEWEG,               -- Transctn type [J_3GBEWEG]
    J_3GBELSTE,              -- Ext. doc. sts [J_3GBELSTE]
    SLWID,                   -- Field key [SLWID]
    USR00,                   -- User field 20 [USRCHAR20]
    USR01,                   -- User field 20 [USRCHAR20]
    USR02,                   -- User-Def. Field [USRCHAR10]
    USR03,                   -- User-Def. Field [USRCHAR10]
    USR04,                   -- User field qty. [USRQUAN13]
    USE04,                   -- User field unit [USRUNIT]
    USR05,                   -- User field qty. [USRQUAN13]
    USE05,                   -- User field unit [USRUNIT]
    USR06,                   -- User field valu [USRCURR13]
    USE06,                   -- User field unit [USRCUKY]
    USR07,                   -- User field valu [USRCURR13]
    USE07,                   -- User field unit [USRCUKY]
    USR08,                   -- User field date [USRDATE]
    USR09,                   -- User field date [USRDATE]
    USR10,                   -- User field ind. [USRFLAG]
    USR11,                   -- User field ind. [USRFLAG]
    VNAME,                   -- Joint venture [JV_NAME]
    RECID,                   -- Recovery Ind. [JV_RECIND]
    ETYPE,                   -- Equity Type [JV_ETYPE]
    JV_OTYPE,                -- JV Object Type [JV_OTYPE]
    JV_JIBCL,                -- JIB/JIBE Class [JV_JIBCL]
    JV_JIBSA,                -- JIB/JIBE SbClsA [JV_JIBSA]
    JV_OCO,                  -- Or. Cost Obj. [JV_OR_CO]
    DUMMY_AFVU_INCL_EEW_PS,  -- Dummy [CFD_DUMMY]
    SPARAMETER1,             -- Sched. parameters [SPARAMETER]
    SPARAMETER2,             -- Sched. parameters [SPARAMETER]
    SPARAMETER3,             -- Sched. parameters [SPARAMETER]
    ILART_OP,                -- MaintActivType [ILA]
    FERC_IND,                -- Reg. indicator [FE_IND]
    J_3GVVCOM1,              -- Comment [J_3GVVCOM]
    J_3GVVCOM2,              -- Comment [J_3GVVCOM]
    GSGEW,                   -- Total Weight [GSGEW]
    GEWEI,                   -- Unit of Weight [GEWEI]
    J_3GABS_BUKRS,           -- Company Code [BUKRS]
    J_3GABS_GSBER,           -- Business Area [GSBER]
    MBLNR,                   -- Material Doc. [MBLNR]
    MJAHR,                   -- Mat. Doc. Year [MJAHR]
    J_3GEMP_BUKRS,           -- Company Code [BUKRS]
    J_3GEMP_GSBER,           -- Business Area [GSBER]
    J_3GABSNPLNR,            -- Network [NPLNR]
    J_3GABSVORNR,            -- Activity [VORNR]
    J_3GEMPNPLNR,            -- Network [NPLNR]
    J_3GEMPVORNR,            -- Activity [VORNR]
    PRIMARY KEY (MANDT, J_3GBELNRI)
);

Learn More