SAP ABAP Table BBP_PDS_HIER (Interface for Item Data and Hierarchy Levels)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ SRM-EBP (Application Component) Enterprise Buyer
⤷ BBP_PRODOC (Package) B2B Procurement Document
⤷ SRM-EBP (Application Component) Enterprise Buyer
⤷ BBP_PRODOC (Package) B2B Procurement Document
Basic Data
Table Category | INTTAB | Structure |
Structure | BBP_PDS_HIER | Table Relationship Diagram |
Short Description | Interface for Item Data and Hierarchy Levels |
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 | HIER_LEVEL | INT4 | INT4 | INT4 | 10 | 0 | Natural number | ||
2 | .INCLUDE | 0 | 0 | Business Transaction Item | |||||
3 | .INCLUDE | 0 | 0 | One Order: Key Fields | |||||
4 | CLIENT | MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
5 | GUID | CRMT_OBJECT_GUID | SYSUUID | RAW | 16 | 0 | GUID of a CRM Order Object | ||
6 | .INCLUDE | 0 | 0 | Item: Structure of System Fields | |||||
7 | .INCLUDE | 0 | 0 | Time and User of Last Transaction Processing | |||||
8 | CREATED_AT | COMT_CREATED_AT_USR | COM_TSTMP | DEC | 15 | 0 | Created At (Output in User Time Zone) | ||
9 | CREATED_BY | CRMT_CREATED_BY | UNAME | CHAR | 12 | 0 | User that Created the Transaction | ||
10 | CHANGED_AT | COMT_CHANGED_AT_USR | COM_TSTMP | DEC | 15 | 0 | Changed At (Output in User Time Zone) | ||
11 | CHANGED_BY | CRMT_CHANGED_BY | UNAME | CHAR | 12 | 0 | Transaction Last Changed By | ||
12 | OBJECT_TYPE | CRMT_SWO_OBJTYP_PROCESS_ITM_DB | CRM_OJ_NAME_PROCESS_ITEM | CHAR | 10 | 0 | CRM Item Object Type | * | |
13 | DESCRIPTION_UC | CRMT_PRSHTEXTG_DB | CRM_PRSHTEXTG40_DB | CHAR | 40 | 0 | Product Short Text in Upper Case for F4 Help | ||
14 | .INCLUDE | 0 | 0 | Item: Structre of External Fields | |||||
15 | HEADER | CRMT_OBJECT_GUID | SYSUUID | RAW | 16 | 0 | GUID of a CRM Order Object | ||
16 | PARENT | CRMT_OBJECT_GUID | SYSUUID | RAW | 16 | 0 | GUID of a CRM Order Object | ||
17 | ALTERNATIVE | CRMT_OBJECT_GUID | SYSUUID | RAW | 16 | 0 | GUID of a CRM Order Object | ||
18 | PRODUCT | CRMT_PRODUCT_GUID_DB | SYSUUID | RAW | 16 | 0 | Internal Unique ID of Product | ||
19 | PRODUCT_SRC_SYS | CRMT_PRODUCT_SRC_SYS | LOGSYS | CHAR | 10 | 0 | Logical System from Which Product Originates | * | |
20 | ORDERED_PROD | CRMT_ORDERED_PROD_DB | CRM_ORDERED_PROD | CHAR | 54 | 0 | Product Name Entered | ||
21 | PARTNER_PROD | CRMT_ITEM_DESCR_PARTNER | PRSHTEXT40 | CHAR | 40 | 0 | Product Number of Business Partner | ||
22 | DESCRIPTION | CRMT_PRSHTEXTX_DB | CRM_PRSHTEXT40_DB | CHAR | 40 | 0 | Product Short Text | ||
23 | ITM_LANGUAGE | CRMT_ITEM_LANGU | SYLANGU | LANG | 1 | 0 | Short Text Language for an Item | ||
24 | NUMBER_INT | CRMT_ITEM_NO | CRM_ITEM_NO | NUMC | 10 | 0 | Item Number in Document | ||
25 | NUMBER_EXT | CRMT_ITEM_NO_EXT | NUMC | 10 | 0 | External Item Number | |||
26 | ITM_TYPE | CRMT_ITEM_TYPE_DB | CRM_ITEM_TYPE | CHAR | 4 | 0 | Item Category | * | |
27 | ORDER_DATE | CRMT_ORDER_DATE | BCOS_TSTMP | DEC | 15 | 0 | Posting Date | ||
28 | SUBST_REASON | CRMT_ITEM_SUBSTITUTION | CRM_ITEM_SUBSTITUTION | CHAR | 4 | 0 | Reason for Product Substitution | * | |
29 | ITM_USAGE | CRMT_ITEM_USAGE | CRM_ITEM_USAGE | CHAR | 2 | 0 | Usage of Higher-Level Item | ||
30 | ITM_TYPE_USAGE | CRMT_IT_TYPE_USAGE | CRM_IT_TYPE_USAGE | CHAR | 4 | 0 | Item Category Usage | * | |
31 | PRODUCT_KIND | CRMT_PRODUCT_KIND | CRM_PRODUCT_KIND | CHAR | 1 | 0 | Technnical Type of Product | ||
32 | LOG_SYSTEM_EXT | CRMT_LOGSYS | LOGSYS | CHAR | 10 | 0 | Logical System | * | |
33 | .INCLUDE | 0 | 0 | EEW Extension | |||||
34 | ORDERADM_I_DUMMY | DUMMY | DUMMY | CHAR | 1 | 0 | Dummy function in length 1 | ||
35 | .INCLUDE | 0 | 0 | ||||||
36 | .INCLU--AP | 0 | 0 | Additional Fields in ORDERADM_I_EXT | |||||
37 | ALTID_TYPE | COMT_ALTID_TYPE | CHAR16 | CHAR | 16 | 0 | ID Type for Alternative IDs | ||
38 | PARENT_IN_COMP_TX | CRMT_COMP_TX_PARENT_GUID | SYSUUID | RAW | 16 | 0 | Higher-Level Item Number in Composite Transaction | ||
39 | NUMBER_INT_COMP_TX | CRMT_COMP_TX_ITEM_NO | CRM_ITEM_NO | NUMC | 10 | 0 | Composite Transaction-Specific Item Number | ||
40 | .INCLUDE | 0 | 0 | Include Item Data General Purchasing | |||||
41 | CATEGORY | BBP_CATEGORY_GUID_RAW | SYSUUID | RAW | 16 | 0 | Product Category GUID | ||
42 | CATEGORY_ID | BBP_CATEGORY_ID | COM_CATEGORY_ID | CHAR | 20 | 0 | Product Category ID | ||
43 | SCHEMA_TYPE | SCHEMA_TYPE | COM_SCHEMA_TYPE | CHAR | 10 | 0 | Standard Schema Type | * | |
44 | CT_CATEGORY_ID | BBP_CT_CATEGORY_ID | CHAR60 | CHAR | 60 | 0 | Category Name | ||
45 | ITM_EX_CT_UN_ID | BBP_ITM_EX_CT_UN_ID | CHAR40 | CHAR | 40 | 0 | Unique Key in External Category | ||
46 | MANU_PROD | BBP_MFRPN | CHAR40 | CHAR | 40 | 0 | Manufacturer Part Number | ||
47 | MFR_NO_EXT | EMNFR | CHAR10 | CHAR | 10 | 0 | External manufacturer code name or number | ||
48 | CATALOGID | BBP_WS_SERVICE_ID | BBP_WS_SERVICE_ID | CHAR | 20 | 0 | Technical Key of a Web Service (for Example - a Catalog) | BBP_CAT_ENTITY | |
49 | CATALOGITEM | BBP_CATALOGITEM | CATALOGITEM | CHAR | 40 | 0 | Catalog Item (Unique Key) | ||
50 | EXT_QUOTE_ID | BBP_EXT_QUOTE_ID | CHAR | 35 | 0 | Number of External Bid | |||
51 | EXT_QUOTE_ITEM | BBP_EXT_QUOTE_ITEM | NUMC | 10 | 0 | Item for an External Bid | |||
52 | PRODUCT_TYPE | BBP_PRODUCT_TYPE | COM_PRODUCT_TYPE | CHAR | 2 | 0 | Product Type | * | |
53 | DEL_DATCAT | LPEIN_INT | PRGRS | CHAR | 1 | 0 | Date type (day, week, month, interval) | ||
54 | DELIV_DATE | EINDT | DATUM | DATS | 8 | 0 | Item delivery date | ||
55 | DELIV_TIME | BBP_DELIV_TIME | TIME | TIMS | 6 | 0 | Delivery Time of the Item | ||
56 | LEADTIME | BBP_LEADTIME | CHAR5 | CHAR | 5 | 0 | Delivery Time in Days | ||
57 | VPER_START | BBP_VPER_START | DATUM | DATS | 8 | 0 | Validity Period From | ||
58 | VPER_END | BBP_VPER_END | DATUM | DATS | 8 | 0 | Validity period | ||
59 | QUANTITY | BBP_MNG | MENG13 | QUAN | 13 | 3 | Quantity in Order Unit | ||
60 | UNIT | BBP_UNIT | MEINS | UNIT | 3 | 0 | Purchase Order Unit | * | |
61 | GROSS_PRICE | BBP_GROSS_PRICE | WERT7 | CURR | 13 | 2 | Gross Price | ||
62 | PRICE | BBP_PRICE | WERT7 | CURR | 13 | 2 | Net Price | ||
63 | PRICE_UNIT | EPEIN | DEC5 | DEC | 5 | 0 | Price unit | ||
64 | PRICE_ORIGIN | BBP_PRICE_ORIGIN | BBP_PRICE_ORIGIN | CHAR | 1 | 0 | Original Price (Determination/Manual Input) | ||
65 | VALUE | BBP_VALUE | WERT8 | CURR | 15 | 2 | Net Value | ||
66 | CURRENCY | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
67 | TAX_CODE | BBP_MWSKZ | BBP_MWSKZ | CHAR | 2 | 0 | Tax Code | ||
68 | BBP_MOVE_TYPE | BBP_MOVE_TYPE | CHAR4 | CHAR | 4 | 0 | Movement Code for Enterprise Buyer Professional Edition | ||
69 | SRC_OBJECT_TYPE | BBP_SRC_I_OBJ_TYP | OJ_NAME | CHAR | 10 | 0 | Object Type of Reference Item | * | |
70 | SRC_ITM_ID | BBP_SRC_ITM_ID | BBP_SRC_ITM_ID | CHAR | 20 | 0 | Unique ID of a Template Item | ||
71 | SRC_LOG_SYS | BBP_SRC_LOG_SYS | LOGSYS | CHAR | 10 | 0 | Logical System of Template Document (Vacant if in Loc. Sys.) | * | |
72 | SRC_GUID | BBP_SRC_I_GUID | SYSUUID | RAW | 16 | 0 | Reference Item GUID | ||
73 | CTR_LOG_SYS | BBP_CTR_LOG_SYSTEM | LOGSYS | CHAR | 10 | 0 | Logical System from Which the Contract Originates | * | |
74 | CTR_GUID | BBP_CTR_I_GUID | SYSUUID | RAW | 16 | 0 | Contract Template Item GUID | ||
75 | CTR_ITEM_NUMBER | BBP_CTR_ITEM | CRM_ITEM_NO | NUMC | 10 | 0 | Number of Contract Item | ||
76 | CTR_HDR_NUMBER | BBP_CTR_ID | CRM_OBJECT_ID | CHAR | 10 | 0 | Contract Number | ||
77 | CTR_HDR_GUID | BBP_CTR_H_GUID | SYSUUID | RAW | 16 | 0 | GUID Contract | ||
78 | COMM_ID | BBP_COMM_ID | EBELP | NUMC | 5 | 0 | Clear Item ID for Commitments Interface | * | |
79 | DEL_IND | BBP_DEL_IND | XFELD | CHAR | 1 | 0 | Deletion Indicator EBP Purchasing Document | ||
80 | FINAL_INV | EREKZ | XFELD | CHAR | 1 | 0 | Final Invoice Indicator | ||
81 | FINAL_ENTRY | BBP_FINAL_ENTRY | XFELD | CHAR | 1 | 0 | Final Entry Indicator (Goods/Services) | ||
82 | DEDUCT_IND | BBP_DEDUCT_IND | XFELD | CHAR | 1 | 0 | Discount/Rejection Indicator at Item Level | ||
83 | REJECT_WI | SWW_WIID | SWW_WIID | NUMC | 12 | 0 | Work item ID | * | |
84 | .INCLUDE | 0 | 0 | Actual Values | |||||
85 | VAL_CF_E | BBP_CF_VALUE_E | WERT8 | CURR | 15 | 2 | Value of Entered Confirmations | ||
86 | VAL_CF | BBP_CF_VALUE | WERT8 | CURR | 15 | 2 | Value of Confirmations Released | ||
87 | VAL_IV_E | BBP_IV_VALUE_E | WERT8 | CURR | 15 | 2 | Entered Invoice Value | ||
88 | VAL_IV | BBP_IV_VALUE | WERT8 | CURR | 15 | 2 | Released Invoice Value | ||
89 | VAL_PO_E | BBP_PO_VALUE_E | WERT8 | CURR | 15 | 2 | Value of POs/Confirmations/Invoices Created for Contract | ||
90 | .INCLUDE | 0 | 0 | Actual Quantity | |||||
91 | QUAN_CF_E | BBP_CF_QUANT_E | MENG15 | QUAN | 15 | 3 | Quantity of Entered Confirmation | ||
92 | QUAN_CF | BBP_CF_QUANT | MENG15 | QUAN | 15 | 3 | Quantity of Released Confirmations | ||
93 | QUAN_IV_E | BBP_IV_QUANT_E | MENG15 | QUAN | 15 | 3 | Entered Invoiced Quantity | ||
94 | QUAN_IV | BBP_IV_QUANT | MENG15 | QUAN | 15 | 3 | Released Invoiced Quantity | ||
95 | QUAN_PO_E | BBP_PO_QUANT_E | MENG15 | QUAN | 15 | 3 | Quantity of POs/Confirmations/Invoices Created for Contract | ||
96 | NUM_CONF | BBP_NUM_CONF | BBP_INT4V | INT4 | 10 | 0 | Number of Entered Confirmations for a Purchase Order | ||
97 | NUM_INV | BBP_NUM_INV | BBP_INT4V | INT4 | 10 | 0 | Number of Entered Invoices for Purchase Order or Confirmat. | ||
98 | DCIND | BBP_DCIND | BBP_DCIND | CHAR | 1 | 0 | Debit/credit Indicator | ||
99 | SUBTYPE | BBP_I_SUBTYPE | BBP_I_SUBTYPE | CHAR | 2 | 0 | Specification Purchase Item (e.g. Direct Material/Hierarch.) | ||
100 | SOURCE_REL_IND | BBP_SOURCE_REL_IND | BBP_SOURCE_REL_IND | CHAR | 1 | 0 | Indicator - If the Document is Sourcing-Relevant | ||
101 | EXT_DEMID | BBP_EXT_DEMID | CHAR32 | CHAR | 32 | 0 | External Requirement Tracking Number | ||
102 | EXT_DEM_POSID | BBP_EXT_DEM_POSID | CHAR32 | CHAR | 32 | 0 | External Requirement Tracking Number | ||
103 | EXT_DEM_LOGSYS | BBP_EXT_DEM_LOGSYS | LOGSYS | CHAR | 10 | 0 | Logical System from where an External Requirement Comes | * | |
104 | PCINS | BBPPCINS | BBPPCINS | CHAR | 4 | 0 | Procurement card company | * | |
105 | PCNUM | BBPPCNUM | BBPPCNUM | CHAR | 25 | 0 | Procurement card number | * | |
106 | PCNAME | BBPPCNAME | CHAR40 | CHAR | 40 | 0 | Name of procurement cardholder | ||
107 | PCDAT_TO | BBPPCDAT_TO | DATUM | DATS | 8 | 0 | Procurement Card Validity Date | ||
108 | LOGSYS_FI | BBP_LOGSYS_FI | LOGSYS | CHAR | 10 | 0 | Logical System of FI System | * | |
109 | ITM_RELEASED | BBP_ITM_RELEASED | XFELD | CHAR | 1 | 0 | Indicator - Item is to be Released | ||
110 | ACTIVE_ITEM | BBP_GUID | SYSUUID | RAW | 16 | 0 | Globally Unique identifier | ||
111 | TIME_FROM | BBP_TIME_FROM | TIME | TIMS | 6 | 0 | Start Time | ||
112 | TIME_TO | BBP_TIME_TO | TIME | TIMS | 6 | 0 | Finish Time | ||
113 | ORIGIN_ORDER_ID | BBP_ORIGIN_ORDER_ID | CHAR35 | CHAR | 35 | 0 | Origninal Customer's PO No. for Third Party Transaction | ||
114 | ORIGIN_ITEM_ID | BBP_ORIGIN_ORDER_ITEM_ID | NUMC10 | NUMC | 10 | 0 | Orignl Customer Purchase Order Item No. - Third Party Trans. | ||
115 | NUM_SOS | BBP_NUM_SOS | BBP_NUM_SOS | CHAR | 1 | 0 | Number of Sources of Supply Found (for Performance) | ||
116 | GROUPING_LEVEL | BBP_GROUPING_LEVEL | BBP_GROUPING_LEVEL | CHAR | 1 | 0 | Specifies How Hierarchy Positions are to be Managed | ||
117 | .INCLUDE | 0 | 0 | ||||||
118 | DELIV_DAYS | BBP_DELIV_DAYS | NUMC3 | NUMC | 3 | 0 | Delivery Time in Days | ||
119 | INCOTERM_KEY | BBP_INCOTERM_KEY | BBP_INCOTERM_KEY | CHAR | 3 | 0 | Incoterm Key | * | |
120 | INCOTERM_LOC | BBP_INCOTERM_LOCATION | BBP_INCOTERM_LOCATION | CHAR | 28 | 0 | Incoterm Location | ||
121 | TAX_CODE_ORIGIN | BBP_TAX_CODE_ORIGIN | BBP_TAX_CODE_ORIGIN | CHAR | 1 | 0 | Origin Tax Code Indicator (Determination/Manual Entry) | ||
122 | MIN_ORDER_VALUE | BBP_VALUE | WERT8 | CURR | 15 | 2 | Net Value | ||
123 | MIN_ORDER_QUAN | BBP_MNG | MENG13 | QUAN | 13 | 3 | Quantity in Order Unit | ||
124 | EXT_DEM_SUBPOSID | BBP_EXT_DEM_SUBPOSID | CHAR32 | CHAR | 32 | 0 | External Requirement Subitem Number | ||
125 | .INCLUDE | 0 | 0 | Include Purchasing Set | |||||
126 | GR_IND | WEPOS | XFELD | CHAR | 1 | 0 | Goods Receipt Indicator | ||
127 | IR_IND | REPOS | XFELD | CHAR | 1 | 0 | Invoice receipt indicator | ||
128 | GR_NON_VAL | BBP_WEUNB | XFELD | CHAR | 1 | 0 | Goods receipt, non-valuated | ||
129 | GR_BASEDIV | WEBRE | XFELD | CHAR | 1 | 0 | Indicator: GR-Based Invoice Verification | ||
130 | ERS | XERSY | XFELD | CHAR | 1 | 0 | Evaluated Receipt Settlement (ERS) | ||
131 | OR_IND | BBP_OR_IND | XFELD | CHAR | 1 | 0 | PO Confirmation Expected (ORDER_RESP_EXP in vendor master) | ||
132 | ASN_IND | BBP_ASN_IND | XFELD | CHAR | 1 | 0 | Shipping Notification Exptd (ASN_EXPECTED in Vendor Master) |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | BBP_PDS_HIER | CATALOGID | BBP_CAT_ENTITY | CATALOGID |
History
Last changed by/on | SAP | 20140802 |
SAP Release Created in |