The obj_acc_doc object represents a comprehensive join between the SAP tables BSEG (Accounting Document Segment) and BKPF (Accounting Document Header). This object consolidates detailed financial document information, facilitating a complete view of accounting transactions for in-depth financial analysis and reporting.
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.
obj_key: Internal primary key of the object, combining document_number, fiscal_year, line_item, company_code.
client: Client (BKPF.MANDT).
document_number: Document Number (BKPF.BELNR).
fiscal_year: Fiscal Year (BKPF.GJAHR).
line_item: Line Item (BSEG.BUZEI).
company_code: Company Code (BKPF.BUKRS).
company_name: Company Code Description (BKPF.BUKRS description).
document_type: Document Type (BKPF.BLART).
document_date: Document Date in Document (BKPF.BLDAT).
document_status: Document Status (BKPF.BSTAT).
posting_date: Posting Date in the Document (BKPF.BUDAT).
period: Posting Period (BKPF.MONAT).
created_on: Creation Date of the Document (BKPF.CPUDT) with Time of Entry (BKPF.CPUTM).
entered_on: Creation Date of the Document (BKPF.CPUDT).
entered_at: Time of Entry (BKPF.CPUTM).
changed_on: Date of Last Change (BKPF.AEDAT).
last_update: Date of Last Update (BKPF.UPDDT).
translatn_date: Translation Date (BKPF.WWERT).
user: User Name (BKPF.USNAM).
user_name: User Description (BKPF.USNAM description).
transaction_code: Transaction Code (BKPF.TCODE).
cross_cc_no_: Cross-Company Code Number (BKPF.BVORG).
reference: Reference Document Number (BKPF.XBLNR).
rec_entry_doc_: Recurring Entry Document (BKPF.DBBLG).
reversed_with: Reversed with Document Number (BKPF.STBLG).
year: Fiscal Year of Reversed Document (BKPF.STJAH).
doc_header_text: Document Header Text (BKPF.BKTXT).
currency: Document Currency (BKPF.WAERS).
exchange_rate: Exchange Rate (BKPF.KURSF).
ref__transactn: Reference Transaction (BKPF.AWTYP).
reference_key: Reference Key (BKPF.AWKEY).
local_currency: Local Currency (BKPF.HWAER).
local_curr__2: Local Currency 2 (BKPF.HWAE2).
local_curr__3: Local Currency 3 (BKPF.HWAE3).
reversal_flag: Reversal Indicator (BKPF.XSTOV).
reversal_date: Reversal Date (BKPF.STODT).
reversal_reason: Reversal Reason (BKPF.STGRD).
parked_by: Parked By (BKPF.PPNAM).
clearing: Clearing Date (BSEG.AUGDT).
clearingentdate: Clearing Entry Date (BSEG.AUGCP).
clrng_doc_: Clearing Document Number (BSEG.AUGBL).
posting_key: Posting Key (BSEG.BSCHL).
account_type: Account Type (BSEG.KOART).
special_g_l_ind: Special G/L Indicator (BSEG.UMSKZ).
debit_credit: Debit/Credit Indicator (BSEG.SHKZG).
business_area: Business Area (BSEG.GSBER).
trdg_part_ba: Trading Partner Business Area (BSEG.PARGB).
company_of_trading_partner: Company Code of Trading Partner (BSEG.VBUND).
tax_code: Tax Code (BSEG.MWSKZ).
w__tax_code: Withholding Tax Code (BSEG.QSSKZ).
amount_in_lc: Amount in Local Currency (BSEG.DMBTR).
risk_amount: Amount in Document Currency (BSEG.WRBTR).
risk_amount_rate: Conversion rate from BKPF.WAERS currency to USD.
risk_currency_key: Document Currency (BKPF.WAERS).
risk_amount_in_usd: Amount in USD (BSEG.WRBTR converted).
amount: Amount in Document Currency (BSEG.WRBTR).
g_l_amount: Amount in Global Currency (BSEG.PSWBT).
g_l_currency: Global Currency (BSEG.PSWSL).
lc_tax: Tax Base Amount in Local Currency (BSEG.MWSTS).
text: Document Line Item Text (BSEG.SGTXT).
assignment: Assignment Number (BSEG.ZUONR).
value_date: Value Date (BSEG.VALUT).
co_area: Controlling Area (BSEG.KOKRS).
cost_center: Cost Center (BSEG.KOSTL).
order: Order Number (BSEG.AUFNR).
billing_doc_: Billing Document (BSEG.VBELN).
sales_document: Sales Document (BSEG.VBEL2).
item: Item Number in Sales Document (BSEG.POSN2).
asset: Asset Number (BSEG.ANLN1).
subnumber: Asset Subnumber (BSEG.ANLN2).
trans__type: Transaction Type (BSEG.ANBWA).
asset_val__date: Asset Value Date (BSEG.BZDAT).
personnel_no_: Personnel Number (BSEG.PERNR).
sales_related: Sales Order Item (BSEG.XUMSW).
oi_management: Open Item Management (BSEG.XOPVW).
individ_set: Individual Value Adjustment (BSEG.XCPDD).
indicator__billing_d: Billing Document Indicator (BSEG.XFAKT).
indicator__transfer: Transfer Document Indicator (BSEG.XUMAN).
indicator__down_paym: Down Payment Request (BSEG.XANET).
g_l_account: G/L Account Number (BSEG.SAKNR).
g_l: G/L Account (BSEG.HKONT).
account_name: G/L Account Description (BSEG.SAKNR description).
customers: Customer Number (BSEG.KUNNR).
customer_name: Customer Name (BSEG.KUNNR description).
vendor: Vendor Number (BSEG.LIFNR).
vendor_name: Vendor Name (BSEG.LIFNR description).
branch: Business Area (BSEG.FILKD).
balance_sheet_acct: Balance Sheet Account Indicator (BSEG.XBILK).
p_l_state__acct: P&L Statement Account (BSEG.GVTYP).
sp_g_l_assgt: Special G/L Assignment (BSEG.HZUON).
baseline_date: Baseline Date for Due Date Calculation (BSEG.ZFBDT).
payt_terms: Payment Terms (BSEG.ZTERM -- deprecated).
pay_terms_desc: Payment Terms Description (BSEG.ZTERM description).
pay_terms: Payment Terms (BSEG.ZTERM).
pay_terms_translated: Payment Terms Description (BSEG.ZTERM description).
days_1: Cash Discount Days 1 (BSEG.ZBD1T).
days_2: Cash Discount Days 2 (BSEG.ZBD2T).
days_net: Net Payment Terms (BSEG.ZBD3T).
disc__percent_1: Cash Discount Percentage 1 (BSEG.ZBD1P).
disc__percent_2: Cash Discount Percentage 2 (BSEG.ZBD2P).
disc__base: Cash Discount Base Amount (BSEG.SKFBT).
discount_amt: Cash Discount Amount (BSEG.SKNTO).
disc__amount: Cash Discount Amount in Document Currency (BSEG.WSKTO).
pmt_method: Payment Method (BSEG.ZLSCH).
pmnt_block: Payment Block (BSEG.ZLSPR).
fixed: Fixed Value Date (BSEG.ZBFIX).
house_bank: House Bank (BSEG.HBKID).
tax_code2: Tax Code 2 (BSEG.MWSK1).
amount1: Amount in Local Currency for Tax 1 (BSEG.DMBT1).
amount2: Amount in Foreign Currency for Tax 1 (BSEG.WRBT1).
tax_code3: Tax Code 3 (BSEG.MWSK2).
amount3: Amount in Local Currency for Tax 2 (BSEG.DMBT2).
amount4: Amount in Foreign Currency for Tax 2 (BSEG.WRBT2).
tax_code4: Tax Code 4 (BSEG.MWSK3).
amount5: Amount in Local Currency for Tax 3 (BSEG.DMBT3).
amount6: Amount in Foreign Currency for Tax 3 (BSEG.WRBT3).
plant: Plant (BSEG.WERKS).
quantity: Quantity (BSEG.MENGE).
base_unit: Base Unit of Measure (BSEG.MEINS).
purchasing_doc_: Purchasing Document Number (BSEG.EBELN).
doc_item: Item in Purchasing Document (BSEG.EBELP).
block_reas_pr_: Blocking Reason for Price (BSEG.SPGRP).
block_reas_qty: Blocking Reason for Quantity (BSEG.SPGRM).
bl__reason_date: Blocking Reason Date (BSEG.SPGRT).
block_reas__opq: Blocking Reason for Order Price Quantity (BSEG.SPGRG).
block_reas_proj: Blocking Reason for Project (BSEG.SPGRV).
man_block_reasn: Manual Blocking Reason (BSEG.SPGRQ).
vat_reg__no_: VAT Registration Number (BSEG.STCEG).
dest_country: Destination Country (BSEG.EGBLD).
lc2_amount: Amount in Local Currency 2 (BSEG.DMBE2).
lc3_amount: Amount in Local Currency 3 (BSEG.DMBE3).
reference_key_1: Reference Key 1 (BSEG.XREF1).
reference_key_2: Reference Key 2 (BSEG.XREF2).
no_of_invoce_the_transaction_belongs_to: Number of Invoice the Transaction Belongs To (BSEG.REBZG).
follow_on_document_type: Follow-On Document Type (BSEG.REBZT).
doc_type_desc: Document Type Description (BKPF.BLART description).
posting_key_name: Posting Key Description (BSEG.BSCHL description).
down_payment_paid: To be completed.
DX_UPDATED_ON: Internal - last extraction date of BSEG row.
document_type_translated: Document Type Description (BKPF.BLART description).
posting_key_translated: Posting Key Description (BSEG.BSCHL description).
pmnt_block_translated: Payment Block Description (BSEG.ZLSPR description).
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article