PAYRQP
PAYRQ-Erweiterung (Länderübergreifende Bankkontenüberträge)
PAYRQP is an SAP database table in S/4HANA. PAYRQ-Erweiterung (Länderübergreifende Bankkontenüberträge). It contains 14 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_MakeBkTransfWithFilter | view | left_outer | BASIC | Items of Track Bank Transfer |
| P_MBTTARGETBANKACCOUNTINFO | view_entity | left_outer | BASIC | target bank account information |
Fields (14)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | mandt | Client | |||
| KEY | keyno | prq_keyno | Key Number | |||
| bukrs | bukrs | Company Code | ||||
| gsber | gsber | Business Area | ||||
| koart | koart | Account type | ||||
| parno | prq_parno | Business partner | ||||
| hkont | hkont | G/L Acct | ||||
| ggrup | prq_zhkont | Bank Account | ||||
| zuonr | dzuonr | Assignment | ||||
| crval | prq_crval | Value date payee | ||||
| bvorg | bvorg | Cross-CC Number | ||||
| cpudt | cpudt | Entered On | ||||
| laufd | laufd | Run On | ||||
| laufi | laufi | Identification |
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.
-- PAYRQ-Erweiterung (Länderübergreifende Bankkontenüberträge)
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PAYRQP (
MANDT, -- Client [mandt]
KEYNO, -- Key Number [prq_keyno]
BUKRS, -- Company Code [bukrs]
GSBER, -- Business Area [gsber]
KOART, -- Account type [koart]
PARNO, -- Business partner [prq_parno]
HKONT, -- G/L Acct [hkont]
GGRUP, -- Bank Account [prq_zhkont]
ZUONR, -- Assignment [dzuonr]
CRVAL, -- Value date payee [prq_crval]
BVORG, -- Cross-CC Number [bvorg]
CPUDT, -- Entered On [cpudt]
LAUFD, -- Run On [laufd]
LAUFI, -- Identification [laufi]
PRIMARY KEY (MANDT, KEYNO)
);
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