SAP table CRLPOTY (RP Account: Posting Types)
SAP table CRLPOTY has 2 primary key fields being MANDT,RL_POTYPE.
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
MANDT
Client
CLNT
3
0
T000
MANDT
RL_POTYPE
Account posting type
CHAR
3
0
RL_POTYPE
RL_POSIGN
+/- Sign for Account Posting Type
CHAR
1
0
RL_POSIGN
POCATEGORY
Account posting type
CHAR
1
0
RL_POCATEGORY
Possible values
1
Individual posting
2
Transfer posting
POST_CTRL
Permissibility of Manual/Automatic Posting
CHAR
1
0
RL_POST_CTRL
Possible values
1
Manually
2
Automatically
3
Manual/automatic
CANPOTYPE
Reverse account posting type
CHAR
3
0
CRLPOTY
RL_CANPOTYPE
REVPOTYPE
Subsequent account posting type
CHAR
3
0
CRLPOTY
RL_REVPOTYPE
OFFPOTYPE
Offsetting account posting type
CHAR
3
0
CRLPOTY
RL_OFFPOTYPE
ROLE_LOC
RP partner role of location in an account posting
CHAR
2
0
CRLROLE
RL_ROLE_LOC
ROLE_EXP
RP partner role of exchange partner in an account posting
CHAR
2
0
CRLROLE
RL_ROLE_EXP
CRLPOTY foreign key relationships
Table
Field
Check Table
Check Field
0 CRLPOTY
MANDT
T000
Clients
MANDT
1 CRLPOTY
ROLE_EXP
CRLROLE
Partner Role for RP Account Postings
MANDT
1 CRLPOTY
ROLE_EXP
CRLROLE
Partner Role for RP Account Postings
ROLE
0 CRLPOTY
ROLE_LOC
CRLROLE
Partner Role for RP Account Postings
MANDT
0 CRLPOTY
ROLE_LOC
CRLROLE
Partner Role for RP Account Postings
ROLE