BBP_PCPOS SAP (Procurement Card Statement: Position Data) Table details

Dictionary Type: Table
Description: Procurement Card Statement: Position Data




ABAP Code to SELECT data from BBP_PCPOS
Related tables to BBP_PCPOS
Access table BBP_PCPOS




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
MANDTClient MANDTCLNT3T000MANDT
PCARD_DOCDocument number for procurement card statements BBPPCDOCNRCHAR10BBP_PCGENALPHABELNR
FISC_YEARFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
PC_LINEProcurement card line number BBPPCLINNUMC6BBPPCLIN
ADDR_NOAddress number AD_ADDRNUMCHAR10ADRCALPHAAD_ADDRNUMADR
FORMOFADDRForm of address text AD_TITLE_TCHAR20TEXT20
NAMEName 1 AD_NAME1CHAR40TEXT40
NAME_2Name 2 AD_NAME2CHAR40TEXT40
NAME_3Name 3 AD_NAME3CHAR40TEXT40
NAME_4Name 4 AD_NAME4CHAR40TEXT40
C_O_NAMEc/o name AD_NAME_COCHAR40TEXT40
CITYCity AD_CITY1CHAR40TEXT40CLCITYNAME
DISTRICTDistrict AD_CITY2CHAR40TEXT40CITY_PART
CITY_NOCity code for city/street file AD_CITYNUMCHAR12ADRCITYALPHACITY_CODE
POSTL_COD1City postal code AD_PSTCD1CHAR10CHAR10
POSTL_COD2PO Box Postal Code AD_PSTCD2CHAR10CHAR10
POSTL_COD3Company Postal Code (for Large Customers) AD_PSTCD3CHAR10CHAR10
PO_BOXPO Box AD_POBXCHAR10CHAR10
PO_BOX_CITPO Box city AD_POBXLOCCHAR40TEXT40CITY_NAME
DELIV_DIS(Not Supported) Post Delivery District AD_PSTLARCHAR15TEXT15
STREETStreet AD_STR_OLDCHAR40TEXT40
STREET_NOStreet Number for City/Street File AD_STRNUMCHAR12ADRSTREETALPHASTRT_CODE
STR_ABBR(Not Supported) Abbreviation of Street Name AD_STRABBRCHAR2ADRSTRTYPESTRTYPEAB
HOUSE_NOHouse Number AD_HSNM1CHAR10TEXT10
STR_SUPPL1Street 2 AD_STRSPP1CHAR40TEXT40
STR_SUPPL2Street 3 AD_STRSPP2CHAR40TEXT40
LOCATIONStreet 5 AD_LCTNCHAR40TEXT40
BUILDINGold: building (no. or abbreviation) AD_BLD_OLDCHAR10TEXT10
FLOORFloor in building AD_FLOORCHAR10TEXT10
ROOM_NORoom or Appartment Number AD_ROOMNUMCHAR10TEXT10
COUNTRYCountry Key LAND1CHAR3T005LAND1LND
LANGULanguage Key SPRASLANG1T002ISOLASPRASSPRH_T002
REGIONSTATE (State, Province, County) REGIOCHAR3T005SREGIO
SORT1Search Term 1 AD_SORT1CHAR20CHAR20
SORT2Search Term 2 AD_SORT2CHAR20CHAR20
TIME_ZONEAddress time zone AD_TZONECHAR6TTZZTZNZONE
TAXJURCODETax Jurisdiction AD_TXJCDCHAR15AD_TXJCDTXJ
ADR_NOTESAddress notes AD_REMARK1CHAR50TEXT50
COMM_TYPECommunication Method (Key) (Business Address Services) AD_COMMCHAR3TSACAD_COMM
TEL1_NUMBRFirst telephone no.: dialling code+number AD_TLNMBR1CHAR30CHAR30
TEL1_EXTFirst Telephone No.: Extension AD_TLXTNS1CHAR10CHAR10
FAX_NUMBERFirst fax no.: dialling code+number AD_FXNMBR1CHAR30CHAR30
FAX_EXTENSFirst fax no.: extension AD_FXXTNS1CHAR10CHAR10
STREET_LNGStreet AD_STREETCHAR60TEXT60CLSTRTNAME
DISTRCT_NODistrict code for City and Street file AD_CITYPNMCHAR8ADRCITYPRTALPHACITYP_CODE
CHCKSTATUSCity file test status AD_CHECKSTCHAR1AD_CHECKST
PBOXCIT_NOCity PO box code (City file) AD_CIT2NUMCHAR12ADRCITYALPHACITY_CODE
TRANSPZONETransportation zone to or from which the goods are delivered LZONECHAR10TZONEZONE
HOUSE_NO2House number supplement AD_HSNM2CHAR10TEXT10
E_MAILE-Mail Address AD_SMTPADRCHAR241SXIDNAD_SMTPADR
STR_SUPPL3Street 4 AD_STRSPP3CHAR40TEXT40
TITLETitle text AD_TITLETXCHAR30TEXT30
COUNTRYISOCountry ISO code INTCACHAR2INTCAF4_INTCA
LANGU_ISO2-Character SAP Language Code LAISOCHAR2LAISO
BUILD_LONGBuilding (Number or Code) AD_BLDNGCHAR20TEXT20
REGIOGROUPRegional structure grouping REGIOGROUPCHAR8ADRREGGRPREGIOGROUP
HOME_CITYCity (different from postal city) AD_CITY3CHAR40TEXT40
HOMECITYNODifferent city for city/street file AD_CITYHNMCHAR12Assigned to domainALPHACITY_CODE
PCODE1_EXT(Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code AD_PST1XTCHAR10CHAR10
PCODE2_EXT(Not Supported) PO Box Postal Code Extension AD_PST2XTCHAR10CHAR10
PCODE3_EXT(Not Supported) Major Customer Postal Code Extension AD_PST3XTCHAR10CHAR10
PO_W_O_NOFlag: PO Box Without Number AD_POBXNUMCHAR1XFELD
PO_BOX_REGRegion for PO Box (Country, State, Province, ...) AD_POBXREGCHAR3Assigned to domainREGIO
POBOX_CTRYPO box country AD_POBXCTYCHAR3Assigned to domainLAND1
PO_CTRYISOCountry ISO code INTCACHAR2INTCAF4_INTCA
HOMEPAGEURI, e.g. Homepage or ftp Address AD_URISCRCHAR132AD_URISCR
DONT_USE_SStreet Address Undeliverable Flag AD_NO_USESCHAR4TSAD12AD_NO_USE
DONT_USE_PPO Box Address Undeliverable Flag AD_NO_USEPCHAR4TSAD12AD_NO_USE
HOUSE_NO3(Not supported) House Number Range AD_HSNM3CHAR10TEXT10
LANGU_CRAddress record creation original language AD_LANGUCRLANG1Assigned to domainISOLASPRAS
LANGUCRISO2-Character SAP Language Code LAISOCHAR2LAISO
PO_BOX_LOBBYPO Box Lobby AD_PO_BOX_LBYCHAR40TEXT40
DELI_SERV_TYPEType of Delivery Service AD_DELIVERY_SERVICE_TYPECHAR4AD_DELIVERY_SERVICE_TYPE
DELI_SERV_NUMBERNumber of Delivery Service AD_DELIVERY_SERVICE_NUMBERCHAR10CHAR10
URI_TYPEURI type flag AD_URITYPECHAR3AD_URITYPE
BBPPCINSProcurement card company BBPPCINSCHAR4BBP_PCINSBBPPCINSPCI
COUNTY_CODECounty code for county AD_CNTYNUMCHAR8Assigned to domainALPHACNTY_CODE
PCNUMProcurement card number BBPPCNUMCHAR25BBP_PCMASBBPPCNUMPCCBBP_PCMAS
COUNTYCounty AD_COUNTYCHAR40TEXT40CLTCNTYNAME
PCNAMEName of procurement cardholder BBPPCNAMECHAR40CHAR40
TOWNSHIP_CODETownship code for Township AD_TWSHPNUMCHAR8Assigned to domainALPHATWSHP_CODE
TOWNSHIPTownship AD_TOWNSHIPCHAR40TEXT40CLTWSHPNAME
PCDAT_FROMProcurement card valid from date BBPPCDATFDATS8DATUM
PCDAT_TOProcurement card expiration date BBPPCDATEDATS8DATUM
TRDATProcurement card transaction date BBPTRDATDATS8DATUM
BBPPCINSProcurement card company BBPPCINSCHAR4BBP_PCINSBBPPCINSPCI
PCNUMProcurement card number BBPPCNUMCHAR25BBP_PCMASBBPPCNUMPCCBBP_PCMAS
TRTIMEProcurement card transaction time BBPTRTIMETIMS6UZEIT
PCNAMEName of procurement cardholder BBPPCNAMECHAR40CHAR40
AUTH_REFNOPayment cards: Authoriz. reference code of clearing house BBP_AUTRACHAR30CHAR30
CC_AUTH_NOPayment cards: Authorization number AUNUMCHAR10CHAR10
PCDAT_FROMProcurement card valid from date BBPPCDATFDATS8DATUM
PCDAT_TOProcurement card expiration date BBPPCDATEDATS8DATUM
AUTH_DATEPayment cards: Authorization date AUDAT_CCDATS8DATUM
TRDATProcurement card transaction date BBPTRDATDATS8DATUM
AUTH_TIMEPayment cards: Authorization time AUTIMTIMS6UZEIT
TRTIMEProcurement card transaction time BBPTRTIMETIMS6UZEIT
MERCHIDCLPayment cards: Merchant ID at the clearing house MERCHCHAR15Assigned to domainMERCH
VENDOR_NOAccount Number of Vendor or Creditor LIFNRCHAR10Assigned to domainALPHALIFNRLIFKRED_C
AUTH_REFNOPayment cards: Authoriz. reference code of clearing house BBP_AUTRACHAR30CHAR30
VEND_CATProcurement card vendor category BBPPCMERCHCHAR12CHAR12
CC_AUTH_NOPayment cards: Authorization number AUNUMCHAR10CHAR10
AUTH_DATEPayment cards: Authorization date AUDAT_CCDATS8DATUM
VAT_REG_NOProcurement card merchant VAT registration number BBPVATNOCHAR20STCEG
AUTH_TIMEPayment cards: Authorization time AUTIMTIMS6UZEIT
VAT_REG_CUProcurement card customer VAT registration number BBPVATCUCHAR20STCEG
DB_CR_INDDebit/Credit Indicator SHKZGCHAR1SHKZG
MERCHIDCLPayment cards: Merchant ID at the clearing house MERCHCHAR15Assigned to domainMERCH
AMOUNTAmount in Local Currency DMBTRCURR13(2) WERT7
VENDOR_NOAccount Number of Vendor or Creditor LIFNRCHAR10Assigned to domainALPHALIFNRLIFKRED_C
CURRENCYCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
VEND_CATProcurement card vendor category BBPPCMERCHCHAR12CHAR12
CURREN_ISOISO currency code ISOCDCHAR3ISOCD
VAT_REG_NOProcurement card merchant VAT registration number BBPVATNOCHAR20STCEG
AMOUNT_TAAmount in Local Currency DMBTRCURR13(2) WERT7
VAT_REG_CUProcurement card customer VAT registration number BBPVATCUCHAR20STCEG
CURREN_TAProcurement card transaction currency code BBPWAER_TACUKY5Assigned to domainWAERS
DB_CR_INDDebit/Credit Indicator SHKZGCHAR1SHKZG
AMOUNTAmount in Local Currency DMBTRCURR13(2) WERT7
CURRTA_ISOISO currency code ISOCDCHAR3ISOCD
CURRENCYCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
REF_DOC_NOReference Document Number XBLNRCHAR16XBLNR
PCSTATUSProcurement card reconciliation status BBPPCSTANUMC2BBP_PCSTABBPPCSTA
CURREN_ISOISO currency code ISOCDCHAR3ISOCD
AMOUNT_TAAmount in Local Currency DMBTRCURR13(2) WERT7
CURREN_TAProcurement card transaction currency code BBPWAER_TACUKY5Assigned to domainWAERS
CURRTA_ISOISO currency code ISOCDCHAR3ISOCD
REF_DOC_NOReference Document Number XBLNRCHAR16XBLNR
PCSTATUSProcurement card reconciliation status BBPPCSTANUMC2BBP_PCSTABBPPCSTA
APPROVERUser Name in User Master Record XUBNAMECHAR12Assigned to domainXUBNAMEXUS

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 table
DATA: 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 as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!