OIU_RV_PDXSS
Settlement Statements/Purchaser - DOI Cross Reference
OIU_RV_PDXSS is an SAP database table in S/4HANA. Settlement Statements/Purchaser - DOI Cross Reference. It contains 11 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_PRASettlmtStmntPurrDOICrsRef | view_entity | from | BASIC | Settlmt Stmnts Purchaser DOI Cross Ref |
Fields (11)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | mandt | Client | |||
| KEY | pu_no | oiu_pu_no | Purchaser | |||
| KEY | pu_vname | oiu_pu_jv_name | Purch Lease No | |||
| KEY | pu_matnr | oiu_pu_matnr | Xref Mat | |||
| KEY | eff_from_dt | oiu_eff_from_dt | Effective From | |||
| eff_to_dt | oiu_eff_to_dt | Effective To | ||||
| bukrs | bukrs | Company Code | ||||
| matnr | matnr | Material | ||||
| vname | jv_name | Joint venture | ||||
| doi_no | oiu_doi_no | Venture/DOI | ||||
| ct_no | oiu_ct_no | Contract |
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.
-- Settlement Statements/Purchaser - DOI Cross Reference
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIU_RV_PDXSS (
MANDT, -- Client [mandt]
PU_NO, -- Purchaser [oiu_pu_no]
PU_VNAME, -- Purch Lease No [oiu_pu_jv_name]
PU_MATNR, -- Xref Mat [oiu_pu_matnr]
EFF_FROM_DT, -- Effective From [oiu_eff_from_dt]
EFF_TO_DT, -- Effective To [oiu_eff_to_dt]
BUKRS, -- Company Code [bukrs]
MATNR, -- Material [matnr]
VNAME, -- Joint venture [jv_name]
DOI_NO, -- Venture/DOI [oiu_doi_no]
CT_NO, -- Contract [oiu_ct_no]
PRIMARY KEY (MANDT, PU_NO, PU_VNAME, PU_MATNR, EFF_FROM_DT)
);
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