SAP ABAP Table /SAPSRM/S_CLL_ITEM_RECONCILE (CLL Item structure for PCard)
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
⤷ 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_ITEM_RECONCILE | Table Relationship Diagram |
Short Description | CLL Item structure for PCard |
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-PDO | 0 | 0 | Store detail to display on screen | |||||
2 | GUIDPDO | BBP_GUID | SYSUUID | RAW | 16 | 0 | Globally Unique identifier | ||
3 | NUMBER_INTPDO | BBP_ITEM_NO | CRM_ITEM_NO | NUMC | 10 | 0 | Item number | ||
4 | PCARD_DOCPDO | BBPPCDOCNR | BELNR | CHAR | 10 | 0 | Document number for procurement card statements | ||
5 | FISC_YEARPDO | GJAHR | GJAHR | NUMC | 4 | 0 | Fiscal Year | ||
6 | DESCRIPTIONPDO | TXZ01 | TEXT40 | CHAR | 40 | 0 | Short Text | ||
7 | RECONCILEPDO | /SAPSRM/PC_RECONCILE_FLAG | /SAPSRM/PC_RECONCILE_FLAG | CHAR | 1 | 0 | Reconcile flag value | ||
8 | POSTPONEPDO | /SAPSRM/PC_RECONCILE_FLAG | /SAPSRM/PC_RECONCILE_FLAG | CHAR | 1 | 0 | Reconcile flag value | ||
9 | SUPPLIERPDO | LIFNR | LIFNR | CHAR | 10 | 0 | Account Number of Vendor or Creditor | * | |
10 | PO_NUMBERPDO | CRMT_OBJECT_ID_DB | CRM_OBJECT_ID | CHAR | 10 | 0 | Transaction ID | ||
11 | ITEM_NUMBERPDO | BBP_ITEM_NO | CRM_ITEM_NO | NUMC | 10 | 0 | Item number | ||
12 | PO_ITEM_DETAILSPDO | /SAPSRM/PC_PO_ITEM_DETAILS | /SAPSRM/PC_PO_ITEM_DETAILS | CHAR | 25 | 0 | Detail to contain PO & Item number | ||
13 | QUANTITYPDO | BBP_BSTMG | MENG13 | QUAN | 13 | 3 | Purchase order quantity | ||
14 | UNITPDO | VRKME | MEINS | UNIT | 3 | 0 | Sales unit | * | |
15 | TRANSACTION_DATEPDO | BBPTRDAT | DATUM | DATS | 8 | 0 | Procurement card transaction date | ||
16 | ACCOUNT_ASSIGNMENTPDO | SAKNR | SAKNR | CHAR | 10 | 0 | G/L Account Number | * | |
17 | NET_PRICEPDO | DMBTR | WERT7 | CURR | 13 | 2 | Amount in local currency | ||
18 | GROSS_PRICEPDO | DMBTR | WERT7 | CURR | 13 | 2 | Amount in local currency | ||
19 | PC_LINEPDO | BBPPCLIN | BBPPCLIN | NUMC | 6 | 0 | Procurement card line number | ||
20 | PC_SUBLINEPDO | BBPPCSLI | NUMC | NUMC | 5 | 0 | Sub-line number for procurement card data feed | ||
21 | .INCLUDE | 0 | 0 | Procurement Card Statement: Position Data | |||||
22 | BBPPCINSPDO | BBPPCINS | BBPPCINS | CHAR | 4 | 0 | Procurement card company | BBP_PCINS | |
23 | PCNUMPDO | BBPPCNUM | BBPPCNUM | CHAR | 25 | 0 | Procurement card number | BBP_PCMAS | |
24 | PCNAMEPDO | BBPPCNAME | CHAR40 | CHAR | 40 | 0 | Name of procurement cardholder | ||
25 | PCDAT_FROMPDO | BBPPCDATF | DATUM | DATS | 8 | 0 | Procurement card valid from date | ||
26 | PCDAT_TOPDO | BBPPCDATE | DATUM | DATS | 8 | 0 | Procurement card expiration date | ||
27 | TRDATPDO | BBPTRDAT | DATUM | DATS | 8 | 0 | Procurement card transaction date | ||
28 | TRTIMEPDO | BBPTRTIME | UZEIT | TIMS | 6 | 0 | Procurement card transaction time | ||
29 | AUTH_REFNOPDO | BBP_AUTRA | CHAR30 | CHAR | 30 | 0 | Payment cards: Authoriz. reference code of clearing house | ||
30 | CC_AUTH_NOPDO | AUNUM | CHAR10 | CHAR | 10 | 0 | Payment cards: Authorization number | ||
31 | AUTH_DATEPDO | AUDAT_CC | DATUM | DATS | 8 | 0 | Payment cards: Authorization date | ||
32 | AUTH_TIMEPDO | AUTIM | UZEIT | TIMS | 6 | 0 | Payment cards: Authorization time | ||
33 | MERCHIDCLPDO | MERCH | MERCH | CHAR | 15 | 0 | Payment cards: Merchant ID at the clearing house | * | |
34 | VENDOR_NOPDO | LIFNR | LIFNR | CHAR | 10 | 0 | Account Number of Vendor or Creditor | * | |
35 | VEND_CATPDO | BBPPCMERCH | CHAR12 | CHAR | 12 | 0 | Procurement card vendor category | ||
36 | VAT_REG_NOPDO | BBPVATNO | STCEG | CHAR | 20 | 0 | Procurement card merchant VAT registration number | ||
37 | VAT_REG_CUPDO | BBPVATCU | STCEG | CHAR | 20 | 0 | Procurement card customer VAT registration number | ||
38 | DB_CR_INDPDO | SHKZG | SHKZG | CHAR | 1 | 0 | Debit/Credit Indicator | ||
39 | AMOUNTPDO | DMBTR | WERT7 | CURR | 13 | 2 | Amount in local currency | ||
40 | CURRENCYPDO | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
41 | CURREN_ISOPDO | ISOCD | ISOCD | CHAR | 3 | 0 | ISO currency code | ||
42 | AMOUNT_TAPDO | DMBTR | WERT7 | CURR | 13 | 2 | Amount in local currency | ||
43 | CURREN_TAPDO | BBPWAER_TA | WAERS | CUKY | 5 | 0 | Procurement card transaction currency code | * | |
44 | CURRTA_ISOPDO | ISOCD | ISOCD | CHAR | 3 | 0 | ISO currency code | ||
45 | REF_DOC_NOPDO | XBLNR | XBLNR | CHAR | 16 | 0 | Reference Document Number | ||
46 | PCSTATUSPDO | BBPPCSTA | BBPPCSTA | NUMC | 2 | 0 | Procurement card reconciliation status | BBP_PCSTA | |
47 | APPROVERPDO | XUBNAME | XUBNAME | CHAR | 12 | 0 | User Name in User Master Record | * | |
48 | PO_GUIDPDO | BBP_GUID | SYSUUID | RAW | 16 | 0 | Globally Unique identifier |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | /SAPSRM/S_CLL_ITEM_RECONCILE | BBPPCINSPDO | BBP_PCINS | BBPPCINS | |||
2 | /SAPSRM/S_CLL_ITEM_RECONCILE | PCNUMPDO | BBP_PCMAS | PCNUM | |||
3 | /SAPSRM/S_CLL_ITEM_RECONCILE | PCSTATUSPDO | BBP_PCSTA | PCSTATUS |
History
Last changed by/on | SAP | 20110913 |
SAP Release Created in | 600 |