EBAN

Purchase Requisition Data

"MANDT", "BANFN" , "BNFPO", "BSTYP", "BSART", "BADAT", "ERNAM", "AFNAM", "BANPR", "MATKL", "MATNR", "MENGE", "PREIS", "WAERS", "MEINS"

BSTYP = 'B'

Date: BADAT

EKKO

Purchasing Document Header Data

"MANDT", "EBELN", "BSTYP", "BSART", "AEDAT", "BUKRS", "WAERS", "WKURS", "LIFNR", "EKORG", "EKGRP", "ERNAM",
"PROCSTAT"

BSTYP = 'F'

Date: AEDAT

EKPO

Purchasing Document Item Data

"MANDT", "EBELN", "EBELP", "BSTYP", "BANFN", "BNFPO", "NETWR", "PRDAT", "MATKL", "MATNR", "MENGE", "LGORT", "WERKS", "KUNNR", "MEINS"

BSTYP = 'F'

EKBE

History per Purchasing Document Data

"MANDT", "EBELN", "EBELP", "BELNR", "BUZEI", "BEWTP", "SHKZG", "CPUDT", "CPUTM", "ERNAM", "ELIKZ"

BEWTP = ‘E' AND SHKZG = 'S'

Date: CPUDT

EKET

Scheduling Agreement Schedule lines data

"MANDT", "EBELN", "EBELP", "EINDT", "SLFDT"

EKKN

Account Assignment in Purchasing Document data

"MANDT", "EBELN", "EBELP", "KOKRS", "KOSTL","GSBER"

RBKP

Document Header Invoice Receipt Data

"MANDT", "BELNR", "GJAHR", "BUKRS", "CPUDT","CPUTM", "USNAM"

Date: CPUDT

RSEG

Document Item Incoming Invoice Data

"MANDT", "BELNR", "GJAHR", "BUZEI", "EBELN", "EBELP"

BKPF

Accounting Document Header Data

"MANDT", "BUKRS", "BELNR", "GJAHR", "CPUDT", "CPUTM", "AWKEY", "BLART", "USNAM"

Date: CPUDT

BSIK

Accounting Secondary Index for Vendors Data

"MANDT", "BUKRS", "BELNR", "GJAHR", "BUZEI"

BUZEI = 001

Date: CPUDT

BSAK

Accounting Secondary Index for Vendors (Cleared Items) Data

"MANDT", "BUKRS", "BELNR", "GJAHR", "BUZEI"

BUZEI = 001

Date: CPUDT

BSE_CLR

Additional Data for Document Segment Clearing Information Data

"MANDT", "BUKRS_CLR", "BELNR_CLR", "GJAHR_CLR", "INDEX_CLR", "CLRIN", "BUKRS", "BELNR", "GJAHR", "BUZEI", "WAERS", "WRBTR", "SHKZG"

BUZEI = 001 AND (CLRIN = '' or CLRIN = 2)

CDHDR

Change Document Header Data

"MANDANT", "OBJECTCLAS", "OBJECTID" , "CHANGENR", "UDATE", "UTIME", "USERNAME"

OBJECTCLAS in [“BANF”, "EINKBELEG", "INCOMINGINVOICE", "BELEG"]

Date: UDATE

CDPOS

Change Document Item Cluster Data

"MANDANT", "OBJECTCLAS", "OBJECTID", "CHANGENR", "TABNAME", "TABKEY", "FNAME", "CHNGIND", "VALUE_OLD", "VALUE_NEW"

`FNAME in ["KEY, "BANPR", "PROCSTAT", "FRGZU", "LOEKZ", "ABSKZ", "NETPR", "ZLSPR", "ZTERM", "ZFBDT", "ZUONR", "BVTYP", "HBKID"]

AND TABNAME in ["EBAN", "EKKO", "EKPO", "RBKP", "RSEG", "BSEG"]`

AND CHANGENR >= '0001299707' AND CHANGENR <= '0001507899'

USR21

User Name/Address Key Assignment Data

"MANDT", "BNAME", "PERSNUMBER", "ADDRNUMBER"

ADRP

Persons (Business Address Services) Data

"CLIENT", "PERSNUMBER", "DATE_FROM", "DATE_TO", "NAME_FIRST", "NAME_LAST", "NATION"

NATION = '' or NATION = 'I'

ADCP

Person/Address Assignment (Business Address Services) Data

"CLIENT",
"PERSNUMBER", "ADDRNUMBER", "DATE_FROM", "DATE_TO", "DEPARTMENT", "FUNCTION", "NATION"

NATION = '' or NATION = 'I'

USR02

Logon Data

"MANDT", "BNAME", "USTYP"

LFA1

General Vendor Master Data

"MANDT", "LIFNR", "NAME1", "NAME2", "LAND1", "REGIO", "XCPDK"

T005T

Country Names Data

"MANDT", "LAND1", "LANDX", "SPRAS"

SPRAS = 'Language'*

T005U

Taxes Region Key Texts data

"MANDT", "LAND1", "BLAND", "BEZEI", "SPRAS"

SPRAS = 'Language'*

KNA1

General Customer Master Data

"MANDT", "KUNNR", "NAME1", "NAME2", "LAND1", "REGIO"

MAKT

Material Descriptions Data

"MANDT", "MATNR", "MAKTX", "SPRAS"

SPRAS = 'Language'*

T023T

Material Group Descriptions Data

"MANDT", "MATKL", "WGBEZ", "SPRAS"

SPRAS = 'Language'*

T006A

Assign Internal to Language-Dependent Unit Table and Data

"MANDT", "MSEHI", "MSEHT", "SPRAS"

SPRAS = 'Language'*

T001L

Storage Locations Data

"MANDT", "WERKS", "LGORT", "LGOBE"

CSKT

Cost Center Texts data

"MANDT", "KOKRS", "KOSTL", "DATBI", "KTEXT", "SPRAS"

SPRAS = 'Language'*

T001

Company Codes Data

"MANDT", "BUKRS", "BUTXT", "WAERS"

T001W

Plants/Branches Data

"MANDT", "WERKS", "NAME1"

T024

Purchasing Groups Data

"MANDT", "EKGRP", "EKNAM"

T024E

Purchasing Organizations Data

"MANDT", "EKORG", "EKOTX"

TGSBT

Business Area Names data

"MANDT", "SPRAS", "GSBER", "GTEXT"

SPRAS = 'Language'*

T161T

Texts for Purchasing Document Types Data

"MANDT", "BSART", "BSTYP", "BATXT", "SPRAS"

SPRAS = 'Language'*

T008T

Blocking Reason Names in Automatic Payment Transactional data

"MANDT", "ZAHLS", "TEXTL", "SPRAS"

SPRAS = 'Language'*

TCURR

Exchange Rates data

"MANDT", "KURST", "FCURR", "TCURR", "GDATU", "UKURS"

KURST = 'Exchange rate type'*

TCURF

Conversion Factors data

"MANDT", "KURST", "FCURR", "TCURR", "GDATU", "FFACT", "TFACT"

KURST = 'Exchange rate type'*

TCURX

Decimal Places in Currencies data

"CURRKEY", "CURRDEC"