SAP table T049A (Posting Data For Autocash With Lockbox)
SAP table T049A has 3 primary key fields being MANDT,DESTI,ORIGN.
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 | |
| DESTI | Ultimate Destination of Transmission | CHAR | 10 | 0 | DESTI_49A | ||
| ORIGN | Present Source of Transmission | CHAR | 10 | 0 | ORIGN_49A | ||
| BABNK | Bank Posting Document Type | CHAR | 2 | 0 | T003 | BABNK_49A | |
| BADEB | Customer Posting Document Type | CHAR | 2 | 0 | T003 | BADEB_49A | |
| BUKRS | Company Code | CHAR | 4 | 0 | T001 | BUKRS | |
| HBKID | Short Key for a House Bank | CHAR | 5 | 0 | T012 | HBKID | |
| HKTID | ID for Account Details | CHAR | 5 | 0 | T012K | HKTID | |
| BKKTO | Lockbox Holder's Bank (G/L Account) Account | CHAR | 16 | 0 | BKKTO_49A | ||
| SEKTO | Lockbox Holder's Bank Clearing Account (A/R) | CHAR | 16 | 0 | SEKTO_49A | ||
| BSSKS | Posting Key, Debit G/L Account | CHAR | 2 | 0 | TBSL | BSSKS_49A | |
| BSSKH | Posting Key, Credit G/L Account | CHAR | 2 | 0 | TBSL | BSSKH_49A | |
| BSDBH | Posting Key, Credit Customer | CHAR | 2 | 0 | TBSL | BSDBH_49A | |
| XAUTS | Flag for Automatic Search for FBZ1 | CHAR | 1 | 0 | XAUTS_49A | ||
| BSDBS | Posting Key: Debit Customer | CHAR | 2 | 0 | TBSL | BSDBS_49A |
T049A foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 T049A | BABNK | T003 | Document Types | MANDT |
| 1 T049A | BADEB | T003 | Document Types | MANDT |
| 0 T049A | BSDBH | TBSL | Posting Key | MANDT |
| 0 T049A | BSDBH | TBSL | Posting Key | BSCHL |
| 1 T049A | BSDBS | TBSL | Posting Key | MANDT |
| 1 T049A | BSDBS | TBSL | Posting Key | BSCHL |
| 0 T049A | BSSKH | TBSL | Posting Key | MANDT |
| 0 T049A | BSSKH | TBSL | Posting Key | BSCHL |
| 1 T049A | BSSKS | TBSL | Posting Key | MANDT |
| 1 T049A | BSSKS | TBSL | Posting Key | BSCHL |
| 0 T049A | BUKRS | T001 | Company Codes | BUKRS |
| 1 T049A | HBKID | T012 | House Banks | BUKRS |
| 0 T049A | HKTID | T012K | House Bank Accounts | MANDT |
| 0 T049A | HKTID | T012K | House Bank Accounts | BUKRS |
| 0 T049A | HKTID | T012K | House Bank Accounts | HBKID |
| 0 T049A | HKTID | T012K | House Bank Accounts | HKTID |
| 1 T049A | MANDT | T000 | Clients | MANDT |