Field in Extract Structure

Description of Field in Extract Structure

Table of Origin

Field in Table of Origin

BUKRS

Company code

BSID, BSAD

BSID-BUKRS

FISCPER

Fiscal year/period

BSID, BSAD

BSID-GJAHR,

BSID-MONAT

BELNR

Accounting document number

BSID, BSAD

BSID-BELNR

BUZEI

Account document posting line

BSID, BSAD

BSID-BUZEI

UPOSZ

Subitem number

= 0001

STATUSPS

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

BSID, BSAD

BSID-BSTAT,

BSID- AUGDT

KUNNR

Customer number

BSID, BSAD

BSID-KUNNR

KKBER

Credit control area

BSID, BSAD, T001

BSID-KKBER or T001-KKBER

MABER

Dunning area

BSID, BSAD

BSID-MABER

KOART

Account type

= D

UMSKZ

Special G/L indicator

BSID, BSAD

BSID-UMSKZ

BLART

Document type

BSID, BSAD

BSID-BLART

BSCHL

Posting key

BSID, BSAD

BSID-BSCHL

FISCVAR

Fiscal year variant

T001

T001-PERIV

BLDAT

Document date in document

BSID, BSAD

BSID-BLDAT

BUDAT

Posting date in the document

BSID, BSAD

BSID-BUDAT

CPUDT

Day on which accounting document was created

BSID, BSAD

BSID-CPUDT

AUGDT

Clearing date

BSID, BSAD

BSID- AUGDT

MADAT

Last dunning date

BSID, BSAD

BSID-MADAT

NETDT

Due date for net payment

BSID, BSAD

See below 1)

SK1DT

Due date according to cash discount terms 1

BSID, BSAD

See below 1)

SK2DT

Due date according to cash discount terms 2

BSID, BSAD

See below 1)

ZFBDT

Baseline date for due date calculation

BSID, BSAD

BSID-ZFBDT

ZBD1T

Cash discount days 1

BSID, BSAD

BSID-ZBD1T

ZBD2T

Cash discount days 2

BSID, BSAD

BSID-ZBD2T

ZBD3T

Net payment terms period

BSID, BSAD

BSID-ZBD3T

ZBD1P

Cash discount percentage 1

BSID, BSAD

BSID-ZBD1P

ZBD2P

Cash discount percentage 2

BSID, BSAD

BSID-ZBD2P

LAND1

Country key

T001

T001-LAND1

ZLSCH

Payment method

BSID, BSAD

BSID-ZLSCH

ZTERM

Terms of payment key

BSID, BSAD

BSID-ZTERM

ZLSPR

Payment block key

BSID, BSAD

BSID-ZLSPR

RSTGR

Reason code for payments

BSID, BSAD

BSID-RSTGR

MANSP

Dunning block

BSID, BSAD

BSID-MANSP

MSCHL

Dunning key

BSID, BSAD

BSID-MSCHL

MANST

Dunning level

BSID, BSAD

BSID-MANST  

LCURR

Currency key of the local currency

T001

T001-WAERS

DMSOL

Debit amount in local currency

BSID, BSAD

BSID-SHKZG,

BSID-DMBTR

DMHAB

Credit amount in local currency

BSID, BSAD

BSID-SHKZG,

BSID-DMBTR

DMSHB

Local currency amount (+/-)

BSID, BSAD

BSID-SHKZG,

BSID-DMBTR

SKNTO

Cash discount amount in local currency

BSID, BSAD

BSID- SKNTO

WAERS

Currency key

BSID, BSAD

BSID-WAERS

WRSOL

Debit amount in foreign currency

BSID, BSAD

BSID-SHKZG,

BSID-WRBTR

WRHAB

Credit amount in foreign currency

BSID, BSAD

BSID-SHKZG,

BSID-WRBTR

WRSHB

Foreign currency amount (+/-)

BSID, BSAD

BSID-SHKZG,

BSID-WRBTR

SKFBT

Amount eligible for cash discount in document currency

BSID, BSAD

BSID- SKFBT

WSKTO

Cash discount amount in document currency

BSID, BSAD

BSID- WSKTO

KTOPL

Chart of accounts

T001

T001-KTOPL

HKONT

General ledger account in G/L accounting.

BSID, BSAD

BSID-HKONT

SAKNR

G/L account number

BSID, BSAD

BSID-SAKNR

FILKD

Branch account number

BSID, BSAD

BSID-FILKD

AUGBL

Clearing document number

BSID, BSAD

BSID-AUGBL

XBLNR

Reference document number

BSID, BSAD

BSID-XBLNR

REBZG

Invoice document number

BSID, BSAD

BSID-REBZG

REBZJ

Fiscal year of the relevant invoice

BSID, BSAD

BSID-REBZJ

REBZZ

Posting item in the relevant invoice

BSID, BSAD

BSID-REBZZ

VBELN

Sales document number

BSID, BSAD

BSID-VBELN

XREF1

Reference key of the business partner

BSID, BSAD

BSID-XREF1

XREF2

Reference key of the business partner

BSID, BSAD

BSID-XREF2

XREF3

Reference key for the document items

BSID, BSAD

BSID-XREF3

SGTXT

Item text

BSID, BSAD

BSID-SGTXT

XNGEP

Flag: Negative Posting

BSID, BSAD

BSID- XNGEP

XARCH

Indicator: amount already in archive

BSID, BSAD

BSID-XARCH

UMSKS

Transaction class Special Ledger

BSID, BSAD

BSID-UMSKS

UPDMOD

BW delta process: Update mode

ZUONR

Assignment number

.INCLUDE CI_BSID

Customer exits for extract structure DTFIAR_3

See below 2)