HRFIO_D_BDHU_D

Transparent Table Application Table
68 Fields 1 CDS Views

Draft table for entity I_HU_HCM_ESSBANKDATATP

HRFIO_D_BDHU_D is an SAP database table in S/4HANA. Draft table for entity I_HU_HCM_ESSBANKDATATP. It contains 68 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_HU_HCM_ESSBankDataDraft view_entity from BASIC My Bank Data HU - Draft

Fields (68)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY hcmpersonnelnumber PERSNO Personnel No.
KEY hcmsubtype SUBTY Subtype
KEY hcmobjectidentification OBJPS Object ID
KEY hcmrecordislocked SPRPS Lock indicator
KEY enddate ENDDA End Date
KEY startdate BEGDA Start Date
KEY hcmsequentialnumber SEQNR IT record no.
KEY hcmdraftsequentialnumber HRFIO_PER_DRAFT_SEQ_NUMBER Sequential Number
lastchangeddate AEDAT Changed On
lastchangedbyuser AENAM Changed By
hcminfotyperecordhastext ITXEX Text exists
hcminfotyperecordscreenctrl ITBLD Screen control
hcmsubtypetext SBTTX Name
hcmetag SYSUUID_C32 UUID
hcmvaliditystartdate HRFIO_PER_VALID_FROM Valid from
hcmvalidityenddate HRFIO_PER_VALID_TO Valid to
hcmdefaultdate SYDATUM Current Date
hcmrecordisstoredindatabase ABAP_BOOLEAN Truth Value
hcmvaliditystartdatefieldctrl INT1 INT1
hcminfotypeversion abap.char
hcmcountryregiongrouping MOLGA HCM Local.
hcmbankdetailssalaryportionamt PAD_VGBTR Standard Value
currency PAD_WAERS Pymnt currency
hcmbankdetailssalaryportnpct VGPRO Standard Pct.
hcmunitofmeasure PT_ZEINH Time unit/meas.
hcmbankdetailstype BNKSA Bank detail ty.
paymentmethod PCODE Payment Method
paymentmethodname TEXT1 Text
hcmpayeename EMFTX Payee
hcmpayeepostalcode PSTLZ Postal Code
hcmpayeecityname ORT01 City
bankcountry BANKS Bank Ctry/Reg.
banknumber BANKK Bank Key
bankaccount BANKN Bank Account
bankcontrolkey BKONT Control Key
swiftcode SWIFT SWIFT/BIC
dataexchangeinstructionkey DTAWS Instruction Key
datamediumexchangecontrol DTAMS DME Rec. Code
taxid1 STCD1 Tax Number 1
taxid2 STCD2 Tax Number 2
postofficebankaccount PSKTO Curr.Acct or Ref.No.
paytslipwthrefsubscriber ESRNR ISR Number
paytslipwthrefreference ESRRE ISR/QR Ref.
paytslipwthrefcheckdigit ESRPZ Check digit
hcmpayeekey EMFSL Payee
hcmbanktransferpurposetext DZWECK Purpose
hcmpayrolltype PAYTY Payroll type
hcmpayrolloffcycleid PAYID Payroll Identifier
hcmpayrolloffcyclereason PAY_OCRSN Off-cycle reas.
hcmpayrolloffcyclepaymentdate BONDT Payment date
referencebankdetails BKREF Reference
hcmpayeestreet STRAS Street/House
hcmpayeeregion REGIO Region
hcmpayeeregionname BEZEI20 Description
hcmbankdetshasdrctdebitauthzn P00_XDEBIT_INFTY Autom. Debit Auth.
hcminternationalbankacctnumber IBAN IBAN
hcmbankdatasubtype0ishidden ABAP_BOOLEAN Truth Value
hcmbankdatasubtype1ishidden ABAP_BOOLEAN Truth Value
hcmbankdatasubtype2ishidden ABAP_BOOLEAN Truth Value
hcmdefaultisoverwritten ABAP_BOOLEAN Truth Value
draftentitycreationdatetime SYCH_BDL_DRAFT_CREATED_AT Draft Created
draftentitylastchangedatetime SYCH_BDL_DRAFT_LAST_CHANGED_AT Draft Changed
draftadministrativedatauuid SYCH_BDL_DRAFT_ADMIN_UUID Admin. UUID
draftentityoperationcode SYCH_BDL_DRAFT_OPERATION_CODE Operation Code
hasactiveentity SYCH_BDL_DRAFT_HASACTIVE Has active
draftfieldchanges SYCH_BDL_DRAFT_FIELD_CHANGES Draft Changes
component_to_be_changed abap.strg

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.

-- Draft table for entity I_HU_HCM_ESSBANKDATATP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE HRFIO_D_BDHU_D (
    MANDT,                           -- Client [MANDT]
    HCMPERSONNELNUMBER,              -- Personnel No. [PERSNO]
    HCMSUBTYPE,                      -- Subtype [SUBTY]
    HCMOBJECTIDENTIFICATION,         -- Object ID [OBJPS]
    HCMRECORDISLOCKED,               -- Lock indicator [SPRPS]
    ENDDATE,                         -- End Date [ENDDA]
    STARTDATE,                       -- Start Date [BEGDA]
    HCMSEQUENTIALNUMBER,             -- IT record no. [SEQNR]
    HCMDRAFTSEQUENTIALNUMBER,        -- Sequential Number [HRFIO_PER_DRAFT_SEQ_NUMBER]
    LASTCHANGEDDATE,                 -- Changed On [AEDAT]
    LASTCHANGEDBYUSER,               -- Changed By [AENAM]
    HCMINFOTYPERECORDHASTEXT,        -- Text exists [ITXEX]
    HCMINFOTYPERECORDSCREENCTRL,     -- Screen control [ITBLD]
    HCMSUBTYPETEXT,                  -- Name [SBTTX]
    HCMETAG,                         -- UUID [SYSUUID_C32]
    HCMVALIDITYSTARTDATE,            -- Valid from [HRFIO_PER_VALID_FROM]
    HCMVALIDITYENDDATE,              -- Valid to [HRFIO_PER_VALID_TO]
    HCMDEFAULTDATE,                  -- Current Date [SYDATUM]
    HCMRECORDISSTOREDINDATABASE,     -- Truth Value [ABAP_BOOLEAN]
    HCMVALIDITYSTARTDATEFIELDCTRL,   -- INT1 [INT1]
    HCMINFOTYPEVERSION,              -- abap.char
    HCMCOUNTRYREGIONGROUPING,        -- HCM Local. [MOLGA]
    HCMBANKDETAILSSALARYPORTIONAMT,  -- Standard Value [PAD_VGBTR]
    CURRENCY,                        -- Pymnt currency [PAD_WAERS]
    HCMBANKDETAILSSALARYPORTNPCT,    -- Standard Pct. [VGPRO]
    HCMUNITOFMEASURE,                -- Time unit/meas. [PT_ZEINH]
    HCMBANKDETAILSTYPE,              -- Bank detail ty. [BNKSA]
    PAYMENTMETHOD,                   -- Payment Method [PCODE]
    PAYMENTMETHODNAME,               -- Text [TEXT1]
    HCMPAYEENAME,                    -- Payee [EMFTX]
    HCMPAYEEPOSTALCODE,              -- Postal Code [PSTLZ]
    HCMPAYEECITYNAME,                -- City [ORT01]
    BANKCOUNTRY,                     -- Bank Ctry/Reg. [BANKS]
    BANKNUMBER,                      -- Bank Key [BANKK]
    BANKACCOUNT,                     -- Bank Account [BANKN]
    BANKCONTROLKEY,                  -- Control Key [BKONT]
    SWIFTCODE,                       -- SWIFT/BIC [SWIFT]
    DATAEXCHANGEINSTRUCTIONKEY,      -- Instruction Key [DTAWS]
    DATAMEDIUMEXCHANGECONTROL,       -- DME Rec. Code [DTAMS]
    TAXID1,                          -- Tax Number 1 [STCD1]
    TAXID2,                          -- Tax Number 2 [STCD2]
    POSTOFFICEBANKACCOUNT,           -- Curr.Acct or Ref.No. [PSKTO]
    PAYTSLIPWTHREFSUBSCRIBER,        -- ISR Number [ESRNR]
    PAYTSLIPWTHREFREFERENCE,         -- ISR/QR Ref. [ESRRE]
    PAYTSLIPWTHREFCHECKDIGIT,        -- Check digit [ESRPZ]
    HCMPAYEEKEY,                     -- Payee [EMFSL]
    HCMBANKTRANSFERPURPOSETEXT,      -- Purpose [DZWECK]
    HCMPAYROLLTYPE,                  -- Payroll type [PAYTY]
    HCMPAYROLLOFFCYCLEID,            -- Payroll Identifier [PAYID]
    HCMPAYROLLOFFCYCLEREASON,        -- Off-cycle reas. [PAY_OCRSN]
    HCMPAYROLLOFFCYCLEPAYMENTDATE,   -- Payment date [BONDT]
    REFERENCEBANKDETAILS,            -- Reference [BKREF]
    HCMPAYEESTREET,                  -- Street/House [STRAS]
    HCMPAYEEREGION,                  -- Region [REGIO]
    HCMPAYEEREGIONNAME,              -- Description [BEZEI20]
    HCMBANKDETSHASDRCTDEBITAUTHZN,   -- Autom. Debit Auth. [P00_XDEBIT_INFTY]
    HCMINTERNATIONALBANKACCTNUMBER,  -- IBAN [IBAN]
    HCMBANKDATASUBTYPE0ISHIDDEN,     -- Truth Value [ABAP_BOOLEAN]
    HCMBANKDATASUBTYPE1ISHIDDEN,     -- Truth Value [ABAP_BOOLEAN]
    HCMBANKDATASUBTYPE2ISHIDDEN,     -- Truth Value [ABAP_BOOLEAN]
    HCMDEFAULTISOVERWRITTEN,         -- Truth Value [ABAP_BOOLEAN]
    DRAFTENTITYCREATIONDATETIME,     -- Draft Created [SYCH_BDL_DRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,   -- Draft Changed [SYCH_BDL_DRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,     -- Admin. UUID [SYCH_BDL_DRAFT_ADMIN_UUID]
    DRAFTENTITYOPERATIONCODE,        -- Operation Code [SYCH_BDL_DRAFT_OPERATION_CODE]
    HASACTIVEENTITY,                 -- Has active [SYCH_BDL_DRAFT_HASACTIVE]
    DRAFTFIELDCHANGES,               -- Draft Changes [SYCH_BDL_DRAFT_FIELD_CHANGES]
    COMPONENT_TO_BE_CHANGED,         -- abap.strg
    PRIMARY KEY (MANDT, HCMPERSONNELNUMBER, HCMSUBTYPE, HCMOBJECTIDENTIFICATION, HCMRECORDISLOCKED, ENDDATE, STARTDATE, HCMSEQUENTIALNUMBER, HCMDRAFTSEQUENTIALNUMBER)
);

Learn More