BCA_US_HOLD SAP (Hold Amounts Which Affect Available Balance) Table details
Dictionary Type: Table
Description: Hold Amounts Which Affect Available Balance
Description: Hold Amounts Which Affect Available Balance
Table field list including key, data, relationships and ABAP select examples
BCA_US_HOLD is a standard SAP Table which is used to store Hold Amounts Which Affect Available Balance data and is available within R/3 SAP systems depending on the version and release level.
The BCA_US_HOLD table consists of various fields, each holding specific information or linking keys about Hold Amounts Which Affect Available Balance data available in SAP. These include BKKRS (Bank Area), ACNUM_INT (Paying Account Reference-Internal), RECORD_ID (Record ID Type for Hold Table), GROUP_ID (Hold Group ID).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP BCA_US_HOLD table fields - Full list of fields found in SAP data dictionary
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
| MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
| BKKRS | Bank Area | BKK_BKKRS | CHAR | 4 | TBKK01 | BKK_BKKRS | BNS | ||
| ACNUM_INT | Paying Account Reference-Internal | BCA_US_PACINT | CHAR | 10 | BKK40 | ALPHA | BKK_ACCNT | ||
| RECORD_ID | Record ID Type for Hold Table | BCA_US_H_RECORD_ID | CHAR | 10 | BCA_US_H_RECORD_ID | ||||
| GROUP_ID | Hold Group ID | BCA_US_GROUP_ID | NUMC | 8 | BCA_US_GROUP_ID | ||||
| HOLD_TYPE | Hold Type ID | BCA_US_HOLD_TYPE | NUMC | 2 | TBCA_US_H_TYPE | BCA_US_HOLD_TYPE | |||
| HOLD_CUR | Hold Currency | BCA_US_HOLD_CUR | CUKY | 5 | Assigned to domain | SYCURR | |||
| HOLD_AMOUNT | Hold Amount | BCA_US_HOLD_AMT | CURR | 23(2) | BKK_TOAMT | ||||
| VALIDFROM | Valid From | BCA_VALIDFRO | DATS | 8 | DATUM | ||||
| VALIDTO | Valid To Field | BCA_VALIDTO | DATS | 8 | BCA_VALIDTO | ||||
| REF_NUM | Hold Reference Number | BCA_US_REF_NUM | CHAR | 30 | BCA_US_REF_NUM | ||||
| REF_TYPE | Hold Reference Type | BCA_HOLD_REF_TYPE | CHAR | 2 | TBCA_US_R_HOLD | BCA_HOLD_REF_TYPE | |||
| HOLD_ACTIVE | Hold Active Indicator | BCA_US_HOLD_ACTIVE | CHAR | 1 | XFELD | ||||
| ISSUE_DATE | Date Hold Issued | BCA_US_HOLD_ISS_DT | DATS | 8 | DATUM | ||||
| REMOVE_DATE | Date Hold Removed | BCA_US_HOLD_REM_DT | DATS | 8 | DATUM | ||||
| CHANGE_USER | Last changed by | BKK_CHUSER | CHAR | 12 | SYCHAR12 | ||||
| CHANGE_DATE | Changed On | BKK_CHDATE | DATS | 8 | DATUM | ||||
| DELETE_FLG | Marked for Deletion | BKK_XLIDEL | CHAR | 1 | X | ||||
| STATUS | Hold Status | BCA_HOLD_STATUS | CHAR | 2 | BCA_HOLD_STATUS | ||||
| DOCNO | Item number in current accounts | BKK_DOCNO | NUMC | 12 | BKKIT | BKK_DOCNO | DOCNO | ||
| POSNO | Position in Item | BKK_POSNO | NUMC | 3 | BKKIT | BKK_POSNO | POSNO | ||
| CRUSR | User who created the object | BKK_CRUSR | CHAR | 12 | USNAM | ||||
| CRDAT | Date on which the object was created | BKK_CRDAT | DATS | 8 | DATUM | ||||
| CRTIM | Time at which the object was created | BKK_CRTIM | TIMS | 6 | UZEIT | ||||
| CHUSR | Last user to change object | BKK_CHUSR | CHAR | 12 | USNAM | ||||
| CHDAT | Date on which the object was last changed | BKK_CHDAT | DATS | 8 | DATUM | ||||
| CHTIM | Time at Which Object was Last Changed | BKK_CHTIM | TIMS | 6 | UZEIT | ||||
| RLUSR | User who released object | BKK_RLUSR | CHAR | 12 | USNAM | ||||
| RLDAT | Date on which object was released | BKK_RLDAT | DATS | 8 | DATUM | ||||
| RLTIM | Time at Which Object Was Released | BKK_RLTIM | TIMS | 6 | UZEIT |
| Key field | Non-key field |
How do I retrieve data from SAP table BCA_US_HOLD using ABAP code
The following ABAP code Example will allow you to do a basic selection on BCA_US_HOLD to SELECT all data from the tableDATA: WA_BCA_US_HOLD TYPE BCA_US_HOLD.
SELECT SINGLE *
FROM BCA_US_HOLD
INTO CORRESPONDING FIELDS OF WA_BCA_US_HOLD
WHERE...
How to access SAP table BCA_US_HOLD
Within an ECC or HANA version of SAP you can also view further information about BCA_US_HOLD and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects