PA0001

Transparent Table Application Table
52 Fields 44 CDS Views

HR Master Record: Infotype 0001 (Org. Assignment)

PA0001 is an SAP database table in S/4HANA. HR Master Record: Infotype 0001 (Org. Assignment). It contains 52 fields. 44 CDS views read from this table.

CDS Views using this table (44)

ViewTypeJoinVDMDescription
FNDEI_PA0001_BLOCKINGINFO view from Blocking Info View for table PA0001
FNDEI_PA0001_FILTER view from Filter View for table PA0001
hrpy_pcc_main_1 view from PCC Main Selection (Infotype 0 and 1)
I_DFS_MaintPersonnelDetsBasic view from BASIC Personnel Details Basic view
I_DfsCapabilityOwner view from BASIC Value Help for Owner
I_DfsScenarioOwner view from BASIC Interface View for Scenario Owner
I_EmployeeLineManager view from BASIC Employee Line Manager
I_EmployeeOp view left_outer BASIC Employee CDS view for OP
I_EmployStatDet view inner BASIC Employment status
I_HCMEmplNotifEmailTemplate view_entity from BASIC Employee data for email template
I_HCMEmployeeAddressBook view inner Employee Address Book
I_HCMOrganizationalAssignment view_entity from BASIC HCM Organizational Assignment
I_InsurClmCapabilityOwner view from BASIC Werthilfe für den Eigentümer
I_PersnWrkAgrmtRoleForOPg view inner BASIC Person Work Agreement Role Details for Object Page
I_PersonWorkAgreementAction view_entity inner BASIC Plain infotype PA0000
I_PersonWorkAgreementComm view_entity inner BASIC Plain Infotype PA0105
I_PersonWorkAgreementOrgAss view_entity from BASIC Plain infotype PA0001
I_PersonWorkAgrmtOrglDetails view from BASIC Person Work Agreement Organization Details
I_PersonWorkAgrmtPlndWrkgTime view inner BASIC Work Agreement Planned Working time
I_PersonWorkAgrmtSrvcCostLevel view inner BASIC Work Agreement Service Cost Level
I_PersonWorkAgrmtStatus view inner BASIC Work Agreement Status
I_PersWrkAgrmtPosDet view from BASIC Person Work Agreement Details with Position
I_ProjSchedMaintOrdRespPerson view from BASIC Project Schedule Data for Person Responsible of Work Order
I_TravelExpenseGeneralData view_entity inner BASIC Travel Expense General Data
I_TravelGeneralData view_entity inner BASIC Travel Request General Data
I_TravelOnBehalfEmployeeVH view_entity from BASIC Assistants employee number list
I_TravelPlan view_entity inner BASIC Travel Plan
I_TravelUsersVH view inner BASIC Travel Users
I_WorkAssignmentOrglDetail view_entity from BASIC Workforce person organizational details
P_EmployeeLineManager view from BASIC
P_EmployOrgDetOp view from BASIC
P_EmployStatDet view inner BASIC
P_EmployWSDet view inner BASIC
P_HRPADKZ_EHR_SELFLT_EMPLEE view from BASIC
P_N_PERSONWORKAGREEMENTTYPE view_entity inner BASIC
P_O_Employment view inner BASIC
P_O_Employmentcostlevel view inner BASIC
P_O_EmployOrgDetOp view from BASIC
P_O_EmployStatDet view inner BASIC
P_O_EmployWSDet view inner BASIC
P_O_PersWrkAgrmtPosDet view from BASIC
P_PERSONWORKAGREEMENTTYPE view inner BASIC
P_PersWrkAgrmtPosDet view from BASIC
P_RMSEmployeeDS view from BASIC

Fields (52)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY pernr PERSNO Personnel No.
KEY subty SUBTY Subtype
KEY objps OBJPS Object ID
KEY sprps SPRPS Lock indicator
KEY endda ENDDA End Date
KEY begda BEGDA Start Date
KEY seqnr SEQNR IT record no.
aedtm AEDAT Changed On
uname AENAM Changed By
histo HISTO Historical rec.
itxex ITXEX Text exists
refex PRFEX Ref. exists
ordex ORDEX Conf.fields ex.
itbld ITBLD Screen control
preas PREAS Change Reason
flag1 NUSED Reserved Field/Unused Field
flag2 NUSED Reserved Field/Unused Field
flag3 NUSED Reserved Field/Unused Field
flag4 NUSED Reserved Field/Unused Field
rese1 NUSED2 Reserved Field/Unused Field of Length 2
rese2 NUSED2 Reserved Field/Unused Field of Length 2
grpvl PCCE_GPVAL Grouping Value
bukrs BUKRS Company Code
werks PERSA Personnel area
persg PERSG EE group
persk PERSK EE subgroup
vdsk1 VDSK1 Org.key
gsber GSBER Business Area
btrtl BTRTL Pers. subarea
juper JUPER Legal person
abkrs ABKRS Payroll area
ansvh ANSVH Work contract
kostl KOSTL Cost Center
orgeh ORGEH Org. Unit
plans PLANS Position
stell STELL Job
mstbr MSTBR Supervisor
sacha SACHA Payroll admin.
sachp SACHP Pers.admin.
sachz SACHZ Time admin.
sname SMNAM Last/First Name
ename EMNAM Empl./appl.name
otype OTYPE Object type
sbmod SBMOD Group
kokrs KOKRS CO Area
fistl FISTL Funds Center
geber BP_GEBER Fund
fkber FKBER Functional Area
grant_nbr GM_GRANT_NBR Grant
sgmnt FB_SEGMENT Segment
budget_pd FM_BUDGET_PERIOD Budget Period

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- HR Master Record: Infotype 0001 (Org. Assignment)
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PA0001 (
    MANDT,      -- Client [MANDT]
    PERNR,      -- Personnel No. [PERSNO]
    SUBTY,      -- Subtype [SUBTY]
    OBJPS,      -- Object ID [OBJPS]
    SPRPS,      -- Lock indicator [SPRPS]
    ENDDA,      -- End Date [ENDDA]
    BEGDA,      -- Start Date [BEGDA]
    SEQNR,      -- IT record no. [SEQNR]
    AEDTM,      -- Changed On [AEDAT]
    UNAME,      -- Changed By [AENAM]
    HISTO,      -- Historical rec. [HISTO]
    ITXEX,      -- Text exists [ITXEX]
    REFEX,      -- Ref. exists [PRFEX]
    ORDEX,      -- Conf.fields ex. [ORDEX]
    ITBLD,      -- Screen control [ITBLD]
    PREAS,      -- Change Reason [PREAS]
    FLAG1,      -- Reserved Field/Unused Field [NUSED]
    FLAG2,      -- Reserved Field/Unused Field [NUSED]
    FLAG3,      -- Reserved Field/Unused Field [NUSED]
    FLAG4,      -- Reserved Field/Unused Field [NUSED]
    RESE1,      -- Reserved Field/Unused Field of Length 2 [NUSED2]
    RESE2,      -- Reserved Field/Unused Field of Length 2 [NUSED2]
    GRPVL,      -- Grouping Value [PCCE_GPVAL]
    BUKRS,      -- Company Code [BUKRS]
    WERKS,      -- Personnel area [PERSA]
    PERSG,      -- EE group [PERSG]
    PERSK,      -- EE subgroup [PERSK]
    VDSK1,      -- Org.key [VDSK1]
    GSBER,      -- Business Area [GSBER]
    BTRTL,      -- Pers. subarea [BTRTL]
    JUPER,      -- Legal person [JUPER]
    ABKRS,      -- Payroll area [ABKRS]
    ANSVH,      -- Work contract [ANSVH]
    KOSTL,      -- Cost Center [KOSTL]
    ORGEH,      -- Org. Unit [ORGEH]
    PLANS,      -- Position [PLANS]
    STELL,      -- Job [STELL]
    MSTBR,      -- Supervisor [MSTBR]
    SACHA,      -- Payroll admin. [SACHA]
    SACHP,      -- Pers.admin. [SACHP]
    SACHZ,      -- Time admin. [SACHZ]
    SNAME,      -- Last/First Name [SMNAM]
    ENAME,      -- Empl./appl.name [EMNAM]
    OTYPE,      -- Object type [OTYPE]
    SBMOD,      -- Group [SBMOD]
    KOKRS,      -- CO Area [KOKRS]
    FISTL,      -- Funds Center [FISTL]
    GEBER,      -- Fund [BP_GEBER]
    FKBER,      -- Functional Area [FKBER]
    GRANT_NBR,  -- Grant [GM_GRANT_NBR]
    SGMNT,      -- Segment [FB_SEGMENT]
    BUDGET_PD,  -- Budget Period [FM_BUDGET_PERIOD]
    PRIMARY KEY (MANDT, PERNR, SUBTY, OBJPS, SPRPS, ENDDA, BEGDA, SEQNR)
);

Learn More