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
1 Individual posting
2 Transfer posting
POST_CTRL Permissibility of Manual/Automatic Posting CHAR 1 0 RL_POST_CTRL
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