SAP table BP021 (Fiscal Year Information)
SAP table BP021 has 3 primary key fields being MANDT,PARTNR,BUSINESS_Y.
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 | |
PARTNR | Business Partner Number | CHAR | 10 | 0 | * | BP_PARTNR_NEW | |
BUSINESS_Y | Fiscal year | NUMC | 4 | 0 | BP_BUSIN_Y | ||
BAL_SH_CUR | Balance Sheet Currency | CUKY | 5 | 0 | TCURC | BP_BAL_CUR | |
GEN_MEET_D | Date of Annual Stockholders Meeting | DATS | 8 | 0 | BP_GE_ME_D | ||
BU_Y_BEGIN | Fiscal Year Start Date | DATS | 8 | 0 | BP_B_Y_BEG | ||
BU_Y_END | Fiscal Year End Date | DATS | 8 | 0 | BP_B_Y_END | ||
ANNUAL_ACC | Year-End Closing | CHAR | 1 | 0 | BP_ANN_ACC | ||
ANNU_ACC_D | Year-End Closing Date for Fiscal Year | DATS | 8 | 0 | BP_A_ACC_D | ||
CONS_FST_D | Date of Consolidated Financial Statements of Group Company | DATS | 8 | 0 | BP_C_FST_D | ||
CAPI_STOCK | Amount of Authorized Capital Stock for Company | CURR | 15 | 2 | BP_CAP_STK | ||
SHAR_STOCK | Amount of Issued Stock Capital for Company | CURR | 15 | 2 | BP_SHA_STK | ||
PRSH_STOCK | Amount of Participation Certificates Outstanding for Company | CURR | 15 | 2 | BP_PRS_STK | ||
EQUITY | Amount of Equity Capital for Company | CURR | 15 | 2 | BP_EQUITY | ||
GROSS_AMNT | Gross Premium | CURR | 15 | 2 | BP_GROSS_A | ||
NET_AMOUNT | Net Premium | CURR | 15 | 2 | BP_NET_A | ||
TURNOVER | Amount of Annual Sales for Company | CURR | 15 | 2 | BP_TURNOVR | ||
NET_INCOME | Amount of Annual Net Income/Net Loss for Company | CURR | 15 | 2 | BP_NET_IN | ||
DIV_DIS_AM | Dividend/Profit Distribution Amount for Company | CURR | 15 | 2 | BP_DIV_DIS | ||
DEBTS_FACT | Debt Ratio in Years | DEC | 6 | 3 | BP_DEBTS_F | ||
DIS_PROFIT | Amount of Annual Profit/Loss for Organization | CURR | 15 | 2 | BP_PROFIT | ||
BAL_AMOUNT | Amount of Balance Sheet Total for Company | CURR | 15 | 2 | BP_BAL_AMT | ||
STAFF_COUNT | Number of Employees in Company | NUMC | 7 | 0 | BP_STAFF_CNT | ||
CAP_RES | Amount of Capital Reserve for Company | CURR | 15 | 2 | BP_CAP_RESERV | ||
REV_RES_LEG | Amount of Legal Revenue Reserves for Company | CURR | 15 | 2 | BP_REVENUE_RESERV_LEG | ||
REV_RES_OWN_SHR | Revenue Reserves for Own Stock | CURR | 15 | 2 | BP_REVENUE_RESERV_OWN_SHARES | ||
REV_RES_BY_LAWS | Amount of Statutory Revenue Reserve for Company | CURR | 15 | 2 | BP_REVENUE_RESERV_BY_LAWS | ||
REV_RES_OTHERS | Amount of Other Revenue Reserves for Company | CURR | 15 | 2 | BP_REVENUE_RESERV_OTHERS | ||
FORW_PROFIT_LOSS | Amount of Profit/Loss Carried Forward for Company | CURR | 15 | 2 | BP_FORWARD_PROFIT_LOSS | ||
LIABILIT_SECOND | Amount of Subordinated Liabilities for Company | CURR | 15 | 2 | BP_LIABILIT_SECOND | ||
RET_TOT_CAP_EMPL | Return on Total Capital Employed for Company in Percent | DEC | 5 | 2 | BP_RETURN_TOTAL_CAP_EMPL | ||
REDUC_LONG_TERM | Debt Clearance Period in Years | DEC | 5 | 2 | BP_REDUC_LONG_TERM | ||
COEFF_FINANCE | Financing Coefficient for Company in Percent | DEC | 5 | 2 | BP_COEFF_FINANCE | ||
EQUITY_CAPIT | Equity Ratio of Company in Percent | DEC | 5 | 2 | BP_EQUITY_CAPIT |
BP021 foreign key relationships
Table | Field | Check Table | Check Field | |
---|---|---|---|---|
0 BP021 | BAL_SH_CUR | TCURC | Currency Codes | WAERS |
1 BP021 | MANDT | T000 | Clients | MANDT |