SAP A405 ContractNr/Well/WC/Material Table

Overview

A405 is a standard SAP S/4HANA table that stores ContractNr/Well/WC/Material data. There are total 10 fields in the A405 table. The following is a list of the fields that make up this table. Key fields are marked in blue.

The table A405 belongs to Production and Revenue Accounting (IS-OIL-PRA) module and is located in the package PRA Production and Revenue Accounting (Upstream Business) (OIU).

In addition, following links provide an overview of foreign key relationships, if any, that link A405 to other SAP tables and standard CDS views available based on A405 table in S/4HANA 2020.

Techincal Settings of A405

Below are technical details of the table A405

  • Buffering switched on
  • Full table is passed to buffer
  • Storage type is Column Store

List of A405 Fields

The following table gives you an overview of the fields available in A405

FieldDescriptionData ElementCheck TableData TypeLength
MANDTClientMANDTT000CLNT3
KAPPLApplicationKAPPLT681ACHAR2
KSCHLCondition typeKSCHAT685CHAR4
OICONTNROutline agreement: contractOIC_CONTNRVBAKCHAR10
OIU_PC_WL_NOWell ID numberOIU_WL_NOOIU_PR_WELLCHAR15
OIU_PC_WC_NOWell Completion NumberOIU_WC_NOOIU_PR_WCCHAR5
MATNRMaterial NumberMATNRMARACHAR40
DATBIValidity end date of the condition recordKODATBIDATS8
DATABValidity start date of the condition recordKODATABDATS8
KNUMHNumber of the Condition RecordKNUMHCHAR10

Foreign Key Relationships

A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for A405

Table NameFieldCardinalityCheck Table
A405KAPPL:T681A
A405KSCHL:T685
A405MANDT:T000
A405MATNR:MARA
A405OICONTNR:VBAK
A405OIU_PC_WC_NO:OIU_PR_WC
A405OIU_PC_WL_NO:OIU_PR_WELL

Other References