SAP table T8PSA_PSC (PSC Master)

SAP table T8PSA_PSC has 3 primary key fields being MANDT,BUKRS,PSC_NAME.

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 PSA_NAME
COUNTRY Company Country/Region CHAR 3 0 T005 LAND
SIGN_DATE PSC Sign Date DATS 8 0 PSA_SIGN_DATE
PSC_CURRENCY PSA Currency CUKY 5 0 TCURC PSA_CUR
PSC_CUR_TYPE PSC Currency type CHAR 2 0 PSA_CURT
PSC_BILL_FREQ PSC reporting frequency CHAR 1 0 PSA_REPORT_FREQ
M Monthly reporting
Q Quarterly reporting
S Semi-annual reporting
Y Annual reporting
PSC_STATUS PSC Status CHAR 1 0 PSA_STATUS
1 PSC active for data collection
2 PSC active for data collection and recovery
3 PSC deactived
FIRST_OIL First Production Date DATS 8 0 PSA_FIRSTOIL
LPERFR License Period From DATS 8 0 PSA_LPERFR
LPERTO License Period to DATS 8 0 PSA_LPERTO
NO_EG_PSC No EG for PSC CHAR 1 0 PSA_NO_EG_PSC
CREATE_DATE Entered On DATS 8 0 ERFDT
CREATE_TIME Time of Entry TIMS 6 0 CPUTM
CREATE_BY Entered By CHAR 12 0 ERFNM
CHANGE_DATE Last Changed On DATS 8 0 AEDAT
CHANGE_TIME Changed At TIMS 6 0 AENZT
CHANGE_BY Last Changed By CHAR 12 0 AENNM
GOVERNMENT Government (NOC) - Customer Number CHAR 10 0 KNA1 PSA_GOVERNMENT
OPERATOR Contractor (operator) CHAR 10 0 KNB1 PSA_OPERATOR

T8PSA_PSC foreign key relationships

Table Field Check Table Check Field
0 T8PSA_PSC BUKRS T001 Company Codes BUKRS
1 T8PSA_PSC COUNTRY T005 Countries MANDT
1 T8PSA_PSC COUNTRY T005 Countries LAND1
0 T8PSA_PSC GOVERNMENT KNA1 General Data in Customer Master MANDT
0 T8PSA_PSC GOVERNMENT KNA1 General Data in Customer Master KUNNR
1 T8PSA_PSC OPERATOR KNB1 Customer Master (Company Code) MANDT
1 T8PSA_PSC OPERATOR KNB1 Customer Master (Company Code) KUNNR
1 T8PSA_PSC OPERATOR KNB1 Customer Master (Company Code) BUKRS
0 T8PSA_PSC PSC_CURRENCY TCURC Currency Codes MANDT
0 T8PSA_PSC PSC_CURRENCY TCURC Currency Codes WAERS