J_3GBELP_ALT SAP (Document Data - Item Data) Structure details
Description: Document Data - Item Data
Structure field list including key, data, relationships and ABAP select examples
J_3GBELP_ALT is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Document Data - Item Data" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_J_3GBELP_ALT TYPE J_3GBELP_ALT.
The J_3GBELP_ALT table consists of various fields, each holding specific information or linking keys about Document Data - Item Data data available in SAP. These include J_3GBELNRI (Document Number), J_3GPOSNRI (Document Item), J_3GUPOSNR (Sub-Item Number), ERNAM (Name of Person who Created the Object).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP J_3GBELP_ALT structure fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
J_3GBELNRI | Document Number | J_3GBELNRI | CHAR | 10 | J_3GBELK | ALPHA | J_3GBELNR | J2Q | J_3GB |
J_3GPOSNRI | Document Item | J_3GBELPOS | NUMC | 5 | Assigned to domain | J_3GPOSNR | |||
J_3GUPOSNR | Sub-Item Number | J_3GUPOSNR | NUMC | 2 | NUMC2 | ||||
ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | USNAM | ||||
ERZET | Entry time | ERZET | TIMS | 6 | UZEIT | ||||
ERDAT | Date on Which Record Was Created | ERDAT | DATS | 8 | DATUM | ||||
UNAME | Name of Person Who Changed Object | AENAM | CHAR | 12 | USNAM | ||||
AEZET | Time last change was made | AEZET | TIMS | 6 | UZEIT | ||||
AEDTM | Changed On | AEDAT | DATS | 8 | DATUM | ||||
J_3GABSEND | Sender | J_3GABSEND | CHAR | 10 | KNA1 | ALPHA | KUNNR | ||
J_3GABSREF | Reference Type Sender | J_3GABSREF | CHAR | 2 | J_3GREFTYP | ||||
J_3GABSPSP | WBS Element Sender | J_3GABSPSP | NUMC | 8 | PRPS | ABPSP | PS_POSNR | ||
J_3GABSPRO | Project Number Sender | J_3GABSPRO | NUMC | 8 | PROJ | KONPD | PS_PSPNR | ||
J_3GABSKOS | Cost Center Sender | J_3GABSKOS | CHAR | 10 | CSKS | ALPHA | KOSTL | ||
J_3GABSKOK | Controlling Area Sender | J_3GABSKOK | CHAR | 4 | TKA01 | CACCD | |||
J_3GABSACO | Sender of CO Order | J_3GABSACO | CHAR | 12 | AUFK | ALPHA | AUFNR | ||
J_3GABSAPM | Sender of PM Order | J_3GABSAPM | CHAR | 12 | AUFK | ALPHA | AUFNR | ||
J_3GABSWRK | Plant Sender | J_3GABSWRK | CHAR | 4 | T001W | WERKS | |||
J_3GABSLAG | Storage Location/Warehouse Sender | J_3GABSLAG | CHAR | 4 | T001L | LGORT | |||
J_3GABSEXT | External Ship-to Party - Sender | J_3GABSEXT | CHAR | 10 | KNA1 | ALPHA | KUNNR | ||
J_3GABSDEB | Debtor of Sender | J_3GABSDEB | CHAR | 10 | KNA1 | ALPHA | KUNNR | ||
J_3GEMPFAE | Recipient | J_3GEMPFAE | CHAR | 10 | KNA1 | ALPHA | KUNNR | ||
J_3GEMPREF | Receiving Reference Type | J_3GEMPREF | CHAR | 2 | J_3GREFTYP | ||||
J_3GEMPPSP | Receiving WBS Element | J_3GEMPPSP | NUMC | 8 | PRPS | ABPSP | PS_POSNR | ||
J_3GEMPPRO | Receiving Project Number | J_3GEMPPRO | NUMC | 8 | PROJ | KONPD | PS_PSPNR | ||
J_3GEMPKOS | Receiving Cost Center | J_3GEMPKOS | CHAR | 10 | CSKS | ALPHA | KOSTL | ||
J_3GEMPKOK | Receiving Controlling Area | J_3GEMPKOK | CHAR | 4 | TKA01 | CACCD | |||
J_3GEMPACO | CO Order Recipient | J_3GEMPACO | CHAR | 12 | AUFK | ALPHA | AUFNR | ||
J_3GEMPAPM | PM Order Recipient | J_3GEMPAPM | CHAR | 12 | AUFK | ALPHA | AUFNR | ||
J_3GEMPWRK | Receiving Plant | J_3GEMPWRK | CHAR | 4 | T001W | WERKS | |||
J_3GEMPLAG | Receiving Storage Location | J_3GEMPLAG | CHAR | 4 | T001L | LGORT | |||
J_3GEMPEXT | External Ship-To Party - Recipient | J_3GEMPEXT | CHAR | 10 | KNA1 | ALPHA | KUNNR | ||
J_3GEMPDEB | Debtor of Recipient | J_3GEMPDEB | CHAR | 10 | KNA1 | ALPHA | KUNNR | ||
J_3GMITTLE | Intermediate Recipient | J_3GMITTLE | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | DEBI | |
J_3GMITREF | Reference Type - Intermediate Recipient | J_3GMITREF | CHAR | 2 | J_3GREFTYP | ||||
J_3GMITPSP | WBS Element - Intermediate Recipient | J_3GMITPSP | NUMC | 8 | PRPS | ABPSP | PS_POSNR | ||
J_3GMITPRO | Project Number - Intermediate Recipient | J_3GMITPRO | NUMC | 8 | PROJ | KONPD | PS_PSPNR | ||
J_3GMITKOS | Cost Center - Intermediate Recipient | J_3GMITKOS | CHAR | 10 | CSKS | ALPHA | KOSTL | ||
J_3GMITKOK | Controlling Area - Intermediate Recipient | J_3GMITKOK | CHAR | 4 | TKA01 | CACCD | |||
J_3GMITACO | CO Order - Intermediate Recipient | J_3GMITACO | CHAR | 12 | AUFK | ALPHA | AUFNR | ||
J_3GMITAPM | PM Order Recipient | J_3GMITAPM | CHAR | 12 | AUFK | ALPHA | AUFNR | ||
J_3GMITWRK | Plant - Intermediate Recipient | J_3GMITWRK | CHAR | 4 | T001W | WERKS | |||
J_3GMITLAG | Storage Location - Intermediate Recipient | J_3GMITLAG | CHAR | 4 | T001L | LGORT | |||
J_3GFREMDP | Indicator for External Employees | J_3GFREMDP | CHAR | 1 | X | ||||
PERNR | Personal Number | J_3GPERNR | NUMC | 8 | J_3GPERNR | ||||
NACHN | Last Name | NACHN | CHAR | 25 | NACHN | ||||
J_3GEMPPER | Receiving Cost Center for Personnel | J_3GEMPPER | CHAR | 10 | KNA1 | ALPHA | KUNNR | ||
J_3GBELSTA | Internal Document Status | J_3GBELSTA | CHAR | 1 | J_3GBELSTA | ||||
J_3GPIABS | Document Flat Rate Indicator (Internal) - Sender | J_3GPIABS | CHAR | 1 | J_3GPAUSCH | ||||
J_3GPEABS | Document Flat Rate Indicator (External) - Sender | J_3GPEABS | CHAR | 1 | J_3GPAUSCH | ||||
J_3GPIEMPF | Document Flat Rate Indicator (Internal) - Recipient | J_3GPIEMPS | CHAR | 1 | J_3GPAUSCH | ||||
J_3GPEEMPS | Document Flat Rate Indicator (External) - Recipient | J_3GPEEMPS | CHAR | 1 | J_3GPAUSCH | ||||
J_3GBETR1 | Internal Flat Rate - Sender | J_3GBETR1 | CURR | 15(2) | WERTV8 | ||||
J_3GBETR2 | External Flat Rate - Sender | J_3GBETR2 | CURR | 15(2) | WERTV8 | ||||
J_3GBETR3 | Internal Flat Rate - Recipient | J_3GBETR3 | CURR | 15(2) | WERTV8 | ||||
J_3GBETR4 | External Flat Rate - Recipient | J_3GBETR4 | CURR | 15(2) | WERTV8 | ||||
J_3GWAERS1 | Currency Flat Rate Amount (Internal) - Sender | J_3GWAERS1 | CUKY | 5 | TCURC | WAERS | |||
J_3GWAERS2 | Currency Flat Rate Amount (External) - Sender | J_3GWAERS2 | CUKY | 5 | TCURC | WAERS | |||
J_3GWAERS3 | Currency Flat Rate Amount (Internal) - Recipient | J_3GWAERS3 | CUKY | 5 | TCURC | WAERS | |||
J_3GWAERS4 | Currency Flat Rate Amount (External) - Recipient | J_3GWAERS4 | CUKY | 5 | TCURC | WAERS | |||
J_3GFAKTAB | Billing Indicator - Sender | J_3GFAKTAB | CHAR | 1 | J_3GFAKTKZ | ||||
J_3GFAKTEM | Billing Indicator - Recipient | J_3GFAKTEM | CHAR | 1 | J_3GFAKTKZ | ||||
EQUNR | Equipment Number | EQUNR | CHAR | 18 | EQUI | ALPHA | EQUNR | EQN | EQUI |
J_3GTPLKZ | Catalog Code | J_3GTPLKZ | CHAR | 5 | J_3GT370S | J_3GTPLKZ | J2R | ||
J_3GKATNRC | Number in Catalog | J_3GKATNRC | CHAR | 30 | J_3GKATAL | J_3GKATNRC | J2GKAL | ||
LFDNR | Sequence Number | J_3GLFDNR4 | NUMC | 4 | NUMC4 | ||||
J_3GDOMLMB | Pricing Dominancy (Provider/Intermediate Recipient/Debtor) | J_3GDOMLMB | CHAR | 1 | J_3GDOMLMB | ||||
J_3GDOMMB | Pricing Dominancy (Intermediate Recipient/Debtor) | J_3GDOMMB | CHAR | 1 | J_3GDOMLMB | ||||
J_3GBELNR | External Document Number | J_3GBELNR | CHAR | 10 | ALPHA | J_3GBELNR | |||
J_3GPOSNR | Document Item | J_3GBELPOS | NUMC | 5 | Assigned to domain | J_3GPOSNR | |||
J_3GGRUND | Internal Indicator for Transaction Type | J_3GBEWEG | CHAR | 1 | J_3GZUABGR | J_3GBEWEG | |||
J_3GLFDNR | Sequence Number | J_3GLFDNR2 | NUMC | 2 | J_3GZUABGR | NUMC2 | |||
J_3GLVART | Activity Type | J_3GLVART | CHAR | 4 | J_3GLEIART | J_3GLVART | |||
J_3GMENGE | Quantity | J_3GMENGE | QUAN | 13(3) | MENG13 | ||||
J_3GMEINS | Unit of measure | MEINA | UNIT | 3 | T006 | CUNIT | MEINS | ||
J_3GMENGE2 | Quantity | J_3GMENGE | QUAN | 13(3) | MENG13 | ||||
J_3GMEINS2 | Unit of measure | MEINA | UNIT | 3 | T006 | CUNIT | MEINS | ||
J_3GKZLATR | Activity Type Separation | J_3GKZLATR | CHAR | 1 | J_3GKZLATR | ||||
J_3GVBELNE | Number of External Billing Document | J_3GVBELNE | CHAR | 10 | VBUK | ALPHA | VBELN | ||
EQUNR2 | Equipment Number | EQUNR | CHAR | 18 | EQUI | ALPHA | EQUNR | EQN | EQUI |
J_3GKZMENG | Item/Multipart Indicator | J_3GKZMENG | CHAR | 1 | J_3GKZMENG | ||||
MATNR | Material Number | MATNR | CHAR | 18 | MARA | MATN1 | MATNR | MAT | S_MAT1 |
J_3GGENSTA | Generation Status | J_3GGENSTA | CHAR | 1 | J_3GGENSTA | ||||
J_3GKZFRIS | Usage Period Indicator | J_3GKZFRIS | CHAR | 1 | J_3GKZFRIS | ||||
J_3GEINEND | End of Usage Period | J_3GEINEND | DATS | 8 | DATUM | ||||
J_3GDATLAB | Date of Activity Output | J_3GDATLAB | DATS | 8 | DATUM | ||||
J_3GKZLADI | Indicator: Internal Loading Costs | J_3GKZLADI | CHAR | 1 | J_3GKZLAD | ||||
J_3GKZLADE | Indicator: External (Un)Loading Costs | J_3GKZLADE | CHAR | 1 | J_3GKZLAD | ||||
J_3GKZBERG | Indicator for Provision Fees | J_3GKZBERG | CHAR | 1 | J_3GKZBERG | ||||
J_3GBESTEM | Inventory Management - Recipient | J_3GBESTEM | CHAR | 10 | KNA1 | ALPHA | KUNNR | ||
J_3GKZSPIL | Indicator: Special Price for Internal Provider of Service | J_3GKZSPIL | CHAR | 1 | J_3GKZSOPR | ||||
J_3GKZSPEL | Indicator: Special Price for External Provider of Service | J_3GKZSPEL | CHAR | 1 | J_3GKZSOPR | ||||
J_3GKZSPIB | Indicator: Special Price for Internal Recipient of Service | J_3GKZSPIB | CHAR | 1 | J_3GKZSOPR | ||||
J_3GKZSPEB | Indicator: Special Price for External Recipient of Service | J_3GKZSPEB | CHAR | 1 | J_3GKZSOPR | ||||
J_3GKZLVOI | Indicator: Calculate Internal PBE as TBE | J_3GKZLVOI | CHAR | 1 | X | ||||
J_3GKZLVOE | Indicator: Calculate external PBE as TBE | J_3GKZLVOE | CHAR | 1 | X | ||||
J_3GUMVERI | Redirection Settlement Type - Internal | J_3GUMVERI | CHAR | 4 | J_3GLEIART | J_3GLVART | |||
J_3GUMVERE | Redirection Settlement Type - External | J_3GUMVERE | CHAR | 4 | J_3GLEIART | J_3GLVART | |||
J_3GIMPT1 | Actual Value of Measuring Point | J_3GIMPT1 | CHAR | 12 | Assigned to domain | ALPHA | IMRC_POINT | ||
J_3GIMPT2 | Calculated Value of Measuring Point | J_3GIMPT2 | CHAR | 12 | Assigned to domain | ALPHA | IMRC_POINT | ||
J_3GMPOBJ | Object Number for the Measuring Point Object | IMRC_MPOBJ | CHAR | 22 | Assigned to domain | J_OBJNR | ONR | ||
J_3GMPBEG1 | Actual Start of Measuring Point | J_3GMPBEG1 | NUMC | 10 | NUM10 | ||||
J_3GMPEND1 | Actual End of Measuring Point | J_3GMPEND1 | NUMC | 10 | NUMC10 | ||||
J_3GCDIFF | Counter Reading Difference | J_3GCDIFF | NUMC | 10 | NUMC10 | ||||
J_3GMDOCM1 | Measurement Document | IMRC_MDOCM | CHAR | 20 | Assigned to domain | ALPHA | IMRC_MDOCM | IMD | IMRM |
J_3GMDOCM2 | Measurement Document | IMRC_MDOCM | CHAR | 20 | Assigned to domain | ALPHA | IMRC_MDOCM | IMD | IMRM |
J_3GIDATE | Date of the Measurement | IMRC_IDATE | DATS | 8 | DATUM | ||||
J_3GITIME | Time of Measurement | IMRC_ITIME | TIMS | 6 | UZEIT | ||||
J_3GBELSTE | External Document Status | J_3GBELSTE | CHAR | 1 | J_3GBELSTA |
Key field | Non-key field |
How do I retrieve data from SAP structure J_3GBELP_ALT using ABAP code?
As J_3GBELP_ALT is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on J_3GBELP_ALT as there is no data to select.How to access SAP table J_3GBELP_ALT
Within an ECC or HANA version of SAP you can also view further information about J_3GBELP_ALT and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects