/1PYXXFO/SAP_PAYJNAL_CA3_M0001 SAP () Structure details

Dictionary Type: Structure
Description:




ABAP Code to SELECT data from /1PYXXFO/SAP_PAYJNAL_CA3_M0001
Related tables to /1PYXXFO/SAP_PAYJNAL_CA3_M0001
Access table /1PYXXFO/SAP_PAYJNAL_CA3_M0001




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

/1PYXXFO/SAP_PAYJNAL_CA3_M0001 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 "" 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_/1PYXXFO/SAP_PAYJNAL_CA3_M0001 TYPE /1PYXXFO/SAP_PAYJNAL_CA3_M0001.

The /1PYXXFO/SAP_PAYJNAL_CA3_M0001 table consists of various fields, each holding specific information or linking keys about data available in SAP. These include COMPANY_CODE (Company Code), COMPANY_CODE_TEXT (Name of Company Code or Company), COSTCENTER_KEY (), CATEXT (Name of the controlling area).. 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: Not classified


SAP /1PYXXFO/SAP_PAYJNAL_CA3_M0001 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
COMPANY_CODE_KEY 0
COMPANY_CODECompany Code BUKRSCHAR4BUKRSBUKC_T001
COMPANY_CODE_TEXTName of Company Code or Company BUTXTCHAR25TEXT25
COSTCENTER_KEY 0
CATEXTName of the controlling area BEZEICHAR25TEXT25
CCTEXTDescription KLTXTCHAR40TEXT40
COSTCENTERCost Center KOSTLCHAR10ALPHAKOSTLKOS
CTRL_AREAControlling Area KOKRSCHAR4CACCDCAC
PROFIT_CENTERProfit Center PRCTRCHAR10ALPHAPRCTRPRCPRCTR_EMPTY
SEGMENTSegment for Segmental Reporting FB_SEGMENTCHAR10ALPHAFB_SEGMENT
EMPLOYEE_KEY 0
ADRS1_NAME_FMTFormat for HR name editing PNAFONUMC2PNAFO
ADRS2_NAME_FMTFormat for HR name editing PNAFONUMC2PNAFO
ADRS3_NAME_FMTFormat for HR name editing PNAFONUMC2PNAFO
BEGDAStart Date BEGDADATS8DATUM
ENDDAEnd Date ENDDADATS8DATUM
IGNORE_DATESCheckbox XFELDCHAR1XFELD
NAME1_FORMATFormat for HR name editing PNAFONUMC2PNAFO
NAME2_FORMATFormat for HR name editing PNAFONUMC2PNAFO
NAME3_FORMATFormat for HR name editing PNAFONUMC2PNAFO
PERSONNEL_NUMBERPersonnel Number P_PERNRNUMC8PERNR
EMPLOYEE_ADDRESS 0
ANREDTitle ANREDCHAR15TEXT15
NAME1Name 1 of an address NAME1_ADRSCHAR40TEXT40
NAME2Name 2 of an address NAME2_ADRSCHAR40TEXT40
NAME3Name 3 of an address NAME3_ADRSCHAR40TEXT40
NAME4Name 4 of an address NAME4_ADRSCHAR40TEXT40
STRASHouse number and street STRAS_GPCHAR35TEXT35
PFACHPO box PFACH_BASCHAR10PFACH
PSTL2PO Box postal code PSTL2_BASCHAR10PSTLZ
PFORTPO Box city PFORT_ADRSCHAR40TEXT40
LAND1Country Key LAND1CHAR3LAND1LND
PSTLZPostal code PSTLZ_BASCHAR10PSTLZ
ORT01City ORT01_GPCHAR35TEXT35
ORT02City ORT01_GPCHAR35TEXT35
REGIOSTATE (State, Province, County) REGIOCHAR3REGIO
SPRASLanguage Key SPRASLANG1ISOLASPRASSPRH_T002
INLNDCountry Key LAND1CHAR3LAND1LND
ANZZLNumber of lines in address ANZEIDEC2ANZEI
PRIORAddress lines priority PRITY_ADRSCHAR9CHAR9
WARENDelivery address ID WARENCHAR1WAREN
LINE0Address line LINESCHAR80LINES
LINE1Address line LINESCHAR80LINES
LINE2Address line LINESCHAR80LINES
LINE3Address line LINESCHAR80LINES
LINE4Address line LINESCHAR80LINES
LINE5Address line LINESCHAR80LINES
LINE6Address line LINESCHAR80LINES
LINE7Address line LINESCHAR80LINES
LINE8Address line LINESCHAR80LINES
LINE9Address line LINESCHAR80LINES
LINEKAddress line LINESCHAR80LINES
LINEDAddress line LINESCHAR80LINES
LINED0Address line LINESCHAR80LINES
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
COUNTYCounty AD_COUNTYCHAR40TEXT40CLTCNTYNAME
TOWNSHIPTownship AD_TOWNSHIPCHAR40TEXT40CLTWSHPNAME
EMPLOYEE_ADDRESS2 0
ANREDTitle ANREDCHAR15TEXT15
NAME1Name 1 of an address NAME1_ADRSCHAR40TEXT40
NAME2Name 2 of an address NAME2_ADRSCHAR40TEXT40
NAME3Name 3 of an address NAME3_ADRSCHAR40TEXT40
NAME4Name 4 of an address NAME4_ADRSCHAR40TEXT40
STRASHouse number and street STRAS_GPCHAR35TEXT35
PFACHPO box PFACH_BASCHAR10PFACH
PSTL2PO Box postal code PSTL2_BASCHAR10PSTLZ
PFORTPO Box city PFORT_ADRSCHAR40TEXT40
LAND1Country Key LAND1CHAR3LAND1LND
PSTLZPostal code PSTLZ_BASCHAR10PSTLZ
ORT01City ORT01_GPCHAR35TEXT35
ORT02City ORT01_GPCHAR35TEXT35
REGIOSTATE (State, Province, County) REGIOCHAR3REGIO
SPRASLanguage Key SPRASLANG1ISOLASPRASSPRH_T002
INLNDCountry Key LAND1CHAR3LAND1LND
ANZZLNumber of lines in address ANZEIDEC2ANZEI
PRIORAddress lines priority PRITY_ADRSCHAR9CHAR9
WARENDelivery address ID WARENCHAR1WAREN
LINE0Address line LINESCHAR80LINES
LINE1Address line LINESCHAR80LINES
LINE2Address line LINESCHAR80LINES
LINE3Address line LINESCHAR80LINES
LINE4Address line LINESCHAR80LINES
LINE5Address line LINESCHAR80LINES
LINE6Address line LINESCHAR80LINES
LINE7Address line LINESCHAR80LINES
LINE8Address line LINESCHAR80LINES
LINE9Address line LINESCHAR80LINES
LINEKAddress line LINESCHAR80LINES
LINEDAddress line LINESCHAR80LINES
LINED0Address line LINESCHAR80LINES
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
COUNTYCounty AD_COUNTYCHAR40TEXT40CLTCNTYNAME
TOWNSHIPTownship AD_TOWNSHIPCHAR40TEXT40CLTWSHPNAME
EMPLOYEE_ADDRESS3 0
ANREDTitle ANREDCHAR15TEXT15
NAME1Name 1 of an address NAME1_ADRSCHAR40TEXT40
NAME2Name 2 of an address NAME2_ADRSCHAR40TEXT40
NAME3Name 3 of an address NAME3_ADRSCHAR40TEXT40
NAME4Name 4 of an address NAME4_ADRSCHAR40TEXT40
STRASHouse number and street STRAS_GPCHAR35TEXT35
PFACHPO box PFACH_BASCHAR10PFACH
PSTL2PO Box postal code PSTL2_BASCHAR10PSTLZ
PFORTPO Box city PFORT_ADRSCHAR40TEXT40
LAND1Country Key LAND1CHAR3LAND1LND
PSTLZPostal code PSTLZ_BASCHAR10PSTLZ
ORT01City ORT01_GPCHAR35TEXT35
ORT02City ORT01_GPCHAR35TEXT35
REGIOSTATE (State, Province, County) REGIOCHAR3REGIO
SPRASLanguage Key SPRASLANG1ISOLASPRASSPRH_T002
INLNDCountry Key LAND1CHAR3LAND1LND
ANZZLNumber of lines in address ANZEIDEC2ANZEI
PRIORAddress lines priority PRITY_ADRSCHAR9CHAR9
WARENDelivery address ID WARENCHAR1WAREN
LINE0Address line LINESCHAR80LINES
LINE1Address line LINESCHAR80LINES
LINE2Address line LINESCHAR80LINES
LINE3Address line LINESCHAR80LINES
LINE4Address line LINESCHAR80LINES
LINE5Address line LINESCHAR80LINES
LINE6Address line LINESCHAR80LINES
LINE7Address line LINESCHAR80LINES
LINE8Address line LINESCHAR80LINES
LINE9Address line LINESCHAR80LINES
LINEKAddress line LINESCHAR80LINES
LINEDAddress line LINESCHAR80LINES
LINED0Address line LINESCHAR80LINES
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
COUNTYCounty AD_COUNTYCHAR40TEXT40CLTCNTYNAME
TOWNSHIPTownship AD_TOWNSHIPCHAR40TEXT40CLTWSHPNAME
EMPLOYEE_BIRTH_DATEDate of Birth GBDATDATS8PDATEGBDAT
EMPLOYEE_BIRTH_PLACEBirthplace PAD_GBORTCHAR40PAD_ORT01
EMPLOYEE_FIRE_DATEEnd Date ENDDADATS8DATUM
EMPLOYEE_FIRST_NAMEFirst Name PAD_VORNACHAR40PAD_VORNM
EMPLOYEE_FULL_NAMEComplete Name PAD_CNAMECHAR80TEXT80
EMPLOYEE_GENDERGender Key GESCHCHAR1GESCH
EMPLOYEE_GENDER_TEXTShort Text for Fixed Values VAL_TEXTCHAR60DDTEXT
EMPLOYEE_HIRE_DATEStart Date BEGDADATS8DATUM
EMPLOYEE_LANGUCommunication Language PAD_SPRASLANG1Assigned to domainISOLASPRASSPRH_T002
EMPLOYEE_LAST_NAMELast Name PAD_NACHNCHAR40PAD_NACHN
EMPLOYEE_MARITAL_STKEYMarital Status Key FAMSTCHAR1Assigned to domainFAMST
EMPLOYEE_MARITAL_STTEXTMarital Status FATXTCHAR6FATXT
EMPLOYEE_MARRIED_SINCEValid From Date of Current Marital Status FAMDTDATS8DATUM
EMPLOYEE_NATIONALITYNationality NATSLCHAR3Assigned to domainLAND1NAT
EMPLOYEE_NATIO_TEXTNationality NATIOCHAR15TEXT15
EMPLOYEE_PERSONNEL_IDPersonnel ID Number PRDNICHAR20CHAR20
EMPLOYEE_PRINT_NAMEFormatted Name of Employee or Applicant EMNAMCHAR40TEXT40
EMPLOYEE_PRINT_NAME2Formatted Name of Employee or Applicant EMNAMCHAR40TEXT40
EMPLOYEE_PRINT_NAME3Formatted Name of Employee or Applicant EMNAMCHAR40TEXT40
EMPLOYEE_SORT_NAMEEmployee's Name (Sortable by LAST NAME FIRST NAME) SMNAMCHAR30CHAR30
EMPLOYEE_TELNRTelephone Number TELNRCHAR14TELNR
EMPLOYEE_SORT 0
IGNORE_DATES 0
FORPAYROLL_AREA_KEY 0
PAYROLL_AREAPayroll Area ABKRSCHAR2ABKRSABK
PERIOD_MODIFPeriod Parameters PERMONUMC2PERMO
FORPAYROLL_AREA_PAYR_AREA_TEXTPayroll Area Text ABKTXCHAR20TEXT20
FORPAYROLL_AREA_PER_MOD_TEXTPeriod parameter - name PERMOTXCHAR20TEXT20
FORPERIOD_ID_KEY 0
PERIODIn-period for payroll IPERICHAR6CHAR6
PERIOD_MODIFIERPeriod Parameters PERMONUMC2PERMO
FORPERIOD_ID_BEGDAStart Date BEGDADATS8DATUM
FORPERIOD_ID_ENDDAEnd Date ENDDADATS8DATUM
FORPERIOD_OC_KEY 0
BONDTOff-cycle payroll payment date BONDTDATS8DATUM
OFFCYCLE_CATCategory for off-cycle reason PAY_OCCATCHAR2PAY_OCCAT
OFFCYCLE_REASONReason for Off-Cycle Payroll PAY_OCRSNCHAR4PAY_OCRSNOCR
PAYROLL_IDPayroll Identifier PAYIDCHAR1CHAR1
PAYROLL_TYPEPayroll type PAYTYCHAR1PAYTY
INPAYROLL_AREA_KEY 0
PAYROLL_AREAPayroll Area ABKRSCHAR2ABKRSABK
PERIOD_MODIFPeriod Parameters PERMONUMC2PERMO
INPAYROLL_AREA_PAYR_AREA_TEXTPayroll Area Text ABKTXCHAR20TEXT20
INPAYROLL_AREA_PER_MOD_TEXTPeriod parameter - name PERMOTXCHAR20TEXT20
INPERIOD_ID_KEY 0
PERIODIn-period for payroll IPERICHAR6CHAR6
PERIOD_MODIFIERPeriod Parameters PERMONUMC2PERMO
INPERIOD_ID_BEGDAStart Date BEGDADATS8DATUM
INPERIOD_ID_ENDDAEnd Date ENDDADATS8DATUM
INPERIOD_OC_KEY 0
BONDTOff-cycle payroll payment date BONDTDATS8DATUM
OFFCYCLE_CATCategory for off-cycle reason PAY_OCCATCHAR2PAY_OCCAT
OFFCYCLE_REASONReason for Off-Cycle Payroll PAY_OCRSNCHAR4PAY_OCRSNOCR
PAYROLL_IDPayroll Identifier PAYIDCHAR1CHAR1
PAYROLL_TYPEPayroll type PAYTYCHAR1PAYTY
ORG_UNIT_KEY 0
ORG_UNITOrganizational Unit ORGEHNUMC8ORGEH
TEXTShort Text of Organizational Unit ORGTXCHAR25TEXT25
PERS_AREA_KEY 0
PERS_AREAPersonnel Area PERSACHAR4PERSAPBR
PERS_AREA_ADDRESS_KEYAddress ADRNRCHAR10Assigned to domainALPHAADRNR
PERS_AREA_CITYCity ORT01CHAR25TEXT25
PERS_AREA_COUNTRYCountry Key LAND1CHAR3Assigned to domainLAND1LND
PERS_AREA_NAME_2Name 2 NAME2CHAR30TEXT30
PERS_AREA_POSTAL_CODEPostal Code PSTLZCHAR10PSTLZ
PERS_AREA_POST_BOXPO Box PFACHCHAR10PFACH
PERS_AREA_REGIONSTATE (State, Province, County) REGIOCHAR3Assigned to domainREGIO
PERS_AREA_STREET_ADDRESSHouse number and street STRASCHAR30TEXT30
PERS_AREA_TEXTPersonnel Area Text PBTXTCHAR30TEXT30
PERS_SUBAREA_KEY 0
PERS_AREAPersonnel Area PERSACHAR4PERSAPBR
PERS_SUBAREAPersonnel Subarea BTRTL_001PCHAR4BTRTL
PERS_SUBAREA_ADDRESS 0
ANREDTitle ANREDCHAR15TEXT15
NAME1Name 1 of an address NAME1_ADRSCHAR40TEXT40
NAME2Name 2 of an address NAME2_ADRSCHAR40TEXT40
NAME3Name 3 of an address NAME3_ADRSCHAR40TEXT40
NAME4Name 4 of an address NAME4_ADRSCHAR40TEXT40
STRASHouse number and street STRAS_GPCHAR35TEXT35
PFACHPO box PFACH_BASCHAR10PFACH
PSTL2PO Box postal code PSTL2_BASCHAR10PSTLZ
PFORTPO Box city PFORT_ADRSCHAR40TEXT40
LAND1Country Key LAND1CHAR3LAND1LND
PSTLZPostal code PSTLZ_BASCHAR10PSTLZ
ORT01City ORT01_GPCHAR35TEXT35
ORT02City ORT01_GPCHAR35TEXT35
REGIOSTATE (State, Province, County) REGIOCHAR3REGIO
SPRASLanguage Key SPRASLANG1ISOLASPRASSPRH_T002
INLNDCountry Key LAND1CHAR3LAND1LND
ANZZLNumber of lines in address ANZEIDEC2ANZEI
PRIORAddress lines priority PRITY_ADRSCHAR9CHAR9
WARENDelivery address ID WARENCHAR1WAREN
LINE0Address line LINESCHAR80LINES
LINE1Address line LINESCHAR80LINES
LINE2Address line LINESCHAR80LINES
LINE3Address line LINESCHAR80LINES
LINE4Address line LINESCHAR80LINES
LINE5Address line LINESCHAR80LINES
LINE6Address line LINESCHAR80LINES
LINE7Address line LINESCHAR80LINES
LINE8Address line LINESCHAR80LINES
LINE9Address line LINESCHAR80LINES
LINEKAddress line LINESCHAR80LINES
LINEDAddress line LINESCHAR80LINES
LINED0Address line LINESCHAR80LINES
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
COUNTYCounty AD_COUNTYCHAR40TEXT40CLTCNTYNAME
TOWNSHIPTownship AD_TOWNSHIPCHAR40TEXT40CLTWSHPNAME
PERS_SUBAREA_PERS_SUBAREATEXTPersonnel Subarea Text BTRTXCHAR15TEXT15
PERS_SUBAREA_SHORT_ADDRESSAddress Text (Name, Street, City, Tel. No.) ADRTXCHAR40TEXT40
PERS_SUBAREA_TELEPHONEAddress Text (Name, Street, City, Tel. No.) ADRTXCHAR40TEXT40
RESULT_RETRO_KEY 0
RETROCheckbox XFELDCHAR1XFELD
RESULT_STATUS_KEY 0
RESULT_STATUSIndicator: Status of record SRTZACHAR1SRTZA
RESULT_STATUS_SORT 0
RESULT_STATUS 0
WAGETYPE_KEY 0
COUNTRYCountry Grouping MOLGACHAR2MOLGAMOL
WAGETYPEWage Type LGARTCHAR4LGART
WAGETYPE_LONGTEXTWage Type Long Text LGTXTCHAR25TEXT25
WAGETYPE_SHORTTEXTShort Text for Wage Type KZTXTCHAR8TEXT8
WAGETYPE_SORT 0
WAGETYPE 0
PAY_RATEHR Payroll: Amount MAXBTCURR15(2) PRBETRG
RTE_CURRCurrency Key WAERSCUKY5Assigned to domainWAERSFWS

Key field Non-key field



How do I retrieve data from SAP structure /1PYXXFO/SAP_PAYJNAL_CA3_M0001 using ABAP code?

As /1PYXXFO/SAP_PAYJNAL_CA3_M0001 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 /1PYXXFO/SAP_PAYJNAL_CA3_M0001 as there is no data to select.

How to access SAP table /1PYXXFO/SAP_PAYJNAL_CA3_M0001

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