PTRV_DB_CARDHOLDER SAP (Database Structure for VISA VCF4 Cardholder Record Type) Structure details

Dictionary Type: Structure
Description: Database Structure for VISA VCF4 Cardholder Record Type




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




Structure field list including key, data, relationships and ABAP select examples

PTRV_DB_CARDHOLDER is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Database Structure for VISA VCF4 Cardholder Record Type" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_PTRV_DB_CARDHOLDER TYPE PTRV_DB_CARDHOLDER.

The PTRV_DB_CARDHOLDER table consists of various fields, each holding specific information or linking keys about Database Structure for VISA VCF4 Cardholder Record Type data available in SAP. These include LOAD_TRANSACTION_CODE (Load Transaction Code), COMPANY_IDENTIFICATION (Company Identification), CARDHOLDER_IDENTIFICATION (Cardholder Identification), HIERARCHY_NODE (Hierarchy Node).. 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:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced


SAP PTRV_DB_CARDHOLDER structure 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
CCARD_GUIDGUID of a Payment Card CARD_GUIDRAW16SYSUUID
LOAD_TRANSACTION_CODELoad Transaction Code PTRV_LOAD_TRANSACTION_CODENUMC1
COMPANY_IDENTIFICATIONCompany Identification PTRV_COMPANY_IDENTIFICATIONNUMC10
CARDHOLDER_IDENTIFICATIONCardholder Identification PTRV_CARDHOLDER_IDENTIFICATIONCHAR20
HIERARCHY_NODEHierarchy Node PTRV_HIERARCHY_NODECHAR40
FIRST_NAMEName PTRV_VCF4_NAMECHAR20
LAST_NAMEName PTRV_VCF4_NAMECHAR20
ADDRESS_LINE_1Address Line PTRV_VCF4_ADDRESS_LINECHAR40
ADDRESS_LINE_2Address Line PTRV_VCF4_ADDRESS_LINECHAR40
CITYName PTRV_VCF4_NAMECHAR20
STATE_PROVINCE_CODEState/Province Code PTRV_STATE_PROVINCE_CODECHAR40
ISO_COUNTRY_CODEISO Country Code PTRV_ISO_COUNTRY_CODENUMC5
POSTAL_CODEPostal Code PTRV_POSTAL_CODECHAR14
ADDRESS_LINE_3Address Line PTRV_VCF4_ADDRESS_LINECHAR40
MAIL_STOPMail Stop PTRV_MAIL_STOPCHAR14
PHONE_NUMBERPhone Number PTRV_PHONE_NUMBERCHAR14
FAX_NUMBERFax Number PTRV_FAX_NUMBERCHAR14
SSN_OTHER_IDSSN Other ID PTRV_SSN_OTHER_IDCHAR20
TRAINING_DATEVISA VCF4 Formatted Date: MMDDCCYY PTRV_VCF4_DATECHAR8
E_MAIL_ADDRESSE-Mail Address PRTV_E_MAIL_ADDRESSCHAR128
AUTHORIZED_USER_1Authorized User PTRV_USERCHAR26
AUTHORIZED_USER_2Authorized User PTRV_USERCHAR26
AUTHORIZED_USER_3Authorized User PTRV_USERCHAR26
EMPLOYEE_IDEmployee ID PTRV_VCF4_EMPLOYEE_IDCHAR10
HOME_PHONE_NUMBERPhone Number PTRV_PHONE_NUMBERCHAR14
MIDDLE_NAMEMiddle Name PTRV_MIDDLE_NAMECHAR30
VISA_COMMERCE_BUYER_IDVisa Commerce ID PTRV_VISA_COMMERCE_IDCHAR19
VEHICLE_IDVehicle ID PTRV_VEHICLE_IDCHAR20
MISCELLANEOUS_FIELD_1Miscellaneous Field PTRV_MISCELLANEOUS_FIELDCHAR16
MISCELLANEOUS_FIELD_1_DESCMiscellaneous Field Description PTRV_MISCELLANEOUS_FIELD_DESCCHAR26
MISCELLANEOUS_FIELD_2Miscellaneous Field PTRV_MISCELLANEOUS_FIELDCHAR16
MISCELLANEOUS_FIELD_2_DESCMiscellaneous Field Description PTRV_MISCELLANEOUS_FIELD_DESCCHAR26
OPTIONAL_FIELD_1Optional Field, Free Format PTRV_OPTIONAL_FIELDCHAR26
OPTIONAL_FIELD_2Optional Field, Free Format PTRV_OPTIONAL_FIELDCHAR26
OPTIONAL_FIELD_3Optional Field, Free Format PTRV_OPTIONAL_FIELDCHAR26
OPTIONAL_FIELD_4Optional Field, Free Format PTRV_OPTIONAL_FIELDCHAR26

Key field Non-key field



How do I retrieve data from SAP structure PTRV_DB_CARDHOLDER using ABAP code?

As PTRV_DB_CARDHOLDER is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on PTRV_DB_CARDHOLDER as there is no data to select.

How to access SAP table PTRV_DB_CARDHOLDER

Within an ECC or HANA version of SAP you can also view further information about PTRV_DB_CARDHOLDER 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!