BBP_INV_BW_GET_TD_STRUC SAP (Extraction Structure: Movement Data SAP BBP Invoice) Structure details
Description: Extraction Structure: Movement Data SAP BBP Invoice
Related tables to BBP_INV_BW_GET_TD_STRUC
Access table BBP_INV_BW_GET_TD_STRUC
Structure field list including key, data, relationships and ABAP select examples
BBP_INV_BW_GET_TD_STRUC 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 "Extraction Structure: Movement Data SAP BBP Invoice" 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_BBP_INV_BW_GET_TD_STRUC TYPE BBP_INV_BW_GET_TD_STRUC.
The BBP_INV_BW_GET_TD_STRUC table consists of various fields, each holding specific information or linking keys about Extraction Structure: Movement Data SAP BBP Invoice data available in SAP. These include GUID (INV GUID 32 Char.), INV_NUMBER (Invoice Number), PROCESS_TYPE (Business Transaction Type), DOC_DATE (Document Date).. 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 BBP_INV_BW_GET_TD_STRUC 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 |
CLIENT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
GUID | INV GUID 32 Char. | BBP_BW_INV_H_GUID | CHAR | 32 | SYSUUID_C | ||||
INV_NUMBER | Invoice Number | BBP_BW_INV_NUMBER | CHAR | 10 | ALPHA | CRM_OBJECT_ID | BBP_OBJECT_ID | ||
PROCESS_TYPE | Business Transaction Type | CRMT_PROCESS_TYPE_DB | CHAR | 4 | Assigned to domain | CRM_PROCESS_TYPE | |||
DOC_DATE | Document Date | DOC_DATE | DATS | 8 | DATE | ||||
DESCRIPTION | Transaction Description | CRMT_PROCESS_DESCRIPTION | CHAR | 40 | CRM_PROCESS_DESCRIPTION | ||||
DESCRIPTION_UC | Transaction Description (Upper Case) | CRMT_PROCESS_DESCRIPTION_UC | CHAR | 40 | CRM_PROCESS_DESCRIPTION_UC | ||||
CREATED_AT | Creation Date of Document | BBP_BW_CR_AT | DATS | 8 | |||||
CHANGED_AT | Change Date of Document | BBP_BW_CHNG_AT | DATS | 8 | |||||
CREATED_BY | User that Created the Transaction | CRMT_CREATED_BY | CHAR | 12 | UNAME | USER_ADDR | |||
CHANGED_BY | Transaction Last Changed By | CRMT_CHANGED_BY | CHAR | 12 | UNAME | ||||
BUP_ORDERER_ID | Business Partner Number | BU_PARTNER | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | BUPA |
BUP_ORDERER_GUID | Company GUID 32 Char. | BBP_BW_ORD_GUID_32 | CHAR | 32 | SYSUUID_C | ||||
BUP_VENDOR_ID | Business Partner Number | BU_PARTNER | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | BUPA |
BUP_VENDOR_GUID | Vendor GUID 32 Char. | BBP_BW_VEND_GUID_32 | CHAR | 32 | SYSUUID_C | ||||
REF_DOC_NO | Reference Document Number | XBLNR | CHAR | 16 | XBLNR | ||||
POSTING_DATE_FI | Transaction Posting Date in Accounting | POSTING_DATE_FI | DATS | 8 | DATUM | ||||
CO_CODE | Company Code in FI System | BBP_CO_CODE | CHAR | 4 | Assigned to domain | BUKRS | |||
BBP_LOG_SYSTEM | Logical System EBP | BBP_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 Key | WAERS | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
GROSS_AMOUNT | Gross invoice amount in document currency | BBP_IV_AMOUNT | CURR | 15(2) | WERT8 | ||||
REASON_CODE | Reason for Rejection | BBP_PD_REASON | CHAR | 4 | CHAR4 | ||||
TAX_AMOUNT | Tax Amount | BBP_TAX_AMOUNT | CURR | 15(2) | WERT8 | ||||
FRT_AMOUNT | Shipment Costs | BBP_FRT_AMOUNT | CURR | 15(2) | WERT8 | ||||
FRT_TAX_CODE | Tax on Sales/Purchases Code | BBP_MWSKZ | CHAR | 2 | BBP_MWSKZ | ||||
INP_TYPE | Creation Indictaor (Dialog, XML and so on) | BBP_INP_TYPE | CHAR | 1 | BBP_INP_TYPE | ||||
SUBTYPE | Specification of a Purchasing Doc.(e.g. Credit Memo/Invoice) | BBP_H_SUBTYPE | CHAR | 2 | BBP_H_SUBTYPE | ||||
IS_BBP | Flag for Update in BBP (X = TRUE ) or Backend Systems | BBP_BW_IS_BBP | CHAR | 1 | |||||
INV_COUNT | Counter for Number of Header Levels in Document | BBP_BW_PO_CNT | NUMC | 1 | COUNTER | ||||
STAT_PROCESS | Object status | J_STATUS | CHAR | 5 | J_STATUS | ||||
STAT_RELEASE | Object status | J_STATUS | CHAR | 5 | J_STATUS | ||||
STAT_TRANSFER | Object status | J_STATUS | CHAR | 5 | J_STATUS | ||||
ITM_GUID | Globally Unique Identifier in 32-Character Display | BBP_GUID_32 | CHAR | 32 | SYSUUID_C | ||||
ITM_CREATED_AT | Creation Date of Document | BBP_BW_CR_AT | DATS | 8 | |||||
ITM_CHANGED_AT | Change Date of Document | BBP_BW_CHNG_AT | DATS | 8 | |||||
ITM_CREATED_BY | User that Created the Transaction | CRMT_CREATED_BY | CHAR | 12 | UNAME | USER_ADDR | |||
ITM_CHANGED_BY | Transaction Last Changed By | CRMT_CHANGED_BY | CHAR | 12 | UNAME | ||||
ITM_PARENT | Globally Unique Identifier in 32-Character Display | BBP_GUID_32 | CHAR | 32 | SYSUUID_C | ||||
ITM_PRODUCT_GUID | Product Guid 32 Char. | BBP_BW_PROD_GUID_32 | CHAR | 32 | SYSUUID_C | ||||
ITM_PRODUCT_ID | Product Name Entered | CRMT_ORDERED_PROD_DB | CHAR | 54 | CRM_ORDERED_PROD | ||||
ITM_DESCRIPTION | Product Description | COMT_PRSHTEXTX | CHAR | 40 | PRSHTEXT40 | ||||
ITM_DESCRIP_UC | Product Description in Uppercase for F4 Help | COMT_PRSHTEXTG | CHAR | 40 | PRSHTEXTG40 | ||||
ITM_NUMBER | Item Number in Document | CRMT_ITEM_NO | NUMC | 10 | CRM_ITEM_NO | ||||
ITM_TYPE | Item Category | CRMT_ITEM_TYPE_DB | CHAR | 4 | Assigned to domain | CRM_ITEM_TYPE | |||
ITM_CAT_GUID | Globally Unique Identifier in 32-Character Display | BBP_GUID_32 | CHAR | 32 | SYSUUID_C | ||||
ITM_CATEGORY_ID | Category ID | COMT_CATEGORY_ID | CHAR | 20 | COM_CATEGORY_ID | COM_CATEGORY_ID | COM_CAT_HIER | ||
ITM_SCHEMA_TYPE | Standard Schema Type | SCHEMA_TYPE | CHAR | 10 | Assigned to domain | COM_SCHEMA_TYPE | |||
ITM_EX_CT_UN_ID | Unique Key in External Category | BBP_ITM_EX_CT_UN_ID | CHAR | 40 | CHAR40 | ||||
ITM_CT_CAT_ID | Category Name | BBP_CT_CATEGORY_ID | CHAR | 60 | CHAR60 | ||||
ITM_MANU_PROD | Manufacturer Part Number | BBP_MFRPN | CHAR | 40 | CHAR40 | ||||
ITM_MFR_NO_EXT | External manufacturer code name or number | EMNFR | CHAR | 10 | CHAR10 | ||||
ITM_CATALOGID | Catalog ID from which the line was selected | CATALOG | CHAR | 20 | BBP_WS_SERVICE_ID | ||||
ITM_PRODUCT_TYPE | Product Type | COMT_PRODUCT_TYPE | CHAR | 2 | Assigned to domain | COM_PRODUCT_TYPE | COM_PRODUCT_TYPE | COM_PR_TYPE_ACTIVE | |
ITM_PROD_SRC_SYS | Logical System from Which Product Originates | CRMT_PRODUCT_SRC_SYS | CHAR | 10 | Assigned to domain | ALPHA | LOGSYS | ||
ITM_SYS_TYPE | System type | BBP_SYSTEM_TYPE | CHAR | 10 | BBP_SYSTEM_TYPE | ||||
ITM_SLD_SYS_NAME | Name of a System im System Landscape Directory (SLD) | BBP_SLD_SYS_NAME | CHAR | 60 | TEXT60 | ||||
ITM_QUANTITY | Quantity in Order Unit | BBP_MNG | QUAN | 13(3) | MENG13 | ||||
ITM_UNIT | Unit of Measurement | BBP_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 | Business Partner Number | BU_PARTNER | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | BUPA |
ITM_REQUEST_GUID | Requester GUID 32 Char. | BBP_BW_REQU_GUID_32 | CHAR | 32 | SYSUUID_C | ||||
ITM_RECIPNT_ID | Business Partner Number | BU_PARTNER | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | BUPA |
ITM_RECIPNT_GUID | Goods Recipient GUID 32 Char | BBP_BW_RCPT_GUID_32 | CHAR | 32 | SYSUUID_C | ||||
ITM_LOC_ID | Location Number | BBP_LOCATION_NO | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | BUPA |
ITM_LOC_GUID | Plant GUID 32 Char | BBP_LOC_GUID_32 | CHAR | 32 | SYSUUID_C | ||||
ITM_WORKER_ID | Service Agent Number | BBP_SRV_PROVIDER | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | BUPA |
ITM_WORKER_GUID | Service Provider GUID 32 Char. | BBP_BW_SRV_GUID_32 | CHAR | 32 | SYSUUID_C | ||||
ITM_WRKR_SRC_SYS | Logical System from Which Partner Originates | COMT_PARTNER_SRC_SYS | CHAR | 10 | Assigned to domain | ALPHA | LOGSYS | ||
ITM_WORKER_NAME | Full Name | BU_NAME1TX | CHAR | 80 | TEXT80 | ||||
ITM_WRK_NO_TYPE | Partner Number Type (e.g. GUID, Pers. No., ...), Internal | CRMT_PARTNER_NO_TYPE | CHAR | 2 | COMT_PARTNER_NO_TYPE | ||||
ITM_CUSTOMER_ID | Customer Number (Third Party PO) | BBP_CUSTOMER | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | BUPA |
ITM_CUST_GUID | Customer GUID 32 Char. (Third Party PO) | BBP_BW_CUST_GUID_32 | CHAR | 32 | SYSUUID_C | ||||
ITM_CUST_SRC_SYS | Logical System from Which Partner Originates | COMT_PARTNER_SRC_SYS | CHAR | 10 | Assigned to domain | ALPHA | LOGSYS | ||
ITM_CUST_NAME | Search Help Field 1 (Name 1/Last Name) | BU_MCNAME1 | CHAR | 35 | CHAR35 | ||||
ITM_CUST_NO_TYPE | Partner Number Type (e.g. GUID, Pers. No., ...), Internal | CRMT_PARTNER_NO_TYPE | CHAR | 2 | COMT_PARTNER_NO_TYPE | ||||
ITM_TAX_CODE | Tax on Sales/Purchases Code | BBP_MWSKZ | CHAR | 2 | BBP_MWSKZ | ||||
ITM_PO_GUID | PO GUID 32 Char. | BBP_BW_PO_H_GUID | CHAR | 32 | SYSUUID_C | ||||
ITM_PO_NUMBER | Purchase Order Number | BBP_BW_PO_NUMBER | CHAR | 10 | ALPHA | CRM_OBJECT_ID | BBP_OBJECT_ID | ||
ITM_PO_ITM_GUID | PO Item GUID 32 Char. | BBP_BW_PO_I_GUID | CHAR | 32 | SYSUUID_C | ||||
ITM_PO_ITEM_NO | Item Number in Document | CRMT_ITEM_NO | NUMC | 10 | CRM_ITEM_NO | ||||
ITM_CONF_GUID | CONF GUID 32 Char. | BBP_BW_CONF_H_GUID | CHAR | 32 | SYSUUID_C | ||||
ITM_CONF_NUMBER | Confirmation Number | BBP_BW_CONF_NUMBER | CHAR | 10 | ALPHA | CRM_OBJECT_ID | |||
ITM_CONF_ITMGUID | CONF Item GUID 32 Char. | BBP_BW_CONF_I_GUID | CHAR | 32 | SYSUUID_C | ||||
ITM_CONF_ITM_NO | Item Number in Document | CRMT_ITEM_NO | NUMC | 10 | CRM_ITEM_NO | ||||
ITM_CTR_GUID | Globally Unique Identifier in 32-Character Display | BBP_GUID_32 | CHAR | 32 | SYSUUID_C | ||||
ITM_CTR_NUMBER | Contract Number | BBP_CTR_OBJECT_ID | CHAR | 10 | ALPHA | CRM_OBJECT_ID | BBP_OBJECT_ID | ||
ITM_CTR_ITMGUID | Globally Unique Identifier in 32-Character Display | BBP_GUID_32 | CHAR | 32 | SYSUUID_C | ||||
ITM_CTR_ITM_NO | Item Number in Document | CRMT_ITEM_NO | NUMC | 10 | CRM_ITEM_NO | ||||
ITM_DEL_IND | Deletion Indicator SRM Purchasing Document | BBP_DEL_IND | CHAR | 1 | XFELD | ||||
ITM_COUNT | Counter for Number of Items | BBP_BW_ITEM_CNT | DEC | 5(4) | |||||
ACC_GUID | Globally Unique Identifier in 32-Character Display | BBP_GUID_32 | 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_ELEM_E | 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 | ||
SCHED_LINE | Schedule Line Number | BBP_ETENR | NUMC | 4 | Assigned to domain | ETENR | |||
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 | ||
BUDGET_PERIOD | FM: Budget Period | FM_BUDGET_PERIOD | CHAR | 10 | Assigned to domain | FM_BUDGET_PERIOD | BUDPER |
Key field | Non-key field |
How do I retrieve data from SAP structure BBP_INV_BW_GET_TD_STRUC using ABAP code?
As BBP_INV_BW_GET_TD_STRUC 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 BBP_INV_BW_GET_TD_STRUC as there is no data to select.How to access SAP table BBP_INV_BW_GET_TD_STRUC
Within an ECC or HANA version of SAP you can also view further information about BBP_INV_BW_GET_TD_STRUC 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