SAP table BPDKTO (BP Stucture: Account Management (in Company Code))
SAP table BPDKTO has 3 primary key fields being MANDT,PARTNR,BUKRS.
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 | BUT000 | BP_PARTNR_NEW | |
BUKRS | Company Code | CHAR | 4 | 0 | T001 | BUKRS | |
CUSTOMER | Customer Number | CHAR | 10 | 0 | KUNNR | ||
ZUAWA | Key for sorting according to assignment numbers | CHAR | 3 | 0 | TZUN | DZUAWA | |
AKONT | Reconciliation Account in General Ledger | CHAR | 10 | 0 | SKB1 | AKONT | |
BEGRU | Authorization Group | CHAR | 4 | 0 | * | BRGRU | |
FDGRV | Planning Group | CHAR | 10 | 0 | T035 | FDGRV | |
BLNKZ | (Obsolete) Subsidy Ind. for Determining the Reduction Rate | CHAR | 2 | 0 | T057 | BLNKZ | |
KNRZE | Head Office Account Number (in branch accounts) | CHAR | 10 | 0 | KNA1 | KNRZE | |
BUSAB | Accounting Clerk Abbreviation | CHAR | 2 | 0 | T001S | BUSAB |
BPDKTO foreign key relationships
Table | Field | Check Table | Check Field | |
---|---|---|---|---|
0 BPDKTO | AKONT | SKB1 | G/L account master (company code) | MANDT |
0 BPDKTO | AKONT | SKB1 | G/L account master (company code) | BUKRS |
1 BPDKTO | BLNKZ | T057 | Preference Indicator | MANDT |
1 BPDKTO | BLNKZ | T057 | Preference Indicator | BLNKZ |
1 BPDKTO | BLNKZ | T057 | Preference Indicator | BEGDA |
0 BPDKTO | BUKRS | T001 | Company Codes | BUKRS |
1 BPDKTO | BUSAB | T001S | Accounting Clerks | MANDT |
1 BPDKTO | BUSAB | T001S | Accounting Clerks | BUKRS |
1 BPDKTO | BUSAB | T001S | Accounting Clerks | BUSAB |
0 BPDKTO | FDGRV | T035 | Planning groups | GRUPP |
1 BPDKTO | KNRZE | KNA1 | General Data in Customer Master | MANDT |
1 BPDKTO | KNRZE | KNA1 | General Data in Customer Master | KUNNR |
0 BPDKTO | MANDT | T000 | Clients | MANDT |