DBERCHZ4

Individual line items (rarely used fields) | #transactional | Component: Contract Billing
Column Name Description
MANDT Client
BELNR Billing Document Number
BELZEILE Billing line item for billing documents
Column Name Description
💲 Currency key for amount (WAERSF):
NETTOFRMD Amount in foreign currency with +/- sign
Column Name Description
Column Name Description
UMRECHDAT Conversion Date for Foreign Currency Amount
DATEFROM Start Date
TIMEFROM Start Time
DATETO End Date
TIMETO End Time
Column Name Description
SPERRUNG Time slice is in a disconnection period Show values
TAXREL Line Contains Tax Determination Quantity for Invoicing Show values
RATERELCAT Rate Relationship Category Show values
PROPORTION_EXT Distribution Proportion Show values
Column Name Description Domain name
LEUCHTNR External lighting number LEUCHTNR
SPGRUND Disconnection reason SPGRUND
EIN05 Input operand E_OPERAND
EIN06 Input operand E_OPERAND
EIN07 Input operand E_OPERAND
EIN08 Input operand E_OPERAND
EIN09 Input operand E_OPERAND
EIN10 Input operand E_OPERAND
AUS03 Output operand E_OPERAND
AUS04 Output operand E_OPERAND
AUS05 Output operand E_OPERAND
SC_BELNR Number of billing document in adjustment reversal E_BELNR
SC_BELZEILE Billing line item for billing documents LFDNR6
REFBELZEILE Reference billing line item for billing documents LFDNR6
UMRECHKURS Exchange rate btwn net amount and foreign currency amount KURSF
REFBELZONE Ref. billing line item for documents resulting from blocking LFDNR6
REFBILLDOCNO Reference Document Number E_BELNR
FIRSTBELNR Billing Document Number of First Invoiced Document E_BELNR
TAXGROUP Categorize Amounts for Tax Determination KENNZ4
BILLTYPE Waste Billing Category BILLTYPE_ID
OBJNR Number of service frequency EOBJNR
ORDERNR Internal Number for Identifying a Waste Disposal Order EORDERNR
LAUFNR Sequence Number of Service Frequency NUMC5
ORDER_LAUFNR Sequence Number for Waste Disposal Order Item NUMC4
GGVERTRAG Guarantor Contract E_GUARANTOR_CONTRACT
OLD_BELNR Billing Document Number E_BELNR
CONDIREF Internal: Reference Number for a Condition LFDNR4
RATERELGROUP Rate Relationship Group (in Schema) E_RATERELGROUP
BASIC_RATE Rate key TARIFNR
CONDBILLPROGID Conditional Billing Program ID E_CONDBILLPROG_ID
GEN_CONTRACT Contract VERTRAG
REC_CONTRACT Contract VERTRAG
GEN_TOU Generating TOU ETOU
REC_TOU ISU_Brazil: Consuming TOU ETOU
PROPORTION null EPROPORTION
V_ZAHL5 Pre-decimal places in a number V_ZAHL
N_ZAHL5 Decimal places in a number N_ZAHL
V_ZAHL6 Pre-decimal places in a number V_ZAHL
N_ZAHL6 Decimal places in a number N_ZAHL
COLOGRP_INST_L Colocation group for Installation COLOGRP_KK
Master Data Relations Join Conditions
Operation Type for Lighting Unit
  • DBERCHZ4.MANDT == TE497.MANDT
  • DBERCHZ4.BETRART == TE497.BETRART
Unit of Measurement
  • DBERCHZ4.MANDT == T006.MANDT
  • DBERCHZ4.MASS5 == T006.MSEHI
Unit of Measurement
  • DBERCHZ4.MANDT == T006.MANDT
  • DBERCHZ4.MASS6 == T006.MSEHI
Currency key for amount
  • DBERCHZ4.MANDT == TCURC.MANDT
  • DBERCHZ4.WAERSF == TCURC.WAERS