SAP Table
TBSL Posting Key
SAP table TBSL has 2 primary key fields being MANDT,BSCHL.
If you are only analysing data from a single SAP instance you may omit field MANDT in your relationships as it will be the same across the entire dataset. On the other hand, if you are combining data from multiple SAP instances you need to take MANDT into account.
/ Fields
TBSL columns.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| KeyMANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |||||||||||
| KeyBSCHL | Posting Key | CHAR | 2 | 0 | BSCHL | ||||||||||||
| SHKZG | Debit/Credit Indicator | CHAR | 1 | 0 | SHKZG | ||||||||||||
|
|||||||||||||||||
| KOART | Account type | CHAR | 1 | 0 | KOART | ||||||||||||
|
|||||||||||||||||
| XUMSW | Indicator: Sales-Related Item ? | CHAR | 1 | 0 | XUMSW_BSL | ||||||||||||
| FAUS1 | Account/Posting Key Field Selection | CHAR | 50 | 0 | FAUS1 | ||||||||||||
| XZAHL | Indicator: Is Posting Key Used in a Payment Transaction? | CHAR | 1 | 0 | XZAHL | ||||||||||||
| STBSL | Posting Key for Reversal/Reverse Entry | CHAR | 2 | 0 | STBSL | ||||||||||||
| XSONU | Indicator: Posting Key for Special G/L Transactions | CHAR | 1 | 0 | XSONU | ||||||||||||
| FAUS2 | Account/Posting Key Field Selection | CHAR | 80 | 0 | FAUS2 | ||||||||||||