CFIN_AV_SO_ROOT - Sales Document: Header Data
Sales Document: Header Data information is stored in SAP table CFIN_AV_SO_ROOT.
It is part of development package FINS_CFIN_ACC_VIEW in software component FI-CF-AVL. This development package consists of objects that can be grouped under "Central Finance - Accounting View".
It is part of development package FINS_CFIN_ACC_VIEW in software component FI-CF-AVL. This development package consists of objects that can be grouped under "Central Finance - Accounting View".
Fields for table CFIN_AV_SO_ROOT
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | |
| .INCLUDE | KEY | X | FINS_CFIN_S_AV_DBKEY | 0 | ||
| AV_DBKEY | Accounting View DB KEY | X | FINS_CFIN_AV_DBKEY | RAW | 16 | |
| .INCLUDE | ADMIN | FINS_CFIN_S_AV_ADMIN_DATA | 0 | |||
| AV_CHANGEDTIME | Accounting View Changed Time | FINS_CFIN_AV_CHANGEDTIME | DEC | 8 | ||
| AV_CHANGEUSER | Accounting View Change User | FINS_CFIN_AV_CHANGEUSER | CHAR | 24 | ||
| AV_CREATEDTIME | Accounting View Created Time | FINS_CFIN_AV_CREATEDTIME | DEC | 8 | ||
| AV_CREATEUSER | Accounting View Create User | FINS_CFIN_AV_CREATEUSER | CHAR | 24 | ||
| .INCLUDE | DATA | FINS_CFIN_S_AV_SO_ROOT | 0 | |||
| FINS_LOGSYS | Logical system | LOGSYS | CHAR | 20 | TBDLS | |
| VBELN | Sales Document | VBELN_VA | CHAR | 20 | ||
| VGBEL | Document number of the reference document | VGBEL | CHAR | 20 | ||
| VGTYP | Document Category of Preceding SD Document | VBTYPL_V | CHAR | 8 | ||
| VKORG | Sales Organization | VKORG | CHAR | 8 | TVKO | |
| VTWEG | Distribution Channel | VTWEG | CHAR | 4 | TVKOV | |
| BUKRS_VF | Company Code to Be Billed | BUKRS_VF | CHAR | 8 | T001 | |
| ERDAT | Date on which the record was created | ERDAT | DATS | 16 | ||
| VBTYP | SD Document Category | VBTYPL | CHAR | 8 | ||
| AUART | Sales Document Type | AUART | CHAR | 8 | TVAK | |
| KOSTL | Cost Center | KOSTL | CHAR | 20 | * | |
| WAERK | SD Document Currency | WAERK | CUKY | 10 | TCURC | |
| AEDAT | Last Changed On | AEDAT | DATS | 16 | ||
| ERNAM | Name of Person Responsible for Creating the Object | ERNAM | CHAR | 24 | ||
| AUDAT | Document Date (Date Received/Sent) | AUDAT | DATS | 16 | ||
| TRVOG | Transaction Group | TRVOG | CHAR | 2 | ||
| NETWR | Net Value of the Sales Order in Document Currency | NETWR_AK | CURR | 8 | ||
| VKGRP | Sales group | VKGRP | CHAR | 6 | TVBVK | |
| VKBUR | Sales office | VKBUR | CHAR | 8 | TVKBZ | |
| KOKRS | Controlling Area | KOKRS | CHAR | 8 | TKA01 | |
| PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | NUMC | 16 | PRPS | |
| KNUMV | Number of the Document Condition | KNUMV | CHAR | 20 | ||
| KALSM | Pricing Procedure in Pricing | KALSMASD | CHAR | 12 | T683 | |
| LANDTX | Tax Departure Country/Region | LANDTX | CHAR | 6 | T005 | |
| KUNNR | Sold-to Party | KUNAG | CHAR | 20 | KNA1 | |
| IUUC_OPERAT_FLAG | Delete/Archive Indicator | FINS_CFIN_AV_OPERATION | CHAR | 2 | ||
| SPART | Division | SPART | CHAR | 4 | TVTA | |
| .INCLUDE | CFAVSO_INCL_EEW_PS | 0 | ||||
| DUMMY_AVSO_INCL_EEW_PS | Custom Fields: Dummy for Use in Extension Includes | CFD_DUMMY | CHAR | 2 |