WBHP
Trading Contract: Partner Assignment
WBHP is an SAP database table in S/4HANA. Trading Contract: Partner Assignment. It contains 37 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_TradingContractPartnerDets | view | from | BASIC | Interface view for Trading Contract Partner details |
| R_TrdgDocPartnerBasic | view_entity | from | BASIC | Partner of Trading Document |
Fields (37)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | tkonn | TKONN | Trading Contract | |||
| KEY | tposn | TPOSN | Item Number | |||
| KEY | tposn_sub | TPOSN_SUB | Subitem | |||
| KEY | parvw | PARVW | Partner Functn | |||
| KEY | parza | PARZA | Partner counter | |||
| ernam | ERNAM | Created By | ||||
| erdat | ERDAT | Created On | ||||
| lifnr | LIFN2 | Ref. to suplr | ||||
| kunnr | KUNN2 | Customer | ||||
| defpa | DEFPA | Default Partner | ||||
| parnr | PARNR | Contact Person | ||||
| pernr | PERNR_D | Personnel No. | ||||
| adrnr | ADRNR | Address | ||||
| adrda | ADRDA | Adress ind. | ||||
| _dataaging | DATA_TEMPERATURE | Data Aging | ||||
| assigned_bp | BU_PARTNER | Busn. Partner | ||||
| addr_operation | SD_ADDR_OPERATION | Address Detn | ||||
| addr_type | AD_ADRTYPE | Address Type | ||||
| adrnp | AD_PERSNUM | Person Number | ||||
| bp_ref_adrnr | SDPD_BP_REF_ADDRNUM | BP Ref. Address Num. | ||||
| histunr | HISTUNR | Hierarchy level | ||||
| stcd1 | STCD1 | Tax Number 1 | ||||
| stcd2 | STCD2 | Tax Number 2 | ||||
| stcd3 | STCD3 | Tax Number 3 | ||||
| stcd4 | STCD4 | Tax Number 4 | ||||
| stkzn | STKZN | Natural person | ||||
| stcdt | J_1ATOID | Tax number type | ||||
| j_1kfrepre | REPRES | Rep's Name | ||||
| j_1kftbus | GESTYP | Type of Business | ||||
| j_1kftind | INDTYP | Type of Industry | ||||
| ablad | ABLAD | Unloading Point | ||||
| hityp_sd | HITYP_KH | Hierarchy type | ||||
| hityp_mm | HITYP_LH | Hierarchy Cat. | ||||
| prfre | PRFRE | Price determin. | ||||
| bokre | BOKRE | Rebate | ||||
| bolre | BOLRE | Subseq. sett. |
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.
-- Trading Contract: Partner Assignment
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE WBHP (
MANDT, -- Client [MANDT]
TKONN, -- Trading Contract [TKONN]
TPOSN, -- Item Number [TPOSN]
TPOSN_SUB, -- Subitem [TPOSN_SUB]
PARVW, -- Partner Functn [PARVW]
PARZA, -- Partner counter [PARZA]
ERNAM, -- Created By [ERNAM]
ERDAT, -- Created On [ERDAT]
LIFNR, -- Ref. to suplr [LIFN2]
KUNNR, -- Customer [KUNN2]
DEFPA, -- Default Partner [DEFPA]
PARNR, -- Contact Person [PARNR]
PERNR, -- Personnel No. [PERNR_D]
ADRNR, -- Address [ADRNR]
ADRDA, -- Adress ind. [ADRDA]
_DATAAGING, -- Data Aging [DATA_TEMPERATURE]
ASSIGNED_BP, -- Busn. Partner [BU_PARTNER]
ADDR_OPERATION, -- Address Detn [SD_ADDR_OPERATION]
ADDR_TYPE, -- Address Type [AD_ADRTYPE]
ADRNP, -- Person Number [AD_PERSNUM]
BP_REF_ADRNR, -- BP Ref. Address Num. [SDPD_BP_REF_ADDRNUM]
HISTUNR, -- Hierarchy level [HISTUNR]
STCD1, -- Tax Number 1 [STCD1]
STCD2, -- Tax Number 2 [STCD2]
STCD3, -- Tax Number 3 [STCD3]
STCD4, -- Tax Number 4 [STCD4]
STKZN, -- Natural person [STKZN]
STCDT, -- Tax number type [J_1ATOID]
J_1KFREPRE, -- Rep's Name [REPRES]
J_1KFTBUS, -- Type of Business [GESTYP]
J_1KFTIND, -- Type of Industry [INDTYP]
ABLAD, -- Unloading Point [ABLAD]
HITYP_SD, -- Hierarchy type [HITYP_KH]
HITYP_MM, -- Hierarchy Cat. [HITYP_LH]
PRFRE, -- Price determin. [PRFRE]
BOKRE, -- Rebate [BOKRE]
BOLRE, -- Subseq. sett. [BOLRE]
PRIMARY KEY (MANDT, TKONN, TPOSN, TPOSN_SUB, PARVW, PARZA)
);
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