Field in Extract Structure

Description of Field in Extract Structure

Table of Origin

Field in Table of Origin

BUKRS

Company code

BSIK, BSAK

BSIK-BUKRS

FISCPER

Fiscal year/period

BSIK, BSAK

BSIK-GJAHR

BSIK-MONAT

BELNR

Accounting document number

BSIK, BSAK

BSIK-BELNR

BUZEI

Account document posting line

BSIK, BSAK

BSIK-BUZEI

UPOSZ

Subitem number

= 0001

STATUSPS

Status of the FI item (O = open, C = cleared)

BSIK, BSAK

BSIK-BSTAT,

BSIK-AUGDT

LIFNR

Account number of the vendor or creditor

BSIK, BSAK

BSIK-LIFNR

KKBER

Credit control area

BSIK, BSAK, T001

BSIK-KKBER or T001-KKBER

MABER

Dunning area

BSIK, BSAK

BSIK-MABER

KOART

Account type

= K

UMSKZ

Special G/L indicator

BSIK, BSAK

BSIK-UMSKZ

BLART

Document type

BSIK, BSAK

BSIK-BLART

BSCHL

Posting key

BSIK, BSAK

BSIK-BSCHL

FISCVAR

Fiscal year variant

T001

T001-PERIV

BLDAT

Document date in document

BSIK, BSAK

BSIK-BLDAT

BUDAT

Posting date in the document

BSIK, BSAK

BSIK-BUDAT

CPUDT

Day on which accounting document was created

BSIK, BSAK

BSIK-CPUDT

AUGDT

Clearing date

BSIK, BSAK

BSIK-AUGDT

MADAT

Last dunning date

BSIK, BSAK

BSIK-MADAT

NETDT

Due date for net payment

BSIK, BSAK

Calculated, see below 1)

SK1DT

Due date according to cash discount terms 1

BSIK, BSAK

Calculated, see below 1)

SK2DT

Due date according to cash discount terms 2

BSIK, BSAK

Calculated, see below 1)

ZFBDT

Baseline date for due date calculation

BSIK, BSAK

BSIK-ZFBDT

ZBD1T

Cash discount days 1

BSIK, BSAK

BSIK-ZBD1T

ZBD2T

Cash discount days 2

BSIK, BSAK

BSIK-ZBD2T

ZBD3T

Net payment terms period

BSIK, BSAK

BSIK-ZBD3T

ZBD1P

Cash discount percentage 1

BSIK, BSAK

BSIK-ZBD1P

ZBD2P

Cash discount percentage 2

BSIK, BSAK

BSIK-ZBD2P

LAND1

Country key

T001

T001-LAND1

ZLSCH

Payment method

BSIK, BSAK

BSIK-ZLSCH

ZTERM

Terms of payment key

BSIK, BSAK

BSIK-ZTERM

ZLSPR

Payment block key

BSIK, BSAK

BSIK-ZLSPR

RSTGR

Reason code for payments

BSIK, BSAK

BSIK-RSTGR

MANSP

Dunning block

BSIK, BSAK

BSIK-MANSP

MSCHL

Dunning key

BSIK, BSAK

BSIK-MSCHL

MANST

Dunning level

BSIK, BSAK

BSIK-MANST  

LCURR

Currency key of the local currency

T001

T001-WAERS

DMSOL

Debit amount in local currency

BSIK, BSAK

BSIK-SHKZG,

BSIK-DMBTR

DMHAB

Credit amount in local currency

BSIK, BSAK

BSIK-SHKZG,

BSIK-DMBTR

DMSHB

Local currency amount (+/-)

BSIK, BSAK

BSIK-SHKZG,

BSIK-DMBTR

SKNTO

Cash discount amount in local currency

BSIK, BSAK

BSIK- SKNTO

WAERS

Currency key

BSIK, BSAK

BSIK-WAERS

WRSOL

Debit amount in foreign currency

BSIK, BSAK

BSIK-SHKZG,

BSIK-WRBTR

WRHAB

Credit amount in foreign currency

BSIK, BSAK

BSIK-SHKZG,

BSIK-WRBTR

WRSHB

Foreign currency amount (+/-)

BSIK, BSAK

BSIK-SHKZG,

BSIK-WRBTR

SKFBT

Amount eligible for cash discount in document currency

BSIK, BSAK

BSIK-SKFBT

WSKTO

Cash discount amount in document currency

BSIK, BSAK

BSIK-WSKTO

KTOPL

Chart of accounts

T001

T001-KTOPL

HKONT

General ledger account in G/L accounting.

BSIK, BSAK

BSIK-HKONT

SAKNR

G/L account number

BSIK, BSAK

BSIK-SAKNR

FILKD

Branch account number

BSIK, BSAK

BSIK-FILKD

AUGBL

Clearing document number

BSIK, BSAK

BSIK-AUGBL

XBLNR

Reference document number

BSIK, BSAK

BSIK-XBLNR

REBZG

Invoice document number

BSIK, BSAK

BSIK-REBZG

REBZJ

Fiscal year of the relevant invoice

BSIK, BSAK

BSIK-REBZJ

REBZZ

Posting item in the relevant invoice

BSIK, BSAK

BSIK-REBZZ

VBELN

Sales document number

XREF1

Reference key of the business partner

BSIK, BSAK

BSIK-XREF1

XREF2

Reference key of the business partner

BSIK, BSAK

BSIK-XREF2

XREF3

Reference key for the document items

BSIK, BSAK

BSIK-XREF3

SGTXT

Item text

BSIK, BSAK

BSIK-SGTXT

XNEGP

Flag: Negative Posting

BSIK, BSAK

BSIK-XNEGP

XARCH

Indicator: amount already in archive

BSIK, BSAK

BSIK-XARCH

UMSKS

Transaction class Special Ledger

BSIK, BSAK

BSIK-UMSKS

UPDMOD

BW delta process: Update mode

ZUONR

Assignment number

.INCLUDE DTFIAP-WF

.INCLUDE CI_BSIK

Customer exits for extract structure DTFIAP_3

Calculated, see below 2)