C_ID_BillgItmCndnPriceQuery

ID Billing Condition Price - Query | view: CIDBITMPRICEQ | Extraction: Not supported | Component: Financials Indonesia
Column Name Description
CompanyCode Company Code
AccountingDocument Document Number of an Accounting Document
FiscalYear Fiscal Year
Material FK Material Number
TransactionTypeDetermination Transaction Key
TaxDeclnAmountType Amount Type for Statutory Reporting Show values
TaxItemGroupingVersion Grouping Version for Advance Return for Tax on Sales/Purch.
UnifiedTaxBoxStructureType Tax Box Structure Type (Adv. Tax Return)
TaxGroup Tax Group
TaxBoxStrucValidityStartDate Valid From Date for Tax Box Structure
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
EligibleAmountForCashDiscount null
NetAmount Net Value of Billing item in Document Currency
TaxBaseAmountInCoCodeCrcy Net Value of Billing item in Document Currency
LuxuryTaxAmt null
TaxAmountInCoCodeCrcy null
Column Name Description
BillingQuantity Actual billed quantity
Column Name Description
TaxBoxStrucValidityStartDate Valid From Date for Tax Box Structure
TaxBoxStrucValidityEndDate Valid To Date for Tax Box Structure
PostingDate Posting Date in the Document
TaxReportingDate Tax Reporting Date
DocumentDate Journal Entry Date
TaxRateValidityStartDate Valid-From Date of the Tax Rate
Column Name Description
TaxDeclnAmountType Amount Type for Statutory Reporting Show values
Column Name Description Domain name
BusinessPlace Business Place J_1BBRANCH
BillingDocument Billing Document VBELN
Customer Customer Number KUNNR
TaxRate TaxRate (Percentage)
BillingDocumentItemText Short text for sales order item TEXT40
TaxInvoiceItemNetUnitPrice null
LuxuryTaxRate TaxRate (Percentage)
Master Data Relations Join Conditions
Material Number
  • Client
  • Material Number
  • C_ID_BILLGITMCNDNPRICEQUERY.MANDT == MARA.MANDT
  • C_ID_BILLGITMCNDNPRICEQUERY.MATERIAL == MARA.MATNR