SAP ABAP Table /SAPSRM/S_PDO_RECONCILE (Store detail to display on screen)
Hierarchy
☛
SRM_SERVER (Software Component) SRM_SERVER
⤷ SRM-EBP-PRC (Application Component) Procurement Card
⤷ /SAPSRM/PDO_BO_PC (Package) Package for PCard reconciliation screen
⤷ SRM-EBP-PRC (Application Component) Procurement Card
⤷ /SAPSRM/PDO_BO_PC (Package) Package for PCard reconciliation screen
Basic Data
Table Category | INTTAB | Structure |
Structure | /SAPSRM/S_PDO_RECONCILE | Table Relationship Diagram |
Short Description | Store detail to display on screen |
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 | GUID | BBP_GUID | SYSUUID | RAW | 16 | 0 | Globally Unique identifier | ||
2 | NUMBER_INT | BBP_ITEM_NO | CRM_ITEM_NO | NUMC | 10 | 0 | Item number | ||
3 | PCARD_DOC | BBPPCDOCNR | BELNR | CHAR | 10 | 0 | Document number for procurement card statements | ||
4 | FISC_YEAR | GJAHR | GJAHR | NUMC | 4 | 0 | Fiscal Year | ||
5 | DESCRIPTION | TXZ01 | TEXT40 | CHAR | 40 | 0 | Short Text | ||
6 | RECONCILE | /SAPSRM/PC_RECONCILE_FLAG | /SAPSRM/PC_RECONCILE_FLAG | CHAR | 1 | 0 | Reconcile flag value | ||
7 | POSTPONE | /SAPSRM/PC_RECONCILE_FLAG | /SAPSRM/PC_RECONCILE_FLAG | CHAR | 1 | 0 | Reconcile flag value | ||
8 | SUPPLIER | LIFNR | LIFNR | CHAR | 10 | 0 | Account Number of Vendor or Creditor | * | |
9 | PO_NUMBER | CRMT_OBJECT_ID_DB | CRM_OBJECT_ID | CHAR | 10 | 0 | Transaction ID | ||
10 | ITEM_NUMBER | BBP_ITEM_NO | CRM_ITEM_NO | NUMC | 10 | 0 | Item number | ||
11 | PO_ITEM_DETAILS | /SAPSRM/PC_PO_ITEM_DETAILS | /SAPSRM/PC_PO_ITEM_DETAILS | CHAR | 25 | 0 | Detail to contain PO & Item number | ||
12 | QUANTITY | BBP_BSTMG | MENG13 | QUAN | 13 | 3 | Purchase order quantity | ||
13 | UNIT | VRKME | MEINS | UNIT | 3 | 0 | Sales unit | * | |
14 | TRANSACTION_DATE | BBPTRDAT | DATUM | DATS | 8 | 0 | Procurement card transaction date | ||
15 | ACCOUNT_ASSIGNMENT | SAKNR | SAKNR | CHAR | 10 | 0 | G/L Account Number | * | |
16 | NET_PRICE | DMBTR | WERT7 | CURR | 13 | 2 | Amount in local currency | ||
17 | GROSS_PRICE | DMBTR | WERT7 | CURR | 13 | 2 | Amount in local currency | ||
18 | PC_LINE | BBPPCLIN | BBPPCLIN | NUMC | 6 | 0 | Procurement card line number | ||
19 | PC_SUBLINE | BBPPCSLI | NUMC | NUMC | 5 | 0 | Sub-line number for procurement card data feed | ||
20 | .INCLUDE | 0 | 0 | Procurement Card Statement: Position Data | |||||
21 | BBPPCINS | BBPPCINS | BBPPCINS | CHAR | 4 | 0 | Procurement card company | BBP_PCINS | |
22 | PCNUM | BBPPCNUM | BBPPCNUM | CHAR | 25 | 0 | Procurement card number | BBP_PCMAS | |
23 | PCNAME | BBPPCNAME | CHAR40 | CHAR | 40 | 0 | Name of procurement cardholder | ||
24 | PCDAT_FROM | BBPPCDATF | DATUM | DATS | 8 | 0 | Procurement card valid from date | ||
25 | PCDAT_TO | BBPPCDATE | DATUM | DATS | 8 | 0 | Procurement card expiration date | ||
26 | TRDAT | BBPTRDAT | DATUM | DATS | 8 | 0 | Procurement card transaction date | ||
27 | TRTIME | BBPTRTIME | UZEIT | TIMS | 6 | 0 | Procurement card transaction time | ||
28 | AUTH_REFNO | BBP_AUTRA | CHAR30 | CHAR | 30 | 0 | Payment cards: Authoriz. reference code of clearing house | ||
29 | CC_AUTH_NO | AUNUM | CHAR10 | CHAR | 10 | 0 | Payment cards: Authorization number | ||
30 | AUTH_DATE | AUDAT_CC | DATUM | DATS | 8 | 0 | Payment cards: Authorization date | ||
31 | AUTH_TIME | AUTIM | UZEIT | TIMS | 6 | 0 | Payment cards: Authorization time | ||
32 | MERCHIDCL | MERCH | MERCH | CHAR | 15 | 0 | Payment cards: Merchant ID at the clearing house | * | |
33 | VENDOR_NO | LIFNR | LIFNR | CHAR | 10 | 0 | Account Number of Vendor or Creditor | * | |
34 | VEND_CAT | BBPPCMERCH | CHAR12 | CHAR | 12 | 0 | Procurement card vendor category | ||
35 | VAT_REG_NO | BBPVATNO | STCEG | CHAR | 20 | 0 | Procurement card merchant VAT registration number | ||
36 | VAT_REG_CU | BBPVATCU | STCEG | CHAR | 20 | 0 | Procurement card customer VAT registration number | ||
37 | DB_CR_IND | SHKZG | SHKZG | CHAR | 1 | 0 | Debit/Credit Indicator | ||
38 | AMOUNT | DMBTR | WERT7 | CURR | 13 | 2 | Amount in local currency | ||
39 | CURRENCY | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
40 | CURREN_ISO | ISOCD | ISOCD | CHAR | 3 | 0 | ISO currency code | ||
41 | AMOUNT_TA | DMBTR | WERT7 | CURR | 13 | 2 | Amount in local currency | ||
42 | CURREN_TA | BBPWAER_TA | WAERS | CUKY | 5 | 0 | Procurement card transaction currency code | * | |
43 | CURRTA_ISO | ISOCD | ISOCD | CHAR | 3 | 0 | ISO currency code | ||
44 | REF_DOC_NO | XBLNR | XBLNR | CHAR | 16 | 0 | Reference Document Number | ||
45 | PCSTATUS | BBPPCSTA | BBPPCSTA | NUMC | 2 | 0 | Procurement card reconciliation status | BBP_PCSTA | |
46 | APPROVER | XUBNAME | XUBNAME | CHAR | 12 | 0 | User Name in User Master Record | * | |
47 | PO_GUID | 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_PDO_RECONCILE | BBPPCINS | BBP_PCINS | BBPPCINS | |||
2 | /SAPSRM/S_PDO_RECONCILE | PCNUM | BBP_PCMAS | PCNUM | |||
3 | /SAPSRM/S_PDO_RECONCILE | PCSTATUS | BBP_PCSTA | PCSTATUS |
History
Last changed by/on | SAP | 20110913 |
SAP Release Created in | 600 |