EBSEG SAP (Doc.Segment of Fin.Accntng External Documents) Table details

Dictionary Type: Table
Description: Doc.Segment of Fin.Accntng External Documents




ABAP Code to SELECT data from EBSEG
Related tables to EBSEG
Access table EBSEG




Table field list including key, data, relationships and ABAP select examples

EBSEG is a standard SAP Table which is used to store Doc.Segment of Fin.Accntng External Documents data and is available within R/3 SAP systems depending on the version and release level.

The EBSEG table consists of various fields, each holding specific information or linking keys about Doc.Segment of Fin.Accntng External Documents data available in SAP. These include GLSBK (Name of global company code), BELNR (Accounting Document Number), GJAHR (Fiscal Year), GLEBK (Name of global company code).. 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: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP EBSEG table 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
MANDTClient MANDTCLNT3T000MANDT
GLSBKName of global company code BUKRS_GLOBCHAR6Assigned to domainBUKRS_GLOB
BELNRAccounting Document Number BELNR_DCHAR10ALPHABELNRBLN
GJAHRFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
GLEBKName of global company code BUKRS_GLOBCHAR6Assigned to domainBUKRS_GLOB
BUZEINumber of Line Item Within Accounting Document BUZEINUMC3BUZEIBUZ
ESBKRCompany Code Receiving External Documents ICPEBCHAR4T001BUKRS
BUZIDIdentification of the Line Item BUZIDCHAR1CHAR1
BSCHLPosting Key BSCHLCHAR2TBSLBSCHL
SHKZGDebit/Credit Indicator SHKZGCHAR1SHKZG
GSBERReceiving Business Area in Local System ICPSGCHAR4TGSBGSBER
GLBERGlobally unique business area GSBER_GLOBCHAR4Assigned to domainGSBER_GLOB
PARGBReceiving Business Area of Customer/Vendor ICPPGCHAR4TGSBGSBER
MWSKZTax on sales/purchases code MWSKZCHAR2T007AMWSKZ
DMBTRAmount in Local Currency DMBTRCURR13(2) WERT7
DMBE2Amount in Second Local Currency DMBE2CURR13(2) WERT7
DMBE3Amount in Third Local Currency DMBE3CURR13(2) WERT7
WRBTRAmount in document currency WRBTRCURR13(2) WERT7
MWSTSTax Amount in Local Currency MWSTSCURR13(2) WERT7
MWST2Tax Amount in Second Local Currency MWST2CURR13(2) WERT7
MWST3Tax Amount in Third Local Currency MWST3CURR13(2) WERT7
WMWSTTax amount in document currency WMWSTCURR13(2) WERT7
MWARTTax Type MWARTCHAR1MWART
TXGRPGroup Indicator for Tax Line Items TXGRPNUMC3NUM03
KURSRHedged Exchange Rate KURSRDEC9(5) KURSP
GBETRHedged Amount in Foreign Currency GBETRCURR13(2) WERT7
VALUTValue date VALUTDATS8DATUM
ZUONRAssignment Number DZUONRCHAR18ZUONR
SGTXTItem Text SGTXTCHAR50TEXT50
VBUNDCompany ID of trading partner RASSCCHAR6T880ALPHARCOMPPGS
BEWARTransaction Type RMVCTCHAR3T856RMVCT
ALTKTAccount Number in Group ALTKTCHAR10ALPHAALTKT
VORGNTransaction Type for General Ledger VORGNCHAR4VORGN
KOKRSControlling Area KOKRSCHAR4TKA01CACCDCAC
KOSTLCost Center KOSTLCHAR10Assigned to domainALPHAKOSTLKOS
AUFNROrder Number AUFNRCHAR12AUFKALPHAAUFNRANR
VBELNBilling Document VBELN_VFCHAR10VBUKALPHAVBELNVF
VBEL2Sales Document VBELN_VACHAR10VBUKALPHAVBELNAUN
POSN2Sales Document Item POSNR_VANUMC6VBUPPOSNRAPO
ANLN1Main Asset Number ANLN1CHAR12ANLHALPHAANLN1AN1
ANLN2Asset Subnumber ANLN2CHAR4ANLAALPHAANLN2AN2
ANBWAAsset Transaction Type ANBWACHAR3TABWBWASL
BZDATAsset value date BZDATDATS8DATUM
DABRZReference Date for Settlement DABRBEZDATS8DDAT
PERNRPersonnel Number PERNR_DNUMC8PERNRPER
XSKRLIndicator: Line item not liable to cash discount? XSKRLCHAR1XFELD
XAUTOIndicator: Line item automatically created XAUTOCHAR1XFELD
SAKNRG/L Account Number SAKNRCHAR10SKB1ALPHASAKNRSAKC_SAKNR
BVTYPPartner Bank Type BVTYPCHAR4BVTYP
ABPERSettlement period ABPER_RFACCP6BUPER
VRSKZInsurance indicator VRSKZCHAR1CHAR1
VRSDTInsurance date VRSDTDATS8DATUM
MATNRMaterial Number MATNRCHAR18MARAMATN1MATNRMATS_MAT1
WERKSPlant WERKS_DCHAR4T001WWERKSWRKH_T001W_C
MENGEQuantity MENGE_DQUAN13(3) MENG13
MEINSBase Unit of Measure MEINSUNIT3T006CUNITMEINS
ELIKZ'Delivery Completed' Indicator ELIKZCHAR1XFELD
BWTARValuation Type BWTAR_DCHAR10T149DBWTARBWT
EGBLDCountry of Destination for Delivery of Goods EGBLDCHAR3T005LAND1
EGLLDSupplying Country for Delivery of Goods EGLLDCHAR3T005LAND1
PRCTRProfit Center PRCTRCHAR10Assigned to domainALPHAPRCTRPRCPRCTR_EMPTY
VNAMEJoint Venture JV_NAMECHAR6T8JVALPHAJV_NAMEJVV
RECIDRecovery Indicator JV_RECINDCHAR2T8JJALPHAJV_RECIND
EGRUPEquity group JV_EGROUPCHAR3T8JFALPHAJV_EGROUPGJE
VPTNRPartner account number JV_PARTCHAR10KNA1ALPHAKUNNR
TXJCDTax Jurisdiction TXJCDCHAR15TTXJTXJCDTXJ
IMKEYInternal Key for Real Estate Object IMKEYCHAR8IMKEY
KSTRGCost Object KSTRGCHAR12Assigned to domainKSTRGKTR
NPLNRNetwork Number for Account Assignment NPLNRCHAR12Assigned to domainALPHAAUFNRNET
AUFPLRouting number of operations in the order CO_AUFPLNUMC10AUFPL
PAOBJNRProfitability Segment Number (CO-PA) RKEOBJNRNUMC10RKEOBJNR
PASUBNRProfitability segment changes (CO-PA) RKESUBNRNUMC4RKESUBNR
BTYPEPayroll Type JV_BILINDCHAR2T8JAALPHAJV_BILIND
ETYPEEquity type JV_ETYPECHAR3T8JEALPHAJV_ETYPE
XEGDRIndicator: Triangular deal within the EU ? XEGDRCHAR1XFELD
LNRANSequence number of asset line items in fiscal year LNRANNUMC5Assigned to domainLNRAN
KUNNRCustomer Number of an External Company Code ICPKNRCHAR10ICPKNR
LIFNRVendor Number of an External Company Code ICPLFRCHAR10ICPLFR
HWMETMethod with Which the Local Currency Amount Was Determined HWMETCHAR1HWMET
STBUKTax Company Code STBUKCHAR4Assigned to domainBUKRSBUK
PROJKInput Field for PS_PSP_PNR ICPPSCHAR24ICPPS
GLPGBGlobally unique business area GSBER_GLOBCHAR4Assigned to domainGSBER_GLOB
.INCLU--AP 0
PRODPER JVA_PROD_MONTHACCP6BUPER

Key field Non-key field



How do I retrieve data from SAP table EBSEG using ABAP code

The following ABAP code Example will allow you to do a basic selection on EBSEG to SELECT all data from the table
DATA: WA_EBSEG TYPE EBSEG.

SELECT SINGLE *
FROM EBSEG
INTO CORRESPONDING FIELDS OF WA_EBSEG
WHERE...

How to access SAP table EBSEG

Within an ECC or HANA version of SAP you can also view further information about EBSEG and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!