SAP table T149A (Valuation types for valuation area)

SAP table T149A has 3 primary key fields being MANDT,BWKEY,BWTAR.

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
BWKEY Valuation area CHAR 4 0 T001K BWKEY
BWTAR Valuation Type CHAR 10 0 T149D BWTAR_D
KKREF Account category reference CHAR 4 0 T025K KKREF
BSEXT External Purchase Orders Allowed CHAR 1 0 BSEXT
0 No external purchase orders allowed
1 External purchase orders allowed, but warning issued
2 External purchase orders allowed
BSINT Internal purchase orders allowed CHAR 1 0 BSINT
0 No internal purchase orders allowed
1 Internal purchase orders allowed, but warning issued
2 Internal purchase orders allowed

T149A foreign key relationships

Table Field Check Table Check Field
0 T149A BWTAR T149D Global Valuation Types MANDT
0 T149A BWTAR T149D Global Valuation Types BWTAR
1 T149A KKREF T025K Account Category Reference KKREF
0 T149A MANDT T000 Clients MANDT