SAP ABAP Table BBPS_BI_TD_CF (Extraction Structure: Movement Data SAP SRM Confirmation)
Hierarchy
☛
SRM_SERVER (Software Component) SRM_SERVER
⤷ SRM-BW (Application Component) SRM Analytics
⤷ BBP_BI (Package) Business Intelligence
⤷ SRM-BW (Application Component) SRM Analytics
⤷ BBP_BI (Package) Business Intelligence
Basic Data
Table Category | INTTAB | Structure |
Structure | BBPS_BI_TD_CF | Table Relationship Diagram |
Short Description | Extraction Structure: Movement Data SAP SRM Confirmation |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | GUID | BBP_BI_DOC_GUID | SYSUUID_C | CHAR | 32 | 0 | GUID of Document | ||
2 | OBJECT_ID | BBP_BI_DOC_NUMBER | CRM_OBJECT_ID | CHAR | 10 | 0 | Document Number | ||
3 | PROCESS_TYPE | BBP_BI_PROCESS_TYPE | CRM_PROCESS_TYPE | CHAR | 4 | 0 | Business Transaction Type | * | |
4 | POSTING_DATE | BBP_BI_POST_DATE | DATE | DATS | 8 | 0 | Posting Date | ||
5 | DESCRIPTION | BBP_BI_DOC_DESCR | CRM_PROCESS_DESCRIPTION | CHAR | 40 | 0 | Description of Document | ||
6 | CREATED_AT | BBP_BI_CREAT_DATE | DATS | 8 | 0 | Creation Date of Document | |||
7 | CHANGED_AT | BBP_BI_CHANG_DATE | DATS | 8 | 0 | Change Date of Document | |||
8 | CREATED_BY | BBP_BI_CREAT_BY | UNAME | CHAR | 12 | 0 | User That Created the Document | ||
9 | CHANGED_BY | BBP_BI_CHANG_BY | UNAME | CHAR | 12 | 0 | User That Changed the Document | ||
10 | ORDERER_ID | BBP_BI_ORDERER_ID | BU_PARTNER | CHAR | 10 | 0 | Orderer ID | * | |
11 | VENDOR_ID | BBP_BI_VENDOR_ID | BU_PARTNER | CHAR | 10 | 0 | Supplier ID | * | |
12 | VEN_DOC_NO | BBP_BI_VENDOR_DOC | XBLNR | CHAR | 16 | 0 | Supplier Document Number | ||
13 | CO_CODE | BBP_CO_CODE | BUKRS | CHAR | 4 | 0 | Company Code in FI System | * | |
14 | BBP_LOG_SYSTEM | BBP_BI_LOG_SYS | LOGSYS | CHAR | 10 | 0 | Logical System for SRM | * | |
15 | BE_LOG_SYSTEM | BE_LOG_SYSTEM | LOGSYS | CHAR | 10 | 0 | Logical System of Logistics Backend | * | |
16 | LOGSYS_FI | BBP_LOGSYS_FI | LOGSYS | CHAR | 10 | 0 | Logical System of FI System | * | |
17 | CURRENCY | BBP_BI_DOC_CURRENCY | WAERS | CUKY | 5 | 0 | Currency of Document | * | |
18 | REASON_CODE | BBP_PD_REASON | CHAR4 | CHAR | 4 | 0 | Reason for Rejection | ||
19 | INP_TYPE | BBP_INP_TYPE | BBP_INP_TYPE | CHAR | 1 | 0 | Creation Indictaor (Dialog, XML and so on) | ||
20 | SUBTYPE | BBP_H_SUBTYPE | BBP_H_SUBTYPE | CHAR | 2 | 0 | Specification of a Purchasing Doc.(e.g. Credit Memo/Invoice) | ||
21 | IS_BBP | BBP_BI_IS_BBP | CHAR | 1 | 0 | Document Originates in SAP SRM System | |||
22 | DOC_COUNT | BBP_BI_DOC_COUNT | DEC | 5 | 4 | Counter for Number of Documents | |||
23 | STAT_PROCESS | BBP_BI_PROC_STAT | J_STATUS | CHAR | 5 | 0 | Processing Status | ||
24 | STAT_RELEASE | BBP_BI_REL_STAT | J_STATUS | CHAR | 5 | 0 | Release Status | ||
25 | STAT_TRANSFER | BBP_BI_TRAN_STAT | J_STATUS | CHAR | 5 | 0 | Transfer Status | ||
26 | ITM_GUID | BBP_BI_ITEM_GUID | SYSUUID_C | CHAR | 32 | 0 | GUID of Item | ||
27 | ITM_CREATED_AT | BBP_BI_ITEM_CREAT_DATE | DATS | 8 | 0 | Creation Date of Item | |||
28 | ITM_CHANGED_AT | BBP_BI_ITEM_CHANG_DATE | DATS | 8 | 0 | Change Date of Item | |||
29 | ITM_CREATED_BY | BBP_BI_ITEM_CREAT_BY | UNAME | CHAR | 12 | 0 | User That Created the Item | ||
30 | ITM_CHANGED_BY | BBP_BI_ITEM_CHANG_BY | UNAME | CHAR | 12 | 0 | User That Changed the Item | ||
31 | ITM_PRODUCT_GUID | BBP_BI_PROD_GUID | SYSUUID_C | CHAR | 32 | 0 | Product GUID | ||
32 | ITM_PRODUCT_ID | BBP_BI_PROD_ID | CRM_ORDERED_PROD | CHAR | 54 | 0 | Product ID | ||
33 | ITM_DESCRIPTION | COMT_PRSHTEXTX | PRSHTEXT40 | CHAR | 40 | 0 | Product Description | ||
34 | ITM_NUMBER | BBP_BI_ITEM_NO | CRM_ITEM_NO | NUMC | 10 | 0 | Item Number | ||
35 | ITM_TYPE | BBP_BI_ITEM_TYPE | CRM_ITEM_TYPE | CHAR | 4 | 0 | Item Category | * | |
36 | ITM_CAT_GUID | BBP_CATEGORY_GUID_RAW | SYSUUID | RAW | 16 | 0 | Product Category GUID | ||
37 | ITM_CATEGORY_ID | BBP_CATEGORY_ID | COM_CATEGORY_ID | CHAR | 20 | 0 | Product Category ID | ||
38 | ITM_SCHEMA_TYPE | SCHEMA_TYPE | COM_SCHEMA_TYPE | CHAR | 10 | 0 | Standard Schema Type | * | |
39 | ITM_EXT_CAT_ID | BBP_ITM_EX_CT_UN_ID | CHAR40 | CHAR | 40 | 0 | Unique Key in External Category | ||
40 | ITM_EXT_CAT_NAME | BBP_CT_CATEGORY_ID | CHAR60 | CHAR | 60 | 0 | Category Name | ||
41 | ITM_MANU_PROD_EX | EMNFR | CHAR10 | CHAR | 10 | 0 | External manufacturer code name or number | ||
42 | ITM_MANU_PROD_IN | BBP_MFRPN | CHAR40 | CHAR | 40 | 0 | Manufacturer Part Number | ||
43 | ITM_CATALOGID | CATALOG | BBP_WS_SERVICE_ID | CHAR | 20 | 0 | Catalog ID from which the line was selected | ||
44 | ITM_PRODUCT_TYPE | BBP_PRODUCT_TYPE | COM_PRODUCT_TYPE | CHAR | 2 | 0 | Product Type | * | |
45 | ITM_PROD_SRC_SYS | BBP_BI_PRODUCT_SRC_SYS | LOGSYS | CHAR | 10 | 0 | Original Logical System of Product | * | |
46 | ITM_SYS_TYPE | BBP_SYSTEM_TYPE | BBP_SYSTEM_TYPE | CHAR | 10 | 0 | System type | ||
47 | ITM_SLD_SYS_NAME | BBP_SLD_SYS_NAME | TEXT60 | CHAR | 60 | 0 | Name of a System im System Landscape Directory (SLD) | ||
48 | ITM_DELIV_DATE | EINDT | DATUM | DATS | 8 | 0 | Item delivery date | ||
49 | ITM_QUANTITY | BBP_MNG | MENG13 | QUAN | 13 | 3 | Quantity in Order Unit | ||
50 | ITM_QUANTITY_BUM | BBP_BI_QUANTITY_BASE_UNIT | MENG13 | QUAN | 13 | 3 | Quantity in Base Unit of Measurement | ||
51 | ITM_UNIT | BBP_UNIT | MEINS | UNIT | 3 | 0 | Purchase Order Unit | * | |
52 | ITM_BASE_UNIT | BBP_BI_BASE_UNIT | MEINS | UNIT | 3 | 0 | Base Unit | * | |
53 | ITM_PRICE | BBP_PRICE | WERT7 | CURR | 13 | 2 | Net Price | ||
54 | ITM_PRICE_UNIT | EPEIN | DEC5 | DEC | 5 | 0 | Price unit | ||
55 | ITM_VALUE | BBP_VALUE | WERT8 | CURR | 15 | 2 | Net Value | ||
56 | ITM_REQUEST_ID | BBP_BI_REQUESTER_ID | BU_PARTNER | CHAR | 10 | 0 | Requester ID | * | |
57 | ITM_RECIPNT_ID | BBP_BI_RECIPIENT_ID | BU_PARTNER | CHAR | 10 | 0 | Recipient ID | * | |
58 | ITM_LOC_ID | BBP_BI_LOCATION_ID | BU_PARTNER | CHAR | 10 | 0 | Location ID | * | |
59 | ITM_WORKER_ID | BBP_BI_SRV_PROVIDER_ID | BU_PARTNER | CHAR | 10 | 0 | Service Provider ID | * | |
60 | ITM_WRKR_SRC_SYS | COMT_PARTNER_SRC_SYS | LOGSYS | CHAR | 10 | 0 | Logical System from Which Partner Originates | * | |
61 | ITM_WORKER_NAME | BBP_BI_SRV_PROVIDER_FULLNAME | TEXT80 | CHAR | 80 | 0 | Service Provider's Full Name | ||
62 | ITM_WRK_NO_TYPE | BBP_BI_SRV_PROVIDER_NO_TYPE | COMT_PARTNER_NO_TYPE | CHAR | 2 | 0 | Internal Service Provider Type (for example, GUID, pers.no.) | ||
63 | ITM_CUSTOMER_ID | BBP_BI_CUSTOMER_ID | BU_PARTNER | CHAR | 10 | 0 | Customer ID | * | |
64 | ITM_CUST_SRC_SYS | COMT_PARTNER_SRC_SYS | LOGSYS | CHAR | 10 | 0 | Logical System from Which Partner Originates | * | |
65 | ITM_CUST_NAME | BBP_BI_CUSTOMER_FULLNAME | CHAR35 | CHAR | 35 | 0 | Customer's Full Name | ||
66 | ITM_CUST_NO_TYPE | BBP_BI_CUSTOMER_NO_TYPE | COMT_PARTNER_NO_TYPE | CHAR | 2 | 0 | Internal Customer No.Type (for example, GUID, pers. no.) | ||
67 | ITM_TAX_CODE | BBP_MWSKZ | BBP_MWSKZ | CHAR | 2 | 0 | Tax Code | ||
68 | ITM_TAX_AMOUNT | BBP_TAX_AMOUNT | WERT8 | CURR | 15 | 2 | Tax Amount | ||
69 | ITM_PO_NUMBER | BBP_BI_REF_PO_NO | CRM_OBJECT_ID | CHAR | 10 | 0 | Referenced Purchase Order Number | ||
70 | ITM_PO_ITEM_NO | BBP_BI_REF_PO_ITEM_NO | CRM_ITEM_NO | NUMC | 10 | 0 | Referenced Item Number of Purchase Order | ||
71 | ITM_CTR_NUMBER | BBP_BI_REF_CTR_NO | CRM_OBJECT_ID | CHAR | 10 | 0 | Referenced Contract Number | ||
72 | ITM_CTR_ITM_NO | BBP_BI_REF_CTR_ITEM_NO | CRM_ITEM_NO | NUMC | 10 | 0 | Referenced Item Number of Contract | ||
73 | ITM_DEL_IND | BBP_DEL_IND | XFELD | CHAR | 1 | 0 | Deletion Indicator EBP Purchasing Document | ||
74 | ITM_FIN_ENTRY_CF | BBP_BI_FINAL_ENTRY_CF | XFELD | CHAR | 1 | 0 | Final Entry Indicator (Goods/Services) in CF | ||
75 | ITM_COUNT | BBP_BI_ITEM_COUNT | DEC | 5 | 4 | Counter for Number of Items | |||
76 | ACC_NO | BBP_ACC_NO | BBP_ACCNO | NUMC | 4 | 0 | Sequential Account Assignment No. in EBP Purchase Document | ||
77 | ACC_CAT | BBP_ACC_CAT | BBP_ACCCAT | CHAR | 5 | 0 | Account Assignment Category in Enterprise Buyer | ||
78 | ACC_DISTR_PERC | BBP_VPROZ | BBP_VPROZ | DEC | 5 | 2 | Distribution Percentage in the Case of Multiple Acct Assgt | ||
79 | ACC_G_L_ACCT | SAKNR | SAKNR | CHAR | 10 | 0 | G/L Account Number | * | |
80 | ACC_BUS_AREA | GSBER | GSBER | CHAR | 4 | 0 | Business Area | * | |
81 | ACC_CO_AREA | KOKRS | CACCD | CHAR | 4 | 0 | Controlling Area | * | |
82 | ACC_COST_CTR | KOSTL | KOSTL | CHAR | 10 | 0 | Cost Center | * | |
83 | ACC_ASSET_NO | ANLN1 | ANLN1 | CHAR | 12 | 0 | Main Asset Number | * | |
84 | ACC_SUB_NUMBER | ANLN2 | ANLN2 | CHAR | 4 | 0 | Asset Subnumber | * | |
85 | ACC_ORDER_NO | AUFNR | AUFNR | CHAR | 12 | 0 | Order Number | * | |
86 | ACC_PROFIT_CTR | PRCTR | PRCTR | CHAR | 10 | 0 | Profit Center | ||
87 | ACC_WBS_ELEMENT | WBS_ELEM | PS_POSID | CHAR | 24 | 0 | Work breakdown structure element (WBS element) | ||
88 | ACC_NETWORK | NPLNR | AUFNR | CHAR | 12 | 0 | Network Number for Account Assignment | * | |
89 | ACC_ACTIVITY | VORNR | VORNR | CHAR | 4 | 0 | Operation/Activity Number | ||
90 | ACC_STR | BBP_ACC_GENERIC | CHAR64 | CHAR | 64 | 0 | Generic Account Assignment | ||
91 | CMMT_ITEM | FIPOS | FIPOS | CHAR | 14 | 0 | Commitment Item | * | |
92 | GRANT_NBR | GM_GRANT_NBR | GM_GRANT_NBR | CHAR | 20 | 0 | Grant | ||
93 | FUNDS_CTR | FISTL | FISTL | CHAR | 16 | 0 | Funds Center | * | |
94 | FUND | BP_GEBER | BP_GEBER | CHAR | 10 | 0 | Fund | * | |
95 | FUNC_AREA | FKBER_SHORT | FKBER_SHORT | CHAR | 4 | 0 | Functional Area | ||
96 | SD_DOC | BBP_VBELN | VBELN | CHAR | 10 | 0 | Sales and Distribution Document Number | ||
97 | SDOC_ITEM | BBP_POSNR_VA | POSNR | NUMC | 6 | 0 | Sales Document Item | ||
98 | SCL_NO | BBP_ETENR | ETENR | NUMC | 4 | 0 | Schedule Line Number | * | |
99 | ORG_RESP_ORG | BBP_PROG_ORG_RESP | HROBJEC_14 | CHAR | 14 | 0 | Responsible Organizational Unit (purchasing) | ||
100 | ORG_PURCH_ORG | BBP_PROC_ORG | HROBJEC_14 | CHAR | 14 | 0 | Responsible Purchasing Organization | ||
101 | ORG_PURCH_GROUP | BBP_PROC_GROUP | HROBJEC_14 | CHAR | 14 | 0 | Responsible Purchasing Group | ||
102 | UPDMOD | RODMUPDMOD | RODMUPDMOD | CHAR | 1 | 0 | BW Delta Process: Record Mode | ||
103 | .INCLUDE | 0 | 0 | FM Fields Earmarked Funds | |||||
104 | FUNDS_RES | BBP_KBLNR | KBLNR | CHAR | 10 | 0 | Document number for earmarked funds | * | |
105 | RES_ITEM | KBLPOS | KBLPOS | NUMC | 3 | 0 | Earmarked Funds: Document Item | * | |
106 | ITM_REV_LEV | CC_REVLV | CC_REVLV | CHAR | 2 | 0 | Revision Level | ||
107 | BUDGET_PERIOD | FM_BUDGET_PERIOD | FM_BUDGET_PERIOD | CHAR | 10 | 0 | FM: Budget Period | * |
History
Last changed by/on | SAP | 20130528 |
SAP Release Created in | 500 |