SAP VBSEGS Document Segment for Document Parking - G/L Account Database Table

Overview

VBSEGS is a standard SAP S/4HANA table that stores Document Segment for Document Parking - G/L Account Database data. There are total 170 fields in the VBSEGS table. The following is a list of the fields that make up this table. Key fields are marked in blue.

The table VBSEGS belongs to Financial Accounting (FI) module and is located in the package Financial Accounting "Basis" (FBAS).

In addition, following links provide an overview of foreign key relationships, if any, that link VBSEGS to other SAP tables and standard CDS views available based on VBSEGS table in S/4HANA 2020.

Techincal Settings of VBSEGS

Below are technical details of the table VBSEGS

  • Buffering not allowed
  • No buffering
  • Storage type is Column Store

List of VBSEGS Fields

The following table gives you an overview of the fields available in VBSEGS

FieldDescriptionData ElementCheck TableData TypeLength
MANDTClientMANDTT000CLNT3
AUSBKSource Company CodeAUSBKT001CHAR4
BELNRAccounting Document NumberBELNR_DCHAR10
GJAHRFiscal YearGJAHRVBKPFNUMC4
BZKEYNumber of Line Item Within Accounting DocumentBUZEINUMC3
BUKRSCompany CodeBUKRST001CHAR4
BUZEINumber of Line Item Within Accounting DocumentBUZEINUMC3
BSCHLPosting KeyBSCHLCHAR2
SHKZGDebit/Credit IndicatorSHKZGCHAR1
GSBERBusiness AreaGSBERCHAR4
PARGBTrading partner's business areaPARGBCHAR4
TAX_COUNTRYTax Reporting CountryFOT_TAX_COUNTRYCHAR3
MWSKZTax on sales/purchases codeMWSKZCHAR2
TXDATDate for Determining Tax RatesTXDATDATS8
DMBTRAmount in local currencyDMBTRCURR23
DMBE2Amount in Second Local Currency or General CurrencyDMBE2CURR23
DMBE3Amount in Third Local Currency or First Freely-Def. CurrencyDMBE3CURR23
WRBTRAmount in document currencyWRBTRCURR23
HWMETMethod with Which the Local Currency Amount Was DeterminedHWMETCHAR1
HWBASTax Base Amount in Local CurrencyHWBASCURR23
FWBASTax Base Amount in Document CurrencyFWBASCURR23
MWARTTax TypeMWARTCHAR1
KURSRHedged Exchange RateKURSRDEC9
GBETRHedged Amount in Foreign CurrencyGBETRCURR23
ZFBDTBaseline Date for Due Date CalculationDZFBDTDATS8
VALUTValue dateVALUTDATS8
ZUONRAssignment numberDZUONRCHAR18
SGTXTItem TextSGTXTCHAR50
ANBWAAsset Transaction TypeANBWACHAR3
ZINKZExempted from Interest CalculationDZINKZCHAR2
RMVCTTransaction typeRMVCTCHAR3
FDLEVPlanning LevelFDLEVCHAR2
FDGRPPlanning GroupFDGRPCHAR10
FDWBTPlanned Amount in Document or G/L Account CurrencyFDWBTCURR23
FDTAGPlanning DateFDTAGDATS8
KOKRSControlling AreaKOKRSCHAR4
KOSTLCost CenterKOSTLCHAR10
AUFNROrder NumberAUFNRCHAR12
KDAUFSales Order NumberKDAUFCHAR10
KDPOSItem number in Sales OrderKDPOSNUMC6
PPRCTRPartner Profit CenterPPRCTRCHAR10
IMKEYInternal Key for Real Estate ObjectIMKEYCHAR8
PERNRPersonnel NumberPERNR_DNUMC8
XUMSWIndicator: Sales-Related Item ?XUMSWCHAR1
XSKRLIndicator: Line Item Not Liable to Cash Discount?XSKRLCHAR1
SAKNRG/L Account NumberSAKNRCHAR10
HZUONAssignment Number for Special G/L AccountsHZUONCHAR18
LZBKZState Central Bank IndicatorLZBKZCHAR3
LANDLSupplying CountryLANDLCHAR3
MATNRMaterial NumberMATNRCHAR40
WERKSPlantWERKS_DCHAR4
MENGEQuantityMENGE_DQUAN13
MEINSBase Unit of MeasureMEINSUNIT3
BPMNGQuantity in Purchase Order Price UnitBPMNGQUAN13
EBELNPurchasing Document NumberEBELNCHAR10
EBELPItem Number of Purchasing DocumentEBELPNUMC5
REWRTInvoice Value Entered (in Local Currency)REEWRCURR13
REWWRInvoice Amount in Foreign CurrencyREWWRCURR23
ZEKKNSequential Number of Account AssignmentDZEKKNNUMC2
LFBNRNumber of goods receipt documentWEBLNCHAR10
LFPOSItem in Material DocumentMBLPONUMC4
LFGJAMaterial Document YearMJAHRNUMC4
BWKEYValuation areaBWKEYCHAR4
BWTARValuation TypeBWTAR_DCHAR10
TBTKZIndicator: Subsequent Debit/CreditTBTKZCHAR1
STCEGVAT Registration NumberSTCEGCHAR20
PRCTRProfit CenterPRCTRCHAR10
VNAMEJoint ventureJV_NAMECHAR6
RECIDRecovery IndicatorJV_RECINDCHAR2
EGRUPEquity groupJV_EGROUPCHAR3
VPTNRPartner account numberJV_PARTCHAR10
VERTTContract TypeRANTYPCHAR1
VERTNContract NumberRANLCHAR13
VBEWAFlow TypeSBEWARTCHAR4
TXJCDTax JurisdictionTXJCDCHAR15
DABRZReference date for settlementDABRBEZDATS8
KSTRGCost ObjectKSTRGCHAR12
NPLNRNetwork Number for Account AssignmentNPLNRCHAR12
AUFPLRouting number of operations in the orderCO_AUFPLNUMC10
PS_PSP_PNRWork Breakdown Structure Element (WBS Element)PS_PSP_PNRNUMC8
PAOBJNRProfitability Segment Number (CO-PA)RKEOBJNRNUMC10
PASUBNRProfitability Segment Changes (CO-PA)RKESUBNRNUMC4
BTYPEPayroll TypeJV_BILINDCHAR2
ETYPEEquity typeJV_ETYPECHAR3
XEGDRIndicator: Triangular Deal Within the EUXEGDRCHAR1
HRKFTOrigin Group as Subdivision of Cost ElementHRKFTCHAR4
FIPOSCommitment ItemFIPOSCHAR14
KOARTAccount typeKOARTCHAR1
VPRSVPrice control indicatorVPRSVCHAR1
PEINHPrice unitPEINHDEC5
KDEINSchedule Line NumberETENRNUMC4
ANLN1Main Asset NumberANLN1CHAR12
ANLN2Asset SubnumberANLN2CHAR4
SMWSKTax Category in Account Master RecordSMWSKCHAR2
SWAERCurrency KeyWAERSCUKY5
STUNRStep NumberSTUNRNUMC3
ZAEHKCondition CounterDZAEHKNUMC3
XFDISIndicator: Cash Management Activated?XFDISCHAR1
KBLNRDocument number for earmarked fundsKBLNR_FIKBLKCHAR10
KBLPOSEarmarked Funds: Document ItemKBLPOSKBLPNUMC3
STTAXTax Amount as Statistical Information in Document CurrencySTTAXCURR13
GEBERFundBP_GEBERCHAR10
FISTLFunds CenterFISTLCHAR16
VORNROperation/Activity NumberVORNRCHAR4
ABPERSettlement PeriodABPER_RFACCP6
EREKZFinal Invoice IndicatorEREKZCHAR1
FKBERFunctional AreaFKBERTFKBCHAR16
VBUNDCompany ID of Trading PartnerRASSCCHAR6
XREF1Business Partner Reference KeyXREF1CHAR12
XREF2Business Partner Reference KeyXREF2CHAR12
XREF3Reference key for line itemXREF3CHAR20
CCBTCPayment cards: Settlement runCCBTCCHAR10
RSTGRReason Code for PaymentsRSTGRT053RCHAR3
GRICDActivity Code for Gross Income TaxJ_1AGICD_DJ_1AGICDCHAR2
GRIRGRegion (State Province County)REGIOT005SCHAR3
GITYPDistribution Type for Employment TaxJ_1ADTYP_DJ_1ADTYPCHAR2
IDXSPInflation IndexJ_1AINDXSPJ_1AINFT20CHAR5
BUZIDIdentification of the Line ItemBUZIDCHAR1
ERLKZCompletion indicator for line itemKBLERLKZCHAR1
BUPLABusiness PlaceBUPLACHAR4
LSTARActivity TypeLSTARCHAR6
PSTYPItem category in purchasing documentPSTYPCHAR1
PRZNRBusiness ProcessCO_PRZNRCHAR12
KONTTAccount Assignment Category for Industry SolutionKONTT_FICHAR2
KONTLAcct assignment string for industry-specific acct assignmntsKONTL_FICHAR50
HBKID_SShort Key for a House BankHBKIDCHAR5
HKTID_SID for Account DetailsHKTIDCHAR5
ZTEST98765ABCDEFG - ChangeZTEST98765CHAR80
ZDIRECTTest 456ZTEST456CHAR2
GRANT_NBRGrantGM_GRANT_NBRCHAR20
BZDATAsset Value DateBZDATDATS8
XNEGPIndicator: Negative PostingXNEGPCHAR1
SEGMENTSegment for Segmental ReportingFB_SEGMENTCHAR10
PSEGMENTPartner Segment for Segmental ReportingFB_PSEGMENTCHAR10
UZAWEPayment method supplementUZAWECHAR2
PGEBERPartner FundFM_PFUNDCHAR10
PGRANT_NBRPartner GrantGM_GRANT_PARTNERCHAR20
MEASUREFunded ProgramFM_MEASURECHAR24
BUDGET_PDBudget PeriodFM_BUDGET_PERIODCHAR10
PBUDGET_PDFM: Partner Budget PeriodFM_PBUDGET_PERIODCHAR10
NETDTNet Due DateNETDTDATS8
SERVICE_DOC_TYPEService Document TypeFCO_SRVDOC_TYPECHAR4
SERVICE_DOC_IDService Document IDFCO_SRVDOC_IDCHAR10
SERVICE_DOC_ITEM_IDService Document Item IDFCO_SRVDOC_ITEM_IDNUMC6
ACROBJTYPEType of the Accrual ObjectACR_OBJ_TYPETACR_OBJ_TYPECHAR4
ACRLOGSYSLogical System of the Accrual ObjectACR_LOGSYSCHAR10
ACROBJ_IDIdentifier of the Accrual ObjectACR_OBJ_IDCHAR32
ACRSOBJ_IDIdentifier of the Accrual SubobjectACR_SUBOBJ_IDCHAR32
ACRITMTYPEType of the Item of the Accrual SubobjectACR_ITEM_TYPECHAR11
ACRVALDATAccrual Value DateACR_VALUE_DATEDATS8
SDM_VERSIONSDM: Version field for BSEGFINS_SDM_VERSION_BSEGCHAR2
ANLN2_PNAsset SubnumberANLN2*CHAR4
BWASL_PNAsset Transaction TypeBWASL*CHAR3
BZDAT_PNAsset Value DateBZDATDATS8
XVABG_PNIndicator: Post Complete RetirementXVABGCHAR1
ANBTR_PNAmount PostedANBTRCURR23
PROZS_PNAsset retirement: Percentage ratePROZSDEC5
FIPEXCommitment item - Do not use field - see note 447805FM_FIPEX_DONT_USE*CHAR24
PEROP_BEGBilling Period of Performance Start DateFM_PEROP_FI_LOWDATS8
PEROP_ENDBilling Period of Performance End DateFM_PEROP_FI_HIGHDATS8
FASTPAYPPA Fast Pay IndicatorFMFG_FASTPAY_FLGCHAR1
PPA_EX_INDPPA Exclude IndicatorEXCLUDE_FLGCHAR1
FMFGUS_KEYUnited States Federal Government FieldsFMFG_US_KEYCHAR22
PRODPERProduction Month (Date to find period and year)JV_PRODPERDATS8
HSN_SACHSN or SAC CodeJ_1IG_HSN_SACCHAR16
INWARD_DTIncoming Document DateSAFM_AP_INWARD_DTDATS8
GROUND_NOPayment Basis Document NumberSAFM_AP_PYBSNOCHAR16
GROUND_DTPayment Basis Document DateSAFM_AP_PYBSDATDATS8
GROUND_TYPType of Payment Basis DocumentSAFM_AP_PYBSTYPCHAR2
CHWRBDocument Parking: Amount not ModifiableCHWRBCHAR1

Foreign Key Relationships

A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for VBSEGS

Table NameFieldCardinalityCheck Table
VBSEGSACROBJTYPE:TACR_OBJ_TYPE
VBSEGSAUSBK1: CNT001
VBSEGSBUKRS1: CNT001
VBSEGSFKBER1: CNTFKB
VBSEGSGITYP1: CNJ_1ADTYP
VBSEGSGJAHR1: CNVBKPF
VBSEGSGRICD1: CNJ_1AGICD
VBSEGSGRIRG1: CNT005S
VBSEGSIDXSP1: CNJ_1AINFT20
VBSEGSKBLNRC: CNKBLK
VBSEGSKBLPOSC: CKBLP
VBSEGSMANDT1: CNT000
VBSEGSRSTGRC: CNT053R
VBSEGSZZBRAND1:ZTBRAND
VBSEGSZZCHECK1:YTESTV1

Other References