I_PRATSTVALNTOL
Test Validation - PRA Valuation Tolerance
I_PRATSTVALNTOL is a CDS View in S/4HANA. Test Validation - PRA Valuation Tolerance. It contains 39 fields. 6 CDS views read from this table.
CDS Views using this table (6)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_PRATstCombinedAcctCompare | view | inner | COMPOSITE | TV - Combined Run Account - Compare |
| I_PRATstCombinedHdrCompare | view | inner | COMPOSITE | Test Validn - Combined Run Hdr Compare |
| I_PRATstCombinedMktCompare | view | inner | COMPOSITE | TV - Combined Run Mkt - Compare |
| I_PRATstCombinedOwnrCompare | view | inner | COMPOSITE | TV - Combined Run Owner - Compare |
| I_PRATstCombinedTaxCompare | view | inner | COMPOSITE | TV - Combined Run Tax - Compare |
| I_PRATstValnTolTP | view | from | TRANSACTIONAL | Valuation Tolerance View TP |
Fields (39)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| ActlExternalMktgTolVal | ActlExternalMktgTolVal | 1 | |
| ActlGrssStateTaxTolVal | ActlGrssStateTaxTolVal | 1 | |
| ActlInternalMktgTolVal | ActlInternalMktgTolVal | 1 | |
| ActlMktgReimbmtTolVal | ActlMktgReimbmtTolVal | 1 | |
| ActlStateTaxReimbmtTolVal | ActlStateTaxReimbmtTolVal | 1 | |
| ActualEngyReducnTolVal | ActualEngyReducnTolVal | 1 | |
| ActualGrssValueTolVal | ActualGrssValueTolVal | 1 | |
| ActualGrssVolumeTolVal | ActualGrssVolumeTolVal | 1 | |
| ActualPriceTolVal | ActualPriceTolVal | 1 | |
| ActualStateTaxTolVal | ActualStateTaxTolVal | 1 | |
| ActualVolReducnTolVal | ActualVolReducnTolVal | 1 | |
| EntitledEnergyTolVal | EntitledEnergyTolVal | 1 | |
| EntitledStateTaxReimbmtTolVal | EntitledStateTaxReimbmtTolVal | 1 | |
| EntitledStateTaxTolVal | EntitledStateTaxTolVal | 1 | |
| EntitledVolReducnTolVal | EntitledVolReducnTolVal | 1 | |
| EntldEngyReducnTolVal | EntldEngyReducnTolVal | 1 | |
| EntldExtMktgTolVal | EntldExtMktgTolVal | 1 | |
| EntldGrossValueTolVal | EntldGrossValueTolVal | 1 | |
| EntldGrossVolumeTolVal | EntldGrossVolumeTolVal | 1 | |
| EntldGrssStateTaxTolVal | EntldGrssStateTaxTolVal | 1 | |
| EntldInternalMktgTolVal | EntldInternalMktgTolVal | 1 | |
| EntldMktgReimbmtTolVal | EntldMktgReimbmtTolVal | 1 | |
| GrossEnergyTolVal | GrossEnergyTolVal | 1 | |
| GrossEngyReducnTolVal | GrossEngyReducnTolVal | 1 | |
| GrossVolReducnTolVal | GrossVolReducnTolVal | 1 | |
| GrossVolumeTolVal | GrossVolumeTolVal | 1 | |
| MarketingAmountTolVal | MarketingAmountTolVal | 1 | |
| NetReimbmtMktgTolVal | NetReimbmtMktgTolVal | 1 | |
| OtherDeductAmountTolVal | OtherDeductAmountTolVal | 1 | |
| OwnerEnergyTolVal | OwnerEnergyTolVal | 1 | |
| OwnerGrssValueTolVal | OwnerGrssValueTolVal | 1 | |
| OwnerNetValueTolPct | OwnerNetValueTolPct | 1 | |
| OwnerNetVolumeTolPct | OwnerNetVolumeTolPct | 1 | |
| OwnerTotalTaxesTolVal | OwnerTotalTaxesTolVal | 1 | |
| OwnerVolumeReducnTolVal | OwnerVolumeReducnTolVal | 1 | |
| SequenceNumber | SequenceNumber | 4 | |
| TaxReimbmtAmountTolVal | TaxReimbmtAmountTolVal | 1 | |
| TotalCreditAmountTolVal | TotalCreditAmountTolVal | 1 | |
| TotalDebitAmountTolVal | TotalDebitAmountTolVal | 1 |
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.
-- Test Validation - PRA Valuation Tolerance
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PRATSTVALNTOL (
ACTLEXTERNALMKTGTOLVAL,
ACTLGRSSSTATETAXTOLVAL,
ACTLINTERNALMKTGTOLVAL,
ACTLMKTGREIMBMTTOLVAL,
ACTLSTATETAXREIMBMTTOLVAL,
ACTUALENGYREDUCNTOLVAL,
ACTUALGRSSVALUETOLVAL,
ACTUALGRSSVOLUMETOLVAL,
ACTUALPRICETOLVAL,
ACTUALSTATETAXTOLVAL,
ACTUALVOLREDUCNTOLVAL,
ENTITLEDENERGYTOLVAL,
ENTITLEDSTATETAXREIMBMTTOLVAL,
ENTITLEDSTATETAXTOLVAL,
ENTITLEDVOLREDUCNTOLVAL,
ENTLDENGYREDUCNTOLVAL,
ENTLDEXTMKTGTOLVAL,
ENTLDGROSSVALUETOLVAL,
ENTLDGROSSVOLUMETOLVAL,
ENTLDGRSSSTATETAXTOLVAL,
ENTLDINTERNALMKTGTOLVAL,
ENTLDMKTGREIMBMTTOLVAL,
GROSSENERGYTOLVAL,
GROSSENGYREDUCNTOLVAL,
GROSSVOLREDUCNTOLVAL,
GROSSVOLUMETOLVAL,
MARKETINGAMOUNTTOLVAL,
NETREIMBMTMKTGTOLVAL,
OTHERDEDUCTAMOUNTTOLVAL,
OWNERENERGYTOLVAL,
OWNERGRSSVALUETOLVAL,
OWNERNETVALUETOLPCT,
OWNERNETVOLUMETOLPCT,
OWNERTOTALTAXESTOLVAL,
OWNERVOLUMEREDUCNTOLVAL,
SEQUENCENUMBER,
TAXREIMBMTAMOUNTTOLVAL,
TOTALCREDITAMOUNTTOLVAL,
TOTALDEBITAMOUNTTOLVAL
);
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