|
|
SQL Banking / Payable Information
API TPW2
TPW2 - Payable Information Table
TPW2 SQL Table
Tax Payment Wizard OTPW SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | AbsEntry KEY UNIQUE | Absolute Entry No | Int | 11 | OTPW Tax Payment Wizard | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| LineNumber | Line Number | Int | 11 | |||||
| TaxCategry | Tax Category | Int | 11 | |||||
| TaxType | Tax Type | Int | 11 | |||||
| PyblAmnt | Payable Amount | Num | 20 | |||||
| PyblAmntFC | Payable Amount FC | Num | 20 | |||||
| PyblAmntSC | Payable Amount SC | Num | 20 | |||||
| PLAAmnt | P.L.A. Amount | Num | 20 | |||||
| PLAAmntFC | P.L.A. Amount (FC) | Num | 20 | |||||
| PLAAmntSC | P.L.A. Amount (SC) | Num | 20 |
Table relationship map
SELECT statement
SELECT
TPW2.AbsEntry AS 'Absolute Entry No',
TPW2.LineNumber AS 'Line Number',
TPW2.TaxCategry AS 'Tax Category',
TPW2.TaxType AS 'Tax Type',
TPW2.PyblAmnt AS 'Payable Amount',
TPW2.PyblAmntFC AS 'Payable Amount FC',
TPW2.PyblAmntSC AS 'Payable Amount SC',
TPW2.PLAAmnt AS 'P.L.A. Amount',
TPW2.PLAAmntFC AS 'P.L.A. Amount (FC)',
TPW2.PLAAmntSC AS 'P.L.A. Amount (SC)'
FROM TPW2 AS TPW2
Related information
TPW2 SQL Table
Tax Payment Wizard OTPW SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
