BP3100
Additional information
BP3100 is an SAP database table in S/4HANA. Additional information. It contains 15 fields. 6 CDS views read from this table.
CDS Views using this table (6)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_CreditAccountAdditionalInfo | view | from | BASIC | Credit Account Additional Information |
| R_CrdtMAcctTmpLimitIncr | view | from | BASIC | Credit Mgmt Acct: Temp. Limit Increase |
| R_CrdtMBPCollateral | view | from | BASIC | Credit Mgmt: BP Collateral |
| R_CrdtMBPCreditInsurance | view | from | BASIC | Credit Mgmt: BP Credit Insurance |
| R_CrdtMBPNegativeEvent | view | from | BASIC | Credit Mgmt: Negative Event |
| R_CrdtMBPSpprsdCheckStep | view_entity | from | BASIC | Credit Mgmt: BP Suppressed Check Step |
Fields (15)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | partner | BP_PARTNER | Bus Partner Number | |||
| KEY | criter | BP_CRITER | Criterion | |||
| KEY | addtype | BP_ADDTYPE | Information Category | |||
| KEY | data_type | BP_DATA_TYPE | Information Type | |||
| KEY | timestamp | TZNTSTMPS | Time Stamp | |||
| KEY | counter | BP_COUNTER | Counter | |||
| ct_field | BP_CT_FIELD | Field wth Input Help | ||||
| xfeld | BP_XFELD | Indicator | ||||
| text | BP_TEXT | Text Field | ||||
| amnt | BP_AMNT | Amount | ||||
| curr | BP_CURR | Currency | ||||
| datefr | BP_DATEFR | Valid-From Date | ||||
| dateto | BP_DATETO | Valid-To Date | ||||
| addate | BP_ADDATE | Date |
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.
-- Additional information
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE BP3100 (
MANDT, -- Client [MANDT]
PARTNER, -- Bus Partner Number [BP_PARTNER]
CRITER, -- Criterion [BP_CRITER]
ADDTYPE, -- Information Category [BP_ADDTYPE]
DATA_TYPE, -- Information Type [BP_DATA_TYPE]
TIMESTAMP, -- Time Stamp [TZNTSTMPS]
COUNTER, -- Counter [BP_COUNTER]
CT_FIELD, -- Field wth Input Help [BP_CT_FIELD]
XFELD, -- Indicator [BP_XFELD]
TEXT, -- Text Field [BP_TEXT]
AMNT, -- Amount [BP_AMNT]
CURR, -- Currency [BP_CURR]
DATEFR, -- Valid-From Date [BP_DATEFR]
DATETO, -- Valid-To Date [BP_DATETO]
ADDATE, -- Date [BP_ADDATE]
PRIMARY KEY (MANDT, PARTNER, CRITER, ADDTYPE, DATA_TYPE, TIMESTAMP, COUNTER)
);
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