1. Home
  2. Resources
  3. SAP Tables
  4. BCA_US_HOLD - Hold Amounts Which Affect Available Balance

SAP Table BCA_US_HOLD

Hold Amounts Which Affect Available Balance

BCA_US_HOLD (Hold Amounts Which Affect Available Balance) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link BCA_US_HOLD to other SAP tables.

BCA_US_HOLD table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
BKKRS Bank Area BKK_BKKRS TBKK01 CHAR 4 0
ACNUM_INT Paying Account Reference-Internal BCA_US_PACINT BKK40 CHAR 10 0
RECORD_ID Record ID Type for Hold Table BCA_US_H_RECORD_ID CHAR 10 0
GROUP_ID Hold Group ID BCA_US_GROUP_ID NUMC 8 0
HOLD_TYPE Hold Type ID BCA_US_HOLD_TYPE TBCA_US_H_TYPE NUMC 2 0
HOLD_CUR Hold Currency BCA_US_HOLD_CUR CUKY 5 0
HOLD_AMOUNT Hold Amount BCA_US_HOLD_AMT CURR 23 2
VALIDFROM Valid From BCA_VALIDFRO DATS 8 0
VALIDTO Valid To Field BCA_VALIDTO DATS 8 0
REF_NUM Hold Reference Number BCA_US_REF_NUM CHAR 30 0
REF_TYPE Hold Reference Type BCA_HOLD_REF_TYPE TBCA_US_R_HOLD CHAR 2 0
HOLD_ACTIVE Hold Active Indicator BCA_US_HOLD_ACTIVE CHAR 1 0
X Yes
NULL No
ISSUE_DATE Date Hold Issued BCA_US_HOLD_ISS_DT DATS 8 0
REMOVE_DATE Date Hold Removed BCA_US_HOLD_REM_DT DATS 8 0
CHANGE_USER Last changed by BKK_CHUSER CHAR 12 0
CHANGE_DATE Changed On BKK_CHDATE DATS 8 0
DELETE_FLG Marked for Deletion BKK_XLIDEL CHAR 1 0
X Yes
NULL No
STATUS Hold Status BCA_HOLD_STATUS CHAR 2 0
01 Active
02 Flagged for Deletion
03 Inactive
04 Active but change in Release
05 Awaiting Approval
DOCNO Item number in current accounts BKK_DOCNO BKKIT NUMC 12 0
POSNO Position in Item BKK_POSNO BKKIT NUMC 3 0
CRUSR User who created the object BKK_CRUSR CHAR 12 0
CRDAT Date on which the object was created BKK_CRDAT DATS 8 0
CRTIM Time at which the object was created BKK_CRTIM TIMS 6 0
CHUSR Last user to change object BKK_CHUSR CHAR 12 0
CHDAT Date on which the object was last changed BKK_CHDAT DATS 8 0
CHTIM Time at Which Object was Last Changed BKK_CHTIM TIMS 6 0
RLUSR User who released object BKK_RLUSR CHAR 12 0
RLDAT Date on which object was released BKK_RLDAT DATS 8 0
RLTIM Time at Which Object Was Released BKK_RLTIM TIMS 6 0

BCA_US_HOLD foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
BCA_US_HOLD ACNUM_INT BCA_US_HOLD MANDT BKK40 Current Account Master Data: General MANDT
BCA_US_HOLD ACNUM_INT BCA_US_HOLD BKKRS BKK40 Current Account Master Data: General BKKRS
BCA_US_HOLD ACNUM_INT BCA_US_HOLD ACNUM_INT BKK40 Current Account Master Data: General ACNUM_INT
BCA_US_HOLD BKKRS BCA_US_HOLD MANDT TBKK01 Bank Area Table MANDT
BCA_US_HOLD BKKRS BCA_US_HOLD BKKRS TBKK01 Bank Area Table BKKRS
BCA_US_HOLD DOCNO BCA_US_HOLD BKKRS BKKIT Payment Item BKKRS
BCA_US_HOLD DOCNO BCA_US_HOLD DOCNO BKKIT Payment Item DOCNO
BCA_US_HOLD DOCNO BCA_US_HOLD POSNO BKKIT Payment Item POSNO
BCA_US_HOLD DOCNO SYST MANDT BKKIT Payment Item MANDT
BCA_US_HOLD HOLD_TYPE SYST MANDT TBCA_US_H_TYPE Hold Types Table MANDT
BCA_US_HOLD HOLD_TYPE BCA_US_HOLD HOLD_TYPE TBCA_US_H_TYPE Hold Types Table HOLD_TYPE
BCA_US_HOLD POSNO BCA_US_HOLD POSNO BKKIT Payment Item POSNO
BCA_US_HOLD POSNO SYST MANDT BKKIT Payment Item MANDT
BCA_US_HOLD POSNO BCA_US_HOLD BKKRS BKKIT Payment Item BKKRS
BCA_US_HOLD POSNO BCA_US_HOLD DOCNO BKKIT Payment Item DOCNO
BCA_US_HOLD REF_TYPE BCA_US_HOLD REF_TYPE TBCA_US_R_HOLD Refrence adjustment types that can be created REF_TYPE
BCA_US_HOLD REF_TYPE SYST MANDT TBCA_US_R_HOLD Refrence adjustment types that can be created MANDT
BCA_US_HOLD REF_TYPE BCA_US_HOLD HOLD_TYPE TBCA_US_R_HOLD Refrence adjustment types that can be created HOLD_TYPE