SAP ABAP Table S067 (Open deliveries/billing documents (KM))
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷
CRM (Application Component) Customer Relationship Management
⤷
CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷ MCS (Package) R/3 application development: Logistics Information Warehouse
BBPCRM (Software Component) BBPCRM⤷
CRM (Application Component) Customer Relationship Management⤷
CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages⤷
MCS (Package) R/3 application development: Logistics Information Warehouse
Basic Data
| Table Category | TRANSP | Transparent table |
| Transparent table | S067 |
Table Relationship Diagram 
|
| Short Description | Open deliveries/billing documents (KM) |
Delivery and Maintenance
| Pool/cluster | ||
| Delivery Class | A | Application Table (Master- and Transaction Data) |
| Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
 |
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|---|---|---|---|---|---|---|---|---|---|
| 1 |  MANDT |
MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
| 2 | SSOUR |
SSOUR | SSOUR | CHAR | 4 | 0 | Statistic(s) origin | ||
| 3 | VRSIO |
VRSIO | VRSIO | CHAR | 3 | 0 | Version number in the information structure | * | |
| 4 | KKBER |
KKBER | KKBER | CHAR | 4 | 0 | Credit control area | T014 | |
| 5 | KNKLI |
KNKLI | KUNNR | CHAR | 10 | 0 | Customer's account number with credit limit reference | KNA1 | |
| 6 | SPMON |
SPMON | MCPERIOD | NUMC | 6 | 0 | Period to analyze - month | ||
| 7 | SPTAG |
SPTAG | DATUM | DATS | 8 | 0 | Period to analyze - current date | ||
| 8 | SPWOC |
SPWOC | MCPERIOD | NUMC | 6 | 0 | Period to analyze - week | ||
| 9 | SPBUP |
SPBUP | MCPERIOD | NUMC | 6 | 0 | Period to analyze - posting period | ||
| 10 | PERIV |
PERIV | PERIV | CHAR | 2 | 0 | Fiscal Year Variant | T009 | |
| 11 | VWDAT |
VWDAT | VWDAT | NUMC | 10 | 0 | Pointer to administrative data | ||
| 12 | CMWAE |
WAERS_CM | WAERS | CUKY | 5 | 0 | Currency key of credit control area | * | |
| 13 | OLIKW |
MC_OLIKW | WERTV10 | CURR | 19 | 2 | Open delivery credit value | ||
| 14 | OFAKW |
MC_OFAKW | WERTV10 | CURR | 19 | 2 | Open billing document credit value | ||
| 15 | AOLIW |
MC_OLIKWAA | WERTV10 | CURR | 19 | 2 | Guaranteed open delivery value | ||
| 16 | AOFAW |
MC_OFAKWAA | WERTV10 | CURR | 19 | 2 | Guaranteed open billing values |
Foreign Keys
| |
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right |
|---|---|---|---|---|---|---|---|
 |
|
|
|
|
|
|
|
| 1 | S067 | KKBER |  T014 |
KKBER |
|||
| 2 | S067 | KNKLI | KNA1 |
KUNNR |
|||
| 3 | S067 | MANDT | T000 |
MANDT |
|||
| 4 | S067 | PERIV | T009 |
PERIV |
History
| Last changed by/on | SAP | 20100310 |
| SAP Release Created in | 470 |
