PCEC
Vornumerierte Schecks
PCEC is an SAP database table in S/4HANA. Vornumerierte Schecks. It contains 15 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| E_Apcheckbook | view | from | EXTENSION | CDS view Checkbook extensibility |
| P_APCheckbook | view | from | BASIC | CDS view Checkbook basic |
Fields (15)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | mandt | Client | |||
| KEY | zbukr | dzbukr | Paying co. code | |||
| KEY | hbkid | hbkid | House Bank | |||
| KEY | hktid | hktid | Account ID | |||
| KEY | stapl | stapl | Lot Number | |||
| checf | checf | Check Number | ||||
| chect | chect | Check number | ||||
| fstap | fstap | Next lot | ||||
| checl | checl | Number Status | ||||
| stapi | stapi | Short Info | ||||
| xarcp | xarcp | Part.Archived | ||||
| xarct | xarct | Archived | ||||
| xchch | xchch | Non-Sequential | ||||
| purdt | purdt | Purchase date | ||||
| zwels | rzawl | Pmnt Meths List |
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.
-- Vornumerierte Schecks
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PCEC (
MANDT, -- Client [mandt]
ZBUKR, -- Paying co. code [dzbukr]
HBKID, -- House Bank [hbkid]
HKTID, -- Account ID [hktid]
STAPL, -- Lot Number [stapl]
CHECF, -- Check Number [checf]
CHECT, -- Check number [chect]
FSTAP, -- Next lot [fstap]
CHECL, -- Number Status [checl]
STAPI, -- Short Info [stapi]
XARCP, -- Part.Archived [xarcp]
XARCT, -- Archived [xarct]
XCHCH, -- Non-Sequential [xchch]
PURDT, -- Purchase date [purdt]
ZWELS, -- Pmnt Meths List [rzawl]
PRIMARY KEY (MANDT, ZBUKR, HBKID, HKTID, STAPL)
);
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