Follow us on LinkedIn for your next SAP project

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 Possible values
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
P1DAY
Payment Due Profile: Payment Due Date
PXDAY
NUMC
2 0
P1MON
Payment due profile: month
PXMON
CHAR
1 0
P2DHI
Settlement profile: period delimitation
PXDHI
NUMC
2 0
P2DAY
Payment Due Profile: Payment Due Date
PXDAY
NUMC
2 0
P2MON
Payment due profile: month
PXMON
CHAR
1 0
P3DHI
Settlement profile: period delimitation
PXDHI
NUMC
2 0
P3DAY
Payment Due Profile: Payment Due Date
PXDAY
NUMC
2 0
P3MON
Payment due profile: month
PXMON
CHAR
1 0
ERS_ZTERM
ERS terms of payment key
ERS_ZTERM
CHAR
4 0
ERSBA
ERS procedure: type of document selection
ERS_ERSBA
CHAR
2 0

CVALID foreign key relationships

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