BBP_PDHGP SAP (Business Transaction Purchasing Information) Table details
Description: Business Transaction Purchasing Information
Table field list including key, data, relationships and ABAP select examples
BBP_PDHGP is a standard SAP Table which is used to store Business Transaction Purchasing Information data and is available within R/3 SAP systems depending on the version and release level.
The BBP_PDHGP table consists of various fields, each holding specific information or linking keys about Business Transaction Purchasing Information data available in SAP. These include GUID (Globally Unique identifier), REF_DOC_NO (Reference Document Number), POSTING_DATE_FI (Transaction Posting Date in Accounting), GR_GI_SLIP_NO (Goods receipt/issue slip number).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP BBP_PDHGP table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
CLIENT | Client | EC_CLIENT | CLNT | 3 | Assigned to domain | MANDT | |||
GUID | Globally Unique identifier | BBP_GUID | RAW | 16 | SYSUUID | ||||
REF_DOC_NO | Reference Document Number | BBP_XBLNR | CHAR | 16 | XBLNR | ||||
POSTING_DATE_FI | Transaction Posting Date in Accounting | POSTING_DATE_FI | DATS | 8 | DATUM | ||||
GR_GI_SLIP_NO | Goods receipt/issue slip number | BBP_GRGI_SLIP_NO | CHAR | 10 | ALPHA | BELNR | |||
BILL_OF_LADING | Bill of Lading Number | BBP_BILL_OF_LADING | CHAR | 16 | XBLNR | ||||
CO_CODE | Company Code in FI System | BBP_CO_CODE | CHAR | 4 | Assigned to domain | BUKRS | |||
LOGSYS_FI | Logical System of FI System | BBP_LOGSYS_FI | CHAR | 10 | Assigned to domain | ALPHA | LOGSYS | BBP_BACKEND_DESTINATION_F4 | |
CURRENCY | Currency Key | WAERS | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
GROSS_AMOUNT | Gross invoice amount in document currency | BBP_IV_AMOUNT | CURR | 15(2) | WERT8 | ||||
TOTAL_VALUE | Total Value of Shopping Cart / Target Value of Contract | BBP_TOTAL_VALUE | CURR | 15(2) | WERT8 | ||||
TOTAL_TAX | Tax Amount | BBP_TAX_AMOUNT | CURR | 15(2) | WERT8 | ||||
TOTAL_VALUE_APPR | Total Value of Shopping Cart at Time of Approval (BI) | BBP_TOTAL_VALUE_APPR | CURR | 15(2) | WERT8 | ||||
USR_BUDGET_VALUE | Total Value of Shopping Cart Relevant to User Budget | BBP_USER_BUDGET_VALUE | CURR | 15(2) | WERT8 | ||||
PMNTTRMS | Terms of Payment Key | BBP_DZTERM | CHAR | 4 | ZTERM | /SAPSRM/H_PMNTTRMS | |||
DSCNT1_TO | Cash discount days 1 | BBP_BDET1BAPI | DEC | 3 | ZBDXT | ||||
DSCNT2_TO | Cash discount days 2 | BBP_BDET2BAPI | DEC | 3 | ZBDXT | ||||
DSCNT3_TO | Cash discount days 3 | BBP_BDET3BAPI | DEC | 3 | ZBDXT | ||||
CASH_DISC1 | Cash Discount Percentage 1 | DZBD1P | DEC | 5(3) | PRZ23 | ||||
CASH_DISC2 | Cash Discount Percentage 2 | DZBD2P | DEC | 5(3) | PRZ23 | ||||
VPER_START | Timeframe From | BBP_VPER_START | DATS | 8 | DATUM | ||||
VPER_END | Timeframe To | BBP_VPER_END | DATS | 8 | DATUM | ||||
PCINS | Procurement card company | BBPPCINS | CHAR | 4 | Assigned to domain | BBPPCINS | PCI | ||
PCNUM | Procurement card number | BBPPCNUM | CHAR | 25 | Assigned to domain | BBPPCNUM | PCC | BBP_PCMAS | |
PCNAME | Name of procurement cardholder | BBPPCNAME | CHAR | 40 | CHAR40 | ||||
PCDAT_TO | Procurement Card Validity Date | BBPPCDAT_TO | DATS | 8 | DATUM | ||||
DOC_CLOSED | Indicator Document Closed | BBP_DOC_CLOSED | CHAR | 1 | XFELD | ||||
DOC_INCOMPLETE | Indicator Document Incomplete | BBP_DOC_INCOMPLETE | CHAR | 1 | XFELD | ||||
DOC_FLOW_CTRL | Indicator of Possible Subsequent Processes | BBP_DOC_FLOW_CTRL | CHAR | 1 | BBP_DOC_FLOW_CTRL | ||||
INP_TYPE | Creation Indictaor (Dialog, XML and so on) | BBP_INP_TYPE | CHAR | 1 | BBP_INP_TYPE | ||||
WFL_CREATOR_TYPE | Type/Role of the Person who Starts the Approval Workflow | BBP_WFL_CREATOR_TYPE | CHAR | 1 | BBP_WFL_CREATOR_TYPE | ||||
SRC_OBJECT_TYPE | Object Type of Reference Document | BBP_SRC_H_OBJ_TYP | CHAR | 10 | Assigned to domain | OJ_NAME | |||
SRC_GUID | Reference Document GUID | BBP_SRC_H_GUID | RAW | 16 | SYSUUID | ||||
SRC_OBJECT_ID | Business Transaction Document ID | BBP_BTD_ID | CHAR | 35 | BBP_BTD_ID | ||||
SRC_LOGSYS | Logical system | LOGSYS | CHAR | 10 | Assigned to domain | ALPHA | LOGSYS | ||
REASON_CODE | Reason for Rejection | BBP_PD_REASON | CHAR | 4 | BBP_IVREA | CHAR4 | |||
TZONE | Time Zone for Date and Time Fields of Procurement Document | BBP_TZONE | CHAR | 6 | BBP_TZONE | ||||
NF_TYPE | Nota Fiscal Type | BBP_NFTYPE | CHAR | 2 | Assigned to domain | BBP_NFTYPE | |||
DOC_LANGU | Language Key for Document / Vendor | BBP_DOCUMENT_LANGU | LANG | 1 | ISOLA | SYLANGU | |||
SUBTYPE | Specification of a Purchasing Doc.(e.g. Credit Memo/Invoice) | BBP_H_SUBTYPE | CHAR | 2 | BBP_H_SUBTYPE | ||||
REF_OBJECT_ID | Reference Transaction Number | BBP_REF_OBJECT_ID | CHAR | 10 | BBP_OBJECT_ID | ||||
EXT_DEM_LOGSYS | Logical System from where an External Requirement Comes | BBP_EXT_DEM_LOGSYS | CHAR | 10 | Assigned to domain | ALPHA | LOGSYS | ||
TOL_GROUP | Tolerance Group | BBP_TOL_GROUP | CHAR | 4 | CHAR4 | ||||
PAYMENT_REF_NO | Country Specific Payment Reference | BBP_PAYMENT_REF_NO | CHAR | 30 | CHAR30 | ||||
APPROVAL_IND | Approval Indicator | BBP_APPROVAL_IND | CHAR | 1 | BBP_APPROVAL_IND | ||||
ICC_BUPLA_AR | Business Place | ICC_BUPLA | CHAR | 4 | BBP_ICC_J_1BBRANCH | ||||
ICC_BR_NF_FRE | Nota Fiscal: Freight Value including Taxes | BBP_ICC_NFFRE | CURR | 15(2) | BBP_ICC_WERTV8 | ||||
ICC_BR_NF_INS | Nota Fiscal: Insurance Value including Taxes | BBP_ICC_NFINS | CURR | 15(2) | BBP_ICC_WERTV8 | ||||
ICC_BR_NF_OTH | Nota Fiscal: Expenses including Taxes | BBP_ICC_NFOTH | CURR | 15(2) | BBP_ICC_WERTV8 | ||||
ICC_BR_NF_DIS | Nota Fiscal: Discount Value including Taxes | BBP_ICC_NFDIS | CURR | 15(2) | BBP_ICC_WERTV8 | ||||
ICC_BR_NF_NET | Nota Fiscal: Net Value including Taxes | BBP_ICC_NFNET | CURR | 15(2) | BBP_ICC_WERTV8 | ||||
ICC_BR_NF_TOT | Nota Fiscal: Total Value including All Taxes | BBP_ICC_NFTOT | CURR | 15(2) | BBP_ICC_WERTV8 | ||||
ICC_BUPLA_BR | Business Place | ICC_BUPLA | CHAR | 4 | BBP_ICC_J_1BBRANCH | ||||
ICC_KIDNO_DK | Payment Reference Number | ID_KIDNO | CHAR | 30 | CHAR30 | ||||
ICC_KIDNO_FI | Payment Reference Number | ID_KIDNO | CHAR | 30 | CHAR30 | ||||
ICC_BUPLA_KR | Business Place | ICC_BUPLA | CHAR | 4 | BBP_ICC_J_1BBRANCH | ||||
ICC_KIDNO_NO | Payment Reference Number | ID_KIDNO | CHAR | 30 | CHAR30 | ||||
ICC_KIDNO_SE | Payment Reference Number | ID_KIDNO | CHAR | 30 | CHAR30 | ||||
ICC_BUPLA_TH | Business Place | ICC_BUPLA | CHAR | 4 | BBP_ICC_J_1BBRANCH | ||||
ICC_BUPLA_TW | Business Place | ICC_BUPLA | CHAR | 4 | BBP_ICC_J_1BBRANCH | ||||
VERSION_TYPE | Version Type (Active Document, 'Normal', Work Version) | BBP_VERSION_TYPE | CHAR | 1 | BBP_VERSION_TYPE | ||||
ACTIVE_HEADER | Globally Unique identifier | BBP_GUID | RAW | 16 | SYSUUID | ||||
CHANGE_LOCK | Change Lock ('X': changes not allowed) | BBP_CHANGE_LOCK | CHAR | 1 | XFELD | ||||
VERSION_NO | Version Number | BBP_VERSION_NO | CHAR | 8 | CHAR08 | ||||
EXT_VERSION_NO | Version Number | BBP_VERSION_NO | CHAR | 8 | CHAR08 | ||||
STOCH_CHECK | Document was Flagged by Stochastic Check | BBP_STOCH_CHECK | CHAR | 1 | XFELD | ||||
DELIV_DAYS | Delivery Time in Days | BBP_DELIV_DAYS | NUMC | 3 | NUMC3 | ||||
INCOTERM_KEY | Incoterm Key | BBP_INCOTERM_KEY | CHAR | 3 | Assigned to domain | BBP_INCOTERM_KEY | |||
INCOTERM_LOC | Incoterm Location | BBP_INCOTERM_LOCATION | CHAR | 28 | BBP_INCOTERM_LOCATION | ||||
SK_COUNTRY | Country ISO code | INTCA | CHAR | 2 | INTCA | F4_INTCA | |||
SK_SCENARIO1 | Key of a Scenario for Field Extension | BBP_CUF_SCENARIO_KEY | CHAR | 3 | BBP_CUF_SCENARIO_KEY | ||||
SK_SCENARIO2 | Key of a Scenario for Field Extension | BBP_CUF_SCENARIO_KEY | CHAR | 3 | BBP_CUF_SCENARIO_KEY | ||||
SK_SCENARIO3 | Key of a Scenario for Field Extension | BBP_CUF_SCENARIO_KEY | CHAR | 3 | BBP_CUF_SCENARIO_KEY | ||||
SK_SCENARIO4 | Key of a Scenario for Field Extension | BBP_CUF_SCENARIO_KEY | CHAR | 3 | BBP_CUF_SCENARIO_KEY | ||||
SK_SCENARIO5 | Key of a Scenario for Field Extension | BBP_CUF_SCENARIO_KEY | CHAR | 3 | BBP_CUF_SCENARIO_KEY | ||||
VAL_PO_E | Value of POs/Confirmations/Invoices Created for Contract | BBP_PO_VALUE_E | CURR | 15(2) | WERT8 | ||||
VAL_PO_E_AGG | Value PO / Confirm. / Inv. for Contract Hierarchy | BBP_AGG_VALUE_E | CURR | 15(2) | WERT8 | ||||
ACCEPT_STAT_CODE | Acceptance Status | BBP_ACCEPT_STAT_CODE | CHAR | 1 | BBP_ACCEPT_STAT_CODE | ||||
CONF_MODE_CODE | Type of Confirmation | BBP_CONF_MODE_CODE | CHAR | 1 | BBP_CONF_MODE_CODE | ||||
EXT_CREATE_DATE | Creation Date of PO in External System (SRM/MM) | BBP_EXT_CREATE_DATE | DATS | 8 | DATE | ||||
SUSASN_TRANSTYPE | SUS ASN Transportation Type | BBP_SUSASN_TRANS_TYPE | CHAR | 4 | CHAR4 | ||||
SUSASN_TRANSID | SUS ASN Transportation ID | BBP_SUSASN_TRANS_ID | CHAR | 20 | CHAR20 | ||||
SUSASN_BILL_LAD | SUS Bill of Lading | BBP_SUSASN_BILL_OF_LADING | CHAR | 35 | CHAR35 | ||||
GUARANTEED_MIN | Guaranteed Purchase Value (Public Sector ONLY!!) | BBP_GUARANTEED_MIN | CURR | 15(2) | WERT8 | ||||
TRANSACTION_DATE | Service Provision Date | BBP_TRANSACTION_DATE | DATS | 8 | DATUM | ||||
NO_ITEMS_ALLOWED | Flag for Document Without Items (for example, HDR CTR) | BBP_NO_ITEMS_ALLOWED | CHAR | 1 | XFELD | ||||
ROOT_IND | is Root of a Hierarchy | BBP_ROOT_IND | CHAR | 1 | XFELD | ||||
SENSITIVE | Confidential Level of the SRM Document | BBP_SENSITIVE | CHAR | 1 | BBP_SENSITIVE | ||||
PMNT_BASIS_DATE | Reference Date From Which Payment Terms Apply | BBP_PMNT_BASIS_DATE | NUMC | 15 | BBP_TIME_STAMP | ||||
PURCHTEAM | Team Purchasing: Purchasing Team | BBP_PURCHTEAM | CHAR | 8 | Assigned to domain | BBP_PURCHTEAM | |||
GRP_IND | Grouping logic for locations activation flag | BBP_GOA_DIST_F | CHAR | 1 | XFELD | ||||
TAR_HVAL | Contract header:Relationship of release value to total value | BBP_PER_HVAL | DEC | 3 | DEC3 | ||||
EXPIRY_DAYS | Time Frame Before Contract Validity End (in Days) | BBP_EXPIRY_DAYS | NUMC | 3 | NUMC3 | ||||
SIG_IND | Signature | BBP_SIG_IND | CHAR | 1 | XFELD | ||||
DIST_IND | Distribution Flag | BBP_DIST_FLAG | CHAR | 1 | XFELD | ||||
PRESPEXT | Person Responsible External | BBP_PERSON_RESPONSIBLE_EXT | CHAR | 12 | CHAR12 | ||||
SRV_LOC | Service Location | BBP_SERVICE_LOCATION | CHAR | 25 | CHAR25 | ||||
BIDDING_SYSTEM | System in Which Bidding Takes Place | BBP_BIDDING_SYSTEM | CHAR | 1 | BBP_BIDDING_SYSTEM | ||||
BBP_REVAL | Price Revaluation Status | BBP_PRC_REVAL | CHAR | 1 | BBP_PRC_REVAL_STATUS | ||||
NO_SRVBUNDLING | Service Bundling Indicator | BBP_NO_SERVICE_BUNDLING | CHAR | 1 | NO_SERVICE_BUNDLING | ||||
BBP_WF_COUNT | Workflow trigger counter | BBP_WF_COUNT | NUMC | 1 | BBP_WF_COUNT |
Key field | Non-key field |
How do I retrieve data from SAP table BBP_PDHGP using ABAP code
The following ABAP code Example will allow you to do a basic selection on BBP_PDHGP to SELECT all data from the tableDATA: WA_BBP_PDHGP TYPE BBP_PDHGP.
SELECT SINGLE *
FROM BBP_PDHGP
INTO CORRESPONDING FIELDS OF WA_BBP_PDHGP
WHERE...
How to access SAP table BBP_PDHGP
Within an ECC or HANA version of SAP you can also view further information about BBP_PDHGP and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects