J_3GBELK

Transparent Table Application Table
39 Fields 7 CDS Views

Document File - Header Data

J_3GBELK is an SAP database table in S/4HANA. Document File - Header Data. It contains 39 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 (39)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY j_3gbelnri j_3gbelnri Document number
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_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
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]
    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_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]
    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