	Table	Columns	Description
1	TJKWE	15	IS-M/SD: WBZ, Order Data for Inbound Processing
2	RSADMINC	96	Customizing Table General BW
3	BBP_PD_XML	8	Table for Persistent Class CL_XML_PPF_BBP
4	/OTX/RM_TELIB	24	Enterprise Library Server Settings
5	UMV_TR125	9	Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
7	/ISDFPS/CHVW_E	34	External Batch Where-Used List
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	FMARCPAR	4	Parallelization of FMARC_BATCH
10	CEKRS	5	Movement type parameters for automatic ERS

	Table	Columns	Description
1	OITM	299	Items
2	OINV	386	A/R Invoice
3	OCRD	332	Business Partner
4	ORDR	386	Sales Order
5	INV1	265	A/R Invoice - Rows
6	OJDT	100	Journal Entry
7	OPCH	386	A/P Invoice
8	OVTG	52	Tax Definition
9	OPOR	386	Purchase Order
10	JDT1	124	Journal Entry - Rows

	Table	Columns	Description
1	OITM	249	Items
2	ORCT	154	Incoming Payment
3	OINV	268	A/R Invoice
4	OVPM	154	Outgoing Payments
5	OIVL	77	Whse Journal
6	OPCH	268	A/P Invoice
7	JDT1	110	Journal Entry - Rows
8	OOCR	9	Loading Factors
9	OSRN	20	Serial Numbers Master Data
10	OBOT	10	Bill Of Exchang Transaction

293 COLUMNS | 2 INDEXES | ERP 6.0 | SRMSOCO_DRFT_ITM TABLE

ERP EHP7

6.0

293

Draft Items for FIORI SOCO

SQL: selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, DRAFT_I_GUID, GUID, PARENT, ITM_TYPE, NUMBER_INT, NUMBER_EXT, PRODUCT, DESCRIPTION, CATEGORY, CATEGORY_ID, SCHEMA_TYPE, CT_CATEGORY_ID, ITM_EX_CT_UN_ID, MANU_PROD, MFR_NO_EXT, CATALOGID, CATALOGITEM, EXT_QUOTE_ID, EXT_QUOTE_ITEM, QUANTITY, UNIT, DEL_IND, ORDERED_PROD, PRODUCT_SRC_SYS, PRICE, PRICE_UNIT, SUBTYPE, GROSS_PRICE, CATALOG_PRICE, CURRENCY, DEL_DATCAT, DELIV_DATE, DELIV_TIME, LEADTIME, VPER_START, VPER_END, VPER_TYPE, END_TIME, PARTNER_PROD, PRODUCT_TYPE, SRC_GUID, SRC_OBJECT_TYPE, CTR_LOG_SYS, CTR_GUID, CTR_ITEM_NUMBER, CTR_HDR_NUMBER, CTR_HDR_GUID, GR_IND, IR_IND, ASN_IND, OR_IND, GR_NON_VAL, RFQ_IND, PCINS, PCNUM, PCNAME, PCDAT_TO, LOGSYS_FI, DEDUCT_IND, REJECT_WI, EXT_DEMID, EXT_DEM_POSID, EXT_DEM_SUBPOSID, EXT_DEM_KEY, EXT_DEM_POSKEY, EXT_DEM_LOGSYS, EXT_DEM_CH_AT, PROJECT_ID, PROJECT_TASK_ID, PROJECT_ROLE_ID, ORIGIN_ORDER_ID, ORIGIN_ITEM_ID, NUM_SOS, DOC_PRIORITY, GROUPING_LEVEL, INCOTERM_KEY, INCOTERM_LOC, UOM_DENOMINATOR, UOM_NUMERATOR, LUMP_SUM_IND, BE_LOG_SYSTEM, BE_OBJ_ITEM, BE_OBJECT_TYPE, BE_OBJECT_ID, BE_REFOBJ_TYPE, BE_REFOBJ, BE_REFOBJ_ITEM, BE_REFOBJ_SBITM, BE_REFOBJ_TYPE2, BE_REFOBJ2, BE_REFOBJ_ITEM2, BE_REFOBJ_FYEAR2, BE_STGE_LOC, BE_PLANT, BE_BATCH, BE_VAL_TYPE, BE_MOVE_REAS, BE_EXPERYDATE, BE_PUR_GROUP, BE_PUR_ORG, BE_CO_CODE, BE_DOC_TYPE, BE_ACCREQUIRED, BE_SP_STK_IND, BE_INFO_REC, BE_MOVE_TYPE, BE_PACKNO, BE_INTROW, BE_ITEM_TEXT, BE_PO_PRICE, BE_UNLOAD_PT, BE_DEL_IND, BE_TRACKING_NO, BE_COND_TYPE, BE_COND_STEP, BE_COND_COUNTER, COPY_OF_GUID, ICC_BR_STEUC, ICC_BR_MATUSE, ICC_BR_MATORG, ICC_BR_OWNPRO, ICC_BR_INDUST, ICC_IN_TXJCD, DUMMY_EEW_PDISS_SC, PS_HL_ITEM, PS_HANDLE_ITM, PS_EXSNR, PS_CTRL_KEY, PS_IPT, PS_VALUE_RU, PS_EXLIN_IND, PS_EXT_IND_STATE, EXPSV_ITEM_TYPE, ORIG_GUID, APCGK, APCGK_EXTEND, BAS_DATE, ADATTYP, START_DAT, DEV, INDANX, LIMIT_DAT, NUMERATOR, PS_IDC_TYPE, PS_INFU_IND, PS_SC_AC03, PS_SC_MK03, PS_PO_HDR_GUID, PS_PO_HDR_NUM, PS_PO_ITM_GUID, PS_PO_ITM_NUM, PS_PO_LOG_SYS, PS_PO_DELIV_DATE, PS_PO_DELIV_TIME, PS_PO_OPEN_QUAN, PS_PO_QUAN_UNIT, OPT_IND, OPT_STATUS, OPT_XPER_START, OPT_XPER_END, OPT_REF_GUID, PS_OPT_RF_NUM_INT, PS_OPT_RF_DESC, PS_OPT_RF_ORD_PROD, PS_OPT_RF_EXLIN, PS_OPT_IND_DISP, PS_O_BO_OBJ_ID, PS_O_BO_OBJ_TY, PS_O_BO_DESC, PS_O_BO_GUID, PS_O_BO_ITM_NO, PS_O_BO_DRAFT, PS_O_BO_DOC_TY, PS_PA_ID, PS_PA_MIN_FEE, PS_PA_MAX_FEE, PS_PA_GS_BLW, PS_PA_GS_ABV, PS_PA_CLNG_AMT, PS_PA_TOTL_AMT, PS_PA_NTE_IND, PS_PA_NSP_IND, PS_PA_COMP_KEY, PS_PA_COMP_TYPE, PS_PA_CLOSE_CMMT, PS_PA_VARIANT, OPT_POP_START, OPT_POP_END, PS_DLV_PRIO, PS_EXTERNAL_ITEM, PS_SUBCON_ITEM, PS_US01, PS_US02, PS_US03, PS_US04, PS_US05, PS_US06, PS_US07, PS_US08, PS_US09, PS_US10, PS_US01_DATE, PS_US02_DATE, PS_US03_DATE, PS_US04_DATE, PS_US05_DATE, PS_US06_DATE, PS_US07_DATE, PS_US08_DATE, PS_US09_DATE, PS_US10_DATE, PS_US01_TXT, PS_US02_TXT, PS_US03_TXT, PS_US04_TXT, PS_US05_TXT, PS_US06_TXT, PS_US07_TXT, PS_US08_TXT, PS_US09_TXT, PS_US10_TXT, PS_WH_PRCNT, PS_WH_IND_PA, LAM_QUO_ID, LAM_QUO_ITMNO, LAM_CTR_ID, LAM_CTR_ITMNO, LAM_GAID, LAM_ASS_PO_ID, LAM_EXT_REF1, LAM_EXT_REF2, LAM_TEXT, ICC_BR_TAXCODE, ICC_BR_TAXAMT, ICC_BR_TAXDES, DUMMY_EEW_PDISC_SC, ITEM_PROCESS_TYP, EXLIN, REV_LEV, SOURCE_REL_IND, EXT_DEM_EXLIN, AUC_FD_IND, PO_FD_IND, CTR_FD_IND, RFX_FD_IND, FOL_RS_DESC, HIDE_DATE, HEADER, CREATED_BY, CREATED_AT, CHANGED_BY, CHANGED_AT, DUMMY_EEW_PD_IT_SWD_SC, PS_SC_ORD_QUAN, PS_SC_ORD_UNIT, PS_SC_OPEN_QUAN, PS_SC_OPEN_UNIT, DUMMY_EEW_PD_IT_CSD_SC, VALUE, FINAL_ENTRY, PRICE_ORIGIN, QUAN_CF_E, QUAN_IV_E, QUAN_PO_E, PARENT_ID, ITEM_TYPE, VAL_PO_E, VAL_IV_E, OBJECT_TYPE, LOGICAL_SYSTEM, DELIV_DAYS, SRC_HEADER_GUID, EXTERNAL_RANK, DUMMY_EEW_PD_TRANSFER_ITM, DRAFT_H_GUID, PUR_DRAFT_NO, VENDOR_NO, VENDOR_GUID, VENDOR_NAME, PROP_VENDOR_NO, PROP_VENDOR_GUID, PROP_VENDOR_NAME, REQ_NAME_LAST, REQ_NAME_FIRST, REQ_NAME_TEXT, REQ_TITLE_ACA1, REQ_TITLE_ACA2, REQ_DEPARTMENT, REQ_TELNR_LONG, OBJECT_ID, UNIT_TEXT, DUMMY_DRAFT_ITM_INCL FROM SRMSOCO_DRFT_ITM

TOP ERP 6.0 | SRMSOCO_DRFT_ITM COLUMNS

Column	Field	Description	SQL Type	Length	Decimals	SAP Type	Default Value	Null Allowed	CheckTable	Rollname	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	CLNT	(N'000')	No	*	MANDT	Allow NULL?
2	DRAFT_I_GUID	Globally Unique identifier	varbinary	16	0	RAW		No		BBP_GUID
3	GUID	Globally Unique identifier	varbinary	16	0	RAW		Yes		BBP_GUID
4	PARENT	Parent GUID	varbinary	16	0	RAW		Yes		BBP_PGUID
5	ITM_TYPE	Item Category	nvarchar	4	0	CHAR	(N' ')	Yes	*	CRMT_ITEM_TYPE_DB	Allow NULL?
6	NUMBER_INT	Item Number	nvarchar	10	0	NUMC	(N'0000000000')	Yes		BBP_ITEM_NO	Allow NULL?
7	NUMBER_EXT	External Item Number	nvarchar	10	0	NUMC	(N'0000000000')	Yes		BBP_ITEM_NO_EXT	Allow NULL?
8	PRODUCT	Product GUID	varbinary	16	0	RAW		Yes		BBP_PRODUCT
9	DESCRIPTION	Item Description	nvarchar	40	0	CHAR	(N' ')	Yes		BBP_ITEM_DESC	Allow NULL?
10	CATEGORY	Category GUID	varbinary	16	0	RAW		Yes		COMT_CATEGORY_GUID
11	CATEGORY_ID	Category ID	nvarchar	20	0	CHAR	(N' ')	Yes		COMT_CATEGORY_ID	Allow NULL?
12	SCHEMA_TYPE	Standard Schema Type	nvarchar	10	0	CHAR	(N' ')	Yes	*	SCHEMA_TYPE	Allow NULL?
13	CT_CATEGORY_ID	Category Name	nvarchar	60	0	CHAR	(N' ')	Yes		BBP_CT_CATEGORY_ID	Allow NULL?
14	ITM_EX_CT_UN_ID	Unique Key in External Category	nvarchar	40	0	CHAR	(N' ')	Yes		BBP_ITM_EX_CT_UN_ID	Allow NULL?
15	MANU_PROD	Manufacturer Part Number	nvarchar	40	0	CHAR	(N' ')	Yes		MFRPN	Allow NULL?
16	MFR_NO_EXT	External manufacturer code name or number	nvarchar	10	0	CHAR	(N' ')	Yes		EMNFR	Allow NULL?
17	CATALOGID	Catalog ID from which the line was selected	nvarchar	20	0	CHAR	(N' ')	Yes		CATALOG	Allow NULL?
18	CATALOGITEM	Catalog Item (Unique Key)	nvarchar	40	0	CHAR	(N' ')	Yes		CATALOGITEM	Allow NULL?
19	EXT_QUOTE_ID	Number of an External RFx Response	nvarchar	35	0	CHAR	(N' ')	Yes		BBP_EXT_QUOTE_ID	Allow NULL?
20	EXT_QUOTE_ITEM	Item of an External RFx Response	nvarchar	10	0	NUMC	(N'0000000000')	Yes		BBP_EXT_QUOTE_ITEM	Allow NULL?
21	QUANTITY	Quantity in Order Unit	decimal	13	3	QUAN	((0))	Yes		BBP_MNG
22	UNIT	Unit of Measurement	nvarchar	3	0	UNIT	(N' ')	Yes	*	BBP_UNIT	Allow NULL?
23	DEL_IND	Deletion Indicator SRM Purchasing Document	char	1	0	CHAR	(N' ')	Yes		BBP_DEL_IND	Allow NULL?
24	ORDERED_PROD	Product Name Entered	nvarchar	54	0	CHAR	(N' ')	Yes		CRMT_ORDERED_PROD_DB	Allow NULL?
25	PRODUCT_SRC_SYS	Business Document Service: ID of Logical System	nvarchar	10	0	CHAR	(N' ')	Yes		BBP_LOGSYS	Allow NULL?
26	PRICE	Net Price	decimal	13	2	CURR	((0))	Yes		BBP_PRICE
27	PRICE_UNIT	Price Unit	decimal	5	0	DEC	((0))	Yes		EPEIN
28	SUBTYPE	Specification Purchase Item (e.g. Direct Material/Hierarch.)	nvarchar	2	0	CHAR	(N' ')	Yes		BBP_I_SUBTYPE	Allow NULL?
29	GROSS_PRICE	Gross Price	decimal	13	2	CURR	((0))	Yes		BBP_GROSS_PRICE
30	CATALOG_PRICE	Catalog Price	decimal	13	2	CURR	((0))	Yes		BBP_CATALOG_PRICE
31	CURRENCY	Currency Key	nvarchar	5	0	CUKY	(N' ')	Yes	*	WAERS	Allow NULL?
32	DEL_DATCAT	Date type (day, week, month, interval)	char	1	0	CHAR	(N' ')	Yes		LPEIN_INT	Allow NULL?
33	DELIV_DATE	Item Delivery Date	nvarchar	8	0	DATS	(N'00000000')	Yes		EINDT	Allow NULL?
34	DELIV_TIME	Delivery Time of the Item	nvarchar	6	0	TIMS	(N'000000')	Yes		BBP_DELIV_TIME	Allow NULL?
35	LEADTIME	Delivery Time in Days	nvarchar	5	0	CHAR	(N' ')	Yes		BBP_LEADTIME	Allow NULL?
36	VPER_START	Timeframe From	nvarchar	8	0	DATS	(N'00000000')	Yes		BBP_VPER_START	Allow NULL?
37	VPER_END	Timeframe To	nvarchar	8	0	DATS	(N'00000000')	Yes		BBP_VPER_END	Allow NULL?
38	VPER_TYPE	Delivery Date Type (From-Date, To-Date, Timeframe ...)	nvarchar	2	0	CHAR	(N' ')	Yes		BBP_VPER_TYPE	Allow NULL?
39	END_TIME	Time Stamp f. Submissn Deadline	decimal	15	0	DEC	((0))	Yes		BBP_END_TIMESTP
40	PARTNER_PROD	Product Number of Vendor	nvarchar	40	0	CHAR	(N' ')	Yes		BBP_PARTNER_PROD	Allow NULL?
41	PRODUCT_TYPE	Product Type	nvarchar	2	0	CHAR	(N' ')	Yes	*	COMT_PRODUCT_TYPE	Allow NULL?
42	SRC_GUID	Reference Item GUID	varbinary	16	0	RAW		Yes		BBP_SRC_I_GUID
43	SRC_OBJECT_TYPE	Object Type of Reference Item	nvarchar	10	0	CHAR	(N' ')	Yes	*	BBP_SRC_I_OBJ_TYP	Allow NULL?
44	CTR_LOG_SYS	Logical System from Which the Contract Originates	nvarchar	10	0	CHAR	(N' ')	Yes	*	BBP_CTR_LOG_SYSTEM	Allow NULL?
45	CTR_GUID	Contract Template Item GUID	varbinary	16	0	RAW		Yes		BBP_CTR_I_GUID
46	CTR_ITEM_NUMBER	Number of Contract Item	nvarchar	10	0	NUMC	(N'0000000000')	Yes		BBP_CTR_ITEM	Allow NULL?
47	CTR_HDR_NUMBER	Contract Number	nvarchar	10	0	CHAR	(N' ')	Yes		BBP_CTR_ID	Allow NULL?
48	CTR_HDR_GUID	GUID Contract	varbinary	16	0	RAW		Yes		BBP_CTR_H_GUID
49	GR_IND	Goods Receipt Indicator	char	1	0	CHAR	(N' ')	Yes		WEPOS	Allow NULL?
50	IR_IND	Invoice Receipt Indicator	char	1	0	CHAR	(N' ')	Yes		REPOS	Allow NULL?
51	ASN_IND	Shipping Notification Exptd (ASN_EXPECTED in Vendor Master)	char	1	0	CHAR	(N' ')	Yes		BBP_ASN_IND	Allow NULL?
52	OR_IND	PO Response Expected (ORDER_RESP_EXP in Vendor Master)	char	1	0	CHAR	(N' ')	Yes		BBP_OR_IND	Allow NULL?
53	GR_NON_VAL	Goods Receipt, Non-Valuated	char	1	0	CHAR	(N' ')	Yes		BBP_WEUNB	Allow NULL?
54	RFQ_IND	Follow-On Document is an RFx	char	1	0	CHAR	(N' ')	Yes		BBP_RFQ_IND	Allow NULL?
55	PCINS	Procurement card company	nvarchar	4	0	CHAR	(N' ')	Yes	*	BBPPCINS	Allow NULL?
56	PCNUM	Procurement card number	nvarchar	25	0	CHAR	(N' ')	Yes	*	BBPPCNUM	Allow NULL?
57	PCNAME	Name of procurement cardholder	nvarchar	40	0	CHAR	(N' ')	Yes		BBPPCNAME	Allow NULL?
58	PCDAT_TO	Procurement Card Validity Date	nvarchar	8	0	DATS	(N'00000000')	Yes		BBPPCDAT_TO	Allow NULL?
59	LOGSYS_FI	Logical System of FI System	nvarchar	10	0	CHAR	(N' ')	Yes	*	BBP_LOGSYS_FI	Allow NULL?
60	DEDUCT_IND	Discount/Rejection Indicator at Item Level	char	1	0	CHAR	(N' ')	Yes		BBP_DEDUCT_IND	Allow NULL?
61	REJECT_WI	Work item ID	nvarchar	12	0	NUMC	(N'000000000000')	Yes	*	SWW_WIID	Allow NULL?
62	EXT_DEMID	External Requirement Number	nvarchar	32	0	CHAR	(N' ')	Yes		BBP_EXT_DEMID	Allow NULL?
63	EXT_DEM_POSID	External Requirement Tracking Number	nvarchar	32	0	CHAR	(N' ')	Yes		BBP_EXT_DEM_POSID	Allow NULL?
64	EXT_DEM_SUBPOSID	External Requirement Subitem Number	nvarchar	32	0	CHAR	(N' ')	Yes		BBP_EXT_DEM_SUBPOSID	Allow NULL?
65	EXT_DEM_KEY	Technical Key of External Requirement	varbinary	16	0	RAW		Yes		BBP_EXT_DEMKEY
66	EXT_DEM_POSKEY	Technical Key of External Purchase Requisition	varbinary	16	0	RAW		Yes		BBP_EXT_DEM_POSKEY
67	EXT_DEM_LOGSYS	Logical System from where an External Requirement Comes	nvarchar	10	0	CHAR	(N' ')	Yes	*	BBP_EXT_DEM_LOGSYS	Allow NULL?
68	EXT_DEM_CH_AT	Timestamp When an External Requirement was Recently Changed	decimal	15	0	DEC	((0))	Yes		BBP_EXT_DEM_CHANGED_AT
69	PROJECT_ID	Project Key	nvarchar	32	0	CHAR	(N' ')	Yes		BBP_PROJECT_ID	Allow NULL?
70	PROJECT_TASK_ID	Key of Project Task	nvarchar	32	0	CHAR	(N' ')	Yes		BBP_PROJECT_TASK_ID	Allow NULL?
71	PROJECT_ROLE_ID	Key of Project Role	nvarchar	32	0	CHAR	(N' ')	Yes		BBP_PROJECT_ROLE_ID	Allow NULL?
72	ORIGIN_ORDER_ID	Origninal Customer's PO No. for Third Party Transaction	nvarchar	35	0	CHAR	(N' ')	Yes		BBP_ORIGIN_ORDER_ID	Allow NULL?
73	ORIGIN_ITEM_ID	Orignl Customer Purchase Order Item No. - Third Party Trans.	nvarchar	10	0	NUMC	(N'0000000000')	Yes		BBP_ORIGIN_ORDER_ITEM_ID	Allow NULL?
74	NUM_SOS	Number of Sources of Supply Found (for Performance)	char	1	0	CHAR	(N' ')	Yes		BBP_NUM_SOS	Allow NULL?
75	DOC_PRIORITY	Document Priority	nvarchar	4	0	CHAR	(N' ')	Yes		BBP_DOC_PRIORITY	Allow NULL?
76	GROUPING_LEVEL	Specifies How Hierarchy Positions are to be Managed	char	1	0	CHAR	(N' ')	Yes		BBP_GROUPING_LEVEL	Allow NULL?
77	INCOTERM_KEY	Incoterm Key	nvarchar	3	0	CHAR	(N' ')	Yes	*	BBP_INCOTERM_KEY	Allow NULL?
78	INCOTERM_LOC	Incoterm Location	nvarchar	28	0	CHAR	(N' ')	Yes		BBP_INCOTERM_LOCATION	Allow NULL?
79	UOM_DENOMINATOR	Denominator for Conversion to Base Unit of Measure	int	10	0	INT4	((0))	Yes		BBP_UOM_DENOMINATOR	Allow NULL?
80	UOM_NUMERATOR	Counter for Conversion to Base Unit of Measure	int	10	0	INT4	((0))	Yes		BBP_UOM_NUMERATOR	Allow NULL?
81	LUMP_SUM_IND	Indicator for a Blanket Line	char	1	0	CHAR	(N' ')	Yes		BBP_LUMP_SUM_IND	Allow NULL?
82	BE_LOG_SYSTEM	Logical System of Logistics Backend	nvarchar	10	0	CHAR	(N' ')	Yes	*	BE_LOG_SYSTEM	Allow NULL?
83	BE_OBJ_ITEM	Follow-On Object Item in Back-End System	nvarchar	10	0	CHAR	(N' ')	Yes		BE_OBJ_ITEM	Allow NULL?
84	BE_OBJECT_TYPE	Follow-On Document Object Type in Back-End System	nvarchar	10	0	CHAR	(N' ')	Yes	*	BE_OBJECT_TYPE	Allow NULL?
85	BE_OBJECT_ID	Follow-On Document Object ID in Back-End System	nvarchar	20	0	CHAR	(N' ')	Yes		BE_OBJECT_ID	Allow NULL?
86	BE_REFOBJ_TYPE	Reference Object Type in Back-End System	nvarchar	10	0	CHAR	(N' ')	Yes	*	BE_REFOBJ_TYPE	Allow NULL?
87	BE_REFOBJ	Reference Object in Back-End System	nvarchar	20	0	CHAR	(N' ')	Yes		BE_REFOBJ	Allow NULL?
88	BE_REFOBJ_ITEM	Reference Object Item in Back-End System	nvarchar	10	0	CHAR	(N' ')	Yes		BE_REFOBJ_ITEM	Allow NULL?
89	BE_REFOBJ_SBITM	Reference Object Sub-Position in Backend System	nvarchar	20	0	CHAR	(N' ')	Yes		BE_REFOBJ_SBITM	Allow NULL?
90	BE_REFOBJ_TYPE2	Reference Object Type in Back-End System	nvarchar	10	0	CHAR	(N' ')	Yes	*	BE_REFOBJ_TYPE	Allow NULL?
91	BE_REFOBJ2	Reference Object in Back-End System	nvarchar	20	0	CHAR	(N' ')	Yes		BE_REFOBJ	Allow NULL?
92	BE_REFOBJ_ITEM2	Reference Object Item in Back-End System	nvarchar	10	0	CHAR	(N' ')	Yes		BE_REFOBJ_ITEM	Allow NULL?
93	BE_REFOBJ_FYEAR2	Reference Document Object - Fiscal Year in Back-End System	nvarchar	4	0	NUMC	(N'0000')	Yes		BE_FI_YEAR	Allow NULL?
94	BE_STGE_LOC	Storage Location	nvarchar	4	0	CHAR	(N' ')	Yes	*	LGORT_D	Allow NULL?
95	BE_PLANT	Plant	nvarchar	4	0	CHAR	(N' ')	Yes	*	BE_EWERK	Allow NULL?
96	BE_BATCH	Batch Number	nvarchar	10	0	CHAR	(N' ')	Yes	*	CHARG_D	Allow NULL?
97	BE_VAL_TYPE	Valuation Type	nvarchar	10	0	CHAR	(N' ')	Yes	*	BWTAR_D	Allow NULL?
98	BE_MOVE_REAS	Reason for Movement	nvarchar	4	0	NUMC	(N'0000')	Yes		BE_GRBEW	Allow NULL?
99	BE_EXPERYDATE	Shelf Life Expiration Date	nvarchar	8	0	DATS	(N'00000000')	Yes		BBP_VFDAT	Allow NULL?
100	BE_PUR_GROUP	Purchasing Group	nvarchar	3	0	CHAR	(N' ')	Yes	*	EKGRP	Allow NULL?
101	BE_PUR_ORG	Purchasing Organization	nvarchar	4	0	CHAR	(N' ')	Yes	*	EKORG	Allow NULL?
102	BE_CO_CODE	Company Code	nvarchar	4	0	CHAR	(N' ')	Yes	*	BUKRS	Allow NULL?
103	BE_DOC_TYPE	Purchase Requisition Document Type	nvarchar	4	0	CHAR	(N' ')	Yes	*	BBSRT	Allow NULL?
104	BE_ACCREQUIRED	Account Assignment for Logical Backend Required	char	1	0	CHAR	(N' ')	Yes		BE_ACCREQUIRED	Allow NULL?
105	BE_SP_STK_IND	Key for Special Stock Section	nvarchar	16	0	CHAR	(N' ')	Yes		BBPCIF_CIFSSKEY	Allow NULL?
106	BE_INFO_REC	Number of Purchasing Info Record	nvarchar	10	0	CHAR	(N' ')	Yes	*	INFNR	Allow NULL?
107	BE_MOVE_TYPE	Movement Type (Inventory Management)	nvarchar	3	0	CHAR	(N' ')	Yes	*	BWART	Allow NULL?
108	BE_PACKNO	Package number	nvarchar	10	0	NUMC	(N'0000000000')	Yes	*	PACKNO	Allow NULL?
109	BE_INTROW	Internal line number for limits	nvarchar	10	0	NUMC	(N'0000000000')	Yes		BBP_INTROW	Allow NULL?
110	BE_ITEM_TEXT	Short Text of a Service Purchase Order Item	nvarchar	40	0	CHAR	(N' ')	Yes		BBP_BE_ITEM_TEXT	Allow NULL?
111	BE_PO_PRICE	Price from Backend	char	1	0	CHAR	(N' ')	Yes		BBP_BE_PO_PRICE	Allow NULL?
112	BE_UNLOAD_PT	Unloading Point in Backend	nvarchar	25	0	CHAR	(N' ')	Yes		BBP_UNLOAD_PT	Allow NULL?
113	BE_DEL_IND	Deletion Indicator in Backend Documents	char	1	0	CHAR	(N' ')	Yes		BBP_BE_DEL_IND	Allow NULL?
114	BE_TRACKING_NO	Requirement Tracking Number	nvarchar	10	0	CHAR	(N' ')	Yes		BEDNR	Allow NULL?
115	BE_COND_TYPE	Condition Key	nvarchar	4	0	CHAR	(N' ')	Yes	*	BBP_BE_COND_TYPE	Allow NULL?
116	BE_COND_STEP	Level Number	nvarchar	3	0	NUMC	(N'000')	Yes		BBP_STUNR	Allow NULL?
117	BE_COND_COUNTER	Condition counter	nvarchar	2	0	NUMC	(N'00')	Yes		BBP_DZAEHK	Allow NULL?
118	COPY_OF_GUID	GUID Object is a Copy of	varbinary	16	0	RAW		Yes		BBP_COPY_OF_GUID
119	ICC_BR_STEUC	Brazilian NCM Code	nvarchar	16	0	CHAR	(N' ')	Yes	CRMC_TAX_TCODE	ITL_NCM	Allow NULL?
120	ICC_BR_MATUSE	Material Usage	char	1	0	CHAR	(N' ')	Yes		ITL_MAT_USAGE	Allow NULL?
121	ICC_BR_MATORG	Origin of the material	char	1	0	CHAR	(N' ')	Yes		ITL_NF_MATORG	Allow NULL?
122	ICC_BR_OWNPRO	Produced in-house	char	1	0	CHAR	(N' ')	Yes		ITL_OWNPRO	Allow NULL?
123	ICC_BR_INDUST	Material CFOP category	nvarchar	2	0	CHAR	(N' ')	Yes		ITL_NF_INDUS3	Allow NULL?
124	ICC_IN_TXJCD	Tax Tariff Code	nvarchar	16	0	CHAR	(N' ')	Yes		CRMT_TAX_TARIFF_CODE	Allow NULL?
125	DUMMY_EEW_PDISS_SC	Dummy function in length 1	char	1	0	CHAR	(N' ')	Yes		DUMMY	Allow NULL?
126	PS_HL_ITEM	Higher-Level Item GUID	varbinary	16	0	RAW		Yes		/SAPPSSRM/_HL_ITEM
127	PS_HANDLE_ITM	Globally Unique identifier	varbinary	16	0	RAW		Yes		BBP_GUID
128	PS_EXSNR	External Sort Number	nvarchar	5	0	NUMC	(N'00000')	Yes		/SAPPSSRM/_EXSNR	Allow NULL?
129	PS_CTRL_KEY	Item Process Type Control Key	nvarchar	4	0	CHAR	(N' ')	Yes	*	/SAPPSSRM/_PS_CTRL_KEY	Allow NULL?
130	PS_IPT	Public Sector Item Type	nvarchar	10	0	CHAR	(N' ')	Yes	*	/SAPPSSRM/_IPT	Allow NULL?
131	PS_VALUE_RU	Net Value	decimal	15	2	CURR	((0))	Yes		BBP_VALUE
132	PS_EXLIN_IND	EXLIN Indicator	char	1	0	CHAR	(N' ')	Yes		/SAPPSSRM/_EXLIN_IND	Allow NULL?
133	PS_EXT_IND_STATE	Checkbox Status on the UI	char	1	0	CHAR	(N' ')	Yes		/SAPPSSRM/_EXT_IND_UI_STATE	Allow NULL?
134	EXPSV_ITEM_TYPE	Item Variant	nvarchar	5	0	CHAR	(N' ')	Yes		BBP_EXPRESSIVE_ITEM_TYPE	Allow NULL?
135	ORIG_GUID	Original Item GUID	varbinary	16	0	RAW		Yes		BBP_ORIG_GUID
136	APCGK	Annexing Package Key	nvarchar	4	0	NUMC	(N'0000')	Yes		/LOCSRM/TAPCGK_IL	Allow NULL?
137	APCGK_EXTEND	Extended key for annexing package	nvarchar	10	0	NUMC	(N'0000000000')	Yes		/LOCSRM/TAPCGK_EXT_IL	Allow NULL?
138	BAS_DATE	Base Date	nvarchar	8	0	DATS	(N'00000000')	Yes		/LOCSRM/TBASDATE_IL	Allow NULL?
139	ADATTYP	Annexing Date Type	char	1	0	CHAR	(N' ')	Yes		/LOCSRM/TADATTYP_IL	Allow NULL?
140	START_DAT	Annexing Start Date	nvarchar	8	0	DATS	(N'00000000')	Yes		/LOCSRM/TASDAT_IL	Allow NULL?
141	DEV	Deviation Percentage	decimal	6	3	DEC	((0))	Yes		/LOCSRM/TMPERC_IL
142	INDANX	Order Type Annexed	char	1	0	CHAR	(N' ')	Yes		/LOCSRM/TMANIND_IL	Allow NULL?
143	LIMIT_DAT	Annexing Limit Date	nvarchar	8	0	DATS	(N'00000000')	Yes		/LOCSRM/TALDAT_IL	Allow NULL?
144	NUMERATOR	Char 20	nvarchar	20	0	CHAR	(N' ')	Yes		CHAR20	Allow NULL?
145	PS_IDC_TYPE	Order Type Line Item	nvarchar	10	0	CHAR	(N' ')	Yes	*	/SAPPSSRM/IDC_TYPE	Allow NULL?
146	PS_INFU_IND	Incremental Funding Active	char	1	0	CHAR	(N' ')	Yes		/SAPPSSRM/_INFU_ACTIVE	Allow NULL?
147	PS_SC_AC03	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')	char	1	0	CHAR	(N' ')	Yes		BOOLE_D	Allow NULL?
148	PS_SC_MK03	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')	char	1	0	CHAR	(N' ')	Yes		BOOLE_D	Allow NULL?
149	PS_PO_HDR_GUID	Purchaser Order Header GUID	varbinary	16	0	RAW		Yes		/SAPPSSRM/_PO_HDR_GUID
150	PS_PO_HDR_NUM	Purchase Order Number	nvarchar	10	0	CHAR	(N' ')	Yes		/SAPPSSRM/_PO_HDR_NUM	Allow NULL?
151	PS_PO_ITM_GUID	Purchaser Order Item GUID	varbinary	16	0	RAW		Yes		/SAPPSSRM/_PO_ITM_GUID
152	PS_PO_ITM_NUM	Purchaser Order Item Number	nvarchar	10	0	NUMC	(N'0000000000')	Yes		/SAPPSSRM/_PO_ITM_NUM	Allow NULL?
153	PS_PO_LOG_SYS	Logical System (of the Purchase Order)	nvarchar	10	0	CHAR	(N' ')	Yes	*	/SAPPSSRM/_PO_LOG_SYS	Allow NULL?
154	PS_PO_DELIV_DATE	Purchase Order Item Delivery Date	nvarchar	8	0	DATS	(N'00000000')	Yes		/SAPPSSRM/_PO_DELIV_DATE	Allow NULL?
155	PS_PO_DELIV_TIME	Delivery Time of a Purchase Order Item	nvarchar	6	0	TIMS	(N'000000')	Yes		/SAPPSSRM/_PO_DELIV_TIME	Allow NULL?
156	PS_PO_OPEN_QUAN	Open Quantity of a Purchase Order	decimal	15	3	QUAN	((0))	Yes		/SAPPSSRM/_PO_OPEN_QUAN
157	PS_PO_QUAN_UNIT	Purchase Order Unit	nvarchar	3	0	UNIT	(N' ')	Yes	*	/SAPPSSRM/_PO_QUAN_UNIT	Allow NULL?
158	OPT_IND	Option Type	char	1	0	CHAR	(N' ')	Yes		BBP_OPT_IND	Allow NULL?
159	OPT_STATUS	Option Status	char	1	0	CHAR	(N' ')	Yes		BBP_OPT_STATUS	Allow NULL?
160	OPT_XPER_START	Exercise Period Start Date	nvarchar	8	0	DATS	(N'00000000')	Yes		BBP_OPT_XPER_START	Allow NULL?
161	OPT_XPER_END	Exercise Period End Date	nvarchar	8	0	DATS	(N'00000000')	Yes		BBP_OPT_XPER_END	Allow NULL?
162	OPT_REF_GUID	Option Reference GUID	varbinary	16	0	RAW		Yes		BBP_OPT_REF_GUID
163	PS_OPT_RF_NUM_INT	Item Number	nvarchar	10	0	NUMC	(N'0000000000')	Yes		BBP_ITEM_NO	Allow NULL?
164	PS_OPT_RF_DESC	Item Description	nvarchar	40	0	CHAR	(N' ')	Yes		BBP_ITEM_DESC	Allow NULL?
165	PS_OPT_RF_ORD_PROD	Product Name Entered	nvarchar	54	0	CHAR	(N' ')	Yes		CRMT_ORDERED_PROD_DB	Allow NULL?
166	PS_OPT_RF_EXLIN	Configurable Line Item Number	nvarchar	40	0	CHAR	(N' ')	Yes		/SAPSRM/EXLIN	Allow NULL?
167	PS_OPT_IND_DISP	Option Type	char	1	0	CHAR	(N' ')	Yes		BBP_OPT_IND	Allow NULL?
168	PS_O_BO_OBJ_ID	Transaction Number	nvarchar	10	0	CHAR	(N' ')	Yes		CRMT_OBJECT_ID_DB	Allow NULL?
169	PS_O_BO_OBJ_TY	Object Type	nvarchar	10	0	CHAR	(N' ')	Yes	*	SWO_OBJTYP	Allow NULL?
170	PS_O_BO_DESC	Name of SRM Document	nvarchar	40	0	CHAR	(N' ')	Yes		BBP_DOCNAME	Allow NULL?
171	PS_O_BO_GUID	Globally Unique identifier	varbinary	16	0	RAW		Yes		BBP_GUID
172	PS_O_BO_ITM_NO	Item Number in Document	nvarchar	10	0	NUMC	(N'0000000000')	Yes		CRMT_ITEM_NO	Allow NULL?
173	PS_O_BO_DRAFT	R/2 table	nvarchar	5	0	CHAR	(N' ')	Yes		CHAR5	Allow NULL?
174	PS_O_BO_DOC_TY	Character field, length 32	nvarchar	32	0	CHAR	(N' ')	Yes		CHAR32	Allow NULL?
175	PS_PA_ID	Pricing Arrangement Identifier	nvarchar	4	0	CHAR	(N' ')	Yes		/SAPPSSRM/_PA_STRUC_ID	Allow NULL?
176	PS_PA_MIN_FEE	Minimum Fee	decimal	13	2	CURR	((0))	Yes		/SAPPSSRM/_PA_MINIMUM_FEE
177	PS_PA_MAX_FEE	Maximum Fee	decimal	13	2	CURR	((0))	Yes		/SAPPSSRM/_PA_MAXIMUM_FEE
178	PS_PA_GS_BLW	Government Share Below	decimal	5	2	DEC	((0))	Yes		/SAPPSSRM/_PA_GOV_SHARE_BELOW
179	PS_PA_GS_ABV	Government Share Above	decimal	5	2	DEC	((0))	Yes		/SAPPSSRM/_PA_GOV_SHARE_ABOVE
180	PS_PA_CLNG_AMT	Ceiling Amount	decimal	15	2	CURR	((0))	Yes		/SAPPSSRM/_PA_CEILING_AMOUNT
181	PS_PA_TOTL_AMT	Total Amount of Master Item	decimal	15	2	CURR	((0))	Yes		/SAPPSSRM/_PA_TOTAL_AMOUNT
182	PS_PA_NTE_IND	Not to Exceed	char	1	0	CHAR	(N' ')	Yes		/SAPPSSRM/_NTE_IND	Allow NULL?
183	PS_PA_NSP_IND	Not Separately Priced	char	1	0	CHAR	(N' ')	Yes		/SAPPSSRM/_NSP_IND	Allow NULL?
184	PS_PA_COMP_KEY	Component Key	nvarchar	4	0	CHAR	(N' ')	Yes		/SAPPSSRM/_PA_COMP_KEY	Allow NULL?
185	PS_PA_COMP_TYPE	Pricing Component Type	char	1	0	CHAR	(N' ')	Yes	*	/SAPPSSRM/_PA_COMP_TYPE	Allow NULL?
186	PS_PA_CLOSE_CMMT	Close FM Commitment	char	1	0	CHAR	(N' ')	Yes		/SAPPSSRM/_PA_CLOSE_COMMITMENT	Allow NULL?
187	PS_PA_VARIANT	Variant Type for Web Dynpro	nvarchar	40	0	CHAR	(N' ')	Yes		/SAPPSSRM/_PA_VARIANT	Allow NULL?
188	OPT_POP_START	Option Period of Performance Start Date	nvarchar	8	0	DATS	(N'00000000')	Yes		BBP_OPT_POP_START	Allow NULL?
189	OPT_POP_END	Option Period of Performance End Date	nvarchar	8	0	DATS	(N'00000000')	Yes		BBP_OPT_POP_END	Allow NULL?
190	PS_DLV_PRIO	Delivery Priority	nvarchar	2	0	NUMC	(N'00')	Yes	*	/SAPPSSRM/_DLV_PRIO	Allow NULL?
191	PS_EXTERNAL_ITEM	External Origin of Smart Number	char	1	0	CHAR	(N' ')	Yes		/SAPPSSRM/_EXTERNAL_ITEM_FLAG	Allow NULL?
192	PS_SUBCON_ITEM	X-field item is subcontracting item	char	1	0	CHAR	(N' ')	Yes		/SAPPSSRM/_SUBCON_ITEM	Allow NULL?
193	PS_US01	User-Specified Status 01	nvarchar	5	0	CHAR	(N' ')	Yes	*	/SAPPSSRM/_US_01	Allow NULL?
194	PS_US02	User-Specified Status 02	nvarchar	5	0	CHAR	(N' ')	Yes	*	/SAPPSSRM/_US_02	Allow NULL?
195	PS_US03	User-Specified Status 03	nvarchar	5	0	CHAR	(N' ')	Yes	*	/SAPPSSRM/_US_03	Allow NULL?
196	PS_US04	User-Specified Status 04	nvarchar	5	0	CHAR	(N' ')	Yes	*	/SAPPSSRM/_US_04	Allow NULL?
197	PS_US05	User-Specified Status 05	nvarchar	5	0	CHAR	(N' ')	Yes	*	/SAPPSSRM/_US_05	Allow NULL?
198	PS_US06	User-Specified Status 06	nvarchar	5	0	CHAR	(N' ')	Yes	*	/SAPPSSRM/_US_06	Allow NULL?
199	PS_US07	User-Specified Status 07	nvarchar	5	0	CHAR	(N' ')	Yes	*	/SAPPSSRM/_US_07	Allow NULL?
200	PS_US08	User-Specified Status 08	nvarchar	5	0	CHAR	(N' ')	Yes	*	/SAPPSSRM/_US_08	Allow NULL?
201	PS_US09	User-Specified Status 09	nvarchar	5	0	CHAR	(N' ')	Yes	*	/SAPPSSRM/_US_09	Allow NULL?
202	PS_US10	User-Specified Status 10	nvarchar	5	0	CHAR	(N' ')	Yes	*	/SAPPSSRM/_US_10	Allow NULL?
203	PS_US01_DATE	Date of User-Specified Status 01	nvarchar	8	0	DATS	(N'00000000')	Yes		/SAPPSSRM/_US01_DATE	Allow NULL?
204	PS_US02_DATE	Date of User-Specified Status 02	nvarchar	8	0	DATS	(N'00000000')	Yes		/SAPPSSRM/_US02_DATE	Allow NULL?
205	PS_US03_DATE	Date of User-Specified Status 03	nvarchar	8	0	DATS	(N'00000000')	Yes		/SAPPSSRM/_US03_DATE	Allow NULL?
206	PS_US04_DATE	Date of User-Specified Status 04	nvarchar	8	0	DATS	(N'00000000')	Yes		/SAPPSSRM/_US04_DATE	Allow NULL?
207	PS_US05_DATE	Date of User-Specified Status 05	nvarchar	8	0	DATS	(N'00000000')	Yes		/SAPPSSRM/_US05_DATE	Allow NULL?
208	PS_US06_DATE	Date of User-Specified Status 06	nvarchar	8	0	DATS	(N'00000000')	Yes		/SAPPSSRM/_US06_DATE	Allow NULL?
209	PS_US07_DATE	Date of User-Specified Status 07	nvarchar	8	0	DATS	(N'00000000')	Yes		/SAPPSSRM/_US07_DATE	Allow NULL?
210	PS_US08_DATE	Date of User-Specified Status 08	nvarchar	8	0	DATS	(N'00000000')	Yes		/SAPPSSRM/_US08_DATE	Allow NULL?
211	PS_US09_DATE	Date of User-Specified Status 09	nvarchar	8	0	DATS	(N'00000000')	Yes		/SAPPSSRM/_US09_DATE	Allow NULL?
212	PS_US10_DATE	Date of User-Specified Status 10	nvarchar	8	0	DATS	(N'00000000')	Yes		/SAPPSSRM/_US10_DATE	Allow NULL?
213	PS_US01_TXT	User-Specified Status 01 Description	nvarchar	30	0	CHAR	(N' ')	Yes		/SAPPSSRM/_US_TXT_01	Allow NULL?
214	PS_US02_TXT	User-Specified Status 02 Description	nvarchar	30	0	CHAR	(N' ')	Yes		/SAPPSSRM/_US_TXT_02	Allow NULL?
215	PS_US03_TXT	User-Specified Status 03 Description	nvarchar	30	0	CHAR	(N' ')	Yes		/SAPPSSRM/_US_TXT_03	Allow NULL?
216	PS_US04_TXT	User-Specified Status 04 Description	nvarchar	30	0	CHAR	(N' ')	Yes		/SAPPSSRM/_US_TXT_04	Allow NULL?
217	PS_US05_TXT	User-Specified Status 05 Description	nvarchar	30	0	CHAR	(N' ')	Yes		/SAPPSSRM/_US_TXT_05	Allow NULL?
218	PS_US06_TXT	User-Specified Status 06 Description	nvarchar	30	0	CHAR	(N' ')	Yes		/SAPPSSRM/_US_TXT_06	Allow NULL?
219	PS_US07_TXT	User-Specified Status 07 Description	nvarchar	30	0	CHAR	(N' ')	Yes		/SAPPSSRM/_US_TXT_07	Allow NULL?
220	PS_US08_TXT	User-Specified Status 08 Description	nvarchar	30	0	CHAR	(N' ')	Yes		/SAPPSSRM/_US_TXT_08	Allow NULL?
221	PS_US09_TXT	User-Specified Status 09 Description	nvarchar	30	0	CHAR	(N' ')	Yes		/SAPPSSRM/_US_TXT_09	Allow NULL?
222	PS_US10_TXT	User-Specified Status 10 Description	nvarchar	30	0	CHAR	(N' ')	Yes		/SAPPSSRM/_US_TXT_10	Allow NULL?
223	PS_WH_PRCNT	Retention Value as Percentage	decimal	5	2	DEC	((0))	Yes		/SAPPSSRM/_WH_PERCENT
224	PS_WH_IND_PA	Retention Indicator for Pricing Arrangments	char	1	0	CHAR	(N' ')	Yes		/SAPPSSRM/_WH_IND_PA	Allow NULL?
225	LAM_QUO_ID	Leasing Quotation Number	nvarchar	10	0	CHAR	(N' ')	Yes		LAM_QUO_ID	Allow NULL?
226	LAM_QUO_ITMNO	Item Number in Document	nvarchar	10	0	NUMC	(N'0000000000')	Yes		CRMT_ITEM_NO	Allow NULL?
227	LAM_CTR_ID	Leasing Contract Number	nvarchar	10	0	CHAR	(N' ')	Yes		LAM_CTR_ID	Allow NULL?
228	LAM_CTR_ITMNO	Item Number in Document	nvarchar	10	0	NUMC	(N'0000000000')	Yes		CRMT_ITEM_NO	Allow NULL?
229	LAM_GAID	External Allocation Number	nvarchar	16	0	CHAR	(N' ')	Yes		LAM_ALLOCATION_ID	Allow NULL?
230	LAM_ASS_PO_ID	Leasing PO Assumption ID	nvarchar	35	0	CHAR	(N' ')	Yes		LAM_ASS_PO_ID	Allow NULL?
231	LAM_EXT_REF1	Leasing External Reference 1	nvarchar	35	0	CHAR	(N' ')	Yes		LAM_EXT_REF1	Allow NULL?
232	LAM_EXT_REF2	Leasing External Reference 2	nvarchar	35	0	CHAR	(N' ')	Yes		LAM_EXT_REF2	Allow NULL?
233	LAM_TEXT	Leasing Text	nvarchar	35	0	CHAR	(N' ')	Yes		LAM_TEXT	Allow NULL?
234	ICC_BR_TAXCODE	Tax Code for Brazil	nvarchar	2	0	CHAR	(N' ')	Yes		ITL_TCODE	Allow NULL?
235	ICC_BR_TAXAMT	Tax Amount	decimal	15	2	CURR	((0))	Yes		BBP_TAX_AMOUNT
236	ICC_BR_TAXDES	Enterprise Buyer: Tax Code Description	nvarchar	50	0	CHAR	(N' ')	Yes		BBPTAX_DES	Allow NULL?
237	DUMMY_EEW_PDISC_SC	Dummy function in length 1	char	1	0	CHAR	(N' ')	Yes		DUMMY	Allow NULL?
238	ITEM_PROCESS_TYP	Item Process Type	nvarchar	10	0	CHAR	(N' ')	Yes	*	/SAPSRM/PDO_ITEM_PROCESS_TYPE	Allow NULL?
239	EXLIN	Configurable Line Item Number	nvarchar	40	0	CHAR	(N' ')	Yes		/SAPSRM/EXLIN	Allow NULL?
240	REV_LEV	Revision Level	nvarchar	2	0	CHAR	(N' ')	Yes		CC_REVLV	Allow NULL?
241	SOURCE_REL_IND	Indicator - If the Document is Sourcing-Relevant	char	1	0	CHAR	(N' ')	Yes		BBP_SOURCE_REL_IND	Allow NULL?
242	EXT_DEM_EXLIN	Configurable Line Item Number	nvarchar	40	0	CHAR	(N' ')	Yes		/SAPSRM/EXLIN	Allow NULL?
243	AUC_FD_IND	Follow-on Document for Auction	char	1	0	CHAR	(N' ')	Yes		BBP_AUC_FD_IND	Allow NULL?
244	PO_FD_IND	Follow-on Document for PO	char	1	0	CHAR	(N' ')	Yes		BBP_PO_FD_IND	Allow NULL?
245	CTR_FD_IND	Follow-on Document Contract	char	1	0	CHAR	(N' ')	Yes		BBP_CTR_FD_IND	Allow NULL?
246	RFX_FD_IND	Follow-on Document for RFX	char	1	0	CHAR	(N' ')	Yes		BBP_RFX_FD_IND	Allow NULL?
247	FOL_RS_DESC	Follow on Document Description	nvarchar	80	0	CHAR	(N' ')	Yes		BBP_FOL_DESC	Allow NULL?
248	HIDE_DATE	Deferred until date for SoCo	nvarchar	8	0	DATS	(N'00000000')	Yes		/SAPSRM/HIDE_DATE	Allow NULL?
249	HEADER	Globally Unique identifier	varbinary	16	0	RAW		Yes		BBP_GUID
250	CREATED_BY	Name of Person who Created the Object	nvarchar	12	0	CHAR	(N' ')	Yes		ERNAM	Allow NULL?
251	CREATED_AT	Transaction was Created at this Time	decimal	15	0	DEC	((0))	Yes		CRMT_CREATED_AT
252	CHANGED_BY	Name of Person Responsible for Changing Object	nvarchar	12	0	CHAR	(N' ')	Yes		BBP_CHNAM	Allow NULL?
253	CHANGED_AT	Time of Last Change to the Transaction	decimal	15	0	DEC	((0))	Yes		CRMT_CHANGED_AT
254	DUMMY_EEW_PD_IT_SWD_SC	Dummy function in length 1	char	1	0	CHAR	(N' ')	Yes		DUMMY	Allow NULL?
255	PS_SC_ORD_QUAN	Description: Ordered Quantity	decimal	15	3	QUAN	((0))	Yes		/SAPPSSRM/ORD_QUAN
256	PS_SC_ORD_UNIT	Purchase Order Unit	nvarchar	3	0	UNIT	(N' ')	Yes	*	/SAPPSSRM/_PO_QUAN_UNIT	Allow NULL?
257	PS_SC_OPEN_QUAN	Open Quantity	decimal	15	3	QUAN	((0))	Yes		/SAPPSSRM/OPEN_QUAN
258	PS_SC_OPEN_UNIT	Purchase Order Unit	nvarchar	3	0	UNIT	(N' ')	Yes	*	/SAPPSSRM/_PO_QUAN_UNIT	Allow NULL?
259	DUMMY_EEW_PD_IT_CSD_SC	Dummy function in length 1	char	1	0	CHAR	(N' ')	Yes		DUMMY	Allow NULL?
260	VALUE	Net Value	decimal	15	2	CURR	((0))	Yes		BBP_VALUE
261	FINAL_ENTRY	Final Entry Indicator (Goods/Services)	char	1	0	CHAR	(N' ')	Yes		BBP_FINAL_ENTRY	Allow NULL?
262	PRICE_ORIGIN	Original Price (Determination/Manual Input)	char	1	0	CHAR	(N' ')	Yes		BBP_PRICE_ORIGIN	Allow NULL?
263	QUAN_CF_E	Quantity of Entered Confirmation	decimal	15	3	QUAN	((0))	Yes		BBP_CF_QUANT_E
264	QUAN_IV_E	Entered Invoiced Quantity	decimal	15	3	QUAN	((0))	Yes		BBP_IV_QUANT_E
265	QUAN_PO_E	Quantity of POs/Confirmations/Invoices Created for Contract	decimal	15	3	QUAN	((0))	Yes		BBP_PO_QUANT_E
266	PARENT_ID	Line Number of Shopping Cart from Catalog	nvarchar	5	0	NUMC	(N'00000')	Yes		WSI_OCI_LINE	Allow NULL?
267	ITEM_TYPE	Single-Character Indicator	char	1	0	CHAR	(N' ')	Yes		CHAR1	Allow NULL?
268	VAL_PO_E	Value of POs/Confirmations/Invoices Created for Contract	decimal	15	2	CURR	((0))	Yes		BBP_PO_VALUE_E
269	VAL_IV_E	Entered Invoice Value	decimal	15	2	CURR	((0))	Yes		BBP_IV_VALUE_E
270	OBJECT_TYPE	CRM Item Object Type	nvarchar	10	0	CHAR	(N' ')	Yes	*	CRMT_SWO_OBJTYP_PROCESS_ITM_DB	Allow NULL?
271	LOGICAL_SYSTEM	Logical System EBP	nvarchar	10	0	CHAR	(N' ')	Yes	*	BBP_LOG_SYS	Allow NULL?
272	DELIV_DAYS	Delivery Time in Days	nvarchar	3	0	NUMC	(N'000')	Yes		BBP_DELIV_DAYS	Allow NULL?
273	SRC_HEADER_GUID	Reference Document GUID	varbinary	16	0	RAW		Yes		BBP_SRC_H_GUID
274	EXTERNAL_RANK	Ranking of Bid in External Auction	int	10	0	INT4	((0))	Yes		BBP_EXTERNAL_RANK_QUOT	Allow NULL?
275	DUMMY_EEW_PD_TRANSFER_ITM	Dummy function in length 1	char	1	0	CHAR	(N' ')	Yes		DUMMY	Allow NULL?
276	DRAFT_H_GUID	Globally Unique identifier	varbinary	16	0	RAW		Yes		BBP_GUID
277	PUR_DRAFT_NO	CRM Item Object Type	nvarchar	10	0	CHAR	(N' ')	Yes	*	CRMT_SWO_OBJTYP_PROCESS_ITM_DB	Allow NULL?
278	VENDOR_NO	Business Partner Number	nvarchar	10	0	CHAR	(N' ')	Yes	*	BU_PARTNER	Allow NULL?
279	VENDOR_GUID	Partner Number	nvarchar	32	0	CHAR	(N' ')	Yes		CRMT_PARTNER_NO	Allow NULL?
280	VENDOR_NAME	Name 1	nvarchar	40	0	CHAR	(N' ')	Yes		AD_NAME1	Allow NULL?
281	PROP_VENDOR_NO	Business Partner Number	nvarchar	10	0	CHAR	(N' ')	Yes	*	BU_PARTNER	Allow NULL?
282	PROP_VENDOR_GUID	Partner Number	nvarchar	32	0	CHAR	(N' ')	Yes		CRMT_PARTNER_NO	Allow NULL?
283	PROP_VENDOR_NAME	Name 1	nvarchar	40	0	CHAR	(N' ')	Yes		AD_NAME1	Allow NULL?
284	REQ_NAME_LAST	Last name	nvarchar	40	0	CHAR	(N' ')	Yes		AD_NAMELAS	Allow NULL?
285	REQ_NAME_FIRST	First name	nvarchar	40	0	CHAR	(N' ')	Yes		AD_NAMEFIR	Allow NULL?
286	REQ_NAME_TEXT	Full Name of Person	nvarchar	80	0	CHAR	(N' ')	Yes		AD_NAMTEXT	Allow NULL?
287	REQ_TITLE_ACA1	Academic Title: Key	nvarchar	4	0	CHAR	(N' ')	Yes	*	AD_TITLE1	Allow NULL?
288	REQ_TITLE_ACA2	Second academic title (key)	nvarchar	4	0	CHAR	(N' ')	Yes	*	AD_TITLE2	Allow NULL?
289	REQ_DEPARTMENT	Department	nvarchar	40	0	CHAR	(N' ')	Yes		AD_DPRTMNT	Allow NULL?
290	REQ_TELNR_LONG	Complete number: dialling code+number+extension	nvarchar	30	0	CHAR	(N' ')	Yes		AD_TELNRLG	Allow NULL?
291	OBJECT_ID	Transaction Number	nvarchar	10	0	CHAR	(N' ')	Yes		CRMT_OBJECT_ID_DB	Allow NULL?
292	UNIT_TEXT	Unit of Measurement Text (Maximum 30 Characters)	nvarchar	30	0	CHAR	(N' ')	Yes		MSEHL	Allow NULL?
293	DUMMY_DRAFT_ITM_INCL	Dummy function in length 1	char	1	0	CHAR	(N' ')	Yes		DUMMY	Allow NULL?

TOP ERP 6.0 | SRMSOCO_DRFT_ITM INDEXES

Name	Primary	Unique	Type	Columns
SRMSOCO_DRFT_ITMDO	No	No	NONCLUSTERED	NUMBER_INT, OBJECT_ID, DRAFT_H_GUID
SRMSOCO_DRFT_ITM~0	Yes	Yes	CLUSTERED	DRAFT_I_GUID, MANDT

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

293 COLUMNS | 2 INDEXES | ERP 6.0 | SRMSOCO_DRFT_ITM TABLE

TOP ERP 6.0 | SRMSOCO_DRFT_ITM COLUMNS

TOP ERP 6.0 | SRMSOCO_DRFT_ITM INDEXES

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

293 COLUMNS | 2 INDEXES | ERP 6.0 | SRMSOCO_DRFT_ITM TABLE

TOPERP 6.0 | SRMSOCO_DRFT_ITM COLUMNS

TOPERP 6.0 | SRMSOCO_DRFT_ITM INDEXES

TOP ERP 6.0 | SRMSOCO_DRFT_ITM COLUMNS

TOP ERP 6.0 | SRMSOCO_DRFT_ITM INDEXES