SAP BSIK (Accounting: Secondary Index for Vendors) Table & Fields

BSIK is a SAP table coming under CRM module and BBPCRM component.View details, Fields & related tables of BSIK.
  • Table description : Accounting: Secondary Index for Vendors
  • Module : CRM
  • Parent Module : CRM
  • Package : FBAS
  • Software Component : BBPCRM

BSIK hierarchy

BBPCRMCRMCRMBSIK

BSIK Fields structure

FieldNoteData ElementDomain
MANDTClientMANDTMANDT
BUKRSCompany CodeBUKRSBUKRS
LIFNRAccount Number of Vendor or CreditorLIFNRLIFNR
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
EBELNPurchasing Document NumberEBELNEBELN
EBELPItem Number of Purchasing DocumentEBELPEBELP
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
ZOLLTCustoms Tariff NumberDZOLLTZOLLT
ZOLLDCustoms DateDZOLLDDATUM
LZBKZState central bank indicatorLZBKZLZBKZ
LANDLSupplying CountryLANDLLAND1
DIEKZService indicator (foreign payment)DIEKZDIEKZ
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
XESRDIndicator: Is any ISR data set in the document ?XESRDXFELD
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
QSSKZWithholding Tax CodeQSSKZQSSKZ
QSSHBWithholding Tax Base AmountQSSHBWERT7
QBSHBWithholding Tax Amount (in Document Currency)QBSHBWERT7
BSTATDocument StatusBSTAT_DBSTAT
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
VBUNDCompany ID of trading partnerRASSCRCOMP
REBZTFollow-On Document TypeREBZTREBZT
STCEGVAT Registration NumberSTCEGSTCEG
EGBLDCountry of Destination for Delivery of GoodsEGBLDLAND1
EGLLDSupplying Country for Delivery of GoodsEGLLDLAND1
QSZNRCertificate Number of the Withholding Tax ExemptionQSZNRCHAR10
QSFBTWithholding Tax-Exempt Amount (in Document Currency)QSFBTWERT7
XINVEIndicator: Capital Goods Affected?XINVEXFELD
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
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
BDIF3Valuation Difference for the Third Local CurrencyBDIF3WRTV7
XRAGLIndicator: Clearing was ReversedXRAGLXFELD
RSTGRReason Code for PaymentsRSTGRRSTGR
UZAWEPayment method supplementUZAWEUZAWE
KOSTLCost CenterKOSTLKOSTL
LNRANSequence Number of Asset Line Items in Fiscal YearLNRANLNRAN
XSTOVIndicator: Document is flagged for reversalXSTOVXFELD
KZBTROriginal Reduction Amount in Local CurrencyKZBTR_FIWERT7
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
IMKEYInternal Key for Real Estate ObjectIMKEYIMKEY
ZEKKNSequential Number of Account AssignmentDZEKKNNUM02
FISTLFunds CenterFISTLFISTL
GEBERFundBP_GEBERBP_GEBER
DABRZReference date for settlementDABRBEZDDAT
XNEGPIndicator: Negative postingXNEGPXFELD
EMPFBPayee/PayerEMPFBMAXKK
PRCTRProfit CenterPRCTRPRCTR
XREF3Reference key for line itemXREF3CHAR20
DTWS1Instruction key 1DTAT16DTWSX
DTWS2Instruction key 2DTAT17DTWSX
DTWS3Instruction key 3DTAT18DTWSX
DTWS4Instruction key 4DTAT19DTWSX
XPYPRIndicator: Items from Payment Program BlockedXPYPRXFELD
KIDNOPayment ReferenceKIDNOCHAR30
PYCURCurrency for Automatic PaymentPYCURWAERS
PYAMTAmount in Payment CurrencyPYAMTWERT7
BUPLABusiness PlaceBUPLAJ_1BBRANCH
SECCOSection CodeSECCOSECCO
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
PENLC1Penalty Charge Amount in First Local CurrencyPENALTY1WERT13
PENLC2Penalty Charge Amount in Second Local CurrencyPENALTY2WERT13
PENLC3Penalty Charge Amount in Third Local CurrencyPENALTY3WERT13
PENFCPenalty Charge Amount in Document CurrencyPENALTYWERT13
PENDAYSNumber of Days for Penalty Charge CalculationPDAYSINT4
PENRCReason for Late PaymentPENRCCHAR2
VERTTContract TypeRANTYPRANTYP
VERTNContract NumberRANLRANL
VBEWAFlow TypeSBEWARTSBEWART
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
ZINKZExempted from Interest CalculationDZINKZZINKZ
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
.INCLU--APIS-PS: Data appendix of open items vendors    
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 BSIK    
.INCLUDEAppend Struktur für die Mandatsnummer    
PROPMANOMandate, Mandate-Opening ContractREHORECNNRMRECNNR