BBPS_BI_TD_PO_ACC SAP (Extr.Struc:Transactional Data Purchase Order with Accounting) Structure details
Description: Extr.Struc:Transactional Data Purchase Order with Accounting
Related tables to BBPS_BI_TD_PO_ACC
Access table BBPS_BI_TD_PO_ACC
Structure field list including key, data, relationships and ABAP select examples
BBPS_BI_TD_PO_ACC is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Extr.Struc:Transactional Data Purchase Order with Accounting" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_BBPS_BI_TD_PO_ACC TYPE BBPS_BI_TD_PO_ACC.
The BBPS_BI_TD_PO_ACC table consists of various fields, each holding specific information or linking keys about Extr.Struc:Transactional Data Purchase Order with Accounting data available in SAP. These include OBJECT_ID (Document Number), PROCESS_TYPE (Business Transaction Type), POSTING_DATE (Posting Date), DESCRIPTION (Description of Document).. 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:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP BBPS_BI_TD_PO_ACC structure 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 |
GUID | GUID of Document | BBP_BI_DOC_GUID | CHAR | 32 | SYSUUID_C | ||||
OBJECT_ID | Document Number | BBP_BI_DOC_NUMBER | CHAR | 10 | ALPHA | CRM_OBJECT_ID | BBP_OBJECT_ID | ||
PROCESS_TYPE | Business Transaction Type | BBP_BI_PROCESS_TYPE | CHAR | 4 | Assigned to domain | CRM_PROCESS_TYPE | |||
POSTING_DATE | Posting Date | BBP_BI_POST_DATE | DATS | 8 | DATE | ||||
DESCRIPTION | Description of Document | BBP_BI_DOC_DESCR | CHAR | 40 | CRM_PROCESS_DESCRIPTION | ||||
CREATED_AT | Creation Date of Document | BBP_BI_CREAT_DATE | DATS | 8 | |||||
CHANGED_AT | Change Date of Document | BBP_BI_CHANG_DATE | DATS | 8 | |||||
CREATED_BY | User That Created the Document | BBP_BI_CREAT_BY | CHAR | 12 | UNAME | USER_ADDR | |||
CHANGED_BY | User That Changed the Document | BBP_BI_CHANG_BY | CHAR | 12 | UNAME | ||||
ORDERER_ID | Orderer ID | BBP_BI_ORDERER_ID | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | BUPA |
VENDOR_ID | Supplier ID | BBP_BI_VENDOR_ID | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | BUPA |
CO_CODE | Company Code in FI System | BBP_CO_CODE | CHAR | 4 | Assigned to domain | BUKRS | |||
BBP_LOG_SYSTEM | Logical System for SRM | BBP_BI_LOG_SYS | CHAR | 10 | Assigned to domain | ALPHA | LOGSYS | ||
BE_LOG_SYSTEM | Logical System of Logistics Backend | BE_LOG_SYSTEM | CHAR | 10 | Assigned to domain | ALPHA | LOGSYS | ||
LOGSYS_FI | Logical System of FI System | BBP_LOGSYS_FI | CHAR | 10 | Assigned to domain | ALPHA | LOGSYS | BBP_BACKEND_DESTINATION_F4 | |
CURRENCY | Currency of Document | BBP_BI_DOC_CURRENCY | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
DOC_COUNT | Counter for Number of Documents | BBP_BI_DOC_COUNT | DEC | 5(4) | |||||
STAT_PROCESS | Processing Status | BBP_BI_PROC_STAT | CHAR | 5 | J_STATUS | ||||
ITM_DELIV_DATE | Item Delivery Date | EINDT | DATS | 8 | DATUM | ||||
ITM_GUID | GUID of Item | BBP_BI_ITEM_GUID | CHAR | 32 | SYSUUID_C | ||||
ITM_CREATED_AT | Creation Date of Item | BBP_BI_ITEM_CREAT_DATE | DATS | 8 | |||||
ITM_CHANGED_AT | Change Date of Item | BBP_BI_ITEM_CHANG_DATE | DATS | 8 | |||||
ITM_CREATED_BY | User That Created the Item | BBP_BI_ITEM_CREAT_BY | CHAR | 12 | UNAME | USER_ADDR | |||
ITM_CHANGED_BY | User That Changed the Item | BBP_BI_ITEM_CHANG_BY | CHAR | 12 | UNAME | USER_ADDR | |||
ITM_PRODUCT_GUID | Product GUID | BBP_BI_PROD_GUID | CHAR | 32 | SYSUUID_C | ||||
ITM_PRODUCT_ID | Product ID | BBP_BI_PROD_ID | CHAR | 54 | CRM_ORDERED_PROD | ||||
ITM_DESCRIPTION | Product Description | COMT_PRSHTEXTX | CHAR | 40 | PRSHTEXT40 | ||||
ITM_NUMBER | Item Number | BBP_BI_ITEM_NO | NUMC | 10 | CRM_ITEM_NO | ||||
ITM_CAT_GUID | Product Category GUID | BBP_CATEGORY_GUID_RAW | RAW | 16 | SYSUUID | ||||
ITM_CATEGORY_ID | Product Category ID | BBP_CATEGORY_ID | CHAR | 20 | COM_CATEGORY_ID | COM_CAT | |||
ITM_SCHEMA_TYPE | Standard Schema Type | SCHEMA_TYPE | CHAR | 10 | Assigned to domain | COM_SCHEMA_TYPE | |||
ITM_EXT_CAT_ID | Unique Key in External Category | BBP_ITM_EX_CT_UN_ID | CHAR | 40 | CHAR40 | ||||
ITM_EXT_CAT_NAME | Category Name | BBP_CT_CATEGORY_ID | CHAR | 60 | CHAR60 | ||||
ITM_PRODUCT_TYPE | Product Type | BBP_PRODUCT_TYPE | CHAR | 2 | Assigned to domain | COM_PRODUCT_TYPE | |||
ITM_QUANTITY | Quantity in Order Unit | BBP_MNG | QUAN | 13(3) | MENG13 | ||||
ITM_QUANTITY_BUM | Quantity in Base Unit of Measurement | BBP_BI_QUANTITY_BASE_UNIT | QUAN | 13(3) | MENG13 | ||||
ITM_UNIT | Unit of Measurement | BBP_UNIT | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
ITM_BASE_UNIT | Base Unit | BBP_BI_BASE_UNIT | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
ITM_PRICE | Net Price | BBP_PRICE | CURR | 13(2) | WERT7 | ||||
ITM_PRICE_UNIT | Price Unit | EPEIN | DEC | 5 | DEC5 | ||||
ITM_VALUE | Net Value | BBP_VALUE | CURR | 15(2) | WERT8 | ||||
ITM_REQUEST_ID | Requester ID | BBP_BI_REQUESTER_ID | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | BUPA |
ITM_RECIPNT_ID | Recipient ID | BBP_BI_RECIPIENT_ID | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | BUPA |
ITM_LOC_ID | Location ID | BBP_BI_LOCATION_ID | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | BUPA |
ITM_WORKER_ID | Service Provider ID | BBP_BI_SRV_PROVIDER_ID | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | BUPA |
ITM_WRKR_SRC_SYS | Logical System from Which Partner Originates | COMT_PARTNER_SRC_SYS | CHAR | 10 | Assigned to domain | ALPHA | LOGSYS | ||
ITM_WORKER_NAME | Service Provider's Full Name | BBP_BI_SRV_PROVIDER_FULLNAME | CHAR | 80 | TEXT80 | ||||
ITM_WRK_NO_TYPE | Internal Service Provider Type (for example, GUID, pers.no.) | BBP_BI_SRV_PROVIDER_NO_TYPE | CHAR | 2 | COMT_PARTNER_NO_TYPE | ||||
ITM_TYPE | Item Category | BBP_BI_ITEM_TYPE | CHAR | 4 | Assigned to domain | CRM_ITEM_TYPE | |||
ITM_LIM_OVERALL | Overall Limit | BBP_LIMIT | CURR | 15(2) | WERT8 | ||||
ITM_UNLIMITED | Undefined Limit | BBP_UNLIMITED | CHAR | 1 | CHAR01 | ||||
ITM_EXP_VALUE | Expected value | BBP_EXP_VALUE | CURR | 15(2) | WERT8 | ||||
ITM_TAX_CODE | Tax on Sales/Purchases Code | BBP_MWSKZ | CHAR | 2 | BBP_MWSKZ | ||||
ITM_TAX_AMOUNT | Tax Amount | BBP_TAX_AMOUNT | CURR | 15(2) | WERT8 | ||||
ITM_PROD_SRC_SYS | Original Logical System of Product | BBP_BI_PRODUCT_SRC_SYS | CHAR | 10 | Assigned to domain | ALPHA | LOGSYS | ||
ITM_SUBTYPE | Specification Purchase Item (e.g. Direct Material/Hierarch.) | BBP_I_SUBTYPE | CHAR | 2 | BBP_I_SUBTYPE | ||||
ITM_COUNT | Counter for Number of Items | BBP_BI_ITEM_COUNT | DEC | 5(4) | |||||
ACC_GUID | Accounting GUID | BBP_BI_ACC_GUID | CHAR | 32 | SYSUUID_C | ||||
ACC_NO | Sequential Account Assignment No. in EBP Purchase Document | BBP_ACC_NO | NUMC | 4 | BBP_ACCNO | ||||
ACC_CAT | Account Assignment Category in SRM | BBP_ACC_CAT | CHAR | 5 | BBP_ACCCAT | ||||
ACC_DISTR_PERC | Distribution Percentage in the Case of Multiple Acct Assgt | BBP_VPROZ | DEC | 5(2) | BBP_VPROZ | ||||
ACC_G_L_ACCT | G/L Account Number | SAKNR | CHAR | 10 | Assigned to domain | ALPHA | SAKNR | SAK | C_SAKNR |
ACC_BUS_AREA | Business Area | GSBER | CHAR | 4 | Assigned to domain | GSBER | GSB | ||
ACC_CO_AREA | Controlling Area | KOKRS | CHAR | 4 | Assigned to domain | CACCD | CAC | ||
ACC_COST_CTR | Cost Center | KOSTL | CHAR | 10 | Assigned to domain | ALPHA | KOSTL | KOS | |
ACC_ASSET_NO | Main Asset Number | ANLN1 | CHAR | 12 | Assigned to domain | ALPHA | ANLN1 | AN1 | |
ACC_SUB_NUMBER | Asset Subnumber | ANLN2 | CHAR | 4 | Assigned to domain | ALPHA | ANLN2 | AN2 | |
ACC_ORDER_NO | Order Number | AUFNR | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | ANR | |
ACC_PROFIT_CTR | Profit Center | PRCTR | CHAR | 10 | Assigned to domain | ALPHA | PRCTR | PRC | PRCTR_EMPTY |
ACC_WBS_ELEMENT | Work Breakdown Structure Element (WBS Element) | WBS_ELEM | CHAR | 24 | PROJN | PS_POSID | |||
ACC_NETWORK | Network Number for Account Assignment | NPLNR | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | NET | |
ACC_ACTIVITY | Operation/Activity Number | VORNR | CHAR | 4 | NUMCV | VORNR | VGN | ||
ACC_STR | Generic Account Assignment | BBP_ACC_GENERIC | CHAR | 64 | CHAR64 | ||||
CMMT_ITEM | Commitment Item | FIPOS | CHAR | 14 | Assigned to domain | FIPOS | FIP | ||
GRANT_NBR | Grant | GM_GRANT_NBR | CHAR | 20 | ALPHA | GM_GRANT_NBR | GM_GRANT_NBR | GRANTS_GENERIC | |
FUNDS_CTR | Funds Center | FISTL | CHAR | 16 | Assigned to domain | FISTL | FIS | ||
FUND | Fund | BP_GEBER | CHAR | 10 | Assigned to domain | BP_GEBER | FIC | ||
FUNC_AREA | Functional Area | FKBER_SHORT | CHAR | 4 | FKBER_SHORT | FBE | |||
SD_DOC | Sales and Distribution Document Number | BBP_VBELN | CHAR | 10 | Assigned to domain | ALPHA | VBELN | AUN | |
SDOC_ITEM | Sales Document Item | BBP_POSNR_VA | NUMC | 6 | Assigned to domain | POSNR | APO | ||
ORG_RESP_ORG | Responsible Organizational Unit (Purchasing) | BBP_PROG_ORG_RESP | CHAR | 14 | HROBJEC_14 | ||||
ORG_PURCH_ORG | Responsible Purchasing Organization | BBP_PROC_ORG | CHAR | 14 | HROBJEC_14 | BBP_PROC_ORG | |||
ORG_PURCH_GROUP | Responsible Purchasing Group | BBP_PROC_GROUP | CHAR | 14 | HROBJEC_14 | BBP_PROC_GROUP | |||
UPDMOD | BW Delta Process: Record Mode | RODMUPDMOD | CHAR | 1 | RODMUPDMOD | ||||
FUNDS_RES | Document number for earmarked funds | BBP_KBLNR | CHAR | 10 | Assigned to domain | ALPHA | KBLNR | KBL | |
RES_ITEM | Earmarked Funds: Document Item | KBLPOS | NUMC | 3 | Assigned to domain | KBLPOS | KBP | ||
ITM_DEL_IND | Deletion Indicator SRM Purchasing Document | BBP_DEL_IND | CHAR | 1 | XFELD | ||||
ITM_REV_LEV | Revision Level | CC_REVLV | CHAR | 2 | NUMCV | CC_REVLV | RVS | ||
BUDGET_PERIOD | FM: Budget Period | FM_BUDGET_PERIOD | CHAR | 10 | Assigned to domain | FM_BUDGET_PERIOD | BUDPER | ||
.INCLU--AP | 0 | ||||||||
PS_ATH_NOT_REL | Threshold not Relevant | /SAPPSSRM/_TH_NOT_RELEVANT | CHAR | 1 | XFELD | ||||
PS_ATH_TYPE | Threshold Type | /SAPPSSRM/_TH_TYPE | CHAR | 10 | Assigned to domain | /SAPPSSRM/_TH_TYPE | |||
PS_ATH_NUMBER | Threshold Number | /SAPPSSRM/_TH_NUM | NUMC | 10 | NUMC10 | ||||
PS_ATH_AVAIL_AMT | Remaining Threshold Amount | /SAPPSSRM/_TH_RM_AMNT | CURR | 20(2) | /SAPPSSRM/_TH_RM_AMNT | ||||
PS_ATH_CURRENCY | Currency Key | WAERS | CUKY | 5 | Assigned to domain | WAERS | FWS |
Key field | Non-key field |
How do I retrieve data from SAP structure BBPS_BI_TD_PO_ACC using ABAP code?
As BBPS_BI_TD_PO_ACC is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on BBPS_BI_TD_PO_ACC as there is no data to select.How to access SAP table BBPS_BI_TD_PO_ACC
Within an ECC or HANA version of SAP you can also view further information about BBPS_BI_TD_PO_ACC 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