Description of obj_billing_document

Created by Adi Sarig Zabar, Modified on Thu, 27 Jun, 2024 at 6:45 AM by Adi Sarig Zabar

The obj_billing_document object consolidates detailed billing document information from SAP tables VBRK and VBRP. This object supports comprehensive analysis and reporting needs for billing processes.

Columns and Descriptions

data_source_id: ID of the data source.
data_source_id_translated: Description of the data source.
obj_row_relevant_to_date: Internal creation date of the row in the object.
client: Client (VBRK.MANDT).
billing_doc: Billing document (VBRK.VBELN).
item: Item (VBRP.POSNR).
billing_type: Billing type (VBRK.FKART).
billingcategory: Billing category (VBRK.FKTYP).
document_cat_: Document category (VBRK.VBTYP).
doc__currency: Document currency (VBRK.WAERK).
sales_org_: Sales organization (VBRK.VKORG).
distr__channel: Distribution channel (VBRK.VTWEG).
pric__procedure: Pricing procedure (VBRK.KALSM).
doc__condition: Document condition (VBRK.KNUMV).
shipping_cond_: Shipping condition (VBRK.VSBED).
billing_date: Billing date (VBRK.FKDAT).
document_number: Document number (VBRK.BELNR).
fiscal_year: Fiscal year (VBRK.GJAHR).
posting_period: Posting period (VBRK.POPER).
price_group: Price group (VBRK.KONDA).
customer_group: Customer group (VBRK.KDGRP).
sales_district: Sales district (VBRK.BZIRK).
price_list: Price list (VBRK.PLTYP).
incoterms: Incoterms (VBRK.INCO1).
incoterms_2: Incoterms part 2 (VBRK.INCO2).
export: Export indicator (VBRK.EXPKZ).
posting_status: Posting status (VBRK.RFBSK).
subsinvprocess: Subsequent invoice processing (VBRK.MRNKZ).
exch_rate_acct_: Exchange rate for accounting (VBRK.KURRF).
set_exchange_rt: Set exchange rate (VBRK.CPKUR).
add_value_days: Additional value days (VBRK.VALTG).
fixed_val_date: Fixed value date (VBRK.VALDT).
payt_terms: Payment terms (VBRK.ZTERM).
payt_terms_translated: Description of the payment terms.
pmt_method: Payment method (VBRK.ZLSCH).
acctassggr: Account assignment group (VBRK.KTGRD).
dest__country: Destination country (VBRK.LAND1).
region: Region (VBRK.REGIO).
county_code: County code (VBRK.COUNC).
city_code: City code (VBRK.CITYC).
company_code: Company code (VBRK.BUKRS).
taxclass1_cust_: Tax class 1 customer (VBRK.TAXK1).
taxclass2_cust_: Tax class 2 customer (VBRK.TAXK2).
taxclass3_cust_: Tax class 3 customer (VBRK.TAXK3).
net_value_document: Net value of the document (VBRK.NETWR).
net_value: Net value (VBRP.NETWR).
risk_amount: Risk amount (VBRP.NETWR).
risk_amount_rate: Conversion rate to USD.
risk_currency_key: Risk currency key (VBRK.WAERK).
risk_amount_in_usd: Risk amount in USD (VBRP.NETWR converted).
comb_criteria: Combination criteria (VBRK.ZUKRI).
created_by: Created by (VBRK.ERNAM).
time: Time (VBRK.ERZET).
created_on: Created on (VBRK.ERDAT).
update_group: Update group (VBRK.STAFO).
payer: Payer (VBRK.KUNRG).
sold_to_party: Sold-to party (VBRK.KUNAG).
customer_name: Customer name (KNA1.NAME1).
dunning_area: Dunning area (VBRK.MABER).
stats_currency: Statistics currency (VBRK.STWAE).
for_tr_data_no_: Foreign trade data number (VBRK.EXNUM).
vat_reg__no_: VAT registration number (VBRK.STCEG).
changed_on: Changed on (VBRK.AEDAT).
canclld_bill_dc: Cancelled billing document (VBRK.SFAKN).
agreement: Agreement (VBRK.KNUMA).
inv_list_type: Invoice list type (VBRK.FKART_RL).
billing_date_item: Billing date item (VBRK.FKDAT_RL).
exch__rate_type: Exchange rate type (VBRK.KURST).
dunning_key: Dunning key (VBRK.MSCHL).
dunn__block: Dunning block (VBRK.MANSP).
division: Division (VBRK.SPART).
cred_contr_area: Credit control area (VBRK.KKBER).
credit_account: Credit account (VBRK.KNKLI).
currency: Currency (VBRK.CMWAE).
exchange_rate: Exchange rate (VBRK.CMKUF).
hiertypepricing: Hierarchy type pricing (VBRK.HITYP_PR).
po_number: PO number (VBRK.BSTNK_VF).
trading_partner: Trading partner (VBRK.VBUND).
accrualbilltype: Accrual billing type (VBRK.FKART_AB).
application: Application (VBRK.KAPPL).
tax_depart__cty: Tax department city (VBRK.LANDTX).
reference: Reference (VBRK.XBLNR).
assignment: Assignment (VBRK.ZUONR).
tax_amount: Tax amount (VBRK.MWSBK).
logical_system: Logical system (VBRK.LOGSYS).
cancelled: Cancelled (VBRK.FKSTO).
higher_lev_item: Higher-level item (VBRP.UEPOS).
billed_qty: Billed quantity (VBRP.FKIMG).
sales_unit: Sales unit (VBRP.VRKME).
numerator: Numerator (VBRP.UMVKZ).
denominat_: Denominator (VBRP.UMVKN).
base_unit: Base unit (VBRP.MEINS).
scale_quantity: Scale quantity (VBRP.SMENG).
bill_qty_in_sku: Billed quantity in SKU (VBRP.FKLMG).
required_qty: Required quantity (VBRP.LMENG).
net_weight: Net weight (VBRP.NTGEW).
gross_weight: Gross weight (VBRP.BRGEW).
weight_unit: Weight unit (VBRP.GEWEI).
volume: Volume (VBRP.VOLUM).
volume_unit: Volume unit (VBRP.VOLEH).
business_area: Business area (VBRP.GSBER).
pricing_date: Pricing date (VBRP.PRSDT).
serv_rendered: Service rendered (VBRP.FBUDA).
exchange_rate_: Exchange rate (VBRP.KURSK).
originating_doc: Originating document (VBRP.VBELV).
item___: Item (VBRP.POSNV).
reference_doc_: Reference document (VBRP.VGBEL).
reference_item: Reference item (VBRP.VGPOS).
prec_doc_categ_: Preceding document category (VBRP.VGTYP).
sales_document: Sales document (VBRP.AUBEL).
item_: Item (VBRP.AUPOS).
salesdocumentrefer: Sales document reference (VBRP.AUREF).
material: Material (VBRP.MATNR).
description: Description (VBRP.ARKTX).
pr__ref__matl: Pricing reference material (VBRP.PMATN).
batch: Batch (VBRP.CHARG).
material_group: Material group (VBRP.MATKL).
material_group_desc: Description of the material group.
item_category: Item category (VBRP.PSTYV).
item_category_desc: Description of the item category.
item_type: Item type (VBRP.POSAR).
prod_hierarchy: Product hierarchy (VBRP.PRODH).
shipping_point: Shipping point (VBRP.VSTEL).
replacemt_part: Replacement part (VBRP.ATPKZ).
division_: Division (VBRP.SPART).
partner_item: Partner item (VBRP.POSPA).
plant: Plant (VBRP.WERKS).
country: Country (VBRP.ALAND).
region_dlv_plnt: Region delivery plant (VBRP.WKREG).
county_dlv_plnt: County delivery plant (VBRP.WKCOU).
city_dlv_plant: City delivery plant (VBRP.WKCTY).
tax_class__mat_: Tax class material (VBRP.TAXM1).
taxclass2_matl_: Tax class 2 material (VBRP.TAXM2).
taxclass3_matl_: Tax class 3 material (VBRP.TAXM3).
statist_value: Statistical value (VBRP.KOWRR).
pricing_: Pricing (VBRP.PRSFD).
cash_discount: Cash discount (VBRP.SKTOF).
csh_disc_bas: Cash discount base (VBRP.SKFBP).
mat_pricing_grp: Material pricing group (VBRP.KONDM).
acct_asgnmt_grp: Account assignment group (VBRP.KTGRM).
cost_center: Cost center (VBRP.KOSTL).
sales_group: Sales group (VBRP.VKGRP).
sales_office: Sales office (VBRP.VKBUR).
division_item: Division item (VBRP.SPARA).
returns: Returns (VBRP.SHKZG).
created_by_item: Created by item (VBRP.ERNAM).
created_on_item: Created on item (VBRP.ERDAT).
time_item: Time item (VBRP.ERZET).
valuation_type: Valuation type (VBRP.BWTAR).
stor__location: Storage location (VBRP.LGORT).
update_group_item: Update group item (VBRP.STAFO).
cost: Cost (VBRP.WAVWR).
subtotal_1: Subtotal 1 (VBRP.KZWI1).
subtotal_2: Subtotal 2 (VBRP.KZWI2).
subtotal_3: Subtotal 3 (VBRP.KZWI3).
subtotal_4: Subtotal 4 (VBRP.KZWI4).
subtotal_5: Subtotal 5 (VBRP.KZWI5).
subtotal_6: Subtotal 6 (VBRP.KZWI6).
exch_rate_stats: Exchange rate statistics (VBRP.STCUR).
pricing: Pricing (VBRP.UVPRS).
general: General (VBRP.UVALL).
ean_upc: EAN/UPC (VBRP.EAN11).
profit_center: Profit center (VBRP.PRCTR).
marketing_unit: Marketing unit (VBRP.KVGR4).
container_type: Container type (VBRP.KVGR5).
materialgroup_1: Material group 1 (VBRP.MVGR1).
materialgroup_2: Material group 2 (VBRP.MVGR2).
materialgroup_3: Material group 3 (VBRP.MVGR3).
materialgroup_4: Material group 4 (VBRP.MVGR4).
materialgroup_5: Material group 5 (VBRP.MVGR5).
materialentered: Material entered (VBRP.MATWA).
rebate_basis: Rebate basis (VBRP.BONBA).
co_area: Controlling area (VBRP.KOKRS).
profit__segment: Profit segment (VBRP.PAOBJNR).
wbs_element: WBS element (VBRP.PS_PSP_PNR).
order: Order (VBRP.AUFNR).
tax_jur_: Tax jurisdiction (VBRP.TXJCD).
credit_price: Credit price (VBRP.CMPRE).
credit_active: Credit active (VBRP.CMPNT).
configuration: Configuration (VBRP.CUOBJ).
int_object_no_: Internal object number (VBRP.CUOBJ_CH).
condit_update: Condition update (VBRP.KOUPD).
billing_plan_no: Billing plan number (VBRP.FPLNR).
item__: Item (VBRP.FPLTR).
order_reason: Order reason (VBRP.AUGRU_AUFT).
batch_split_item: Batch split item (VBRP.UECHA).
batch_indicator: Batch indicator (VBRP.XCHAR).
item_category_translated: Description of the item category (VBRP.PSTYV).
sales_org__translated: Description of the sales organization (VBRK.VKORG).
order_reason_translated: Description of the order reason (VBRP.AUGRU_AUFT).
material_group_translated: Description of the material group (VBRP.MATKL).
materialgroup_1: Material group 1 (VBRP.MVGR1).
materialgroup_2: Material group 2 (VBRP.MVGR2).
materialgroup_3: Material group 3 (VBRP.MVGR3).
materialgroup_4: Material group 4 (VBRP.MVGR4).
materialgroup_5: Material group 5 (VBRP.MVGR5).
materialentered: Material entered (VBRP.MATWA).
rebate_basis: Rebate basis (VBRP.BONBA).
co_area: Controlling area (VBRP.KOKRS).
profit__segment: Profit segment (VBRP.PAOBJNR).
wbs_element: WBS element (VBRP.PS_PSP_PNR).
order: Order (VBRP.AUFNR).
tax_jur_: Tax jurisdiction (VBRP.TXJCD).
credit_price: Credit price (VBRP.CMPRE).
credit_active: Credit active (VBRP.CMPNT).
configuration: Configuration (VBRP.CUOBJ).
int_object_no_: Internal object number (VBRP.CUOBJ_CH).
condit_update: Condition update (VBRP.KOUPD).
billing_plan_no: Billing plan number (VBRP.FPLNR).
item__: Item (VBRP.FPLTR).
order_reason: Order reason (VBRP.AUGRU_AUFT).
batch_split_item: Batch split item (VBRP.UECHA).
batch_indicator: Batch indicator (VBRP.XCHAR).
item_category_translated: Description of the item category (VBRP.PSTYV).
sales_org__translated: Description of the sales organization (VBRK.VKORG).
order_reason_translated: Description of the order reason (VBRP.AUGRU_AUFT).
material_group_translated: Description of the material group (VBRP.MATKL).