| 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 | * | MANDT | Allow NULL? |
| 2 | BELNR | Number of a billing document | nvarchar | 12 | 0 | CHAR | (N' ') | No | | E_BELNR | Allow NULL? |
| 3 | BELZEILE | Billing line item for billing documents | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | BELZEILE | Allow NULL? |
| 4 | MWSKZ | Tax on sales/purchases code | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | MWSKZ | Allow NULL? |
| 5 | ERMWSKZ | Indicator: Tax Determination Code | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | ERMWSKZ | Allow NULL? |
| 6 | NETTOBTR | Net amount of billing line item | decimal | 13 | 2 | CURR | ((0)) | Yes | | NETTOBTR | |
| 7 | TWAERS | Transaction Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | TWAERS | Allow NULL? |
| 8 | PREISTUF | Price level | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TE471 | PREISTUF | Allow NULL? |
| 9 | PREISTYP | Price category | char | 1 | 0 | CHAR | (N' ') | Yes | | PREISTYP | Allow NULL? |
| 10 | PREIS | Price | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | E_PREIS | Allow NULL? |
| 11 | PREISZUS | Indicator: Price Summary | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | PREISZUS | Allow NULL? |
| 12 | VONZONE | From-block | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | VONZONE | Allow NULL? |
| 13 | BISZONE | To-block | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | BISZONE | Allow NULL? |
| 14 | ZONENNR | Number of price block or price scale | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | E_ZONENNR | Allow NULL? |
| 15 | PREISBTR | Price amount | decimal | 17 | 8 | DEC | ((0)) | Yes | | PRSBTR | |
| 16 | MNGBASIS | Long quantity base for amount | decimal | 9 | 2 | DEC | ((0)) | Yes | | MENGENBAS | |
| 17 | PREIGKL | Price adjustment clause | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | PREIGKL | Allow NULL? |
| 18 | URPREIS | Base price to which the price adjustment clause relates | decimal | 17 | 8 | DEC | ((0)) | Yes | | URPREIS | |
| 19 | PREIADD | Price to be added for price adjustment | decimal | 17 | 8 | DEC | ((0)) | Yes | | PREIADD | |
| 20 | PREIFAKT | Price adjustment factor | decimal | 12 | 7 | DEC | ((0)) | Yes | | PREIFAKT | |
| 21 | OPMULT | Addition first | char | 1 | 0 | CHAR | (N' ') | Yes | | OPMULT | Allow NULL? |
| 22 | TXDAT_KK | Decisive Date for Calculating Taxes | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | TXDAT_KK | Allow NULL? |
| 23 | PRCTR | Profit Center | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | CEPC | PRCTR | Allow NULL? |
| 24 | KOSTL | Cost Center | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | CSKS | KOSTL | Allow NULL? |
| 25 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | PRPS | PS_PSP_PNR | Allow NULL? |
| 26 | AUFNR | Order Number | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | AUFK | AUFNR | Allow NULL? |
| 27 | PAOBJNR | Profitability Segment Number (CO-PA) | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | RKEOBJNR | Allow NULL? |
| 28 | PAOBJNR_S | Profitability Segment No. for CO-PA Post. Acc. to Cons. Mth | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | RKEOBJNR_S | Allow NULL? |
| 29 | GSBER | Business Area | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TGSB | GSBER | Allow NULL? |
| 30 | APERIODIC | Non-Periodic Posting | char | 1 | 0 | CHAR | (N' ') | Yes | | APERIODIC | Allow NULL? |
| 31 | GROSSGROUP | Gross group | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | GROSSGROUP | Allow NULL? |
| 32 | BRUTTOZEILE | Blling line item is a gross line item | char | 1 | 0 | CHAR | (N' ') | Yes | | BRUTTOZEILE | Allow NULL? |
| 33 | BUPLA | Business Place | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BUPLA | Allow NULL? |
| 34 | LINE_CLASS | Classification Criteria for Billing Line | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | LINE_CLASS | Allow NULL? |
| 35 | PREISART | Price type | char | 1 | 0 | CHAR | (N' ') | Yes | | E_PREISART | Allow NULL? |
| 36 | SEGMENT | Segment for Segmental Reporting | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | FAGL_SEGM | SEGMT_KK | Allow NULL? |
| 37 | V_NETTOBTR_L | Predecimal Places of Long Nett Amount | decimal | 17 | 0 | DEC | ((0)) | Yes | | V_NETTOBTR_L | |
| 38 | N_NETTOBTR_L | Decimal Places for Long Nett Amount | decimal | 14 | 14 | DEC | ((0)) | Yes | | N_NETTOBTR_L | |
