| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | T000 | MANDT | Allow NULL? |
| 2 | BBPPCINS | Procurement card company | nvarchar | 4 | 0 | CHAR | (N' ') | No | BBP_PCINS | BBPPCINS | Allow NULL? |
| 3 | PCNUM | Procurement card number | nvarchar | 25 | 0 | CHAR | (N' ') | No | | BBPPCNUM | Allow NULL? |
| 4 | PCNAME | Name of procurement cardholder | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | BBPPCNAME | Allow NULL? |
| 5 | PCDAT_FROM | Procurement card valid from date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BBPPCDATF | Allow NULL? |
| 6 | PCDAT_TO | Procurement card expiration date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BBPPCDATE | Allow NULL? |
| 7 | PCTYP | Procurement card type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | BBPPCTYP | Allow NULL? |
| 8 | PCBEGRU | Authorization Group | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BRGRU | Allow NULL? |
| 9 | PCHOTYPE | Procurement cardholder type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | PCHOTYPE | Allow NULL? |
| 10 | PCHOBJID | Procurement cardholder ID | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | PCHOBJID | Allow NULL? |
| 11 | USERNAME | User Name in User Master Record | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | USR02 | XUBNAME | Allow NULL? |
| 12 | PCWFOTYPE1 | Workflow agent type 1 for procurement card | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | PCWFOTYPE1 | Allow NULL? |
| 13 | PCWFOBJID1 | First workflow agent ID for procurement card | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | PCWFOBJID1 | Allow NULL? |
| 14 | PCWFOTYPE2 | Workflow agent type 2 for procurement card | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | PCWFOTYPE2 | Allow NULL? |
| 15 | PCWFOBJID2 | Second workflow agent ID for procurement card | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | PCWFOBJID2 | Allow NULL? |
| 16 | PCBLOCK | Reason for blocking procurement card | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | BBP_PCBLO | BBPPCBLOCK | Allow NULL? |
| 17 | LCURRENCY | Local Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | HWAER | Allow NULL? |
| 18 | TALIMIT | Procurement card transaction limit | decimal | 13 | 2 | CURR | ((0)) | Yes | | BBPTALIMIT | |
| 19 | TOLIMIT | Procurement Card: Total Limit | decimal | 13 | 2 | CURR | ((0)) | Yes | | BBPTOLIMIT | |
| 20 | PCAP1LIM | First approval amount limit for the procurement card | decimal | 13 | 2 | CURR | ((0)) | Yes | | PCAP1LIM | |
| 21 | PCAP2LIM | Second approval amount limit for the procurement card | decimal | 13 | 2 | CURR | ((0)) | Yes | | PCAP2LIM | |
| 22 | COMP_CODE | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BUKRS | Allow NULL? |
| 23 | CO_AREA | Controlling Area | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | KOKRS | Allow NULL? |
| 24 | FM_AREA | Financial Management Area | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | FIKRS | Allow NULL? |
