SAP table PSACCDOCCD (Generated Table for View)
SAP table PSACCDOCCD has 10 primary key fields being MANDT,INSPECTITEMDOCUMENTTYPE,CHANGEDOCOBJECTCLASS,CHANGEDOCOBJECT,CHANGEDOCUMENT,DATABASETABLE,CHANGEDOCTABLEKEY,CHANGEDOCDATABASETABLEFIELD,CHANGEDOCITEMCHANGETYPE,ACCOUNTINGDOCUMENTITEM.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
Field
Description
Data Type
Length
Decimals
Checktable
Data Element
Client
CLNT
3
0
T000
MANDT
Document Type of Inspect Items Change Document Log
CHAR
1
0
FARP_INSPECT_ITEM_DOC_TYPE
Possible values
D
Documents
E
External Documents
O
Previously Parked Documents
P
Parked Documents
R
Recurring Entry Documents
S
Sample Documents
Object class
CHAR
15
0
CDOBJECTCL
Object Value
CHAR
90
0
CDOBJECTV
Change Number of Document
CHAR
10
0
CDHDR
CDCHANGENR
Table Name
CHAR
30
0
TABNAME
Changed table record key
CHAR
70
0
CDTABKEY
Field Name
CHAR
30
0
FIELDNAME
Type of Change
CHAR
1
0
CDCHNGIND
Possible values
D
Delete
E
Delete (single field documentation)
I
Insert
J
Insert (single field documentation)
U
Change
Posting View Item
NUMC
3
0
FARP_BUZEI
CHANGEDOCNEWCURRENCY
Change documents, referenced currency
CUKY
5
0
TCURC
CDCUKY
CHANGEDOCNEWFIELDVALUE
New contents of changed field
CHAR
254
0
CDFLDVALN
CHANGEDOCNEWUNIT
Change documents, unit referenced
UNIT
3
0
CDUNIT
CHANGEDOCPREVIOUSCURRENCY
Change documents, referenced currency
CUKY
5
0
TCURC
CDCUKY
CHANGEDOCPREVIOUSFIELDVALUE
Old contents of changed field
CHAR
254
0
CDFLDVALO
CHANGEDOCPREVIOUSUNIT
Change documents, unit referenced
UNIT
3
0
CDUNIT
COMPANYCODE
Company Code
CHAR
4
0
T001
BUKRS
ACCOUNTINGDOCUMENT
Journal Entry
CHAR
10
0
FARP_BELNR_D
FISCALYEAR
Fiscal Year
NUMC
4
0
GJAHR
ACCOUNTINGDOCUMENTTYPE
Journal Entry Type
CHAR
2
0
T003
FARP_BLART
LEDGER
Ledger in General Ledger Accounting
CHAR
2
0
FINSC_LD_CMP
FINS_LEDGER
CHANGEDOCLANGUAGE
Language Key
LANG
1
0
LANGU
CREATIONTIME
Time changed
TIMS
6
0
CDUZEIT
CREATIONDATE
Creation date of the change document
DATS
8
0
CDDATUM
CREATEDBYUSER
User name of the person responsible in change document
CHAR
12
0
CDUSERNAME
CHANGEDOCCHANGETYPE
Type of Change to Application Object
CHAR
1
0
CDCHNGINDH
CHANGETRANSACTIONCODE
Transaction in which a change was made
CHAR
20
0
TSTC
CDTCODE
GLACCOUNT
G/L Account
CHAR
10
0
FIS_GLACCT
CUSTOMER
Customer
CHAR
10
0
KNA1
FIS_KUNNR
SUPPLIER
Supplier
CHAR
10
0
LFA1
FIS_LIFNR
ACCOUNTTYPE
Account Type
CHAR
1
0
FARP_KOART
Possible values
A
Asset
D
Customer
K
Supplier
M
Material
S
G/L Account
POSTINGKEY
Posting Key
CHAR
2
0
FIS_BSCHL
SPECIALGLCODE
Assignment Number for Special G/L Accounts
CHAR
18
0
FINS_HZUON
PSACCDOCCD foreign key relationships
Table
Field
Check Table
Check Field
0 PSACCDOCCD
ACCOUNTINGDOCUMENTTYPE
T003 Document Types
MANDT
1 PSACCDOCCD
CHANGEDOCNEWCURRENCY
TCURC Currency Codes
MANDT
1 PSACCDOCCD
CHANGEDOCNEWCURRENCY
TCURC Currency Codes
WAERS
0 PSACCDOCCD
CHANGEDOCPREVIOUSCURRENCY
TCURC Currency Codes
MANDT
0 PSACCDOCCD
CHANGEDOCPREVIOUSCURRENCY
TCURC Currency Codes
WAERS
1 PSACCDOCCD
CHANGEDOCUMENT
CDHDR Change document header
MANDANT
1 PSACCDOCCD
CHANGEDOCUMENT
CDHDR Change document header
OBJECTCLAS
1 PSACCDOCCD
CHANGEDOCUMENT
CDHDR Change document header
OBJECTID
0 PSACCDOCCD
CHANGETRANSACTIONCODE
TSTC SAP Transaction Codes
TCODE
1 PSACCDOCCD
COMPANYCODE
T001 Company Codes
BUKRS
0 PSACCDOCCD
CUSTOMER
KNA1 General Data in Customer Master
MANDT
0 PSACCDOCCD
CUSTOMER
KNA1 General Data in Customer Master
KUNNR
1 PSACCDOCCD
LEDGER
FINSC_LD_CMP CompCode-Dependent Settings for Univ. Journal Entry Ledger
RLDNR
1 PSACCDOCCD
LEDGER
FINSC_LD_CMP CompCode-Dependent Settings for Univ. Journal Entry Ledger
BUKRS
0 PSACCDOCCD
SUPPLIER
LFA1 Supplier Master (General Section)
MANDT
0 PSACCDOCCD
SUPPLIER
LFA1 Supplier Master (General Section)
LIFNR