SAP table BPDKNB1 (BP: Business Partner-Relevant Fields in KNB1)
SAP table BPDKNB1 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 | MANDT | ||
| PARTNR | Business Partner Number | CHAR | 10 | 0 | BP_PARTNR_NEW | ||
| BUKRS | Company Code | CHAR | 4 | 0 | BUKRS | ||
| CUSTOMER | Customer Number | CHAR | 10 | 0 | KUNNR | ||
| ZUAWA | Key for sorting according to assignment numbers | CHAR | 3 | 0 | * | DZUAWA | |
| AKONT | Reconciliation Account in General Ledger | CHAR | 10 | 0 | * | 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 | |
| VZSKZ | Interest Indicator | CHAR | 2 | 0 | * | VZSKZ | |
| ZINDT | Key Date of Last Interest Calculation | DATS | 8 | 0 | DZINDT | ||
| ZINRT | Interest Calculation Frequency in Months | NUMC | 2 | 0 | DZINRT | ||
| DATLZ | Date of Last Interest Calculation Run | DATS | 8 | 0 | DATLZ | ||
| ZTERM | Terms of payment key | CHAR | 4 | 0 | DZTERM | ||
| WAKON | Terms of Payment Key for Bill of Exchange Charges | CHAR | 4 | 0 | WAKON | ||
| XZVER | Indicator: Record Payment History ? | CHAR | 1 | 0 | XZVER | ||
| TOGRU | Tolerance Group for Business Partner/G/L Account | CHAR | 4 | 0 | * | TOGRU | |
| KULTG | Probable Time Until Check Is Paid | DEC | 3 | 0 | KULTG | ||
| URLID | Short Key for Known/Negotiated Leave | CHAR | 4 | 0 | * | URLID |
BPDKNB1 foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 BPDKNB1 | BLNKZ | T057 | Preference Indicator | MANDT |
| 0 BPDKNB1 | BLNKZ | T057 | Preference Indicator | BLNKZ |
| 0 BPDKNB1 | BLNKZ | T057 | Preference Indicator | BEGDA |
| 1 BPDKNB1 | BUSAB | T001S | Accounting Clerks | MANDT |
| 1 BPDKNB1 | BUSAB | T001S | Accounting Clerks | BUKRS |
| 1 BPDKNB1 | BUSAB | T001S | Accounting Clerks | BUSAB |
| 0 BPDKNB1 | FDGRV | T035 | Planning groups | GRUPP |
| 1 BPDKNB1 | KNRZE | KNA1 | General Data in Customer Master | MANDT |
| 1 BPDKNB1 | KNRZE | KNA1 | General Data in Customer Master | KUNNR |