VBAK

Sales Document Header Data

"MANDT", "VBELN", "VBTYP", "AUART", "KUNNR", "BUKRS_VF", "VKORG", "VTWEG", "SPART", "VKBUR", "VKGRP", "ERNAM"

VBTYP in [‘C', ‘K', 'H]

Date: ERDAT

VBAP

Sales Document Item Data

"MANDT", "VBELN", "POSNR", "ERDAT", "ERZET",' "VGBEL", "VGPOS", "MATNR", "MATKL", "WERKS", "VSTEL", "LGORT", "NETWR", "WAERK",
"PSTYV", "PRCTR", "KWMENG"

Date: ERDAT

VBEP

Sales Document Schedule Line Data

"MANDT", "VBELN", "POSNR", "ETENR"

VBKD

Sales Document Business Data

"MANDT", "VBELN", "POSNR", "ZTERM", "INCO1", "KURSK", "PRSDT", "FKDAT"

LIKP

Delivery Document Header Data

"MANDT", "VBELN", "VBTYP", "KUNNR", "VKORG", "INCO1", "LGNUM", "LGBZO", "VSTEL", "ERNAM", "LFART", "WADAT"

VBTYP in ['J', 'T']

Date: ERDAT

LIPS

Delivery Document Item Data

"MANDT", "VBELN", "POSNR", "ERDAT", "ERZET", "VGBEL", "VGPOS", "MATNR", "MATKL", "WERKS", "VTWEG", "SPART", "VKBUR", "VKGRP", "LGORT", "PSTYV", "LFIMG"

Date: ERDAT

VBRK

Billing Document Header Data

"MANDT", "VBELN", "VBTYP", "ERNAM",
"SFAKN", "STGRD", "ERDAT", "ERZET", "FKDAT", ”FKTYP”

VBTYP in ['M', ‘N', 'O’, 'S’]

Date: ERDAT

VBRP

Billing Document Item Data

"MANDT", "VBELN", POSNR, "ERDAT", "ERZET", "VGBEL", "VGPOS"

Date: ERDAT

BKPF

Payment Document Header Data

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

Date: CPUDT

BSID

Accounting: Secondary Index for Customers data

"MANDT", "BUKRS",
"BELNR", "GJAHR",
"BUZEI", "ZFBDT", "ZBD1T", "ZBD2T", "ZBD3T"

BUZEI = '001'

Date: CPUDT

BSAD

Accounting Secondary Index for Customers (Cleared Items) Data

"MANDT", "BUKRS",
"BELNR", "GJAHR",
"BUZEI", "ZFBDT”, ”ZBD1T”, "ZBD2T", "ZBD3T"

BUZEI = '001'

Date: CPUDT

BSE_CLR

Additional Data for Document Segment Clearing Information Data

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

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

CDHDR

Change Document Header Data

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

OBJECTCLAS in ['VERKBELEG', 'LIEFERUNG', 'FAKTBELEG', 'BELEG', 'BELEGR']

Date: UDATE

CDPOS

Change Document Item Cluster Data

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

`FNAME in ['LFDAT', ‘FKDAT', ‘LIFSK', ‘FAKSK', ‘CMGST', ‘WBSTK','PODAT', 'LFIMG', 'SKFBP', 'ZTERM', 'ZFBDT','ZUONR', 'BVTYP', 'ZLSPR', 'AUGBL', 'NETPR', 'ABGRU','FAKSP', 'WMENG', 'BMENG', 'EDATU', 'LIFSP', 'KOSTK', 'HBKID’,’PRSDT, 'KURSK’, 'WAERK']

AND TABNAME in ['VBAK', 'VBAP', 'VBEP', 'VBKD', 'LIKP', 'LIPS', 'VBUK', 'VBRK', 'VBRP', 'BSEG', 'BSEGR']`

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'

ACDP

Person/Address Assignment (Business Address Services) Data

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

NATION = '' or NATION = 'I'

USR02

Logon Data

"MANDT", "BNAME", "USTYP"

KNA1

General Customer Master Data

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

T005T

Country Names Data

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

SPRAS = 'Language'*

T005U

Taxes Region Key Texts data

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

SPRAS = 'Language'*

MAKT

Material Descriptions Data

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

SPRAS = 'Language'*

T023T

Material Group Descriptions Data

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

SPRAS = 'Language'*

T001

Company Codes Data

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

T001K

Valuation Area Data

"MANDT", "BUKRS", "BWKEY"

T001L

Storage Locations Data

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

T001W

Plants/Branches Data

"MANDT", "WERKS", "NAME1", "BWKEY"

TSPAT

Organizational Unit Sales Divisions Texts Data

"MANDT", "SPART", "VTEXT", "SPRAS"

SPRAS = 'Language'*

TVGRT

Organizational Unit Sales Groups Texts Data

"MANDT", "VKGRP", "BEZEI", "SPRAS"

SPRAS = 'Language'*

TVKBT

Organizational Unit Sales Organizations Data

"MANDT", "VKBUR", "BEZEI", "SPRAS"

SPRAS = 'Language'*

TVKOT

Organizational Unit Sales Organizations Texts Data

"MANDT", "VKORG", "VTEXT", "SPRAS"

SPRAS = 'Language'*

TVST

Organizational Unit Shipping Points Data

"MANDT", "VSTEL", "ALAND"

TVTWT

Organizational Unit Distribution Channels Texts Data

"MANDT", "VTWEG", "VTEXT", "SPRAS"

SPRAS = 'Language'*

TVAPT

Sales Document Item Categories Texts Data

"MANDT", "PSTYV", "VTEXT", "SPRAS"

SPRAS = 'Language'*

TVAKT

Sales Document Types Data

"MANDT", "AUART", "BEZEI", "SPRAS"

SPRAS = 'Language'*

TVLKT

Delivery Type Texts Data

"MANDT", "LFART", "VTEXT", "SPRAS"

SPRAS = 'Language'*

TVLST

Delivery Blocking Reason Texts data

"MANDT", "LIFSP", "VTEXT", "SPRAS"

SPRAS = 'Language'

TVFST

Billing Blocking Reason Texts data

"MANDT", "FAKSP", "VTEXT", "SPRAS"

SPRAS = 'Language'

T008T

Blocking Reason Names in Automatic Payment Transactional data

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

SPRAS = 'Language'

TVAGT

Rejection Reasons for Sales Documents Texts data

"MANDT", "ABGRU", "BEZEI", "SPRAS"

SPRAS = 'Language'

T041CT

Reasons for Reverse Posting (Name) data

"MANDT", "STGRD", "TXT40", "SPRAS"

SPRAS = 'Language'

TCURR

Exchange Rates data

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

KURST = 'M'

TCURF

Conversion Factors data

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

KURST = 'M'

TCURX

Decimal Places in Currencies data

"CURRKEY", "CURRDEC"