/BEV3/CH1030BSG1 SAP (Document Segment CH Event Ledger Part1) Table details

Dictionary Type: Table
Description: Document Segment CH Event Ledger Part1




ABAP Code to SELECT data from /BEV3/CH1030BSG1
Related tables to /BEV3/CH1030BSG1
Access table /BEV3/CH1030BSG1




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

/BEV3/CH1030BSG1 is a standard SAP Table which is used to store Document Segment CH Event Ledger Part1 data and is available within R/3 SAP systems depending on the version and release level.

The /BEV3/CH1030BSG1 table consists of various fields, each holding specific information or linking keys about Document Segment CH Event Ledger Part1 data available in SAP. These include EVENT (Event for export of business data), EVENT_NR (CH BTE Sequence Number of Event Receipt), BUZEI (Number of Line Item Within Accounting Document), BUKRS (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 /BEV3/CH1030BSG1 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 MANDTCLNT3Assigned to domainMANDT
EVENTEvent for export of business data BUS_EVENTCHAR8Assigned to domainBUS_EVENT
EVENT_NRCH BTE Sequence Number of Event Receipt /BEV3/CHEVENRNUMC16/BEV3/CHEVENR
BUZEINumber of Line Item Within Accounting Document BUZEINUMC3BUZEIBUZ
BUKRSCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
BELNRAccounting Document Number BELNR_DCHAR10ALPHABELNRBLN
GJAHRFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
BUZIDIdentification of the Line Item BUZIDCHAR1CHAR1
AUGDTClearing Date AUGDTDATS8DATUM
AUGCPClearing Entry Date AUGCPDATS8DATUM
AUGBLDocument Number of the Clearing Document AUGBLCHAR10ALPHABELNR
BSCHLPosting Key BSCHLCHAR2Assigned to domainBSCHL
KOARTAccount Type KOARTCHAR1KOART
UMSKZSpecial G/L Indicator UMSKZCHAR1Assigned to domainUMSKZ
UMSKSSpecial G/L Transaction Type UMSKSCHAR1UMSKS
ZUMSKTarget Special G/L Indicator DZUMSKCHAR1Assigned to domainUMSKZ
SHKZGDebit/Credit Indicator SHKZGCHAR1SHKZG
GSBERBusiness Area GSBERCHAR4Assigned to domainGSBERGSB
PARGBTrading partner's business area PARGBCHAR4Assigned to domainGSBERGSB
MWSKZTax on sales/purchases code MWSKZCHAR2Assigned to domainMWSKZ
QSSKZWithholding Tax Code QSSKZCHAR2Assigned to domainQSSKZ
DMBTRAmount in Local Currency DMBTRCURR13(2) WERT7
WRBTRAmount in document currency WRBTRCURR13(2) WERT7
KZBTROriginal Reduction Amount in Local Currency KZBTR_FICURR13(2) WERT7
PSWBTAmount for Updating in General Ledger PSWBTCURR13(2) WERT7
PSWSLUpdate Currency for General Ledger Transaction Figures PSWSLCUKY5Assigned to domainWAERS
TXBHWOriginal Tax Base Amount in Local Currency TXBHWCURR13(2) WERT7
TXBFWOriginal Tax Base Amount in Document Currency TXBFWCURR13(2) WERT7
MWSTSTax Amount in Local Currency MWSTSCURR13(2) WERT7
WMWSTTax amount in document currency WMWSTCURR13(2) WERT7
HWBASTax Base Amount in Local Currency HWBASCURR13(2) WERT7
FWBASTax Base Amount in Document Currency FWBASCURR13(2) WERT7
HWZUZProvision Amount in Local Currency HWZUZCURR13(2) WERT7
FWZUZAdditional Tax in Document Currency FWZUZCURR13(2) WERT7
SHZUZDebit/Credit Addition for Cash Discount SHZUZCHAR1CHAR1
STEKZVersion Number Component CHAR2CHAR2CHAR2
MWARTTax Type MWARTCHAR1MWART
TXGRPGroup Indicator for Tax Line Items TXGRPNUMC3NUM03
KTOSLTransaction Key KTOSLCHAR3CHAR3
QSSHBWithholding Tax Base Amount QSSHBCURR13(2) WERT7
KURSRHedged Exchange Rate KURSRDEC9(5) KURSP
GBETRHedged Amount in Foreign Currency GBETRCURR13(2) WERT7
BDIFFValuation Difference BDIFFCURR13(2) WRTV7
BDIF2Valuation Difference for the Second Local Currency BDIF2CURR13(2) WRTV7
VALUTValue date VALUTDATS8DATUM
ZUONRAssignment Number DZUONRCHAR18ZUONR
SGTXTItem Text SGTXTCHAR50TEXT50
ZINKZExempted from interest calculation DZINKZCHAR2ZINKZ
VBUNDCompany ID of trading partner RASSCCHAR6Assigned to domainALPHARCOMPPGS
BEWARTransaction Type RMVCTCHAR3Assigned to domainRMVCT
ALTKTGroup account number BILKT_SKA1CHAR10Assigned to domainALPHASAKNR
VORGNTransaction Type for General Ledger VORGNCHAR4VORGN
FDLEVPlanning level FDLEVCHAR2Assigned to domainFDLEVFFE
FDGRPPlanning Group FDGRPCHAR10Assigned to domainALPHAFDGRPFFG
FDWBTPlanning amount in document currency FDWBTCURR13(2) WERTV7
FDTAGPlanning date FDTAGDATS8DATUMFDT
FKONTFinancial Budget Item FIPLSNUMC3FIPLS
KOKRSControlling Area KOKRSCHAR4Assigned to domainCACCDCAC
KOSTLCost Center KOSTLCHAR10Assigned to domainALPHAKOSTLKOS
PROJNOld: Project number : No longer used --> PS_POSNR PROJNCHAR16PROJN
AUFNROrder Number AUFNRCHAR12Assigned to domainALPHAAUFNRANR
VBELNBilling Document VBELN_VFCHAR10Assigned to domainALPHAVBELNVF
VBEL2Sales Document VBELN_VACHAR10Assigned to domainALPHAVBELNAUN
POSN2Sales Document Item POSNR_VANUMC6Assigned to domainPOSNRAPO
ETEN2Delivery Schedule Line Number ETENRNUMC4Assigned to domainETENR
ANLN1Main Asset Number ANLN1CHAR12Assigned to domainALPHAANLN1AN1
ANLN2Asset Subnumber ANLN2CHAR4Assigned to domainALPHAANLN2AN2
ANBWAAsset Transaction Type ANBWACHAR3Assigned to domainBWASL
BZDATAsset value date BZDATDATS8DATUM
PERNRPersonnel Number PERNR_DNUMC8PERNRPER
XUMSWIndicator: Sales-related item ? XUMSWCHAR1XFELD
XHRESIndicator: Resident G/L account? XHRESCHAR1XFELD
XKRESIndicator: Can Line Items Be Displayed by Account? XKRESCHAR1XFELD
XOPVWIndicator: Open item management? XOPVWCHAR1XFELD
XCPDDIndicator: Address and bank data set individually XCPDDCHAR1XFELD
XSKSTIndicator: Statistical posting to cost center XSKSTCHAR1XFELD
XSAUFIndicator: Posting to order is statistical XSAUFCHAR1XFELD
XSPROIndicator: Posting to project is statistical XSPROCHAR1XFELD
XSERGIndicator: Posting to prof.analysis is statistical XSERGCHAR1XFELD
XFAKTIndicator: Billing document update successful ? XFAKTCHAR1XFELD
XUMANIndicator: Transfer posting from down payment ? XUMANCHAR1XFELD
XANETIndicator: Down payment in net procedure ? XANETCHAR1XFELD
XSKRLIndicator: Line item not liable to cash discount? XSKRLCHAR1XFELD
XINVEIndicator: Capital Goods Affected? XINVECHAR1XFELD
XPANZDisplay item XPANZCHAR1XFELD
XAUTOIndicator: Line item automatically created XAUTOCHAR1XFELD
XNCOPIndicator: Items cannot be copied? XNCOPCHAR1XFELD
XZAHLIndicator: Is the posting key used in a payment transaction? XZAHLCHAR1XFELD
SAKNRG/L Account Number SAKNRCHAR10Assigned to domainALPHASAKNRSAKC_SAKNR
HKONTGeneral Ledger Account HKONTCHAR10Assigned to domainALPHASAKNR
KUNNRCustomer Numbers KUNNRCHAR10Assigned to domainALPHAKUNNRKUNC_KUNNR
LIFNRAccount Number of Vendor or Creditor LIFNRCHAR10Assigned to domainALPHALIFNRLIFKRED_C
FILKDAccount Number of the Branch FILKDCHAR10ALPHAMAXKK
XBILKIndicator: Account is a balance sheet account? XBILKCHAR1XFELD
GVTYPP&L statement account type GVTYPCHAR2CHAR2
HZUONAssignment Number for Special G/L Accounts HZUONCHAR18ZUONR
ZFBDTBaseline Date for Due Date Calculation DZFBDTDATS8DATUM
ZTERMTerms of Payment Key DZTERMCHAR4ZTERM
ZBD1TCash discount days 1 DZBD1TDEC3ZBDXT
ZBD2TCash discount days 2 DZBD2TDEC3ZBDXT
ZBD3TNet Payment Terms Period DZBD3TDEC3ZBDXT
ZBD1PCash Discount Percentage 1 DZBD1PDEC5(3) PRZ23
ZBD2PCash Discount Percentage 2 DZBD2PDEC5(3) PRZ23
SKFBTAmount Eligible for Cash Discount in Document Currency SKFBTCURR13(2) WERT7
SKNTOCash discount amount in local currency SKNTOCURR13(2) WERT7
WSKTOCash discount amount in document currency WSKTOCURR13(2) WERT7
ZLSCHPayment Method SCHZW_BSEGCHAR1Assigned to domainZLSCH
ZLSPRPayment Block Key DZLSPRCHAR1Assigned to domainZAHLSSPE
ZBFIXFixed Payment Terms DZBFIXCHAR1ZBFIX
HBKIDShort Key for a House Bank HBKIDCHAR5Assigned to domainHBKID
BVTYPPartner Bank Type BVTYPCHAR4BVTYP
NEBTRNet Payment Amount NEBTRCURR13(2) WERT7
MWSK1Tax Code for Distribution MWSKXCHAR2Assigned to domainMWSKZ
DMBT1Amount in Local Currency for Tax Distribution DMBTXCURR13(2) WRTV7
WRBT1Amount in foreign currency for tax breakdown WRBTXCURR13(2) WRTV7
MWSK2Tax Code for Distribution MWSKXCHAR2Assigned to domainMWSKZ
DMBT2Amount in Local Currency for Tax Distribution DMBTXCURR13(2) WRTV7
WRBT2Amount in foreign currency for tax breakdown WRBTXCURR13(2) WRTV7
MWSK3Tax Code for Distribution MWSKXCHAR2Assigned to domainMWSKZ
DMBT3Amount in Local Currency for Tax Distribution DMBTXCURR13(2) WRTV7
WRBT3Amount in foreign currency for tax breakdown WRBTXCURR13(2) WRTV7
REBZGNumber of the Invoice the Transaction Belongs to REBZGCHAR10ALPHABELNR
REBZJFiscal Year of the Relevant Invoice (for Credit Memo) REBZJNUMC4GJAHRGJAHR
REBZZLine Item in the Relevant Invoice REBZZNUMC3BUZEI
REBZTFollow-On Document Type REBZTCHAR1REBZT
ZOLLTCustoms Tariff Number DZOLLTCHAR8ZOLLT
ZOLLDCustoms Date DZOLLDDATS8DATUM
LZBKZState Central Bank Indicator LZBKZCHAR3Assigned to domainLZBKZ
LANDLSupplying Country LANDLCHAR3Assigned to domainLAND1
DIEKZService Indicator (Foreign Payment) DIEKZCHAR1DIEKZ
SAMNRInvoice List Number SAMNRNUMC8SAMNR
ABPERSettlement period ABPER_RFACCP6BUPER
VRSKZInsurance indicator VRSKZCHAR1CHAR1
VRSDTInsurance date VRSDTDATS8DATUM
DISBNNumber of Bill of Exchange Usage Document (Discount Doc.) DISBNCHAR10ALPHABELNR
DISBJFiscal Year of Bill of Exchange Usage Document DISBJNUMC4GJAHRGJAHR
DISBZLine Item within the Bill of Exchange Usage Document DISBZNUMC3BUZEI
WVERWBill of exchange usage type WVERWCHAR1WVERW
ANFBNDocument Number of the Bill of Exchange Payment Request ANFBNCHAR10ALPHABELNR
ANFBJFiscal Year of the Bill of Exchange Payment Request Document ANFBJNUMC4GJAHRGJAHR
ANFBUCompany Code in Which Bill of Exch.Payment Request Is Posted ANFBUCHAR4Assigned to domainBUKRS
ANFAEBill of Exchange Payment Request Due Date ANFAEDATS8DATUM
BLNBTBase Amount for Determining the Preference Amount BLNBTCURR13(2) WERT7
BLNKZSubsidy indicator for determining the reduction rates BLNKZCHAR2Assigned to domainBLNKZ
BLNPZPreference Percentage Rate BLNPZDEC7(2) PRZ52
MSCHLDunning key MSCHLCHAR1Assigned to domainMSCHL
MANSPDunning block MANSPCHAR1Assigned to domainMANSP
MADATLast dunned on MADATDATS8DATUM
MANSTDunning level MAHNS_DNUMC1MAHNS
MABERDunning Area MABERCHAR2Assigned to domainMABER
ESRNRISR Subscriber Number ESRNRCHAR11ESRNR
ESRREISR Reference Number ESRRECHAR27ALPHAESRRE
ESRPZISR Check Digit ESRPZCHAR2CHAR2
KLIBTCredit Control Amount KLIBTCURR13(2) WERT7
QSZNRCertificate Number of the Withholding Tax Exemption QSZNRCHAR10CHAR10
QBSHBWithholding Tax Amount (in Document Currency) QBSHBCURR13(2) WERT7
QSFBTWithholding Tax-Exempt Amount (in Document Currency) QSFBTCURR13(2) WERT7
NAVHWNon-Deductible Input Tax (in Local Currency) NAVHWCURR13(2) WERT7
NAVFWNon-Deductible Input Tax (in Document Currency) NAVFWCURR13(2) WERT7
MATNRMaterial Number MATNRCHAR18Assigned to domainMATN1MATNRMATS_MAT1
WERKSPlant WERKS_DCHAR4Assigned to domainWERKSWRKH_T001W_C
MENGEQuantity MENGE_DQUAN13(3) MENG13
MEINSBase Unit of Measure MEINSUNIT3Assigned to domainCUNITMEINS
ERFMGQuantity in Unit of Entry ERFMGQUAN13(3) MENG13
ERFMEUnit of Entry ERFMEUNIT3Assigned to domainCUNITMEINS
BPMNGQuantity in Purchase Order Price Unit BPMNGQUAN13(3) MENG13
BPRMEOrder Price Unit (Purchasing) BPRMEUNIT3Assigned to domainCUNITMEINS
EBELNPurchasing Document Number EBELNCHAR10Assigned to domainALPHAEBELNBESMEKK_C
EBELPItem Number of Purchasing Document EBELPNUMC5Assigned to domainEBELPBSP
ZEKKNSequential Number of Account Assignment DZEKKNNUMC2NUM02
ELIKZ'Delivery Completed' Indicator ELIKZCHAR1XFELD
VPRSVPrice control indicator VPRSVCHAR1VPRSV
PEINHPrice Unit PEINHDEC5PACK3
BWKEYValuation Area BWKEYCHAR4Assigned to domainBWKEYBWK
BWTARValuation Type BWTAR_DCHAR10Assigned to domainBWTARBWT
BUSTWPosting string for values BUSTWCHAR4BUSTW
REWRTInvoice Value Entered (in Local Currency) REEWRCURR13(2) WRTV7
REWWRInvoice value in foreign currency REFWRCURR13(2) WRTV7
BONFBAmount Qualifying for Bonus in Local Currency BONFBCURR13(2) WERT7
BUALTAmount posted in alternative price control BUALTCURR13(2) WERTV7
PSALTAlternative Price Control PSALTCHAR1VPRSV
NPREINew price NPREICURR11(2) WERT11
TBTKZIndicator: subsequent debit/credit TBTKZCHAR1TBTKZ
SPGRPBlocking reason: price SPGRPCHAR1XFELD
SPGRMBlocking reason: quantity SPGRMCHAR1XFELD
SPGRTBlocking Reason: Date SPGRTCHAR1XFELD
SPGRGBlocking reason: order price quantity SPGRGCHAR1XFELD
SPGRVBlocking reason: project budget SPGRVCHAR1XFELD
SPGRQManual Blocking Reason SPGRQCHAR1XFELD
STCEGVAT Registration Number STCEGCHAR20STCEG
EGBLDCountry of Destination for Delivery of Goods EGBLDCHAR3Assigned to domainLAND1
EGLLDSupplying Country for Delivery of Goods EGLLDCHAR3Assigned to domainLAND1
RSTGRReason Code for Payments RSTGRCHAR3Assigned to domainRSTGR
RYACQYear of acquisition RYACQCHAR4GJAHRCJAHR
RPACQPeriod of Acquisition RPACQNUMC3NUM03
RDIFFExchange Rate Gain/Loss Realized RDIFFCURR13(2) WRTV7
RDIF2Exchange Rate Difference Realized for Second Local Currency RDIF2CURR13(2) WRTV7
PRCTRProfit Center PRCTRCHAR10Assigned to domainALPHAPRCTRPRCPRCTR_EMPTY
XHKOMIndicator: G/L account assigned manually ? XHKOMCHAR1XFELD
VNAMEJoint Venture JV_NAMECHAR6Assigned to domainALPHAJV_NAMEJVV
RECIDRecovery Indicator JV_RECINDCHAR2Assigned to domainALPHAJV_RECIND
EGRUPEquity group JV_EGROUPCHAR3Assigned to domainALPHAJV_EGROUPGJE
VPTNRPartner account number JV_PARTCHAR10Assigned to domainALPHAKUNNR
VERTTContract Type RANTYPCHAR1RANTYP
VERTNContract Number RANLCHAR13ALPHARANLRAN
VBEWAFlow Type SBEWARTCHAR4Assigned to domainSBEWART
DEPOTSecurities Account RLDEPOCHAR10Assigned to domainRLDEPODEPACC_CCD_CORE
TXJCDTax Jurisdiction TXJCDCHAR15Assigned to domainTXJCDTXJ
IMKEYInternal Key for Real Estate Object IMKEYCHAR8IMKEY
DABRZReference Date for Settlement DABRBEZDATS8DDAT
POPTSReal estate option rate POPTSATZDEC9(6) POPTSATZ
FIPOSCommitment Item FIPOSCHAR14Assigned to domainFIPOSFIP
KSTRGCost Object KSTRGCHAR12Assigned to domainKSTRGKTR
NPLNRNetwork Number for Account Assignment NPLNRCHAR12Assigned to domainALPHAAUFNRNET
AUFPLTask list number for operations in order AUFPL_CHNUMC10AUFPL
APLZLGeneral counter for order APLZL_CHNUMC8Assigned to domainCO_APLZL
PROJKWork Breakdown Structure Element (WBS Element) PS_PSP_PNRNUMC8Assigned to domainKONPRPS_POSNR
PAOBJNRProfitability Segment Number (CO-PA) RKEOBJNRNUMC10RKEOBJNR
PASUBNRProfitability segment changes (CO-PA) RKESUBNRNUMC4RKESUBNR
SPGRSBlocking Reason: Item Amount SPGRSCHAR1XFELD
SPGRCBlock.reason: quality SPGRCCHAR1XFELD
BTYPEPayroll Type JV_BILINDCHAR2Assigned to domainALPHAJV_BILIND
ETYPEEquity type JV_ETYPECHAR3Assigned to domainALPHAJV_ETYPE
XEGDRIndicator: Triangular deal within the EU ? XEGDRCHAR1XFELD
LNRANSequence number of asset line items in fiscal year LNRANNUMC5Assigned to domainLNRAN
HRKFTOrigin Group as Subdivision of Cost Element HRKFTCHAR4Assigned to domainHRKFT
DMBE2Amount in Second Local Currency DMBE2CURR13(2) WERT7
DMBE3Amount in Third Local Currency DMBE3CURR13(2) WERT7
DMB21Amount in Second Local Currency for Tax Breakdown DMB2XCURR13(2) WRTV7
DMB22Amount in Second Local Currency for Tax Breakdown DMB2XCURR13(2) WRTV7
DMB23Amount in Second Local Currency for Tax Breakdown DMB2XCURR13(2) WRTV7
DMB31Amount in Third Local Currency for Tax Breakdown DMB3XCURR13(2) WRTV7
DMB32Amount in Third Local Currency for Tax Breakdown DMB3XCURR13(2) WRTV7
DMB33Amount in Third Local Currency for Tax Breakdown DMB3XCURR13(2) WRTV7
MWST2Tax Amount in Second Local Currency MWST2CURR13(2) WERT7
MWST3Tax Amount in Third Local Currency MWST3CURR13(2) WERT7
NAVH2Non-Deductible Input Tax in Second Local Currency NAVH2CURR13(2) WERT7
NAVH3Non-Deductible Input Tax in Third Local Currency NAVH3CURR13(2) WERT7
SKNT2Cash Discount Amount in Second Local Currency SKNT2CURR13(2) WERT7
SKNT3Cash Discount Amount in Third Local Currency SKNT3CURR13(2) WERT7
BDIF3Valuation Difference for the Third Local Currency BDIF3CURR13(2) WRTV7
RDIF3Exchange Rate Difference Realized for Third Local Currency RDIF3CURR13(2) WRTV7

Key field Non-key field



How do I retrieve data from SAP table /BEV3/CH1030BSG1 using ABAP code

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

SELECT SINGLE *
FROM /BEV3/CH1030BSG1
INTO CORRESPONDING FIELDS OF WA_/BEV3/CH1030BSG1
WHERE...

How to access SAP table /BEV3/CH1030BSG1

Within an ECC or HANA version of SAP you can also view further information about /BEV3/CH1030BSG1 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!