I_MY_BillingDocumentItemCube

Billing Document Item Cube for MY GAF | view: IMYBILLGDOCCUBE | TRAN | Extraction: Full only | Component: Financials Malaysia
Column Name Description
CompanyCode FK Company Code
BillingDocument Billing Document
BillingDocumentItem Billing Item
TaxItemGroupingVersion Grouping Version for Advance Return for Tax on Sales/Purch.
TaxCode Tax on sales/purchases code
TransactionTypeDetermination Transaction Key
DebitCreditCode Debit/Credit Indicator Show values
Column Name Description
💲 Reporting Currency (ReportingCurrency):
ItemNetAmountOfBillingDoc null
TaxAmount null
💲 Reporting Currency (DocumentCurrency):
ItemNetAmount Net Value of Billing item in Document Currency
TaxAmountInAdditionalCurrency1 Tax Amount in Document Currency
Column Name Description
Column Name Description
PostingDate Posting Date in the Document
TaxReportingDate Tax Reporting Date
ReportingDate Reporting Date
BillingDocumentDate Billing Date
Column Name Description
DebitCreditCode Debit/Credit Indicator Show values
Column Name Description Domain name
ExchangeRate Exchange Rate UKURS
CustomerName Name of Customer TEXT80
CustomerSupplierAddress Business Partner Address
VATRegistration VAT Registration Number STCEG
ReportingCountry Reporting Country/Region LAND1
TaxNumber1 Tax Number 1 STCD1
OrganizationBPName4 Customer BRN BU_NAME
BillingDocumentItemText Short text for sales order item TEXT40
MY_IndustryCode Industry Code for Malaysia CHAR10
CountryName Country/Region Name TEXT50
AccountingDocumentHeaderText Document Header Text TEXT25
Master Data Relations Join Conditions
Authorization Group
  • ?
  • Client
  • Authorization Group
  • I_MY_BILLINGDOCUMENTITEMCUBE.[column in domain "BU_AUOBJ"] == TB037.AUOBJ
  • I_MY_BILLINGDOCUMENTITEMCUBE.MANDT == TB037.CLIENT
  • I_MY_BILLINGDOCUMENTITEMCUBE.AUTHORIZATIONGROUP == TB037.AUGRP
Business Partner Country/Region
  • Business Partner Country/Region
  • Client
  • I_MY_BILLINGDOCUMENTITEMCUBE.BUSINESSPARTNERCOUNTRY == T005.LAND1
  • I_MY_BILLINGDOCUMENTITEMCUBE.MANDT == T005.MANDT
Company Code
  • Client
  • Company Code
  • I_MY_BILLINGDOCUMENTITEMCUBE.MANDT == T001.MANDT
  • I_MY_BILLINGDOCUMENTITEMCUBE.COMPANYCODE == T001.BUKRS
Currency Key
  • Currency Key
  • Client
  • I_MY_BILLINGDOCUMENTITEMCUBE.COMPANYCODECURRENCY == TCURC.WAERS
  • I_MY_BILLINGDOCUMENTITEMCUBE.MANDT == TCURC.MANDT