DBERCHZ7 SAP (Document line items (amount/price data, unimportant rows)) Table details
Description: Document line items (amount/price data, unimportant rows)
Table field list including key, data, relationships and ABAP select examples
DBERCHZ7 is a standard SAP Table which is used to store Document line items (amount/price data, unimportant rows) data and is available within R/3 SAP systems depending on the version and release level.
The DBERCHZ7 table consists of various fields, each holding specific information or linking keys about Document line items (amount/price data, unimportant rows) data available in SAP. These include BELNR (Number of a billing document), BELZEILE (Billing line item for billing documents), MWSKZ (Tax on sales/purchases code), ERMWSKZ (Indicator: Tax Determination Code).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced
SAP DBERCHZ7 table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
BELNR | Number of a billing document | E_BELNR | CHAR | 12 | ALPHA | E_BELNR | BEL | ERCH | |
BELZEILE | Billing line item for billing documents | BELZEILE | NUMC | 6 | LFDNR6 | ||||
MWSKZ | Tax on sales/purchases code | MWSKZ | CHAR | 2 | Assigned to domain | MWSKZ | |||
ERMWSKZ | Indicator: Tax Determination Code | ERMWSKZ | CHAR | 2 | Assigned to domain | ERMWSKZ | |||
NETTOBTR | Net amount of billing line item | NETTOBTR | CURR | 13(2) | WRTV7 | ||||
TWAERS | Transaction Currency | TWAERS | CUKY | 5 | TCURC | WAERS | PCU | ||
PREISTUF | Price level | PREISTUF | CHAR | 10 | TE471 | PREISTUF | PRZ | ||
PREISTYP | Price category | PREISTYP | CHAR | 1 | PREISTYP | PRY | |||
PREIS | Price | E_PREIS | CHAR | 10 | Assigned to domain | ALPHA | E_PREIS | PRX | ISU_F4_PREIS |
PREISZUS | Indicator: Price Summary | PREISZUS | CHAR | 4 | KENNZ4 | ||||
VONZONE | From-block | VONZONE | NUMC | 10 | E_ZONE | ||||
BISZONE | To-block | BISZONE | NUMC | 10 | E_ZONE | ||||
ZONENNR | Number of price block or price scale | E_ZONENNR | NUMC | 3 | E_ZONENNR | ||||
PREISBTR | Price amount | PRSBTR | DEC | 17(8) | PRSBTR | ||||
MNGBASIS | Long quantity base for amount | MENGENBAS | DEC | 9(2) | MENGENBAS | ||||
PREIGKL | Price adjustment clause | PREIGKL | CHAR | 10 | Assigned to domain | PREIGKL | PAC | ||
URPREIS | Base price to which the price adjustment clause relates | URPREIS | DEC | 17(8) | PRSBTR | ||||
PREIADD | Price to be added for price adjustment | PREIADD | DEC | 17(8) | PRSBTR | ||||
PREIFAKT | Price adjustment factor | PREIFAKT | DEC | 12(7) | PREIFAKT | ||||
OPMULT | Addition first | OPMULT | CHAR | 1 | KENZX | ||||
TXDAT_KK | Decisive Date for Calculating Taxes | TXDAT_KK | DATS | 8 | DATUM | ||||
PRCTR | Profit Center | PRCTR | CHAR | 10 | CEPC | ALPHA | PRCTR | PRC | PRCTR_EMPTY |
KOSTL | Cost Center | KOSTL | CHAR | 10 | CSKS | ALPHA | KOSTL | KOS | |
PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | NUMC | 8 | PRPS | KONPR | PS_POSNR | ||
AUFNR | Order Number | AUFNR | CHAR | 12 | AUFK | ALPHA | AUFNR | ANR | |
PAOBJNR | Profitability Segment Number (CO-PA) | RKEOBJNR | NUMC | 10 | RKEOBJNR | ||||
PAOBJNR_S | Profitability Segment No. for CO-PA Post. Acc. to Cons. Mth | RKEOBJNR_S | NUMC | 10 | RKEOBJNR | ||||
GSBER | Business Area | GSBER | CHAR | 4 | TGSB | GSBER | GSB | ||
APERIODIC | Non-Periodic Posting | APERIODIC | CHAR | 1 | KENNZX | ||||
GROSSGROUP | Gross group | GROSSGROUP | CHAR | 4 | GROSSGROUP | ||||
BRUTTOZEILE | Blling line item is a gross line item | BRUTTOZEILE | CHAR | 1 | KENNZX | ||||
BUPLA | Business Place | BUPLA | CHAR | 4 | Assigned to domain | J_1BBRANCH | |||
LINE_CLASS | Classification Criteria for Billing Line | LINE_CLASS | CHAR | 4 | LINE_CLASS | ||||
PREISART | Price type | E_PREISART | CHAR | 1 | E_PREISART | ||||
SEGMENT | Segment for Segmental Reporting | SEGMT_KK | CHAR | 10 | FAGL_SEGM | ALPHA | FB_SEGMENT | ||
V_NETTOBTR_L | Predecimal Places of Long Nett Amount | V_NETTOBTR_L | DEC | 17 | V_NETTOBTR_L | ||||
N_NETTOBTR_L | Decimal Places for Long Nett Amount | N_NETTOBTR_L | DEC | 14(14) | N_NETTOBTR_L |
Key field | Non-key field |
How do I retrieve data from SAP table DBERCHZ7 using ABAP code
The following ABAP code Example will allow you to do a basic selection on DBERCHZ7 to SELECT all data from the tableDATA: WA_DBERCHZ7 TYPE DBERCHZ7.
SELECT SINGLE *
FROM DBERCHZ7
INTO CORRESPONDING FIELDS OF WA_DBERCHZ7
WHERE...
How to access SAP table DBERCHZ7
Within an ECC or HANA version of SAP you can also view further information about DBERCHZ7 and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects