ICL_BS_BP_B
Generated Table for View
ICL_BS_BP_B is an SAP database table in S/4HANA. Generated Table for View. It contains 15 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| SHSM_ICL_BS_BP_B | view | from | Suchhilfeview fur ICL_SBRBNDL_BPARTNER |
Fields (15)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | client | MANDT | Client | |||
| KEY | active | ICL_ACTIVE | Active/Suspense | |||
| KEY | ccevent | ICL_CCEVENT | Claim Bundle | |||
| KEY | role | ICL_ROLE | ParticipantRole | |||
| KEY | bpartner | ICL_PART | Participant | |||
| descrip | ICL_DESCRIP | Participant | ||||
| type | ICLE_CCEVENTTYP | Cat.of ClmBType | ||||
| cctype | ICL_CCEVENTCAT | Clm Bundle Type | ||||
| subtype | ICL_CCEVENTTY | ClmBndleSubType | ||||
| ccsbrtype | ICL_CCSBRTYPE | SubroClaim Type | ||||
| rangefrom | ICL_CCEVENTFROM | Date From | ||||
| status | ICLE_BUNDLE_STATUS_D | Status | ||||
| createdby | ICL_CREATEDBY | Created By | ||||
| changedby | ICL_CHANGEDBY | Changed By | ||||
| changetime | ICL_CHANGEUTC1 | Changed On |
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.
-- Generated Table for View
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ICL_BS_BP_B (
CLIENT, -- Client [MANDT]
ACTIVE, -- Active/Suspense [ICL_ACTIVE]
CCEVENT, -- Claim Bundle [ICL_CCEVENT]
ROLE, -- ParticipantRole [ICL_ROLE]
BPARTNER, -- Participant [ICL_PART]
DESCRIP, -- Participant [ICL_DESCRIP]
TYPE, -- Cat.of ClmBType [ICLE_CCEVENTTYP]
CCTYPE, -- Clm Bundle Type [ICL_CCEVENTCAT]
SUBTYPE, -- ClmBndleSubType [ICL_CCEVENTTY]
CCSBRTYPE, -- SubroClaim Type [ICL_CCSBRTYPE]
RANGEFROM, -- Date From [ICL_CCEVENTFROM]
STATUS, -- Status [ICLE_BUNDLE_STATUS_D]
CREATEDBY, -- Created By [ICL_CREATEDBY]
CHANGEDBY, -- Changed By [ICL_CHANGEDBY]
CHANGETIME, -- Changed On [ICL_CHANGEUTC1]
PRIMARY KEY (CLIENT, ACTIVE, CCEVENT, ROLE, BPARTNER)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA