SE11 ABAP Dictionary SE11 BSIP

Data SE16 SE16
Popular:
VBAK VBAP MARA MAKT BKPF BSEG BVOR EKKO EKPO KNA1 LFA1 LIKP VBRK

BSIP

Index for Vendor Validation of Double Documents
SAP FI Transparent Table 11 Fields
Primary Key:
MANDT BUKRS LIFNR WAERS BLDAT XBLNR WRBTR BELNR GJAHR BUZEI

Dictionary Fields Fields

(11 dari 11 kolom)
# Field Name Key Field Label Type Length Dec Check Table Short Description
1
MANDT
KEY Client CLNT 3 - T000 Client
2
BUKRS
KEY CoCode CHAR 4 - T001 Company Code
3
LIFNR
KEY Vendor CHAR 10 - LFA1 Account Number of Vendor or Creditor
4
WAERS
KEY Currency CUKY 5 - TCURC Currency Key
5
BLDAT
KEY Doc. Date DATS 8 - - Document Date in Document
6
XBLNR
KEY Reference CHAR 16 - - Reference Document Number
7
WRBTR
KEY Amount CURR 13 2 - Amount in document currency
8
BELNR
KEY DocumentNo CHAR 10 - - Accounting Document Number
9
GJAHR
KEY Fiscal Yr NUMC 4 - - Fiscal Year
10
BUZEI
KEY Item NUMC 3 - - Number of Line Item Within Accounting Document
11
SHKZG
- D/C indic. CHAR 1 - - Debit/Credit Indicator

Related References & SQL

Diagram ERD, T-Code standar, tabel terkait, dan contoh query untuk BSIP.

Interactive ERD Diagrams
SAP Finance - FI/CO Document Tables →
Standard T-Codes
SE11 SE16
Related Tables
T001 LFA1 TCURC BKPF BSEG BSAD BSID BSIK
ANSI SQL Query 
SELECT a.BUKRS,
       a.LIFNR,
       a.WAERS,
       a.BLDAT,
       a.XBLNR,
       a.WRBTR,
       a.BELNR
FROM BSIP AS a
WHERE a.BUKRS = '1000'
  AND a.LIFNR = '0000100001';
ABAP OpenSQL (7.40+) 
SELECT a~bukrs,
       a~lifnr,
       a~waers,
       a~bldat,
       a~xblnr,
       a~wrbtr,
       a~belnr
  FROM bsip AS a
  WHERE a~bukrs = '1000'
  and a~lifnr = '0000100001'
  INTO TABLE @DATA(lt_bsip)
  UP TO 100 ROWS.