PA0009

Transparent Table Application Table
61 Fields 2 CDS Views

HR Master Record: Infotype 0009 (Bank Details)

PA0009 is an SAP database table in S/4HANA. HR Master Record: Infotype 0009 (Bank Details). It contains 61 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_HCMBankData view_entity from EXTENSION HCM Bank Data - Extension
I_HCMBankData view_entity from BASIC HCM Bank Data

Fields (61)

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
opken OPKEN Operation ind.
betrg PAD_VGBTR Standard Value
waers PAD_WAERS Pymnt currency
anzhl VGPRO Standard Pct.
zeinh PT_ZEINH Time unit/meas.
bnksa BNKSA Bank detail ty.
zlsch PCODE Payment Method
emftx EMFTX Payee
bkplz BKPLZ P.code/city
bkort ORT01 City
banks BANKS Bank Ctry/Reg.
bankl BANKK Bank Key
bankn BANKN Bank Account
bankp BANKP Check digit/bnk
bkont BKONT Control Key
swift SWIFT SWIFT/BIC
dtaws DTAWS Instruction Key
dtams DTAMS DME Rec. Code
stcd1 STCD1 Tax Number 1
stcd2 STCD2 Tax Number 2
pskto PSKTO Curr.Acct or Ref.No.
esrnr ESRNR ISR Number
esrre ESRRE ISR/QR Ref.
esrpz ESRPZ Check digit
emfsl EMFSL Payee
zweck DZWECK Purpose
bttyp HRPAD_BTTYP Transfer Type
payty PAYTY Payroll type
payid PAYID Payroll Identifier
ocrsn PAY_OCRSN Off-cycle reas.
bondt BONDT Payment date
bkref BKREF Reference
stras STRAS Street/House
state REGIO Region
debit P00_XDEBIT_INFTY Autom. Debit Auth.
iban IBAN IBAN
adrs_banks LAND1 Country/Reg.
p0009_ei_dummy DUMMY Dummy function in length 1

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 0009 (Bank Details)
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PA0009 (
    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]
    OPKEN,           -- Operation ind. [OPKEN]
    BETRG,           -- Standard Value [PAD_VGBTR]
    WAERS,           -- Pymnt currency [PAD_WAERS]
    ANZHL,           -- Standard Pct. [VGPRO]
    ZEINH,           -- Time unit/meas. [PT_ZEINH]
    BNKSA,           -- Bank detail ty. [BNKSA]
    ZLSCH,           -- Payment Method [PCODE]
    EMFTX,           -- Payee [EMFTX]
    BKPLZ,           -- P.code/city [BKPLZ]
    BKORT,           -- City [ORT01]
    BANKS,           -- Bank Ctry/Reg. [BANKS]
    BANKL,           -- Bank Key [BANKK]
    BANKN,           -- Bank Account [BANKN]
    BANKP,           -- Check digit/bnk [BANKP]
    BKONT,           -- Control Key [BKONT]
    SWIFT,           -- SWIFT/BIC [SWIFT]
    DTAWS,           -- Instruction Key [DTAWS]
    DTAMS,           -- DME Rec. Code [DTAMS]
    STCD1,           -- Tax Number 1 [STCD1]
    STCD2,           -- Tax Number 2 [STCD2]
    PSKTO,           -- Curr.Acct or Ref.No. [PSKTO]
    ESRNR,           -- ISR Number [ESRNR]
    ESRRE,           -- ISR/QR Ref. [ESRRE]
    ESRPZ,           -- Check digit [ESRPZ]
    EMFSL,           -- Payee [EMFSL]
    ZWECK,           -- Purpose [DZWECK]
    BTTYP,           -- Transfer Type [HRPAD_BTTYP]
    PAYTY,           -- Payroll type [PAYTY]
    PAYID,           -- Payroll Identifier [PAYID]
    OCRSN,           -- Off-cycle reas. [PAY_OCRSN]
    BONDT,           -- Payment date [BONDT]
    BKREF,           -- Reference [BKREF]
    STRAS,           -- Street/House [STRAS]
    STATE,           -- Region [REGIO]
    DEBIT,           -- Autom. Debit Auth. [P00_XDEBIT_INFTY]
    IBAN,            -- IBAN [IBAN]
    ADRS_BANKS,      -- Country/Reg. [LAND1]
    P0009_EI_DUMMY,  -- Dummy function in length 1 [DUMMY]
    PRIMARY KEY (MANDT, PERNR, SUBTY, OBJPS, SPRPS, ENDDA, BEGDA, SEQNR)
);

Learn More