1. Home
  2. Resources
  3. SAP Tables
  4. T8PSA_PSC - PSC Master

SAP Table T8PSA_PSC

PSC Master

T8PSA_PSC (PSC Master) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link T8PSA_PSC to other SAP tables.

Source: T8PSA_PSC (PSC Master)

T8PSA_PSC table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
BUKRS Company Code BUKRS T001 CHAR 4 0
PSC_NAME PSC Name PSA_NAME CHAR 10 0
COUNTRY Country of company LAND T005 CHAR 3 0
SIGN_DATE PSC Sign Date PSA_SIGN_DATE DATS 8 0
PSC_CURRENCY PSA Currency PSA_CUR TCURC CUKY 5 0
PSC_CUR_TYPE PSC Currency type PSA_CURT CHAR 2 0
00 Document currency
10 Company code currency
11 Company code currency, group valuation
12 Company code currency, profit center valuation
20 Controlling area currency
30 Group currency
31 Group currency, group valuation
32 Group currency, profit center valuation
40 Hard currency
50 Index-based currency
60 Global company currency
70 Controlling object currency
71 Controlling object currency, group valuation
72 Controlling object currency, profit center valuation
80 Ledger currency
81 Ledger currency, group valuation
82 Ledger currency, profit center valuation
90 Profit center invoice currency
92 Profit center accounting currency, profit center valuation
A0 Financial management area currency
B0 Operating concern currency
B2 Operating concern currency, profit center valuation
C0 Consolidation unit currency
C1 Consolidation unit currency, group valuation
C2 Consolidation unit currency, profit center valuation
PSC_BILL_FREQ PSC reporting frequency PSA_REPORT_FREQ CHAR 1 0
M Monthly reporting
Q Quarterly reporting
S Semi-annual reporting
Y Annual reporting
PSC_STATUS PSC Status PSA_STATUS CHAR 1 0
1 PSC active for data collection
2 PSC active for data collection and recovery
3 PSC deactived
FIRST_OIL First Production Date PSA_FIRSTOIL DATS 8 0
LPERFR License Period From PSA_LPERFR DATS 8 0
LPERTO License Period to PSA_LPERTO DATS 8 0
NO_EG_PSC No EG for PSC PSA_NO_EG_PSC CHAR 1 0
X Yes
NULL No
CREATE_DATE Created on ERFDT DATS 8 0
CREATE_TIME Time of Entry CPUTM TIMS 6 0
CREATE_BY Entered by ERFNM CHAR 12 0
CHANGE_DATE Changed On AEDAT DATS 8 0
CHANGE_TIME Changed At AENZT TIMS 6 0
CHANGE_BY Last changed by AENNM CHAR 12 0
GOVERNMENT Government (NOC) - Customer Number PSA_GOVERNMENT KNA1 CHAR 10 0
OPERATOR Contractor (operator) PSA_OPERATOR KNB1 CHAR 10 0

T8PSA_PSC foreign key relationships

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