SAP table BPBK (Doc.Header Controlling Obj.)
SAP table BPBK has 2 primary key fields being MANDT,BELNR.
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 | |
| BELNR | Document number from budget allocation & structure planning | NUMC | 10 | 0 | BP_BELNR | ||
| GJAHR | Fiscal Year | NUMC | 4 | 0 | GJAHR | ||
| VORGA | Budget Type Budgeting/Planning | CHAR | 4 | 0 | T022 | BP_VORGANG | |
| CPUDT | Date Document Was Created | DATS | 8 | 0 | CO_CPUDT | ||
| USNAM | Name of Person Responsible for Creating the Object | CHAR | 12 | 0 | ERNAM | ||
| SUMBZ | Number of Posting Lines for Local Objects | NUMC | 3 | 0 | CO_SUMBZ | ||
| BUDAT | Posting Date in the Document | DATS | 8 | 0 | BUDAT | ||
| PERIO | Posting period | NUMC | 3 | 0 | POPER | ||
| BLDAT | Document Date | DATS | 8 | 0 | BP_BLDAT | ||
| SGTEXT | Item Text | CHAR | 50 | 0 | SGTXT | ||
| NAMTEXT | Text Name | CHAR | 32 | 0 | TDNAM | ||
| DELBZ | Number of Deleted Line Items | NUMC | 3 | 0 | CO_DELBZ | ||
| SUM_BPJA | Number of Posting Lines for Local Objects | NUMC | 3 | 0 | CO_SUMBZ | ||
| DEL_BPJA | Number of Deleted Line Items | NUMC | 3 | 0 | CO_DELBZ | ||
| SUM_BPGE | Number of Posting Lines for Local Objects | NUMC | 3 | 0 | CO_SUMBZ | ||
| DEL_BPGE | Number of Deleted Line Items | NUMC | 3 | 0 | CO_DELBZ | ||
| SUM_BPPE | Number of Posting Lines for Local Objects | NUMC | 3 | 0 | CO_SUMBZ | ||
| DEL_BPPE | Number of Deleted Line Items | NUMC | 3 | 0 | CO_DELBZ | ||
| FOBEL | Follow-On Document Number | NUMC | 10 | 0 | BPBK | BP_FOBEL | |
| VERANT | Person Responsible for Planning/Budgeting | CHAR | 20 | 0 | BP_VERANT | ||
| SVERSN | Planning/budgeting source version | CHAR | 3 | 0 | * | BP_SVERSN | |
| VALKEY | Validation Key Budget/Planning | CHAR | 10 | 0 | BP_VALKEY | ||
| BPDK_BELNR | Entry Document Number | NUMC | 10 | 0 | * | BP_DOCNR |
BPBK foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 BPBK | FOBEL | BPBK | Doc.Header Controlling Obj. | MANDT |
| 0 BPBK | FOBEL | BPBK | Doc.Header Controlling Obj. | BELNR |
| 1 BPBK | MANDT | T000 | Clients | MANDT |