I_HCMBankData

DDL: I_HCMBANKDATA Type: view_entity BASIC
57 Fields 1 Data Sources 1 Associations

HCM Bank Data

I_HCMBankData is a Basic CDS View that provides data about "HCM Bank Data" in SAP S/4HANA. It reads from 1 data source (pa0009) and exposes 57 fields with key fields HCMPersonnelNumber, HCMSubtype, HCMObjectIdentification, HCMRecordIsLocked, EndDate. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
pa0009 pa0009 from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_Currency _Currency $projection.Currency = _Currency.Currency

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label HCM Bank Data view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #BASIC view

Fields (57)

KeyFieldSource TableSource FieldDescription
KEY HCMPersonnelNumber pernr Personnel no.
KEY HCMSubtype subty Subtype
KEY HCMObjectIdentification objps Object ID
KEY HCMRecordIsLocked sprps Single-Character Flag
KEY EndDate endda Valid To
KEY StartDate begda Valid From
KEY HCMSequentialNumber seqnr Tank ID
LastChangedDate aedtm Changed On
LastChangedByUser uname User Name
HCMInfoTypeRecordIsHistorical histo Historical rec.
HCMInfoTypeRecordHasText itxex Text exists
HCMInfoTypeRecordHasRefField refex Single-Character Flag
HCMInfoTypeRecordHasConfField ordex Single-Character Flag
HCMInfoTypeRecordScreenCtrl itbld Screen control
HCMMasterDataChangeReason preas Change Reason
HCMInfoTypeRecordRsrvdFld1 flag1 Text field length 1
HCMInfoTypeRecordRsrvdFld2 flag2 Tr. Evaluation
HCMInfoTypeRecordRsrvdFld3 flag3 Text field length 1
HCMInfoTypeRecordRsrvdFld4 flag4 Usage in the OWN Authorization Context
HCMInfoTypeRecordRsrvdFld1Len2 rese1 Reserved Field/Unused Field of Length 2
HCMInfoTypeRecordRsrvdFld2Len2 rese2 Reserved Field/Unused Field of Length 2
HCMGrpgValForPersAssignments grpvl Grouping Value
HCMBankDetailsType bnksa Bank detail ty.
HCMBankDetailsSalaryPortionAmt betrg Standard Value
Currency waers Transaction Currency
HCMBankDetailsSalaryPortnPct anzhl Standard Pct.
HCMUnitOfMeasure zeinh Time unit/meas.
HCMPayeeKey emfsl Payee
HCMPayeeName emftx Payee
HCMPayeeCountryCode adrs_banks Country/Reg.
HCMPayeeRegion state Vehicle Region
HCMPayeePostalCode bkplz P.code/city
HCMPayeeCityName bkort City
HCMPayeeStreet stras Street/House
BankCountry banks Bank Ctry/Rgn. Key
BankNumber bankl House Bank
SWIFTCode swift SWIFT/BIC
BankAccount bankn Bank acct
ReferenceBankDetails bkref Reference
BankControlKey bkont To Account
HCMInternationalBankAcctNumber iban IBAN House Bank
DataExchangeInstructionKey dtaws Instruction Key
DataMediumExchangeControl dtams DME Rec. Code
TaxID1 stcd1 Tax Number 1
TaxID2 stcd2 Tax Number 2
PostOfficeBankAccount pskto Postal chk acct
PaytSlipWthRefSubscriber esrnr not in use
PaytSlipWthRefReference esrre not in use
PaytSlipWthRefCheckDigit esrpz not in use
PaymentMethod zlsch Pymt Meth.
HCMBankTransferPurposeText zweck Purpose
HCMPayrollType payty Payroll type
HCMPayrollOffCycleID payid Payroll Identifier
HCMPayrollOffCycleReason ocrsn Off-cycle reas.
HCMPayrollOffCyclePaymentDate bondt Payment date
HCMBankDetsHasDrctDebitAuthzn debit Autom. Debit Auth.
_Currency _Currency

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_HCMBankData.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_HCMBankData AS
SELECT
  pernr AS HCMPersonnelNumber,
  subty AS HCMSubtype,
  objps AS HCMObjectIdentification,
  sprps AS HCMRecordIsLocked,
  endda AS EndDate,
  begda AS StartDate,
  seqnr AS HCMSequentialNumber,
  aedtm AS LastChangedDate,
  uname AS LastChangedByUser,
  histo AS HCMInfoTypeRecordIsHistorical,
  itxex AS HCMInfoTypeRecordHasText,
  refex AS HCMInfoTypeRecordHasRefField,
  ordex AS HCMInfoTypeRecordHasConfField,
  itbld AS HCMInfoTypeRecordScreenCtrl,
  preas AS HCMMasterDataChangeReason,
  flag1 AS HCMInfoTypeRecordRsrvdFld1,
  flag2 AS HCMInfoTypeRecordRsrvdFld2,
  flag3 AS HCMInfoTypeRecordRsrvdFld3,
  flag4 AS HCMInfoTypeRecordRsrvdFld4,
  rese1 AS HCMInfoTypeRecordRsrvdFld1Len2,
  rese2 AS HCMInfoTypeRecordRsrvdFld2Len2,
  grpvl AS HCMGrpgValForPersAssignments,
  bnksa AS HCMBankDetailsType,
  betrg AS HCMBankDetailsSalaryPortionAmt,
  waers AS Currency,
  anzhl AS HCMBankDetailsSalaryPortnPct,
  zeinh AS HCMUnitOfMeasure,
  emfsl AS HCMPayeeKey,
  emftx AS HCMPayeeName,
  adrs_banks AS HCMPayeeCountryCode,
  state AS HCMPayeeRegion,
  bkplz AS HCMPayeePostalCode,
  bkort AS HCMPayeeCityName,
  stras AS HCMPayeeStreet,
  banks AS BankCountry,
  bankl AS BankNumber,
  swift AS SWIFTCode,
  bankn AS BankAccount,
  bkref AS ReferenceBankDetails,
  bkont AS BankControlKey,
  iban AS HCMInternationalBankAcctNumber,
  dtaws AS DataExchangeInstructionKey,
  dtams AS DataMediumExchangeControl,
  stcd1 AS TaxID1,
  stcd2 AS TaxID2,
  pskto AS PostOfficeBankAccount,
  esrnr AS PaytSlipWthRefSubscriber,
  esrre AS PaytSlipWthRefReference,
  esrpz AS PaytSlipWthRefCheckDigit,
  zlsch AS PaymentMethod,
  zweck AS HCMBankTransferPurposeText,
  payty AS HCMPayrollType,
  payid AS HCMPayrollOffCycleID,
  ocrsn AS HCMPayrollOffCycleReason,
  bondt AS HCMPayrollOffCyclePaymentDate,
  debit AS HCMBankDetsHasDrctDebitAuthzn
FROM pa0009
LEFT OUTER JOIN I_Currency AS _Currency ON Currency = _Currency.Currency  -- association [0..1]
;

Learn More