Overview
ACCGO_T_SNPDRFT is a standard SAP S/4HANA table that stores I_CONTRACTSNAPSHOT I_CONTRACTSNAPSHOT data. There are total 53 fields in the ACCGO_T_SNPDRFT table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table ACCGO_T_SNPDRFT belongs to SAP Agricultural Contract Management (LO-AGR) module and is located in the package Package for Contracts CDS Views (ACCGO_ACM_CNTRCTS).
In addition, following links provide an overview of foreign key relationships, if any, that link ACCGO_T_SNPDRFT to other SAP tables and standard CDS views available based on ACCGO_T_SNPDRFT table in S/4HANA 2020.
Techincal Settings of ACCGO_T_SNPDRFT
Below are technical details of the table ACCGO_T_SNPDRFT
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of ACCGO_T_SNPDRFT Fields
The following table gives you an overview of the fields available in ACCGO_T_SNPDRFT
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|
| MANDT | Client | MANDT | | CLNT | 3 |
| DRAFTUUID | UUID serving as key (parent key, root key) | /BOBF/UUID | | RAW | 16 |
| DOCUMENTID | Trading Contract | TKONN | | CHAR | 10 |
| SNAPSHOTID | Trading Contract | TKONN | | CHAR | 10 |
| DATEANDTIME | Snapshot Timestamp | /ACCGO/E_SNP_TMPSTMP | | DEC | 15 |
| SNAPSHOTLEVEL | ACM Contract Snapshot Level | /ACCGO/E_CNTRCT_SNP_LEVEL | | CHAR | 1 |
| TPOSN | Item Number of Trading Contract | TPOSN | | NUMC | 6 |
| TRADINGCONTRACTEXTERNALID | External Identifier in Trading Contract | TKONN_EX | | CHAR | 30 |
| CONTRACTNUM | Snapshot ID | /ACCGO/E_SNAP_ID | | CHAR | 30 |
| OUTPUTPROCESSINGSTATUS | Output Processing | /ACCGO/E_OUTPUT_PROC | | CHAR | 1 |
| RELEVANTFORSIGNATUREIND | Snapshot Signature Relevancy | /ACCGO/E_SNP_REL_SIG | | CHAR | 1 |
| SIGNATURESTATUS | Signature Status | /ACCGO/E_SIGNATURE_STATUS | | CHAR | 1 |
| SNAPSHOTLEVELTXT | Snapshot Level Description | /ACCGO/E_SNAPSHOT_LVL_TXT | | CHAR | 10 |
| TRADERID | Amending Trader ID | /ACCGO/E_AMEND_TRADERID | | CHAR | 12 |
| ORIGINALTRADERID | Responsible Trader ID | /ACCGO/E_RESP_TRADERID | | CHAR | 12 |
| SNAPSHOTSTATUS | Snapshot Status | /ACCGO/E_SNAPSHOT_STATUS | | CHAR | 1 |
| FIELDNAME | Snapshot Field Name | /ACCGO/E_SNP_FIELD_NAME | | CHAR | 30 |
| FIELDDESCRIPTION | Snapshot Admin Fields | /ACCGO/E_SNP_FIELD_DESC | | CHAR | 40 |
| VALUE | Snapshots Field Value for Change Relevant Fields | /ACCGO/E_SNP_FIELD_VALUE | | CHAR | 60 |
| VALUEADDITIONAL | Snapshots Field Value for Change Relevant Fields | /ACCGO/E_SNP_FIELD_VALUE | | CHAR | 60 |
| VALUEDESCRIPTION | Short Text for Fixed Values | VAL_TEXT | | CHAR | 60 |
| PURPOSETEXT | Short Text for Fixed Values | VAL_TEXT | | CHAR | 60 |
| COUNTERPARTY | Customer Number | KUNNR | | CHAR | 10 |
| CONTRACTAPPLICATIONSTATUS | Application Status of Trading Contract | BTBSTA | | CHAR | 1 |
| CONTRACTTYPE | Trading Contract Type | TCTYP | | CHAR | 4 |
| CONTRACTTYPENAME | Name of Trading Contract Type | TCTYP_BEZ | | CHAR | 40 |
| CREATEDBY | Name of Person who Created the Object | ERNAM | | CHAR | 12 |
| CREATEDBYNAME | Full Name of Person | AD_NAMTEXT | | CHAR | 80 |
| CREATEDON | Date on which the record was created | ERDAT | | DATS | 8 |
| SALESORGANIZATION | Sales Organization | VKORG | | CHAR | 4 |
| SALESORGANIZATIONNAME | Name | VTXTK | | CHAR | 20 |
| DISTRIBUTIONCHANNEL | Distribution Channel | VTWEG | | CHAR | 2 |
| DISTRIBUTIONCHANNELNAME | Distribution Channel Description | DISTRIBUTIONCHANNELNAME | | CHAR | 20 |
| DIVISON | Division | SPART | | CHAR | 2 |
| DIVISONNAME | Name | VTXTK | | CHAR | 20 |
| PURCHASINGORGANIZATION | Purchasing organization | EKORG | | CHAR | 4 |
| PURCHASINGORGANIZATIONNAME | Description of purchasing organization | EKOTX | | CHAR | 20 |
| PURCHASINGGROUP | Purchasing Group | EKGRP | | CHAR | 3 |
| PURCHASINGGROUPNAME | Purchasing Group Name | MM_A_PURG_GRP_NAME | | CHAR | 18 |
| TRDGCONTRPURGINCOTERMSLOC1TEXT | Incoterms Location 1 | INCO2_L | | CHAR | 70 |
| TRDGCONTRSLSINCOTERMSLOC1TEXT | Incoterms Location 1 | INCO2_L | | CHAR | 70 |
| TRANSACTINGCTPTY | Reference to other vendor | LIFN2 | | CHAR | 10 |
| COMMODITY | Commodity | TBA_STOEFFCHEN | | CHAR | 18 |
| PLANT | Plant | WERKS_D | | CHAR | 4 |
| PLANTNAME | Plant Name | WERKS_NAME | | CHAR | 30 |
| ACMYOURREFERENCE | Your Reference | IHREZ | | CHAR | 12 |
| ACMCUSTOMERREFERENCE | Customer Reference | BSTKD | | CHAR | 35 |
| HASACTIVEENTITY | Draft - Indicator - Has active document | SDRAFT_HAS_ACTIVE | | CHAR | 1 |
| DRAFTENTITYCREATIONDATETIME | Draft Created On | SDRAFT_CREATED_AT | | DEC | 21 |
| DRAFTENTITYLASTCHANGEDATETIME | Draft Last Changed On | SDRAFT_LAST_CHANGED_AT | | DEC | 21 |
| DRAFTADMINISTRATIVEDATAUUID | Technical ID for the Administrative Data of a Draft Document | SDRAFT_ADMIN_UUID | | RAW | 16 |
| DRAFTENTITYCONSISTENCYSTATUS | Draft Consistency Status | SDRAFT_CONSISTENCY_STATUS | | CHAR | 1 |
| DRAFTENTITYOPERATIONCODE | Draft - Operation Code | SDRAFT_OPERATION_CODE | | CHAR | 1 |
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 ACCGO_T_SNPDRFT
Other References