TISU_SMLDOC_BR

IS-U-BR Bill.Sim: Simulated Documents | #masterdata | Component: Utilities Industry Brazil
Column Name Description
MANDT Client
PRINT_DOCUMENT IS-U-BR Bill.Sim: Number of Simulated Print Document
BILLING_ITEM Billing line item for billing documents
SCENARIO_ID IS-U-BR Bill.Sim: Scenario ID
Column Name Description
SBASW Amount Subject to Tax in Transaction Currency (Tax Base Amt)
SBETW Tax Amount in Transaction Currency with +/- Sign
BETRW Amount in Transaction Currency with +/- Sign
AUGBW Clearing Amount in Transaction Currency (With +/- Sign)
SKTOW Cash discount amount in transaction currency with +/- sign
ASKTW Proportional Cash Discount in Transaction Currency
💲 Transaction Currency (TWAERS):
NETTOBTR Net amount of billing line item
💲 Currency key for amount (WAERSF):
NETTOFRMD Amount in foreign currency with +/- sign
Column Name Description
Column Name Description
BLDAT Document Date in Document
BUDAT Posting Date in the Document
FAEDN Due date for net payment
FAEDS Due Date for Cash Discount
AB Date from which time slice is valid
BIS Date at Which a Time Slice Expires
DATUM1 Date
DATUM2 Date
ADATMAX Date of maximum meter reading
THGDATUM Gas allocation date
ZUORDDAT Meter reading allocation date
BEGPROG Start of forecast period
ENDEPROG End of forecast period
TXDAT_KK Decisive Date for Calculating Taxes
UMRECHDAT Conversion Date for Foreign Currency Amount
DATEFROM Start Date
TIMEFROM Start Time
DATETO End Date
TIMETO End Time
Column Name Description
SHKZG Debit/Credit Indicator Show values
XTOTAL_AMNT Consider Items in Bill Sum Total Show values
ABSLKZ Billing Line Item for Budget Billing Amount Determination Show values
DIFFKZ Indicator: difference line item for discount statistics Show values
BUCHREL Billing Line Item Relevant to Posting Show values
MENGESTREL Quantity (billed value) is statistically relevant Show values
BETRSTREL Amount of billing line item is statistically relevant Show values
PRINTREL Billing Line Is Print-Relevant Show values
TIMTYPZA Time category (days or months) for billing line item Show values
TIMTYP Time category (days or months) Show values
FRAN_TYPE Franchise Fee Category Show values
PEB Indicator: billing line item relates to period-end billing Show values
ARTMENGE Classification of billed quantity for statistics Show values
TIMTYPQUOT Time category of meter for time portion of a time slice Show values
AKTIV Meter reading active Show values
PERTYP Category of the internal billing period Show values
ERCHV_ANCHOR Anchor Line for DBERCHV Entry Show values
REGRELSORT Sort help for register relationships during bill printout Show values
EXTPKZ Simulation Indicator for Meter Reading Results Show values
QDPROC Quantity Determination Procedure Show values
PREISTYP Price category Show values
OPMULT Addition first Show values
APERIODIC Non-Periodic Posting Show values
BRUTTOZEILE Blling line item is a gross line item Show values
PREISART Price type Show values
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
DOCUMENT_SAVE_DBERDZ Document Was Saved in DBERDZ Show values
Column Name Description Domain name
ORIGINAL_PRINT_DOCUMENT IS-U-BR Bill.Sim: Number of Original Print Document E_PRINTDOC
BUKRS Company Code BUKRS
KTOSL Transaction Key CHAR3
HKONT General Ledger Account SAKNR
STPRZ Tax rate in output format CHAR8
TXJCD Tax Jurisdiction TXJCD
SKTPZ Cash Discount Percentage Rate PRZ23
VERTRAG Contract VERTRAG
ABPOPBEL Budget billing plan OPBEL_KK
AWTYP Reference procedure AWTYP
AWKEY Reference Key AWKEY
CA_OPBEL Number of a FI-CA Document OPBEL_KK
TAXRATE_INTERNAL Tax rate STPRZ_KK
CSNO Sequence number of schema step during billing LFDSCHEM
STGRQNT Quantity statistics group STGRQNT
STGRAMT Amount statistics group STGRAMT
AKLASSE Billing Class AKLASSE
TAX_TVORG Subtransaction for tax determination for BB line items TVORG_KK
SCHEMANR Number of the billing schema SCHEMANR
SNO Sequence number of schema step in billing schema LFDNR4
PROGRAMM Variant program E_PROGRAMM
SAISON Season E_OPERAND
TIMBASIS Time Basis TIMBASIS
TARIFTYP Rate category TARIFTYP
TARIFNR Rate key TARIFNR
STTARIF Statistical rate STTARIFNR
WDHFAKT Repetition factor for reference values E_FAKTOR
DRCKSTUF Gas pressure level DRCKSTUF_GRID
EIN01 Input operand E_OPERAND
EIN02 Input operand E_OPERAND
EIN03 Input operand E_OPERAND
EIN04 Input operand E_OPERAND
AUS01 Output operand E_OPERAND
AUS02 Output operand E_OPERAND
RABZUS Discount key RABZUS
BACKCANC01 Indicator: reverse backbilling BACKGROUP
BACKCANC02 Indicator: reverse backbilling BACKGROUP
BACKCANC03 Indicator: reverse backbilling BACKGROUP
BACKCANC04 Indicator: reverse backbilling BACKGROUP
BACKCANC05 Indicator: reverse backbilling BACKGROUP
BACKCANC Indicator: Reverse Backbilling BACKGROUP
BACKEXEC Indicator: allocate backbilling BACKGROUP
BACKDOCNO Number of a billing document E_BELNR
BACKDOCLINE Billing line item for billing documents LFDNR6
DYNCANC01 Schema steps for reversal in dynamic period control 1 DYNGROUP
DYNCANC02 Reversal indicator, dynamic period control 2 DYNGROUP
DYNCANC03 Reversal indicator, dynamic period control 3 DYNGROUP
DYNCANC04 Reversal Indicator, Dynamic Period Control 4 DYNGROUP
DYNCANC05 Reversal indicator, dynamic period control 5 DYNGROUP
DYNCANC Indicator: Reverse Backbilling DYNGROUP
DYNEXEC Indicator: Allocate Backbilling DYNGROUP
LRATESTEP Logical Number of Rate Step LRATESTEP
OPLFDNR Consecutive number of an operand LFDNR4
STAFO Update Group for statistics update STAFO
TIMECONTRL Period control TIMECONTRL
TCNUMTOR Numerator of the time portion in a time slice TCNUMTOR
TCDENOMTOR Denominator of the time portion in a time slice TCDENOMTOR
KONZVER Franchise contract KONZVER
OUCONTRACT Master Agreement for Individual Contract VERTRAG
EQUNR Equipment Number EQUNR
GERAET Device GERNR
MATNR Material Number MATNR
ZWNUMMER Register LFDNR3
INDEXNR Consecutive number of register relationship INDEXNR
ATIM Meter reading time (relevant to billing) HHMM
ATIMVA Time of day of previous meter reading HHMM
ATIMMAX Time of maximum meter reading HHMM
ABLBELNR Internal ID for meter reading document ABLBELNR
LOGIKNR Logical device number LOGIKNR
LOGIKZW Logical register number LOGIKZW
ISTABLART Meter reading type ISTABLART
ISTABLARTVA Meter reading type of previous meter reading ISTABLART
ABLHINW Note from meter reader ABLHINW
MRCONNECT Internal ID for meter reading document ABLBELNR
MWSKZ Tax on sales/purchases code MWSKZ
ERMWSKZ Indicator: Tax Determination Code ERMWSKZ
PREIS Price E_PREIS
PREISZUS Indicator: Price Summary KENNZ4
VONZONE From-block E_ZONE
BISZONE To-block E_ZONE
ZONENNR Number of price block or price scale E_ZONENNR
PREISBTR Price amount PRSBTR
MNGBASIS Long quantity base for amount MENGENBAS
PREIGKL Price adjustment clause PREIGKL
URPREIS Base price to which the price adjustment clause relates PRSBTR
PREIADD Price to be added for price adjustment PRSBTR
PREIFAKT Price adjustment factor PREIFAKT
PAOBJNR Profitability Segment Number (CO-PA) RKEOBJNR
PAOBJNR_S Profitability Segment No. for CO-PA Post. Acc. to Cons. Mth RKEOBJNR
GROSSGROUP Gross group GROSSGROUP
BUPLA Business Place J_1BBRANCH
LINE_CLASS Classification Criteria for Billing Line LINE_CLASS
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
I_ZWSTAND Meter reading recorded I_ZWSTAND
I_ZWSTNDAB Billed meter reading I_ZWSTAND
I_ZWSTVOR Previous meter reading I_ZWSTAND
I_ABRMENGE Billing quantity for internal billing format I_ABRMENGE
I_ABRMENGEVOR Billing Quantity: Internal Format of Previous Billing I_ABRMENGE
I_ZWSTDIFF Meter reading difference in internal format I_ZWSTDIFF
I_ZAHL1 Number fields in internal billing format I_ZAHL
I_ZAHL2 Number fields in internal billing format I_ZAHL
I_ZAHL3 Number fields in internal billing format I_ZAHL
I_ZAHL4 Number fields in internal billing format I_ZAHL
I_ZAHL5 Number fields in internal billing format I_ZAHL
I_ZAHL6 Number fields in internal billing format I_ZAHL
ZEITANT Time portion, billing period in days or months E_ZEITANT_L
I_NETTOBTR_L Long Net Amount - Internal Billing Format I_NETTOBTR_L
ERCHBELNR Billing Document Number E_BELNR
ERCHZBELZEILE Billing line item for billing documents LFDNR6
SRCDOCNO Number of Source Document to Be Invoiced SRCDOCNO_KK
ITEMTYPE Type of Invoicing Item INV_ITEMTYPE_KK
SUBTOTAL_GROSS_AMAUNT_LINES INTERNAL: Lines coes from a gross amount
PRINT_DOCUMENT_REFERENCE Reference to Print Document E_PRINTDOC
IS_TYPE Industry System BU_ISTYPE
INVOICING_TRANSACTION Main Invoicing Transaction HVORG_KK
DEBIT_POSTING_SUMARIZATION Summarization Transaction from Ivoicing for Debit Posting TVORG_KK
CREDIT_POSTING_SUMARIZATION Summarization Transaction of Invoicing for Credit Posting TVORG_KK
Master Data Relations Join Conditions
Reason for proration
  • TISU_SMLDOC_BR.MANDT == TE661.MANDT
  • TISU_SMLDOC_BR.ABGGRND1 == TE661.ABGGRND
Reason for proration
  • TISU_SMLDOC_BR.MANDT == TE661.MANDT
  • TISU_SMLDOC_BR.ABGGRND10 == TE661.ABGGRND
Reason for proration
  • TISU_SMLDOC_BR.MANDT == TE661.MANDT
  • TISU_SMLDOC_BR.ABGGRND2 == TE661.ABGGRND
Reason for proration
  • TISU_SMLDOC_BR.MANDT == TE661.MANDT
  • TISU_SMLDOC_BR.ABGGRND3 == TE661.ABGGRND
Reason for proration
  • TISU_SMLDOC_BR.MANDT == TE661.MANDT
  • TISU_SMLDOC_BR.ABGGRND4 == TE661.ABGGRND
Reason for proration
  • TISU_SMLDOC_BR.MANDT == TE661.MANDT
  • TISU_SMLDOC_BR.ABGGRND5 == TE661.ABGGRND
Reason for proration
  • TISU_SMLDOC_BR.MANDT == TE661.MANDT
  • TISU_SMLDOC_BR.ABGGRND6 == TE661.ABGGRND
Reason for proration
  • TISU_SMLDOC_BR.MANDT == TE661.MANDT
  • TISU_SMLDOC_BR.ABGGRND7 == TE661.ABGGRND
Reason for proration
  • TISU_SMLDOC_BR.MANDT == TE661.MANDT
  • TISU_SMLDOC_BR.ABGGRND8 == TE661.ABGGRND
Reason for proration
  • TISU_SMLDOC_BR.MANDT == TE661.MANDT
  • TISU_SMLDOC_BR.ABGGRND9 == TE661.ABGGRND
Meter reading reason TISU_SMLDOC_BR.ABLESGR == TE609.ABLESGR
Previous meter reading reason TISU_SMLDOC_BR.ABLESGRV == TE609.ABLESGR
Order Number
  • Order Number
  • Client
  • TISU_SMLDOC_BR.AUFNR == AUFK.AUFNR
  • TISU_SMLDOC_BR.MANDT == AUFK.MANDT
Line Item Type
  • TISU_SMLDOC_BR.MANDT == TE835.MANDT
  • TISU_SMLDOC_BR.BELZART == TE835.BELZART
Operation Type for Lighting Unit
  • TISU_SMLDOC_BR.MANDT == TE497.MANDT
  • TISU_SMLDOC_BR.BETRART == TE497.BETRART
Industry sector
  • ?
  • Industry
  • Client
  • TISU_SMLDOC_BR.[column in domain "BU_ISTYPE"] == TB038A.ISTYPE
  • TISU_SMLDOC_BR.BRANCHE == TB038A.IND_SECTOR
  • TISU_SMLDOC_BR.MANDT == TB038A.CLIENT
Offsetting trans. for sub-transaction of billing line item
  • ?
  • ?
  • Offsetting trans. for sub-transaction of billing line item
  • TISU_SMLDOC_BR.MANDT == TFKTVO.MANDT
  • TISU_SMLDOC_BR.[column in domain "HVORG_KK"] == TFKTVO.HVORG
  • TISU_SMLDOC_BR.[column in domain "APPLK_KK"] == TFKTVO.APPLK
  • TISU_SMLDOC_BR.GEGEN_TVORG == TFKTVO.TVORG
Weighting key
  • TISU_SMLDOC_BR.MANDT == TE266.MANDT
  • TISU_SMLDOC_BR.GEWKEY == TE266.GEWKEY
F4 help
  • TISU_SMLDOC_BR.MANDT == TGSB.MANDT
  • TISU_SMLDOC_BR.GSBER == TGSB.GSBER
Main Transaction for Line Item
  • ?
  • Main Transaction for Line Item
  • TISU_SMLDOC_BR.MANDT == TFKHVO.MANDT
  • TISU_SMLDOC_BR.[column in domain "APPLK_KK"] == TFKHVO.APPLK
  • TISU_SMLDOC_BR.HVORG == TFKHVO.HVORG
Rate fact group
  • Rate fact group
  • Client
  • TISU_SMLDOC_BR.KONDIGR == TE067.KONDIGR
  • TISU_SMLDOC_BR.MANDT == TE067.MANDT
Franchise fee group
  • TISU_SMLDOC_BR.MANDT == TE241.MANDT
  • TISU_SMLDOC_BR.KONZIGR == TE241.KONZIGR
Cost Center
  • ?
  • Cost Center
  • ?
  • TISU_SMLDOC_BR.MANDT == CSKS.MANDT
  • TISU_SMLDOC_BR.[column in domain "DATBI"] == CSKS.DATBI
  • TISU_SMLDOC_BR.KOSTL == CSKS.KOSTL
  • TISU_SMLDOC_BR.[column in domain "KOKRS"] == CSKS.KOKRS
Presorting of billing line items in billing schema
  • Presorting of billing line items in billing schema
  • Client
  • TISU_SMLDOC_BR.LINESORT == TE530.LINESORT
  • TISU_SMLDOC_BR.MANDT == TE530.MANDT
Unit of Measurement
  • TISU_SMLDOC_BR.MANDT == T006.MANDT
  • TISU_SMLDOC_BR.MASS1 == T006.MSEHI
Unit of Measurement
  • TISU_SMLDOC_BR.MANDT == T006.MANDT
  • TISU_SMLDOC_BR.MASS2 == T006.MSEHI
Unit of Measurement
  • TISU_SMLDOC_BR.MANDT == T006.MANDT
  • TISU_SMLDOC_BR.MASS3 == T006.MSEHI
Unit of Measurement
  • TISU_SMLDOC_BR.MANDT == T006.MANDT
  • TISU_SMLDOC_BR.MASS4 == T006.MSEHI
Unit of Measurement
  • TISU_SMLDOC_BR.MANDT == T006.MANDT
  • TISU_SMLDOC_BR.MASS5 == T006.MSEHI
Unit of Measurement
  • TISU_SMLDOC_BR.MANDT == T006.MANDT
  • TISU_SMLDOC_BR.MASS6 == T006.MSEHI
Unit of measurement for billing
  • TISU_SMLDOC_BR.MANDT == T006.MANDT
  • TISU_SMLDOC_BR.MASSBILL == T006.MSEHI
Profit Center
  • ?
  • ?
  • Profit Center
  • TISU_SMLDOC_BR.MANDT == CEPC.MANDT
  • TISU_SMLDOC_BR.[column in domain "DATBI"] == CEPC.DATBI
  • TISU_SMLDOC_BR.[column in domain "KOKRS"] == CEPC.KOKRS
  • TISU_SMLDOC_BR.PRCTR == CEPC.PRCTR
Price level
  • TISU_SMLDOC_BR.MANDT == TE471.MANDT
  • TISU_SMLDOC_BR.PREISTUF == TE471.PREISTUF
Segment for Segmental Reporting
Division
  • TISU_SMLDOC_BR.MANDT == TSPA.MANDT
  • TISU_SMLDOC_BR.SPARTE == TSPA.SPART
Category of Source Document To Be Invoiced TISU_SMLDOC_BR.SRCDOCCAT == TFK2605C.SRCDOCCAT
Rate type for statistical analysis
  • TISU_SMLDOC_BR.MANDT == TE069.MANDT
  • TISU_SMLDOC_BR.STATTART == TE069.TARIFART
Temperature area
  • Temperature area
  • Client
  • TISU_SMLDOC_BR.TEMP_AREA == TE307.TEMP_AREA
  • TISU_SMLDOC_BR.MANDT == TE307.MANDT
Subtransaction for Document Item
  • ?
  • ?
  • Subtransaction for Document Item
  • TISU_SMLDOC_BR.MANDT == TFKTVO.MANDT
  • TISU_SMLDOC_BR.[column in domain "HVORG_KK"] == TFKTVO.HVORG
  • TISU_SMLDOC_BR.[column in domain "APPLK_KK"] == TFKTVO.APPLK
  • TISU_SMLDOC_BR.TVORG == TFKTVO.TVORG
Transaction Currency
  • TISU_SMLDOC_BR.MANDT == TCURC.MANDT
  • TISU_SMLDOC_BR.TWAERS == TCURC.WAERS
Currency key for amount
  • TISU_SMLDOC_BR.MANDT == TCURC.MANDT
  • TISU_SMLDOC_BR.WAERSF == TCURC.WAERS