SAP StackSAP FICOSAP HRSAP MMSAP SDSAP PMSAP PSSAP ABAPSAP NetWeaverSAP TablesSAP Tcodes ☰MENU

BSID Table in SAP | Accounting: Secondary Index for Customers Table & Fields List

BSID is a SAP table coming under CRM module and BBPCRM component.View details, Fields & related tables of BSID in SAP.

  • Table description : Accounting: Secondary Index for Customers
  • Module : CRM
  • Parent Module : CRM
  • Package : FBAS
  • Software Component : BBPCRM
BSID table in SAP

Here is some free PDF files that you can download free for your reference.
Download Now

Search For SAP Tables

Definitions

What is SAP ?

SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.

What is table in SAP ?

Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.

SAP BSID Table Fields structure

FieldNoteData ElementDomain
MANDTClientMANDTMANDT
BUKRSCompany CodeBUKRSBUKRS
KUNNRCustomer NumberKUNNRKUNNR
UMSKSSpecial G/L Transaction TypeUMSKSUMSKS
UMSKZSpecial G/L IndicatorUMSKZUMSKZ
AUGDTClearing DateAUGDTDATUM
AUGBLDocument Number of the Clearing DocumentAUGBLBELNR
ZUONRAssignment numberDZUONRZUONR
GJAHRFiscal YearGJAHRGJAHR
BELNRAccounting Document NumberBELNR_DBELNR
BUZEINumber of Line Item Within Accounting DocumentBUZEIBUZEI
BUDATPosting Date in the DocumentBUDATDATUM
BLDATDocument Date in DocumentBLDATDATUM
CPUDTAccounting document entry dateCPUDTDATUM
WAERSCurrency KeyWAERSWAERS
XBLNRReference Document NumberXBLNR1XBLNR1
BLARTDocument typeBLARTBLART
MONATFiscal periodMONATMONAT
BSCHLPosting KeyBSCHLBSCHL
ZUMSKTarget Special G/L IndicatorDZUMSKUMSKZ
SHKZGDebit/Credit IndicatorSHKZGSHKZG
GSBERBusiness AreaGSBERGSBER
MWSKZTax on sales/purchases codeMWSKZMWSKZ
DMBTRAmount in local currencyDMBTRWERT7
WRBTRAmount in document currencyWRBTRWERT7
MWSTSTax Amount in Local CurrencyMWSTSWERT7
WMWSTTax amount in document currencyWMWSTWERT7
BDIFFValuation DifferenceBDIFFWRTV7
BDIF2Valuation Difference for the Second Local CurrencyBDIF2WRTV7
SGTXTItem TextSGTXTTEXT50
PROJNOld: Project number : No longer used --> PS_POSNRPROJNPROJN
AUFNROrder NumberAUFNRAUFNR
ANLN1Main Asset NumberANLN1ANLN1
ANLN2Asset SubnumberANLN2ANLN2
SAKNRG/L Account NumberSAKNRSAKNR
HKONTGeneral Ledger AccountHKONTSAKNR
FKONTFinancial Budget ItemFIPLSFIPLS
FILKDAccount Number of the BranchFILKDMAXKK
ZFBDTBaseline date for due date calculationDZFBDTDATUM
ZTERMTerms of payment keyDZTERMZTERM
ZBD1TCash discount days 1DZBD1TZBDXT
ZBD2TCash discount days 2DZBD2TZBDXT
ZBD3TNet Payment Terms PeriodDZBD3TZBDXT
ZBD1PCash discount percentage 1DZBD1PPRZ23
ZBD2PCash Discount Percentage 2DZBD2PPRZ23
SKFBTAmount Eligible for Cash Discount in Document CurrencySKFBTWERT7
SKNTOCash discount amount in local currencySKNTOWERT7
WSKTOCash Discount Amount in Document CurrencyWSKTOWERT7
ZLSCHPayment methodDZLSCHZLSCH
ZLSPRPayment Block KeyDZLSPRZAHLS
ZBFIXFixed Payment TermsDZBFIXZBFIX
HBKIDShort key for a house bankHBKIDHBKID
BVTYPPartner bank typeBVTYPBVTYP
REBZGNumber of the Invoice the Transaction Belongs toREBZGBELNR
REBZJFiscal Year of the Relevant Invoice (for Credit Memo)REBZJGJAHR
REBZZLine Item in the Relevant InvoiceREBZZBUZEI
SAMNRInvoice List NumberSAMNRSAMNR
ANFBNDocument Number of the Bill of Exchange Payment RequestANFBNBELNR
ANFBJFiscal Year of the Bill of Exchange Payment Request DocumentANFBJGJAHR
ANFBUCompany Code in Which Bill of Exch.Payment Request Is PostedANFBUBUKRS
ANFAEBill of Exchange Payment Request Due DateANFAEDATUM
MANSPDunning blockMANSPMANSP
MSCHLDunning keyMSCHLMSCHL
MADATDate of Last Dunning NoticeMADATDATUM
MANSTDunning LevelMAHNS_DMAHNS
MABERDunning AreaMABERMABER
XNETBIndicator: Document posted net ?XNETBXFELD
XANETIndicator: Down Payment in Net Procedure?XANETXFELD
XCPDDIndicator: Address and Bank Data Set IndividuallyXCPDDXFELD
XINVEIndicator: Capital Goods Affected?XINVEXFELD
XZAHLIndicator: Is Posting Key Used in a Payment Transaction?XZAHLXFELD
MWSK1Tax Code for DistributionMWSKXMWSKZ
DMBT1Amount in Local Currency for Tax DistributionDMBTXWRTV7
WRBT1Amount in foreign currency for tax breakdownWRBTXWRTV7
MWSK2Tax Code for DistributionMWSKXMWSKZ
DMBT2Amount in Local Currency for Tax DistributionDMBTXWRTV7
WRBT2Amount in foreign currency for tax breakdownWRBTXWRTV7
MWSK3Tax Code for DistributionMWSKXMWSKZ
DMBT3Amount in Local Currency for Tax DistributionDMBTXWRTV7
WRBT3Amount in foreign currency for tax breakdownWRBTXWRTV7
BSTATDocument StatusBSTAT_DBSTAT
VBUNDCompany ID of trading partnerRASSCRCOMP
VBELNBilling documentVBELN_VFVBELN
REBZTFollow-On Document TypeREBZTREBZT
INFAEInverted Date for Net Due DateINFAECHAR08
STCEGVAT Registration NumberSTCEGSTCEG
EGBLDCountry of Destination for Delivery of GoodsEGBLDLAND1
EGLLDSupplying Country for Delivery of GoodsEGLLDLAND1
RSTGRReason Code for PaymentsRSTGRRSTGR
XNOZAIndicator: Account is not countedXNOZAXFELD
VERTTContract TypeRANTYPRANTYP
VERTNContract NumberRANLRANL
VBEWAFlow TypeSBEWARTSBEWART
WVERWBill of Exchange Usage TypeWVERWWVERW
PROJKWork Breakdown Structure Element (WBS Element)PS_PSP_PNRPS_POSNR
FIPOSCommitment ItemFIPOSFIPOS
NPLNRNetwork Number for Account AssignmentNPLNRAUFNR
AUFPLRouting number of operations in the orderCO_AUFPLAUFPL
APLZLInternal counterCIM_COUNTCIM_COUNT
XEGDRIndicator: Triangular deal within the EU ?XEGDRXFELD
DMBE2Amount in Second Local CurrencyDMBE2WERT7
DMBE3Amount in Third Local CurrencyDMBE3WERT7
DMB21Amount in Second Local Currency for Tax BreakdownDMB2XWRTV7
DMB22Amount in Second Local Currency for Tax BreakdownDMB2XWRTV7
DMB23Amount in Second Local Currency for Tax BreakdownDMB2XWRTV7
DMB31Amount in Third Local Currency for Tax BreakdownDMB3XWRTV7
DMB32Amount in Third Local Currency for Tax BreakdownDMB3XWRTV7
DMB33Amount in Third Local Currency for Tax BreakdownDMB3XWRTV7
BDIF3Valuation Difference for the Third Local CurrencyBDIF3WRTV7
XRAGLIndicator: Clearing was ReversedXRAGLXFELD
UZAWEPayment method supplementUZAWEUZAWE
XSTOVIndicator: Document is flagged for reversalXSTOVXFELD
MWST2Tax Amount in Second Local CurrencyMWST2WERT7
MWST3Tax Amount in Third Local CurrencyMWST3WERT7
SKNT2Cash Discount Amount in Second Local CurrencySKNT2WERT7
SKNT3Cash Discount Amount in Third Local CurrencySKNT3WERT7
XREF1Business partner reference keyXREF1CHAR12
XREF2Business partner reference keyXREF2CHAR12
XARCHIndicator: Document already archived ?XARCHXFELD
PSWSLUpdate Currency for General Ledger Transaction FiguresPSWSLWAERS
PSWBTAmount for Updating in General LedgerPSWBTWERT7
LZBKZState central bank indicatorLZBKZLZBKZ
LANDLSupplying CountryLANDLLAND1
IMKEYInternal Key for Real Estate ObjectIMKEYIMKEY
VBEL2Sales DocumentVBELN_VAVBELN
VPOS2Numeric field: Length 6NUM06NUM06
POSN2Sales Document ItemPOSNR_VAPOSNR
ETEN2Schedule lineETENRETENR
FISTLFunds CenterFISTLFISTL
GEBERFundBP_GEBERBP_GEBER
DABRZReference date for settlementDABRBEZDDAT
XNEGPIndicator: Negative postingXNEGPXFELD
KOSTLCost CenterKOSTLKOSTL
RFZEIPayment Card ItemRFZEI_CCNUM03
KKBERCredit control areaKKBERKKBER
EMPFBPayee/PayerEMPFBMAXKK
PRCTRProfit CenterPRCTRPRCTR
XREF3Reference key for line itemXREF3CHAR20
QSSKZWithholding Tax CodeQSSKZQSSKZ
ZINKZExempted from Interest CalculationDZINKZZINKZ
DTWS1Instruction key 1DTAT16DTWSX
DTWS2Instruction key 2DTAT17DTWSX
DTWS3Instruction key 3DTAT18DTWSX
DTWS4Instruction key 4DTAT19DTWSX
XPYPRIndicator: Items from Payment Program BlockedXPYPRXFELD
KIDNOPayment ReferenceKIDNOCHAR30
ABSBTCredit Management: Hedged AmountABSBTWERT7
CCBTCPayment cards: Settlement runCCBTCCCBTC
PYCURCurrency for Automatic PaymentPYCURWAERS
PYAMTAmount in Payment CurrencyPYAMTWERT7
BUPLABusiness PlaceBUPLAJ_1BBRANCH
SECCOSection CodeSECCOSECCO
CESSION_KZAccounts Receivable Pledging IndicatorCESSION_KZCESSION_KZ
PPDIFFRealized Exchange Rate Gain/Loss 1.Loc.Curr.(Part Payments)PPDIFFWRTV7
PPDIF2Realized Exchange Rate Gain/Loss 2.Loc. Curr.(Part Payments)PPDIF2WRTV7
PPDIF3Realized Exchange Rate Gain/Loss 3.Loc.Curr.(Part Payments)PPDIF3WRTV7
KBLNRDocument number for earmarked fundsKBLNR_FIKBLNR
KBLPOSEarmarked Funds: Document ItemKBLPOSKBLPOS
GRANT_NBRGrantGM_GRANT_NBRGM_GRANT_NBR
GMVKZItem is in ExecutionFM_GMVKZFM_GMVKZ
SRTYPEType of Additional ReceivableFM_SRTYPEFM_SRTYPE
LOTKZLot Number for RequestsPSO_LOTKZLOTKZ
FKBERFunctional AreaFKBERFKBER
INTRENOInternal Real Estate Master Data CodeVVINTRENOVVINTRENO
PPRCTPartner Profit CenterPPRCTRPRCTR
BUZIDIdentification of the Line ItemBUZIDCHAR1
AUGGJFiscal Year of Clearing DocumentAUGGJGJAHR
HKTIDID for account detailsHKTIDHKTID
BUDGET_PDFM: Budget PeriodFM_BUDGET_PERIODFM_BUDGET_PERIOD
PAYS_PROVPayment Service ProviderCOM_WEC_PAYMENT_SRV_PROVIDERCOM_WEC_PAYMENT_SRV_PROVIDER
PAYS_TRANPayment Reference of Payment Service ProviderFPS_TRANSACTIONCOM_WEC_PSP_TRANSACTION_ID
MNDIDUnique Referene to Mandate per Payment RecipientSEPA_MNDIDID035
.INCLU--APIS-PS: Data appendix of open items customers    
KONTTAccount Assignment Category for Industry SolutionKONTT_FIKONTT_FI
KONTLAcct assignment string for industry-specific acct assignmntsKONTL_FICHAR50
UEBGDATTransfer date of an item to legal dunning proceedingUEBGDATDATUM
.INCLU--APJoint Venture Fields    
VNAMEJoint ventureJV_NAMEJV_NAME
EGRUPEquity groupJV_EGROUPJV_EGROUP
BTYPEPayroll TypeJV_BILINDJV_BILIND
.INCLU--APAppend zur Mandatsverwaltung BSID    
.INCLUDEAppend Struktur für die Mandatsnummer    
PROPMANOMandate, Mandate-Opening ContractREHORECNNRMRECNNR

BSID related tables

TableNote
BSADAccounting: Secondary Index for Customers (Cleared Items)
BSAD_BAKAccounting: Secondary index for customers (cleared items)
BSIDAccounting: Secondary Index for Customers
BSID_BAKAccounting: Secondary Index for Customers
BSAKAccounting: Secondary Index for Vendors (Cleared Items)
BSAK_BAKAccounting: Secondary Index for Vendors (Cleared Items)
BSASAccounting: Secondary Index for G/L Accounts (Cleared Items)
BSAS_BAKAccounting: Secondary Index for G/L Accounts (Cleared Items)
BSIKAccounting: Secondary Index for Vendors
BSIK_BAKAccounting: Secondary index for vendors
BSISAccounting: Secondary Index for G/L Accounts
BSIS_BAKAccounting: Secondary Index for G/L Accounts
FAGLBSASAccounting: Secondary Index for G/L Accounts (Cleared Items)
FAGLBSAS_BAKAccounting: Secondary Index for G/L Accounts (Cleared Items)
FAGLBSISAccounting: Secondary Index for G/L Accounts
SAP ALECRMSCMSRMSAP SolutionsSAP ReferencesSAP BasicsPP ModuleWMSAP Partners
HomeContact & Privacy PolicyTwitter
All of the product names here are trademarks of their respective companies. The site sapstack.com is not affiliated with SAP AG.
©2024 sapstack.com