SAP ABAP Table /SAPSRM/S_CLL_PC_ITEM_OVERVIEW (CLL Structure for PCard Item Overview Table)

Hierarchy

☛ SRM_SERVER (Software Component) SRM_SERVER
   ⤷ SRM-EBP-CA-UI (Application Component) User Interface/Templates
     ⤷ /SAPSRM/CLL_SHARED (Package) Generic implementation for all channels

Basic Data

Table Category	INTTAB	Structure
Structure	/SAPSRM/S_CLL_PC_ITEM_OVERVIEW	Table Relationship Diagram
Short Description	CLL Structure for PCard Item Overview Table

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	.INCLU-_I	☐				0	0	Store detail to display on screen
2	GUID_I	☐	BBP_GUID	SYSUUID	RAW	16	0	Globally Unique identifier
3	NUMBER_INT_I	☐	BBP_ITEM_NO	CRM_ITEM_NO	NUMC	10	0	Item number
4	PCARD_DOC_I	☐	BBPPCDOCNR	BELNR	CHAR	10	0	Document number for procurement card statements
5	FISC_YEAR_I	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
6	DESCRIPTION_I	☐	TXZ01	TEXT40	CHAR	40	0	Short Text
7	RECONCILE_I	☐	/SAPSRM/PC_RECONCILE_FLAG	/SAPSRM/PC_RECONCILE_FLAG	CHAR	1	0	Reconcile flag value
8	POSTPONE_I	☐	/SAPSRM/PC_RECONCILE_FLAG	/SAPSRM/PC_RECONCILE_FLAG	CHAR	1	0	Reconcile flag value
9	SUPPLIER_I	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
10	PO_NUMBER_I	☐	CRMT_OBJECT_ID_DB	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
11	ITEM_NUMBER_I	☐	BBP_ITEM_NO	CRM_ITEM_NO	NUMC	10	0	Item number
12	PO_ITEM_DETAILS_I	☐	/SAPSRM/PC_PO_ITEM_DETAILS	/SAPSRM/PC_PO_ITEM_DETAILS	CHAR	25	0	Detail to contain PO & Item number
13	QUANTITY_I	☐	BBP_BSTMG	MENG13	QUAN	13	3	Purchase order quantity
14	UNIT_I	☐	VRKME	MEINS	UNIT	3	0	Sales unit	*
15	TRANSACTION_DATE_I	☐	BBPTRDAT	DATUM	DATS	8	0	Procurement card transaction date
16	ACCOUNT_ASSIGNMENT_I	☐	SAKNR	SAKNR	CHAR	10	0	G/L Account Number	*
17	NET_PRICE_I	☐	DMBTR	WERT7	CURR	13	2	Amount in local currency
18	GROSS_PRICE_I	☐	DMBTR	WERT7	CURR	13	2	Amount in local currency
19	PC_LINE_I	☐	BBPPCLIN	BBPPCLIN	NUMC	6	0	Procurement card line number
20	PC_SUBLINE_I	☐	BBPPCSLI	NUMC	NUMC	5	0	Sub-line number for procurement card data feed
21	.INCLUDE	☐				0	0	Procurement Card Statement: Position Data
22	BBPPCINS_I	☐	BBPPCINS	BBPPCINS	CHAR	4	0	Procurement card company	BBP_PCINS
23	PCNUM_I	☐	BBPPCNUM	BBPPCNUM	CHAR	25	0	Procurement card number	BBP_PCMAS
24	PCNAME_I	☐	BBPPCNAME	CHAR40	CHAR	40	0	Name of procurement cardholder
25	PCDAT_FROM_I	☐	BBPPCDATF	DATUM	DATS	8	0	Procurement card valid from date
26	PCDAT_TO_I	☐	BBPPCDATE	DATUM	DATS	8	0	Procurement card expiration date
27	TRDAT_I	☐	BBPTRDAT	DATUM	DATS	8	0	Procurement card transaction date
28	TRTIME_I	☐	BBPTRTIME	UZEIT	TIMS	6	0	Procurement card transaction time
29	AUTH_REFNO_I	☐	BBP_AUTRA	CHAR30	CHAR	30	0	Payment cards: Authoriz. reference code of clearing house
30	CC_AUTH_NO_I	☐	AUNUM	CHAR10	CHAR	10	0	Payment cards: Authorization number
31	AUTH_DATE_I	☐	AUDAT_CC	DATUM	DATS	8	0	Payment cards: Authorization date
32	AUTH_TIME_I	☐	AUTIM	UZEIT	TIMS	6	0	Payment cards: Authorization time
33	MERCHIDCL_I	☐	MERCH	MERCH	CHAR	15	0	Payment cards: Merchant ID at the clearing house	*
34	VENDOR_NO_I	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
35	VEND_CAT_I	☐	BBPPCMERCH	CHAR12	CHAR	12	0	Procurement card vendor category
36	VAT_REG_NO_I	☐	BBPVATNO	STCEG	CHAR	20	0	Procurement card merchant VAT registration number
37	VAT_REG_CU_I	☐	BBPVATCU	STCEG	CHAR	20	0	Procurement card customer VAT registration number
38	DB_CR_IND_I	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
39	AMOUNT_I	☐	DMBTR	WERT7	CURR	13	2	Amount in local currency
40	CURRENCY_I	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
41	CURREN_ISO_I	☐	ISOCD	ISOCD	CHAR	3	0	ISO currency code
42	AMOUNT_TA_I	☐	DMBTR	WERT7	CURR	13	2	Amount in local currency
43	CURREN_TA_I	☐	BBPWAER_TA	WAERS	CUKY	5	0	Procurement card transaction currency code	*
44	CURRTA_ISO_I	☐	ISOCD	ISOCD	CHAR	3	0	ISO currency code
45	REF_DOC_NO_I	☐	XBLNR	XBLNR	CHAR	16	0	Reference Document Number
46	PCSTATUS_I	☐	BBPPCSTA	BBPPCSTA	NUMC	2	0	Procurement card reconciliation status	BBP_PCSTA
47	APPROVER_I	☐	XUBNAME	XUBNAME	CHAR	12	0	User Name in User Master Record	*
48	PO_GUID_I	☐	BBP_GUID	SYSUUID	RAW	16	0	Globally Unique identifier
49	.INCLUDE	☐				0	0	P-Card header information for reconcillation
50	BBPPCINS	☐	BBPPCINS	BBPPCINS	CHAR	4	0	Procurement card company	*
51	PCNUM	☐	BBPPCNUM	BBPPCNUM	CHAR	25	0	Procurement card number	*
52	PCNAME	☐	BBPPCNAME	CHAR40	CHAR	40	0	Name of procurement cardholder
53	PCDAT_FROM	☐	BBPPCDATF	DATUM	DATS	8	0	Procurement card valid from date
54	PCDAT_TO	☐	BBPPCDATE	DATUM	DATS	8	0	Procurement card expiration date
55	TAX_AMOUNT	☐	DMBTR	WERT7	CURR	13	2	Amount in local currency
56	AMOUNT_TA	☐	DMBTR	WERT7	CURR	13	2	Amount in local currency
57	GROSS_TOTAL_AMOUNT	☐	DMBTR	WERT7	CURR	13	2	Amount in local currency
58	CURRENCY	☐	HWAER	WAERS	CUKY	5	0	Local Currency	*
59	GUID	☐	BBP_GUID	SYSUUID	RAW	16	0	Globally Unique identifier
60	STATUS_RECONCILE	☐			STRG	0	0
61	GROSS_TOTAL	☐	DMBTR	WERT7	CURR	13	2	Amount in local currency

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	/SAPSRM/S_CLL_PC_ITEM_OVERVIEW	BBPPCINS_I	BBP_PCINS	BBPPCINS
2	/SAPSRM/S_CLL_PC_ITEM_OVERVIEW	PCNUM_I	BBP_PCMAS	PCNUM
3	/SAPSRM/S_CLL_PC_ITEM_OVERVIEW	PCSTATUS_I	BBP_PCSTA	PCSTATUS

History

Last changed by/on	SAP	20110913
SAP Release Created in	600