SAP ART_ASSIGN I_ARTICLEASSIGNTP I_ARTICLEASSIGNTP Table

Overview

ART_ASSIGN is a standard SAP S/4HANA table that stores I_ARTICLEASSIGNTP I_ARTICLEASSIGNTP data. There are total 15 fields in the ART_ASSIGN table. The following is a list of the fields that make up this table. Key fields are marked in blue.

The table ART_ASSIGN belongs to Material Master (LO-MD-MM) module and is located in the package VDM Master Data Article Hierarchy (VDM_MD_PRODUCT_ARTICLE_HIER).

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

Techincal Settings of ART_ASSIGN

Below are technical details of the table ART_ASSIGN

  • Buffering not allowed
  • No buffering
  • Storage type is Column Store

List of ART_ASSIGN Fields

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

FieldDescriptionData ElementCheck TableData TypeLength
MANDTClientMANDTCLNT3
DRAFTUUIDUUID serving as key (parent key, root key)/BOBF/UUIDRAW16
HIERARCHYIDHierarchyWRF_HIER_CNTCHAR2
PRODUCTMaterial NumberMATNRCHAR40
HIERARCHYNODEHierarchy NodeWRF_STRUC_NODECHAR18
ARTICLEHIERASSGMTVALDTYSTRTDTEValidity Start Date of Assignment in Article HierarchyWRF_DATE_FROMDATS8
ARTICLEHIERASSGMTVALDTYENDDATEValidity End Date of Assignment in Article HierarchyWRF_DATE_TODATS8
ARTICLEHIERMAINASSIGNMENTMain AssignmentWRF_MAIN_FLAGCHAR1
NODECATEGORYParent NodeWRF_STRUC_PARENTCHAR18
HASACTIVEENTITYDraft - Indicator - Has active documentSDRAFT_HAS_ACTIVECHAR1
DRAFTENTITYCREATIONDATETIMEDraft Created OnSDRAFT_CREATED_ATDEC21
DRAFTENTITYLASTCHANGEDATETIMEDraft Last Changed OnSDRAFT_LAST_CHANGED_ATDEC21
DRAFTADMINISTRATIVEDATAUUIDTechnical ID for the Administrative Data of a Draft DocumentSDRAFT_ADMIN_UUIDRAW16
DRAFTENTITYCONSISTENCYSTATUSDraft Consistency StatusSDRAFT_CONSISTENCY_STATUSCHAR1
DRAFTENTITYOPERATIONCODEDraft - Operation CodeSDRAFT_OPERATION_CODECHAR1

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 ART_ASSIGN

Other References