BBP_PCPOS SAP (Procurement Card Statement: Position Data) Table details
Dictionary Type: Table
Description: Procurement Card Statement: Position Data
Description: Procurement Card Statement: Position Data
Table field list including key, data, relationships and ABAP select examples
BBP_PCPOS is a standard SAP Table which is used to store Procurement Card Statement: Position Data data and is available within R/3 SAP systems depending on the version and release level.
The BBP_PCPOS table consists of various fields, each holding specific information or linking keys about Procurement Card Statement: Position Data data available in SAP. These include PCARD_DOC (Document number for procurement card statements), FISC_YEAR (Fiscal Year), PC_LINE (Procurement card line number), ADDR_NO (Address number).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP BBP_PCPOS table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
PCARD_DOC | Document number for procurement card statements | BBPPCDOCNR | CHAR | 10 | BBP_PCGEN | ALPHA | BELNR | ||
FISC_YEAR | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
PC_LINE | Procurement card line number | BBPPCLIN | NUMC | 6 | BBPPCLIN | ||||
ADDR_NO | Address number | AD_ADDRNUM | CHAR | 10 | ADRC | ALPHA | AD_ADDRNUM | ADR | |
FORMOFADDR | Form of address text | AD_TITLE_T | CHAR | 20 | TEXT20 | ||||
NAME | Name 1 | AD_NAME1 | CHAR | 40 | TEXT40 | ||||
NAME_2 | Name 2 | AD_NAME2 | CHAR | 40 | TEXT40 | ||||
NAME_3 | Name 3 | AD_NAME3 | CHAR | 40 | TEXT40 | ||||
NAME_4 | Name 4 | AD_NAME4 | CHAR | 40 | TEXT40 | ||||
C_O_NAME | c/o name | AD_NAME_CO | CHAR | 40 | TEXT40 | ||||
CITY | City | AD_CITY1 | CHAR | 40 | TEXT40 | CLCITYNAME | |||
DISTRICT | District | AD_CITY2 | CHAR | 40 | TEXT40 | CITY_PART | |||
CITY_NO | City code for city/street file | AD_CITYNUM | CHAR | 12 | ADRCITY | ALPHA | CITY_CODE | ||
POSTL_COD1 | City postal code | AD_PSTCD1 | CHAR | 10 | CHAR10 | ||||
POSTL_COD2 | PO Box Postal Code | AD_PSTCD2 | CHAR | 10 | CHAR10 | ||||
POSTL_COD3 | Company Postal Code (for Large Customers) | AD_PSTCD3 | CHAR | 10 | CHAR10 | ||||
PO_BOX | PO Box | AD_POBX | CHAR | 10 | CHAR10 | ||||
PO_BOX_CIT | PO Box city | AD_POBXLOC | CHAR | 40 | TEXT40 | CITY_NAME | |||
DELIV_DIS | (Not Supported) Post Delivery District | AD_PSTLAR | CHAR | 15 | TEXT15 | ||||
STREET | Street | AD_STR_OLD | CHAR | 40 | TEXT40 | ||||
STREET_NO | Street Number for City/Street File | AD_STRNUM | CHAR | 12 | ADRSTREET | ALPHA | STRT_CODE | ||
STR_ABBR | (Not Supported) Abbreviation of Street Name | AD_STRABBR | CHAR | 2 | ADRSTRTYPE | STRTYPEAB | |||
HOUSE_NO | House Number | AD_HSNM1 | CHAR | 10 | TEXT10 | ||||
STR_SUPPL1 | Street 2 | AD_STRSPP1 | CHAR | 40 | TEXT40 | ||||
STR_SUPPL2 | Street 3 | AD_STRSPP2 | CHAR | 40 | TEXT40 | ||||
LOCATION | Street 5 | AD_LCTN | CHAR | 40 | TEXT40 | ||||
BUILDING | old: building (no. or abbreviation) | AD_BLD_OLD | CHAR | 10 | TEXT10 | ||||
FLOOR | Floor in building | AD_FLOOR | CHAR | 10 | TEXT10 | ||||
ROOM_NO | Room or Appartment Number | AD_ROOMNUM | CHAR | 10 | TEXT10 | ||||
COUNTRY | Country Key | LAND1 | CHAR | 3 | T005 | LAND1 | LND | ||
LANGU | Language Key | SPRAS | LANG | 1 | T002 | ISOLA | SPRAS | SPR | H_T002 |
REGION | STATE (State, Province, County) | REGIO | CHAR | 3 | T005S | REGIO | |||
SORT1 | Search Term 1 | AD_SORT1 | CHAR | 20 | CHAR20 | ||||
SORT2 | Search Term 2 | AD_SORT2 | CHAR | 20 | CHAR20 | ||||
TIME_ZONE | Address time zone | AD_TZONE | CHAR | 6 | TTZZ | TZNZONE | |||
TAXJURCODE | Tax Jurisdiction | AD_TXJCD | CHAR | 15 | AD_TXJCD | TXJ | |||
ADR_NOTES | Address notes | AD_REMARK1 | CHAR | 50 | TEXT50 | ||||
COMM_TYPE | Communication Method (Key) (Business Address Services) | AD_COMM | CHAR | 3 | TSAC | AD_COMM | |||
TEL1_NUMBR | First telephone no.: dialling code+number | AD_TLNMBR1 | CHAR | 30 | CHAR30 | ||||
TEL1_EXT | First Telephone No.: Extension | AD_TLXTNS1 | CHAR | 10 | CHAR10 | ||||
FAX_NUMBER | First fax no.: dialling code+number | AD_FXNMBR1 | CHAR | 30 | CHAR30 | ||||
FAX_EXTENS | First fax no.: extension | AD_FXXTNS1 | CHAR | 10 | CHAR10 | ||||
STREET_LNG | Street | AD_STREET | CHAR | 60 | TEXT60 | CLSTRTNAME | |||
DISTRCT_NO | District code for City and Street file | AD_CITYPNM | CHAR | 8 | ADRCITYPRT | ALPHA | CITYP_CODE | ||
CHCKSTATUS | City file test status | AD_CHECKST | CHAR | 1 | AD_CHECKST | ||||
PBOXCIT_NO | City PO box code (City file) | AD_CIT2NUM | CHAR | 12 | ADRCITY | ALPHA | CITY_CODE | ||
TRANSPZONE | Transportation zone to or from which the goods are delivered | LZONE | CHAR | 10 | TZONE | ZONE | |||
HOUSE_NO2 | House number supplement | AD_HSNM2 | CHAR | 10 | TEXT10 | ||||
E_MAIL | E-Mail Address | AD_SMTPADR | CHAR | 241 | SXIDN | AD_SMTPADR | |||
STR_SUPPL3 | Street 4 | AD_STRSPP3 | CHAR | 40 | TEXT40 | ||||
TITLE | Title text | AD_TITLETX | CHAR | 30 | TEXT30 | ||||
COUNTRYISO | Country ISO code | INTCA | CHAR | 2 | INTCA | F4_INTCA | |||
LANGU_ISO | 2-Character SAP Language Code | LAISO | CHAR | 2 | LAISO | ||||
BUILD_LONG | Building (Number or Code) | AD_BLDNG | CHAR | 20 | TEXT20 | ||||
REGIOGROUP | Regional structure grouping | REGIOGROUP | CHAR | 8 | ADRREGGRP | REGIOGROUP | |||
HOME_CITY | City (different from postal city) | AD_CITY3 | CHAR | 40 | TEXT40 | ||||
HOMECITYNO | Different city for city/street file | AD_CITYHNM | CHAR | 12 | Assigned to domain | ALPHA | CITY_CODE | ||
PCODE1_EXT | (Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code | AD_PST1XT | CHAR | 10 | CHAR10 | ||||
PCODE2_EXT | (Not Supported) PO Box Postal Code Extension | AD_PST2XT | CHAR | 10 | CHAR10 | ||||
PCODE3_EXT | (Not Supported) Major Customer Postal Code Extension | AD_PST3XT | CHAR | 10 | CHAR10 | ||||
PO_W_O_NO | Flag: PO Box Without Number | AD_POBXNUM | CHAR | 1 | XFELD | ||||
PO_BOX_REG | Region for PO Box (Country, State, Province, ...) | AD_POBXREG | CHAR | 3 | Assigned to domain | REGIO | |||
POBOX_CTRY | PO box country | AD_POBXCTY | CHAR | 3 | Assigned to domain | LAND1 | |||
PO_CTRYISO | Country ISO code | INTCA | CHAR | 2 | INTCA | F4_INTCA | |||
HOMEPAGE | URI, e.g. Homepage or ftp Address | AD_URISCR | CHAR | 132 | AD_URISCR | ||||
DONT_USE_S | Street Address Undeliverable Flag | AD_NO_USES | CHAR | 4 | TSAD12 | AD_NO_USE | |||
DONT_USE_P | PO Box Address Undeliverable Flag | AD_NO_USEP | CHAR | 4 | TSAD12 | AD_NO_USE | |||
HOUSE_NO3 | (Not supported) House Number Range | AD_HSNM3 | CHAR | 10 | TEXT10 | ||||
LANGU_CR | Address record creation original language | AD_LANGUCR | LANG | 1 | Assigned to domain | ISOLA | SPRAS | ||
LANGUCRISO | 2-Character SAP Language Code | LAISO | CHAR | 2 | LAISO | ||||
PO_BOX_LOBBY | PO Box Lobby | AD_PO_BOX_LBY | CHAR | 40 | TEXT40 | ||||
DELI_SERV_TYPE | Type of Delivery Service | AD_DELIVERY_SERVICE_TYPE | CHAR | 4 | AD_DELIVERY_SERVICE_TYPE | ||||
DELI_SERV_NUMBER | Number of Delivery Service | AD_DELIVERY_SERVICE_NUMBER | CHAR | 10 | CHAR10 | ||||
URI_TYPE | URI type flag | AD_URITYPE | CHAR | 3 | AD_URITYPE | ||||
BBPPCINS | Procurement card company | BBPPCINS | CHAR | 4 | BBP_PCINS | BBPPCINS | PCI | ||
COUNTY_CODE | County code for county | AD_CNTYNUM | CHAR | 8 | Assigned to domain | ALPHA | CNTY_CODE | ||
PCNUM | Procurement card number | BBPPCNUM | CHAR | 25 | BBP_PCMAS | BBPPCNUM | PCC | BBP_PCMAS | |
COUNTY | County | AD_COUNTY | CHAR | 40 | TEXT40 | CLTCNTYNAME | |||
PCNAME | Name of procurement cardholder | BBPPCNAME | CHAR | 40 | CHAR40 | ||||
TOWNSHIP_CODE | Township code for Township | AD_TWSHPNUM | CHAR | 8 | Assigned to domain | ALPHA | TWSHP_CODE | ||
TOWNSHIP | Township | AD_TOWNSHIP | CHAR | 40 | TEXT40 | CLTWSHPNAME | |||
PCDAT_FROM | Procurement card valid from date | BBPPCDATF | DATS | 8 | DATUM | ||||
PCDAT_TO | Procurement card expiration date | BBPPCDATE | DATS | 8 | DATUM | ||||
TRDAT | Procurement card transaction date | BBPTRDAT | DATS | 8 | DATUM | ||||
BBPPCINS | Procurement card company | BBPPCINS | CHAR | 4 | BBP_PCINS | BBPPCINS | PCI | ||
PCNUM | Procurement card number | BBPPCNUM | CHAR | 25 | BBP_PCMAS | BBPPCNUM | PCC | BBP_PCMAS | |
TRTIME | Procurement card transaction time | BBPTRTIME | TIMS | 6 | UZEIT | ||||
PCNAME | Name of procurement cardholder | BBPPCNAME | CHAR | 40 | CHAR40 | ||||
AUTH_REFNO | Payment cards: Authoriz. reference code of clearing house | BBP_AUTRA | CHAR | 30 | CHAR30 | ||||
CC_AUTH_NO | Payment cards: Authorization number | AUNUM | CHAR | 10 | CHAR10 | ||||
PCDAT_FROM | Procurement card valid from date | BBPPCDATF | DATS | 8 | DATUM | ||||
PCDAT_TO | Procurement card expiration date | BBPPCDATE | DATS | 8 | DATUM | ||||
AUTH_DATE | Payment cards: Authorization date | AUDAT_CC | DATS | 8 | DATUM | ||||
TRDAT | Procurement card transaction date | BBPTRDAT | DATS | 8 | DATUM | ||||
AUTH_TIME | Payment cards: Authorization time | AUTIM | TIMS | 6 | UZEIT | ||||
TRTIME | Procurement card transaction time | BBPTRTIME | TIMS | 6 | UZEIT | ||||
MERCHIDCL | Payment cards: Merchant ID at the clearing house | MERCH | CHAR | 15 | Assigned to domain | MERCH | |||
VENDOR_NO | Account Number of Vendor or Creditor | LIFNR | CHAR | 10 | Assigned to domain | ALPHA | LIFNR | LIF | KRED_C |
AUTH_REFNO | Payment cards: Authoriz. reference code of clearing house | BBP_AUTRA | CHAR | 30 | CHAR30 | ||||
VEND_CAT | Procurement card vendor category | BBPPCMERCH | CHAR | 12 | CHAR12 | ||||
CC_AUTH_NO | Payment cards: Authorization number | AUNUM | CHAR | 10 | CHAR10 | ||||
AUTH_DATE | Payment cards: Authorization date | AUDAT_CC | DATS | 8 | DATUM | ||||
VAT_REG_NO | Procurement card merchant VAT registration number | BBPVATNO | CHAR | 20 | STCEG | ||||
AUTH_TIME | Payment cards: Authorization time | AUTIM | TIMS | 6 | UZEIT | ||||
VAT_REG_CU | Procurement card customer VAT registration number | BBPVATCU | CHAR | 20 | STCEG | ||||
DB_CR_IND | Debit/Credit Indicator | SHKZG | CHAR | 1 | SHKZG | ||||
MERCHIDCL | Payment cards: Merchant ID at the clearing house | MERCH | CHAR | 15 | Assigned to domain | MERCH | |||
AMOUNT | Amount in Local Currency | DMBTR | CURR | 13(2) | WERT7 | ||||
VENDOR_NO | Account Number of Vendor or Creditor | LIFNR | CHAR | 10 | Assigned to domain | ALPHA | LIFNR | LIF | KRED_C |
CURRENCY | Currency Key | WAERS | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
VEND_CAT | Procurement card vendor category | BBPPCMERCH | CHAR | 12 | CHAR12 | ||||
CURREN_ISO | ISO currency code | ISOCD | CHAR | 3 | ISOCD | ||||
VAT_REG_NO | Procurement card merchant VAT registration number | BBPVATNO | CHAR | 20 | STCEG | ||||
AMOUNT_TA | Amount in Local Currency | DMBTR | CURR | 13(2) | WERT7 | ||||
VAT_REG_CU | Procurement card customer VAT registration number | BBPVATCU | CHAR | 20 | STCEG | ||||
CURREN_TA | Procurement card transaction currency code | BBPWAER_TA | CUKY | 5 | Assigned to domain | WAERS | |||
DB_CR_IND | Debit/Credit Indicator | SHKZG | CHAR | 1 | SHKZG | ||||
AMOUNT | Amount in Local Currency | DMBTR | CURR | 13(2) | WERT7 | ||||
CURRTA_ISO | ISO currency code | ISOCD | CHAR | 3 | ISOCD | ||||
CURRENCY | Currency Key | WAERS | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
REF_DOC_NO | Reference Document Number | XBLNR | CHAR | 16 | XBLNR | ||||
PCSTATUS | Procurement card reconciliation status | BBPPCSTA | NUMC | 2 | BBP_PCSTA | BBPPCSTA | |||
CURREN_ISO | ISO currency code | ISOCD | CHAR | 3 | ISOCD | ||||
AMOUNT_TA | Amount in Local Currency | DMBTR | CURR | 13(2) | WERT7 | ||||
CURREN_TA | Procurement card transaction currency code | BBPWAER_TA | CUKY | 5 | Assigned to domain | WAERS | |||
CURRTA_ISO | ISO currency code | ISOCD | CHAR | 3 | ISOCD | ||||
REF_DOC_NO | Reference Document Number | XBLNR | CHAR | 16 | XBLNR | ||||
PCSTATUS | Procurement card reconciliation status | BBPPCSTA | NUMC | 2 | BBP_PCSTA | BBPPCSTA | |||
APPROVER | User Name in User Master Record | XUBNAME | CHAR | 12 | Assigned to domain | XUBNAME | XUS |
Key field | Non-key field |
How do I retrieve data from SAP table BBP_PCPOS using ABAP code
The following ABAP code Example will allow you to do a basic selection on BBP_PCPOS to SELECT all data from the tableDATA: WA_BBP_PCPOS TYPE BBP_PCPOS.
SELECT SINGLE *
FROM BBP_PCPOS
INTO CORRESPONDING FIELDS OF WA_BBP_PCPOS
WHERE...
How to access SAP table BBP_PCPOS
Within an ECC or HANA version of SAP you can also view further information about BBP_PCPOS and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects