C_MY_BillingDocumentItemQuery

Billing Document Item Query for MY GAF | view: CMYBILLGDOCQRY | Extraction: Not supported | 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 Supply Value
TaxAmount Supply Value GST Amount
💲 Reporting Currency (DocumentCurrency):
ItemNetAmount Supply Foreign Currency Amount
TaxAmountInAdditionalCurrency1 Supply Foreign Currency GST Amount
Column Name Description
Column Name Description
TaxReportingDate Tax Reporting Date
ReportingDate Reporting Date
PostingDate Posting Date in the Document
BillingDocumentDate Billing Date
Column Name Description
DebitCreditCode Debit/Credit Indicator Show values
Column Name Description Domain name
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
Business Partner Country/Region
  • Business Partner Country/Region
  • Client
  • C_MY_BILLINGDOCUMENTITEMQUERY.BUSINESSPARTNERCOUNTRY == T005.LAND1
  • C_MY_BILLINGDOCUMENTITEMQUERY.MANDT == T005.MANDT
Company Code
  • Company Code
  • Client
  • C_MY_BILLINGDOCUMENTITEMQUERY.COMPANYCODE == T001.BUKRS
  • C_MY_BILLINGDOCUMENTITEMQUERY.MANDT == T001.MANDT