SAP table T8PSA_PA (Product Assignment)

SAP table T8PSA_PA has 8 primary key fields being MANDT,BUKRS,PSC_NAME,PSC_PRODUCT,VNAME,ETYPE,YEAR_FROM,PERIOD_FROM.

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 * MANDT
BUKRS Company Code CHAR 4 0 T001 BUKRS
PSC_NAME PSC Name CHAR 10 0 T8PSA_PSC PSA_NAME
PSC_PRODUCT PSA Product CHAR 10 0 T8PSA_PRODUCT PSA_PRODUCT
VNAME Joint venture CHAR 6 0 T8JV JV_NAME
ETYPE Equity type CHAR 3 0 T8JE JV_ETYPE
YEAR_FROM Fiscal Year NUMC 4 0 GJAHR
PERIOD_FROM PSA From Period NUMC 2 0 PSA_FROM_PERIOD
PSC_GROUP PSA Group CHAR 5 0 T8PSA_GRP PSA_GROUP
PRODUCING Checkbox CHAR 1 0 XFELD
No
X Yes
COMBINED_PRODUCT PSA Combined Product for calculation purposes(dummy product) CHAR 1 0 PSA_COMBINED_PRODUCT
TRANSFER_PRODUCT PSA Transfer Product (transfer to Combined Product) CHAR 10 0 T8PSA_PRODUCT PSA_TRANSFER_PRODUCT
FLAT_API PSA API (Gravity) DEC 7 4 PSA_API

T8PSA_PA foreign key relationships

Table Field Check Table Check Field
0 T8PSA_PA BUKRS T001 Company Codes BUKRS
1 T8PSA_PA ETYPE T8JE Investment Type MANDT
1 T8PSA_PA ETYPE T8JE Investment Type BUKRS
1 T8PSA_PA ETYPE T8JE Investment Type ETYPE
0 T8PSA_PA PSC_GROUP T8PSA_GRP PSC Group MANDT
0 T8PSA_PA PSC_GROUP T8PSA_GRP PSC Group BUKRS
0 T8PSA_PA PSC_GROUP T8PSA_GRP PSC Group PSC_GROUP
1 T8PSA_PA PSC_NAME T8PSA_PSC PSC Master MANDT
1 T8PSA_PA PSC_NAME T8PSA_PSC PSC Master BUKRS
1 T8PSA_PA PSC_NAME T8PSA_PSC PSC Master PSC_NAME
0 T8PSA_PA PSC_PRODUCT T8PSA_PRODUCT Product Master MANDT
0 T8PSA_PA PSC_PRODUCT T8PSA_PRODUCT Product Master PSC_PRODUCT
1 T8PSA_PA TRANSFER_PRODUCT T8PSA_PRODUCT Product Master MANDT
1 T8PSA_PA TRANSFER_PRODUCT T8PSA_PRODUCT Product Master PSC_PRODUCT
0 T8PSA_PA VNAME T8JV Joint Venture MANDT
0 T8PSA_PA VNAME T8JV Joint Venture BUKRS
0 T8PSA_PA VNAME T8JV Joint Venture VNAME