SAP A4CL Sales Org./Distr. Chl/Overtime/Customer/Material Table

Overview

A4CL is a standard SAP S/4HANA table that stores Sales Org./Distr. Chl/Overtime/Customer/Material data. There are total 13 fields in the A4CL table. The following is a list of the fields that make up this table. Key fields are marked in blue.

The table A4CL belongs to Conditions (SD-MD-CM) module and is located in the package Application development Conditions (VKON).

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

Techincal Settings of A4CL

Below are technical details of the table A4CL

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

List of A4CL Fields

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

FieldDescriptionData ElementCheck TableData TypeLength
MANDTClientMANDTT000CLNT3
KAPPLApplicationKAPPLT681ACHAR2
KSCHLCondition typeKSCHAT685CHAR4
VKORGSales OrganizationVKORGTVKOCHAR4
VTWEGDistribution ChannelVTWEGTVTWCHAR2
CATS_OVERTIME_CATEGORYOvertime CategoryCATS_OVERTIME_CATEGORYTCATS_SSC_OVTMCHAR4
KUNNRCustomer numberKUNNR_VKNA1CHAR10
MATNRMaterial NumberMATNRMARACHAR40
KFRSTRelease StatusKFRSTCHAR1
DATBIValidity end date of the condition recordKODATBIDATS8
DATABValidity start date of the condition recordKODATABDATS8
KBSTATProcessing status for conditionsKBSTATT686ECHAR2
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 A4CL

Table NameFieldCardinalityCheck Table
A4CLCATS_OVERTIME_CATEGORY:TCATS_SSC_OVTM
A4CLKAPPL:T681A
A4CLKBSTAT1: 1T686E
A4CLKSCHL:T685
A4CLKUNNR:KNA1
A4CLMANDT:T000
A4CLMATNR:MARA
A4CLVKORG:TVKO
A4CLVTWEG:TVTW

Other References