1. Home
  2. Resources
  3. SAP Tables
  4. CVALID - Settlement profile for automatic ERS

SAP Table CVALID

Settlement profile for automatic ERS

CVALID (Settlement profile for automatic ERS) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link CVALID to other SAP tables.

CVALID table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
EKORG Purchasing Organization EKORG T024E CHAR 4 0
VALID_PRO Settlement profile for automatic evaluated receipt settlemnt VALID_PRO CHAR 4 0
REF_POST Base date: posting date REF_POST CHAR 1 0
REF_DELI Base date: delivery note date REF_DELI CHAR 1 0
P1DHI Settlement profile: period delimitation PXDHI NUMC 2 0
01 Day of the month
P1DAY Payment Due Profile: Payment Due Date PXDAY NUMC 2 0
P1MON Payment due profile: month PXMON CHAR 1 0
NULL Current month of reference date
1 Month of reference date plus 1
2 Month of reference date plus 2
3 Month of reference date plus 3
P2DHI Settlement profile: period delimitation PXDHI NUMC 2 0
01 Day of the month
P2DAY Payment Due Profile: Payment Due Date PXDAY NUMC 2 0
P2MON Payment due profile: month PXMON CHAR 1 0
NULL Current month of reference date
1 Month of reference date plus 1
2 Month of reference date plus 2
3 Month of reference date plus 3
P3DHI Settlement profile: period delimitation PXDHI NUMC 2 0
01 Day of the month
P3DAY Payment Due Profile: Payment Due Date PXDAY NUMC 2 0
P3MON Payment due profile: month PXMON CHAR 1 0
NULL Current month of reference date
1 Month of reference date plus 1
2 Month of reference date plus 2
3 Month of reference date plus 3
ERS_ZTERM ERS terms of payment key ERS_ZTERM CHAR 4 0
ERSBA ERS procedure: type of document selection ERS_ERSBA CHAR 2 0
1 Document Selection per Vendor
2 Document Selection per Purchase Order
3 Document Selection per Order Item
4 Document Selection per Delivery Document/Service Entry
6 Document Selection per Transportation Service Provider
7 Document Selection per Shipment Order
5 Document selection per exchange number

CVALID foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
CVALID EKORG CVALID EKORG T024E Purchasing Organizations EKORG
CVALID EKORG CVALID MANDT T024E Purchasing Organizations MANDT
CVALID MANDT CVALID MANDT T000 Clients MANDT