SAP ABAP Table DBERCHZ7 (Document line items (amount/price data, unimportant rows))
Hierarchy
☛
IS-UT (Software Component) SAP Utilities/Telecommunication
⤷ IS-U-BI (Application Component) Contract Billing
⤷ EE20 (Package) IS-U: Billing
⤷ IS-U-BI (Application Component) Contract Billing
⤷ EE20 (Package) IS-U: Billing
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | DBERCHZ7 | Table Relationship Diagram |
Short Description | Document line items (amount/price data, unimportant rows) |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | A | Application Table (Master- and Transaction Data) |
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
2 | BELNR | E_BELNR | E_BELNR | CHAR | 12 | 0 | Number of a billing document | ||
3 | BELZEILE | BELZEILE | LFDNR6 | NUMC | 6 | 0 | Billing line item for billing documents | ||
4 | .INCLUDE | 0 | 0 | Substructure of document line items, amounts and prices | |||||
5 | MWSKZ | MWSKZ | MWSKZ | CHAR | 2 | 0 | Tax on sales/purchases code | * | |
6 | ERMWSKZ | ERMWSKZ | ERMWSKZ | CHAR | 2 | 0 | Indicator: Tax Determination Code | * | |
7 | NETTOBTR | NETTOBTR | WRTV7 | CURR | 13 | 2 | Net amount of billing line item | ||
8 | TWAERS | TWAERS | WAERS | CUKY | 5 | 0 | Transaction Currency | TCURC | |
9 | PREISTUF | PREISTUF | PREISTUF | CHAR | 10 | 0 | Price level | TE471 | |
10 | PREISTYP | PREISTYP | PREISTYP | CHAR | 1 | 0 | Price category | ||
11 | PREIS | E_PREIS | E_PREIS | CHAR | 10 | 0 | Price | * | |
12 | PREISZUS | PREISZUS | KENNZ4 | CHAR | 4 | 0 | Indicator: Price Summary | ||
13 | VONZONE | VONZONE | E_ZONE | NUMC | 10 | 0 | From-block | ||
14 | BISZONE | BISZONE | E_ZONE | NUMC | 10 | 0 | To-block | ||
15 | ZONENNR | E_ZONENNR | E_ZONENNR | NUMC | 3 | 0 | Number of price block or price scale | ||
16 | PREISBTR | PRSBTR | PRSBTR | DEC | 17 | 8 | Price amount | ||
17 | MNGBASIS | MENGENBAS | MENGENBAS | DEC | 9 | 2 | Long quantity base for amount | ||
18 | PREIGKL | PREIGKL | PREIGKL | CHAR | 10 | 0 | Price adjustment clause | * | |
19 | URPREIS | URPREIS | PRSBTR | DEC | 17 | 8 | Base price to which the price adjustment clause relates | ||
20 | PREIADD | PREIADD | PRSBTR | DEC | 17 | 8 | Price to be added for price adjustment | ||
21 | PREIFAKT | PREIFAKT | PREIFAKT | DEC | 12 | 7 | Price adjustment factor | ||
22 | OPMULT | OPMULT | KENZX | CHAR | 1 | 0 | Addition first | ||
23 | TXDAT_KK | TXDAT_KK | DATUM | DATS | 8 | 0 | Decisive Date for Calculating Taxes | ||
24 | PRCTR | PRCTR | PRCTR | CHAR | 10 | 0 | Profit Center | CEPC | |
25 | KOSTL | KOSTL | KOSTL | CHAR | 10 | 0 | Cost Center | CSKS | |
26 | PS_PSP_PNR | PS_PSP_PNR | PS_POSNR | NUMC | 8 | 0 | Work Breakdown Structure Element (WBS Element) | PRPS | |
27 | AUFNR | AUFNR | AUFNR | CHAR | 12 | 0 | Order Number | AUFK | |
28 | PAOBJNR | RKEOBJNR | RKEOBJNR | NUMC | 10 | 0 | Profitability Segment Number (CO-PA) | ||
29 | PAOBJNR_S | RKEOBJNR_S | RKEOBJNR | NUMC | 10 | 0 | Profitability Segment No. for CO-PA Post. Acc. to Cons. Mth | ||
30 | GSBER | GSBER | GSBER | CHAR | 4 | 0 | Business Area | TGSB | |
31 | APERIODIC | APERIODIC | KENNZX | CHAR | 1 | 0 | Non-Periodic Posting | ||
32 | GROSSGROUP | GROSSGROUP | GROSSGROUP | CHAR | 4 | 0 | Gross group | ||
33 | BRUTTOZEILE | BRUTTOZEILE | KENNZX | CHAR | 1 | 0 | Blling line item is a gross line item | ||
34 | BUPLA | BUPLA | J_1BBRANCH | CHAR | 4 | 0 | Business Place | * | |
35 | LINE_CLASS | LINE_CLASS | LINE_CLASS | CHAR | 4 | 0 | Classification Criteria for Billing Line | ||
36 | PREISART | E_PREISART | E_PREISART | CHAR | 1 | 0 | Price type | ||
37 | .INCLUDE | 0 | 0 | Predecimal/Decimal Places of Amount Fields in ERCHZ | |||||
38 | V_NETTOBTR_L | V_NETTOBTR_L | V_NETTOBTR_L | DEC | 17 | 0 | Predecimal Places of Long Nett Amount | ||
39 | N_NETTOBTR_L | N_NETTOBTR_L | N_NETTOBTR_L | DEC | 14 | 14 | Decimal Places for Long Nett Amount |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | DBERCHZ7 | AUFNR | AUFK | AUFNR | |||
2 | DBERCHZ7 | GSBER | TGSB | GSBER | |||
3 | DBERCHZ7 | KOSTL | CSKS | KOSTL | |||
4 | DBERCHZ7 | PRCTR | CEPC | PRCTR | |||
5 | DBERCHZ7 | PREISTUF | TE471 | PREISTUF | KEY | ||
6 | DBERCHZ7 | PS_PSP_PNR | PRPS | PSPNR | |||
7 | DBERCHZ7 | TWAERS | TCURC | WAERS | KEY |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 462 |