SAP ABAP Table BBP_PO_BW_GET_TD_STRUC (Extraction Structure: Movement Data SAP BBP Purchase Order)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ SRM-EBP-REP (Application Component) Reporting
⤷ BBP_BW (Package) BW Extractors and Development for BBP
⤷ SRM-EBP-REP (Application Component) Reporting
⤷ BBP_BW (Package) BW Extractors and Development for BBP
Basic Data
Table Category | INTTAB | Structure |
Structure | BBP_PO_BW_GET_TD_STRUC | Table Relationship Diagram |
Short Description | Extraction Structure: Movement Data SAP BBP Purchase Order |
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 | CLIENT | MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
2 | GUID | BBP_BW_PO_H_GUID | SYSUUID_C | CHAR | 32 | 0 | PO GUID 32 Char. | ||
3 | PO_NUMBER | BBP_BW_PO_NUMBER | CRM_OBJECT_ID | CHAR | 10 | 0 | Purchase Order Number | ||
4 | PROCESS_TYPE | CRMT_PROCESS_TYPE | CRM_PROCESS_TYPE | CHAR | 4 | 0 | Business Transaction Type | * | |
5 | PO_DATE | PO_DATE | DATS | 8 | 0 | Purchase Order Date | |||
6 | DESCRIPTION | CRMT_PROCESS_DESCRIPTION | CRM_PROCESS_DESCRIPTION | CHAR | 40 | 0 | Transaction Description | ||
7 | DESCRIPTION_UC | CRMT_PROCESS_DESCRIPTION_UC | CRM_PROCESS_DESCRIPTION_UC | CHAR | 40 | 0 | Transaction Description (Upper Case) | ||
8 | CREATED_AT | BBP_BW_CREATE_DATE | DATS | 8 | 0 | Posting Date for a Business Transaction | |||
9 | CHANGED_AT | BBP_BW_CHNG_AT | DATS | 8 | 0 | Change Date of Document | |||
10 | CREATED_BY | CRMT_CREATED_BY | UNAME | CHAR | 12 | 0 | User that Created the Transaction | ||
11 | CHANGED_BY | CRMT_CHANGED_BY | UNAME | CHAR | 12 | 0 | Transaction Last Changed By | ||
12 | BUP_ORDERER_ID | BU_PARTNER | BU_PARTNER | CHAR | 10 | 0 | Business Partner Number | * | |
13 | BUP_ORDERER_GUID | BBP_BW_ORD_GUID_32 | SYSUUID_C | CHAR | 32 | 0 | Company GUID 32 Char. | ||
14 | BUP_VENDOR_ID | BBP_VENDOR_ID | BU_PARTNER | CHAR | 10 | 0 | Vendor ID | * | |
15 | BUP_VENDOR_GUID | BBP_BW_VEND_GUID_32 | SYSUUID_C | CHAR | 32 | 0 | Vendor GUID 32 Char. | ||
16 | CO_CODE | BBP_CO_CODE | BUKRS | CHAR | 4 | 0 | Company Code in FI System | * | |
17 | BBP_LOG_SYSTEM | BBP_LOG_SYS | LOGSYS | CHAR | 10 | 0 | Logical System EBP | * | |
18 | BE_LOG_SYSTEM | BE_LOG_SYSTEM | LOGSYS | CHAR | 10 | 0 | Logical System of Logistics Backend | * | |
19 | LOGSYS_FI | BBP_LOGSYS_FI | LOGSYS | CHAR | 10 | 0 | Logical System of FI System | * | |
20 | TOTAL_VALUE_APPR | BBP_TOTAL_VALUE_APPR | WERT8 | CURR | 15 | 2 | Total Value of Shopping Cart at Time of Approval (BW) | ||
21 | CURRENCY | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
22 | VPER_START | BBP_VPER_START | DATUM | DATS | 8 | 0 | Validity Period From | ||
23 | VPER_END | BBP_VPER_END | DATUM | DATS | 8 | 0 | Validity period | ||
24 | PCINS | BBPPCINS | BBPPCINS | CHAR | 4 | 0 | Procurement card company | * | |
25 | PCNUM | BBPPCNUM | BBPPCNUM | CHAR | 25 | 0 | Procurement card number | * | |
26 | INCOTERM_KEY | BBP_INCOTERM_KEY | BBP_INCOTERM_KEY | CHAR | 3 | 0 | Incoterm Key | * | |
27 | INCOTERM_LOC | BBP_INCOTERM_LOCATION | BBP_INCOTERM_LOCATION | CHAR | 28 | 0 | Incoterm Location | ||
28 | CONF_IND | WEPOS | XFELD | CHAR | 1 | 0 | Goods Receipt Indicator | ||
29 | IR_IND | REPOS | XFELD | CHAR | 1 | 0 | Invoice receipt indicator | ||
30 | CONF_NON_VAL | WEUNB | XFELD | CHAR | 1 | 0 | Goods Receipt, Non-Valuated | ||
31 | CONF_BASEDIV | WEBRE | XFELD | CHAR | 1 | 0 | Indicator: GR-Based Invoice Verification | ||
32 | ERS | XERSY | XFELD | CHAR | 1 | 0 | Evaluated Receipt Settlement (ERS) | ||
33 | PO_COUNT | BBP_BW_PO_CNT_2 | DEC | 5 | 4 | Counter for Number of Order Headers | |||
34 | STAT_PROCESS | J_STATUS | J_STATUS | CHAR | 5 | 0 | Object status | ||
35 | ITM_GUID | BBP_BW_PO_I_GUID | SYSUUID_C | CHAR | 32 | 0 | PO Item GUID 32 Char. | ||
36 | ITM_CREATED_AT | BBP_BW_CR_AT | DATS | 8 | 0 | Creation Date of Document | |||
37 | ITM_CHANGED_AT | BBP_BW_CHNG_AT | DATS | 8 | 0 | Change Date of Document | |||
38 | ITM_CREATED_BY | CRMT_CREATED_BY | UNAME | CHAR | 12 | 0 | User that Created the Transaction | ||
39 | ITM_CHANGED_BY | CRMT_CHANGED_BY | UNAME | CHAR | 12 | 0 | Transaction Last Changed By | ||
40 | ITM_PARENT | BBP_GUID_32 | SYSUUID_C | CHAR | 32 | 0 | Globally Unique Identifier in 32-Character Display | ||
41 | ITM_PRODUCT_GUID | BBP_BW_PROD_GUID_32 | SYSUUID_C | CHAR | 32 | 0 | Product Guid 32 Char. | ||
42 | ITM_PRODUCT_ID | CRMT_ORDERED_PROD | CRM_ORDERED_PROD | CHAR | 54 | 0 | Product Name Entered | ||
43 | ITM_PARTNER_PROD | CRMT_ITEM_DESCR_PARTNER | PRSHTEXT40 | CHAR | 40 | 0 | Product Number of Business Partner | ||
44 | ITM_DESCRIPTION | COMT_PRSHTEXTX | PRSHTEXT40 | CHAR | 40 | 0 | Product Description | ||
45 | ITM_DESCRIPT_UC | COMT_PRSHTEXTG | PRSHTEXTG40 | CHAR | 40 | 0 | Product Description in Uppercase for F4 Help | ||
46 | ITM_NUMBER | CRMT_ITEM_NO | CRM_ITEM_NO | NUMC | 10 | 0 | Item Number in Document | ||
47 | ITM_TYPE | CRMT_ITEM_TYPE | CRM_ITEM_TYPE | CHAR | 4 | 0 | Item Category | * | |
48 | ITM_CAT_GUID | BBP_GUID_32 | SYSUUID_C | CHAR | 32 | 0 | Globally Unique Identifier in 32-Character Display | ||
49 | ITM_CATEGORY_ID | COMT_CATEGORY_ID | COM_CATEGORY_ID | CHAR | 20 | 0 | Category ID | ||
50 | ITM_SCHEMA_TYPE | SCHEMA_TYPE | COM_SCHEMA_TYPE | CHAR | 10 | 0 | Standard Schema Type | * | |
51 | ITM_EX_CT_UN_ID | BBP_ITM_EX_CT_UN_ID | CHAR40 | CHAR | 40 | 0 | Unique Key in External Category | ||
52 | ITM_CT_CAT_ID | BBP_CT_CATEGORY_ID | CHAR60 | CHAR | 60 | 0 | Category Name | ||
53 | ITM_MANU_PROD | BBP_MFRPN | CHAR40 | CHAR | 40 | 0 | Manufacturer Part Number | ||
54 | ITM_MFR_NO_EXT | EMNFR | CHAR10 | CHAR | 10 | 0 | External manufacturer code name or number | ||
55 | ITM_CATALOGID | CATALOG | KATALOGID | CHAR | 20 | 0 | Catalog ID from which the line was selected | * | |
56 | ITM_PRODUCT_TYPE | COMT_PRODUCT_TYPE | COM_PRODUCT_TYPE | CHAR | 2 | 0 | Product Type | * | |
57 | ITM_DELIV_DATE | EINDT | DATUM | DATS | 8 | 0 | Item delivery date | ||
58 | ITM_QUANTITY | BBP_MNG | MENG13 | QUAN | 13 | 3 | Quantity in Order Unit | ||
59 | ITM_UNIT | BBP_UNIT | MEINS | UNIT | 3 | 0 | Purchase Order Unit | * | |
60 | ITM_PRICE | BBP_PRICE | WERT7 | CURR | 13 | 2 | Net Price | ||
61 | ITM_PRICE_UNIT | EPEIN | DEC5 | DEC | 5 | 0 | Price unit | ||
62 | ITM_VALUE | BBP_VALUE | WERT8 | CURR | 15 | 2 | Net Value | ||
63 | ITM_REQUEST_ID | BU_PARTNER | BU_PARTNER | CHAR | 10 | 0 | Business Partner Number | * | |
64 | ITM_REQUEST_GUID | BBP_BW_REQU_GUID_32 | SYSUUID_C | CHAR | 32 | 0 | Requester GUID 32 Char. | ||
65 | ITM_RECIPNT_ID | BU_PARTNER | BU_PARTNER | CHAR | 10 | 0 | Business Partner Number | * | |
66 | ITM_RECIPNT_GUID | BBP_BW_RCPT_GUID_32 | SYSUUID_C | CHAR | 32 | 0 | Goods Recipient GUID 32 Char | ||
67 | ITM_LOC_ID | BBP_LOCATION_NO | BU_PARTNER | CHAR | 10 | 0 | Plant Number | * | |
68 | ITM_LOC_GUID | BBP_LOC_GUID_32 | SYSUUID_C | CHAR | 32 | 0 | Plant GUID 32 Char | ||
69 | ITM_WORKER_ID | BBP_SRV_PROVIDER | BU_PARTNER | CHAR | 10 | 0 | Service Provider Number | * | |
70 | ITM_WORKER_GUID | BBP_BW_SRV_GUID_32 | SYSUUID_C | CHAR | 32 | 0 | Service Provider GUID 32 Char. | ||
71 | ITM_WRKR_SRC_SYS | COMT_PARTNER_SRC_SYS | LOGSYS | CHAR | 10 | 0 | Logical System from Which Partner Originates | * | |
72 | ITM_WORKER_NAME | BU_NAME1TX | TEXT80 | CHAR | 80 | 0 | Full Name | ||
73 | ITM_WRK_NO_TYPE | CRMT_PARTNER_NO_TYPE | COMT_PARTNER_NO_TYPE | CHAR | 2 | 0 | Partner Number Type (e.g. GUID, Pers. No., ...), Internal | ||
74 | ITM_CUSTOMER_ID | BBP_CUSTOMER | BU_PARTNER | CHAR | 10 | 0 | Customer Number (Third Party PO) | * | |
75 | ITM_CUST_GUID | BBP_BW_CUST_GUID_32 | SYSUUID_C | CHAR | 32 | 0 | Customer GUID 32 Char. (Third Party PO) | ||
76 | ITM_CUST_SRC_SYS | COMT_PARTNER_SRC_SYS | LOGSYS | CHAR | 10 | 0 | Logical System from Which Partner Originates | * | |
77 | ITM_CUST_NAME | BU_MCNAME1 | CHAR35 | CHAR | 35 | 0 | Search Help Field 1 (Name 1/Last Name) | ||
78 | ITM_CUST_NO_TYPE | CRMT_PARTNER_NO_TYPE | COMT_PARTNER_NO_TYPE | CHAR | 2 | 0 | Partner Number Type (e.g. GUID, Pers. No., ...), Internal | ||
79 | ITM_LIM_K | BBP_BW_LIMIT_K | WERT8 | CURR | 15 | 2 | Contract Limit | ||
80 | ITM_LIM_S | BBP_BW_LIMIT_S | WERT8 | CURR | 15 | 2 | Other Limit | ||
81 | ITM_LIM_G | BBP_LIMIT | WERT8 | CURR | 15 | 2 | Overall Limit | ||
82 | ITM_UNLIMITED | BBP_UNLIMITED | CHAR01 | CHAR | 1 | 0 | Undefined Limit | ||
83 | ITM_EXP_VALUE | BBP_EXP_VALUE | WERT8 | CURR | 15 | 2 | Expected value | ||
84 | ITM_TAX_CODE | BBP_MWSKZ | BBP_MWSKZ | CHAR | 2 | 0 | Tax Code | ||
85 | ITM_TAX_AMOUNT | BBP_TAX_AMOUNT | WERT8 | CURR | 15 | 2 | Tax Amount | ||
86 | ITM_PROD_SRC_SYS | CRMT_PRODUCT_SRC_SYS | LOGSYS | CHAR | 10 | 0 | Logical System from Which Product Originates | * | |
87 | ITM_SYS_TYPE | BBP_SYSTEM_TYPE | BBP_SYSTEM_TYPE | CHAR | 10 | 0 | System type | ||
88 | ITM_SLD_SYS_NAME | BBP_SLD_SYS_NAME | TEXT60 | CHAR | 60 | 0 | Name of a System im System Landscape Directory (SLD) | ||
89 | ITM_SC_H_OBJ_ID | BBP_BW_SC_NUMBER | CRM_OBJECT_ID | CHAR | 10 | 0 | Shopping Cart Number | ||
90 | ITM_SC_H_GUID | CRMT_OBJECT_GUID | SYSUUID | RAW | 16 | 0 | GUID of a CRM Order Object | ||
91 | ITM_SC_ITM_GUID | BBP_GUID_32 | SYSUUID_C | CHAR | 32 | 0 | Globally Unique Identifier in 32-Character Display | ||
92 | ITM_SC_ITEM_NO | BBP_PO_ITEM_NO | CRM_ITEM_NO | NUMC | 10 | 0 | Item Number PO Document | ||
93 | ITM_DEL_IND | BBP_DEL_IND | XFELD | CHAR | 1 | 0 | Deletion Indicator EBP Purchasing Document | ||
94 | ITM_FINAL_INV | EREKZ | XFELD | CHAR | 1 | 0 | Final Invoice Indicator | ||
95 | ITM_FINAL_ENTRY | BBP_FINAL_ENTRY | XFELD | CHAR | 1 | 0 | Final Entry Indicator (Goods/Services) | ||
96 | ITM_CTR_GUID | BBP_BW_CTR_GUID_32 | SYSUUID_C | CHAR | 32 | 0 | Contract Header Guid 32 Char. | ||
97 | ITM_CTR_NUMBER | BBP_CTR_OBJECT_ID | CRM_OBJECT_ID | CHAR | 10 | 0 | Contract Number | ||
98 | ITM_CTR_ITMGUID | BBP_BW_CTR_I_GUID_32 | SYSUUID_C | CHAR | 32 | 0 | Contract Item Guid 32 Char. | ||
99 | ITM_CTR_ITM_NO | CRMT_ITEM_NO | CRM_ITEM_NO | NUMC | 10 | 0 | Item Number in Document | ||
100 | ACCEPT_QUANTITY | BBP_BW_ACCEPT_QUANT | MENG15 | QUAN | 15 | 3 | Accepted Quantity | ||
101 | ITM_SUBTYPE | BBP_I_SUBTYPE | BBP_I_SUBTYPE | CHAR | 2 | 0 | Specification Purchase Item (e.g. Direct Material/Hierarch.) | ||
102 | ITM_COUNT | BBP_BW_ITEM_CNT | DEC | 5 | 4 | Counter for Number of Items | |||
103 | ACC_GUID | BBP_GUID_32 | SYSUUID_C | CHAR | 32 | 0 | Globally Unique Identifier in 32-Character Display | ||
104 | ACC_NO | BBP_ACC_NO | BBP_ACCNO | NUMC | 4 | 0 | Sequential Account Assignment No. in EBP Purchase Document | ||
105 | ACC_CAT | BBP_ACC_CAT | BBP_ACCCAT | CHAR | 5 | 0 | Account Assignment Category in Enterprise Buyer | ||
106 | ACC_DISTR_PERC | BBP_VPROZ | BBP_VPROZ | DEC | 5 | 2 | Distribution Percentage in the Case of Multiple Acct Assgt | ||
107 | ACC_G_L_ACCT | SAKNR | SAKNR | CHAR | 10 | 0 | G/L Account Number | * | |
108 | ACC_BUS_AREA | GSBER | GSBER | CHAR | 4 | 0 | Business Area | * | |
109 | ACC_CO_AREA | KOKRS | CACCD | CHAR | 4 | 0 | Controlling Area | * | |
110 | ACC_COST_CTR | KOSTL | KOSTL | CHAR | 10 | 0 | Cost Center | * | |
111 | ACC_ASSET_NO | ANLN1 | ANLN1 | CHAR | 12 | 0 | Main Asset Number | * | |
112 | ACC_SUB_NUMBER | ANLN2 | ANLN2 | CHAR | 4 | 0 | Asset Subnumber | * | |
113 | ACC_ORDER_NO | AUFNR | AUFNR | CHAR | 12 | 0 | Order Number | * | |
114 | ACC_PROFIT_CTR | PRCTR | PRCTR | CHAR | 10 | 0 | Profit Center | ||
115 | ACC_WBS_ELEM_E | WBS_ELEM | PS_POSID | CHAR | 24 | 0 | Work breakdown structure element (WBS element) | ||
116 | ACC_NETWORK | NPLNR | AUFNR | CHAR | 12 | 0 | Network Number for Account Assignment | * | |
117 | ACC_ACTIVITY | VORNR | VORNR | CHAR | 4 | 0 | Operation/Activity Number | ||
118 | ACC_STR | BBP_ACC_GENERIC | CHAR64 | CHAR | 64 | 0 | Generic Account Assignment | ||
119 | CMMT_ITEM | FIPOS | FIPOS | CHAR | 14 | 0 | Commitment Item | * | |
120 | GRANT_NBR | GM_GRANT_NBR | GM_GRANT_NBR | CHAR | 20 | 0 | Grant | ||
121 | FUNDS_CTR | FISTL | FISTL | CHAR | 16 | 0 | Funds Center | * | |
122 | FUND | BP_GEBER | BP_GEBER | CHAR | 10 | 0 | Fund | * | |
123 | FUNC_AREA | FKBER_SHORT | FKBER_SHORT | CHAR | 4 | 0 | Functional Area | ||
124 | SD_DOC | BBP_VBELN | VBELN | CHAR | 10 | 0 | Sales and Distribution Document Number | ||
125 | SDOC_ITEM | BBP_POSNR_VA | POSNR | NUMC | 6 | 0 | Sales Document Item | ||
126 | SCHED_LINE | BBP_ETENR | ETENR | NUMC | 4 | 0 | Schedule Line Number | * | |
127 | ORG_RESP_ORG | BBP_PROG_ORG_RESP | HROBJEC_14 | CHAR | 14 | 0 | Responsible Organizational Unit (purchasing) | ||
128 | ORG_PURCH_ORG | BBP_PROC_ORG | HROBJEC_14 | CHAR | 14 | 0 | Responsible Purchasing Organization | ||
129 | ORG_PURCH_GROUP | BBP_PROC_GROUP | HROBJEC_14 | CHAR | 14 | 0 | Responsible Purchasing Group | ||
130 | UPDMOD | RODMUPDMOD | RODMUPDMOD | CHAR | 1 | 0 | BW Delta Process: Record Mode | ||
131 | .INCLUDE | 0 | 0 | FM Fields Earmarked Funds | |||||
132 | FUNDS_RES | KBLNR | KBLNR | CHAR | 10 | 0 | Document Number for Earmarked Funds | * | |
133 | RES_ITEM | KBLPOS | KBLPOS | NUMC | 3 | 0 | Earmarked Funds: Document Item | * |
History
Last changed by/on | SAP | 20130604 |
SAP Release Created in | 20A |