escription of obj_po_lines object

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

The obj_po_lines object is a comprehensive dataset that consolidates detailed line items of purchase orders EKPO, enriched with relevant header information EKKO, and additional SAP tables like vendors LFA1, purchase requisition EBAN and others. This object supports extensive analysis and reporting needs for procurement processes. This detailed documentation covers the fields in the obj_po_lines and their respective mappings to the SAP tables.

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 purchasing_document_number and item_number_of_purchasing_document.
purchasing_document_number: Purchase order number (EKKO.EBELN).
item_number_of_purchasing_document: Line item number in the purchase order (EKPO.EBELP).
client: Client code (EKKO.MANDT).
company_code: Company code (EKKO.BUKRS).
purchasing_document_category: Document category (EKKO.BSTYP).
purchasing_document_category_desc: Translated values of the document category.
purchasing_document_type: Type of purchase document (EKKO.BSART).
purchasing_document_type_desc_: Description of the document type (T161T.BATXT).
control_indicator_for_purchasing_document_type: Control indicator (EKKO.BSAKZ).
deletion_indicator_in_purchasing_document: Deletion indicator (EKKO.LOEKZ).
status_of_purchasing_document: Status of the purchase document (EKKO.STATU).
date_on_which_record_was_created: Creation date of the record (EKKO.AEDAT).
name_of_person_who_created_the_object: Name of the creator (EKKO.ERNAM).
item_number_interval: Item number interval (EKKO.PINCR).
last_item_number: Last item number (EKKO.LPONR).
vendor_number: Vendor number (EKKO.LIFNR).
vendor_name: Name of the vendor (LFA1.NAME1).
language_key: Language key (EKKO.SPRAS).
terms_of_payment_key: Terms of payment key (EKKO.ZTERM).
terms_of_payment_key_translated: Description of the payment terms key.
cash__prompt_payment__discount_days_1: Cash discount days 1 (EKKO.ZBD1T).
cash__prompt_payment__discount_days_2: Cash discount days 2 (EKKO.ZBD2T).
cash__prompt_payment__discount_days_3: Cash discount days 3 (EKKO.ZBD3T).
cash_discount_percentage_1: Cash discount percentage 1 (EKKO.ZBD1P).
cash_discount_percentage_2: Cash discount percentage 2 (EKKO.ZBD2P).
purchasing_organization: Purchasing organization (EKKO.EKORG).
purchasing_organization_desc: Description of the purchasing organization (T024E.EKOTX).
purchasing_group: Purchasing group (EKKO.EKGRP).
currency_key: Currency key (EKKO.WAERS).
risk_currency_key: Risk currency key (EKKO.WAERS).
exchange_rate: Exchange rate (EKKO.WKURS).
indicator__fixing_of_exchange_rate: Indicator for fixing the exchange rate (EKKO.KUFIX).
purchasing_document_date: Document date (EKKO.BEDAT).
start_of_validity_period: Start of the validity period (EKKO.KDATB).
end_of_validity_period: End of the validity period (EKKO.KDATE).
bid_invitation_number: Bid invitation number (EKKO.AUSNR).
quotation_number: Quotation number (EKKO.ANGNR).
quotation_submission_date: Quotation submission date (EKKO.IHRAN).
your_reference: Your reference (EKKO.IHREZ).
supplying_vendor: Supplying vendor (EKKO.LLIEF).
customer_number: Customer number (EKKO.KUNNR).
number_of_principal_purchase_agreement: Principal purchase agreement number (EKKO.KONNR).
field_not_used: Not used field (EKKO.ABGRU).
incoterms__part_1_: Incoterms part 1 (EKKO.INCO1).
incoterms__part_2_: Incoterms part 2 (EKKO.INCO2).
number_of_the_document_condition: Document condition number (EKKO.KNUMV).
procedure__pricing__output_control__acct__det__costing_: Procedure (EKKO.KALSM).
different_invoicing_party: Different invoicing party (EKKO.LIFRE).
our_reference: Our reference (EKKO.UNSEZ).
release_group: Release group (EKKO.FRGGR).
release_strategy: Release strategy (EKKO.FRGSX).
release_indicator__purchasing_document: Release indicator (EKKO.FRGKE).
release_state: Release state (EKKO.FRGZU).
release_not_yet_completely_effected: Release not yet completely effected (EKKO.FRGRL).
country_for_tax_return: Country for tax return (EKKO.LANDS).
indicator_for_scheduling_agreement_release_documentation: Indicator for scheduling agreement release documentation (EKKO.LPHIS).
address_number: Address number (EKKO.ADRNR).
country_of_sales_tax_id_number: Country of sales tax ID number (EKKO.STCEG_L).
vat_registration_number: VAT registration number (EKKO.STCEG).
reason_for_cancellation: Reason for cancellation (EKKO.ABSGR).
document_number_for_additional: Document number for additional information (EKKO.ADDNR).
correction_of_miscellaneous_provisions: Correction of miscellaneous provisions (EKKO.KORNR).
purchase_order_not_yet_complete: Indicator for incomplete purchase orders (EKKO.MEMORY).
purchasing_document_processing_state: Processing state of the purchase document (EKKO.PROCSTAT).
total_value_at_time_of_release: Total value at the time of release (EKKO.RLWRT).
version_number_in_purchasing: Version number (EKKO.REVNO).
scm_process_that_created_the_purchase_order: SCM process (EKKO.SCMPROC).
goods_receipt_reason_code: Goods receipt reason code (EKKO.REASON_CODE).
category_of_incompleteness: Category of incompleteness (EKKO.MEMORYTYPE).
retention_indicator: Retention indicator (EKKO.RETTP).
retention_in_percent: Retention in percent (EKKO.RETPC).
down_payment_indicator: Down payment indicator (EKKO.DPTYP).
down_payment_percentage: Down payment percentage (EKKO.DPPCT).
down_payment_amount_in_document_currency: Down payment amount (EKKO.DPAMT).
due_date_for_down_payment: Due date for down payment (EKKO.DPDAT).
incomplete: Indicator for incompleteness (EKKO.MEMORY).
deletion_indicator_in_purchasing_document_line: Deletion indicator (EKPO.LOEKZ).
rfq_status: RFQ status (EKPO.STATU).
purchasing_document_item_change_date: Item change date (EKPO.AEDAT).
short_text: Short text description (EKPO.TXZ01).
material_number: Material number (EKPO.MATNR).
material_number_used_by_vendor: Vendor's material number (EKPO.EMATN).
plant: Plant code (EKPO.WERKS).
storage_location: Storage location (EKPO.LGORT).
requirement_tracking_number: Requirement tracking number (EKPO.BEDNR).
material_group: Material group (EKPO.MATKL).
number_of_purchasing_info_record: Purchasing info record number (EKPO.INFNR).
target_quantity: Target quantity (EKPO.KTMNG).
purchase_order_quantity: Order quantity (EKPO.MENGE).
purchase_order_unit_of_measure: Unit of measure (EKPO.MEINS).
order_price_unit__purchasing_: Order price unit (EKPO.BPRME).
net_price_in_purchasing_document__in_document_currency_: Net price (EKPO.NETPR).
last_net_price: Last net price (EKPO.NETPR).
price_unit: Price unit (EKPO.PEINH).
net_order_value_in_po_currency: Net order value (EKPO.NETWR).
risk_amount: Risk amount (EKPO.NETWR).
risk_amount_in_usd: Risk amount in USD (EKPO.NETWR converted).
gross_order_value_in_po_currency: Gross order value (EKPO.BRTWR).
tax_on_sales_purchases_code: Tax code (EKPO.MWSKZ).
settlement_group_1__purchasing_: Settlement group (EKPO.BONUS).
stock_type: Stock type (EKPO.INSMK).
indicator__update_info_record: Update info record indicator (EKPO.SPINF).
price_printout: Price printout indicator (EKPO.PRSDR).
indicator__estimated_price: Estimated price indicator (EKPO.SCHPR).
overdelivery_tolerance_limit: Overdelivery tolerance limit (EKPO.UEBTO).
indicator__unlimited_overdelivery_allowed: Unlimited overdelivery allowed (EKPO.UEBTK).
underdelivery_tolerance_limit: Underdelivery tolerance limit (EKPO.UNTTO).
valuation_type: Valuation type (EKPO.BWTAR).
valuation_category: Valuation category (EKPO.BWTTY).
rejection_indicator: Rejection indicator (EKPO.ABSKZ).
delivery_completed_indicator: Delivery completed indicator (EKPO.ELIKZ).
final_invoice_indicator: Final invoice indicator (EKPO.EREKZ).
item_category_in_purchasing_document: Item category (EKPO.PSTYP).
account_assignment_category: Account assignment category (EKPO.KNTTP).
consumption_posting: Consumption posting (EKPO.KZVBR).
distribution_indicator_for_multiple_account_assignment: Distribution indicator (EKPO.VRTKZ).
partial_invoice_indicator: Partial invoice indicator (EKPO.TWRKZ).
goods_receipt_indicator: Goods receipt indicator (EKPO.WEPOS).
goods_receipt__non_valuated: Non-valuated goods receipt (EKPO.WEUNB).
invoice_receipt_indicator: Invoice receipt indicator (EKPO.REPOS).
indicator__gr_based_invoice_verification: GR-based invoice verification (EKPO.WEBRE).
order_acknowledgment_requirement: Order acknowledgment requirement (EKPO.KZABS).
order_acknowledgment_number: Order acknowledgment number (EKPO.LABNR).
item_number_of_principal_purchase_agreement: Item number of principal purchase agreement (EKPO.KTPNR).
date_of_price_determination: Date of price determination (EKPO.PRDAT).
tax_jurisdiction: Tax jurisdiction (EKPO.TXJCD).
customers: Customers (EKPO.KUNNR).
item_is_statistical: Statistical item indicator (EKPO.STAPO).
material_category: Material category (EKPO.ATTYP).
purchase_requisition_number: Purchase requisition number (EKPO.BANFN).
purchase_requisition_item_number: Requisition item number (EKPO.BNFPO).
package_number: Package number (EKPO.PACKNO).
contract_number: Contract number (from po_contract.EBELN).
contract_creation_date: Contract creation date (EKKO.AEDAT of the related contract).
contract_start_of_validity_period: Start of validity period (EKKO.KDATB of the related contract).
contract_end_of_validity_period: End of validity period (EKKO.KDATE of the related contract).
first_approve_date: Date of the first approval (CDPOS.UDATE for the first change to EKKO.PROCSTAT value 05).
last_approve_date: Date of the last approval (CDPOS.UDATE for the last change to EKKO.PROCSTAT value 05).
is_approved_processing: Indicates if the processing is approved (true when first_approve_date or last_approve_date exists).
first_approver: User who first approved (CDPOS.USERNAME for the first change to EKKO.PROCSTAT value 05).
last_approver: User who last approved (CDPOS.USERNAME for the last change to EKKO.PROCSTAT value 05).
from_create_to_first_approve_days: Days between creation and first approval (EKKO.AEDAT and first_approve_date).
cost_center: Cost center (EKKN.KOSTL if EKPO.KNTTP = 'K`).
cost_center_translated: Description of the cost center (EKKN.KOSTL if EKPO.KNTTP = 'K`).
user_responsible: User responsible (CSKS.VERAK_USER if EKPO.KNTTP = 'K`).
user_responsible_translated: Description of the user responsible (CSKS.VERAK_USER if EKPO.KNTTP = 'K`).
controlling_area: Controlling area (EKKN.KOKRS).
list_price: List price (KONP.KBETR).
is_list_price: Flag indicating if it is a list price (KONP.KBETR).
is_diff_price: Indicator for price difference (KONP.KBETR and EKPO.NETPR).
gl_account: GL account (SKA1.SAKNR).
account_group: Account group (SKA1.KTOKS).
bus_partner_exists: Flag indicating if business partner exists (LFA1.VBUND not empty).
bus_partner: Business partner (LFA1.VBUND).
bus_partner_name: Description of the business partner (LFA1.VBUND).
vendor_country: Vendor country (LFA1.LAND1).
vendor_account_group: Vendor account group (LFA1.KTOKK).
requisition_processing_state: Requisition processing state (EBAN.BANPR).
purchase_requisition_quantity: Purchase requisition quantity (EBAN.MENGE).
price_in_purchase_requisition: Price in purchase requisition (EBAN.PREIS).
requisition_request_date: Requisition request date (EBAN.BADAT).
DX_UPDATED_ON: Last extraction date of the EKKO row.
purchasing_group_translated: Description of the purchasing group (EKKO.EKGRP).
created_by_translated: Not in use (internal).
item_category_in_purchasing_document_translated: Description of the item category (EKPO.PSTYP).
plant_translated: Description of the plant (EKPO.WERKS).
purchasing_document_type_translated: Description of the purchasing document type (EKKO.BSART).
name_of_person_who_created_the_object_translated: Description of the creator (EKKO.ERNAM).
requisition_processing_state_translated: Description of the requisition processing state (EBAN.BANPR).
company_code_translated: Description of the company code (EKKO.BUKRS).
purchasing_organization_translated: Description of the purchasing organization (EKKO.EKORG).
vendor_number_translated: Description of the vendor number (LFA1.NAME1).
company_code_line_translated: Not in use (internal).
purchasing_document_category_translated: Description of the purchasing document category (EKKO.BSTYP).
purchasing_document_line_category_translated: Not in use (internal).
material_group_translated: Description of the material group (EKPO.MATKL).
material_number_translated: Description of the material number (EKPO.MATNR).
release_indicator_translated: Description of the release indicator (EKKO.FRGKE).
pr_material_number_translated: Not in use (internal).
gl_account_translated: Description of the GL account (SKA1.SAKNR).