1. Home
  2. Resources
  3. SAP Tables
  4. VBCO7 - Sales.Doc.Access Methods: Key Fields: Billing Index

SAP Table VBCO7

Sales.Doc.Access Methods: Key Fields: Billing Index

VBCO7 (Sales.Doc.Access Methods: Key Fields: Billing Index) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link VBCO7 to other SAP tables.

VBCO7 table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
FKTYP Billing category FKTYP CHAR 1 0
A Order-related billing document
B Order-related billing document for rebate settlement
C Order-related billing document for partial rebate settlement
D Periodic billing document
E Periodic billing with active invoice accrual
F Accrual
I Delivery-related billing document for inter-company billing
K Order-related billing document for rebate correction
L Delivery-related billing document
P Down payment request
R Invoice list
U Billing request
W POS billing document
X Billing using general interface
S CRM Billing Document
N Provisional or Differential Billing Document
O Final Billing Document
VKORG Sales Organization VKORG TVKO CHAR 4 0
FKDAT Billing date from which billing is to be carried out FKDAT_VON DATS 8 0
FKDAT_BIS Date up to which billing is to be carried out FKDAT_BIS DATS 8 0
KUNNR Sold-to party KUNAG KNA1 CHAR 10 0
FKART Billing Type FKART TVFK CHAR 4 0
LLAND Country of Destination LLAND T005 CHAR 3 0
VBELN From document VBELN_AB VBUK CHAR 10 0
VBELN_BIS To sales and distribution document VBELN_BIS VBUK CHAR 10 0
VTWEG Distribution Channel VTWEG TVTW CHAR 2 0
SPART Division SPART TSPA CHAR 2 0
VBTYP SD document category VBTYP CHAR 1 0
A Inquiry
B Quotation
C Order
D Item proposal
E Scheduling agreement
F Scheduling agreement with external service agent
G Contract
H Returns
I Order w/o charge
J Delivery
K Credit memo request
L Debit memo request
M Invoice
N Invoice cancellation
O Credit memo
P Debit memo
Q WMS transfer order
R Goods movement
S Credit memo cancellation
T Returns delivery for order
U Pro forma invoice
V Purchase Order
W Independent reqts plan
X Handling unit
0 Master contract
1 Sales activities (CAS)
2 External transaction
3 Invoice list
4 Credit memo list
5 Intercompany invoice
6 Intercompany credit memo
7 Delivery/shipping notification
8 Shipment
a Shipment costs
b CRM Opportunity
c Unverified delivery
d Trading Contract
e Allocation table
f Additional Billing Documents
g Rough Goods Receipt (only IS-Retail)
h Cancel Goods Issue
i Goods receipt
j JIT call
n Reserved
o Reserved
p Goods Movement (Documentation)
q Reserved
r TD Transport (only IS-Oil)
s Load Confirmation, Reposting (Only IS-Oil)
t Gain / Loss (Only IS-Oil)
u Reentry into Storage (Only IS-Oil)
v Data Collation (only IS-Oil)
w Reservation (Only IS-Oil)
x Load Confirmation, Goods Receipt (Only IS-Oil)
$ (AFS)
+ Accounting Document (Temporary)
- Accounting Document (Temporary)
# Revenue Recognition (Temporary)
~ Revenue Cancellation (Temporary)
� Revenue Recognition/New View (Temporary)
NULL Revenue Cancellation/New View (Temporary)
: Service Order
. Service Notification
& Warehouse Document
* Pick Order
, Shipment Document
^ Reserved
| Reserved
k Agency Document
NAME_DAZU Is the name of the sold-to party to be read as well? NAME_DAZU CHAR 1 0
X Yes
NULL No
ALLEF Invoice lists ALLEF CHAR 1 0
X Yes
NULL No
ALLEL Delivery-related billing documents ALLEL CHAR 1 0
X Yes
NULL No
ALLEA Order-related billing documents ALLEA CHAR 1 0
X Yes
NULL No
ALLEB Rebate-related billing documents ALLEB CHAR 1 0
X Yes
NULL No
ALLEI Intercompany billing ALLEI CHAR 1 0
X Yes
NULL No
NO_FAKSK No selection of sales documents with billing block NO_FAKSK CHAR 1 0
NULL Do not set flag
X Set flag
SORTKRI Sort Criterion SORTKRI CHAR 20 0
VSTEL Shipping Point/Receiving Point VSTEL TVST CHAR 4 0
PDSTK Documents with POD Status ALPOD CHAR 1 0
X Yes
NULL No
OIEXGNUMV Exchange agreement number OIA_EXGNUM CHAR 10 0
OIEXGNUMB Exchange agreement number to OIA_EXGNUB CHAR 10 0
OIEXGREL Exchange relevant documents OIA_EXREL CHAR 1 0
X Yes
NULL No
OINOEXGREL No exchange-relevant documents OIA_NEXREL CHAR 1 0
X Yes
NULL No
OINFREL Nota Fiscal relevant documents OIC_NFREL CHAR 1 0
X Yes
NULL No

VBCO7 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
VBCO7 FKART VBCO7 MANDT TVFK Billing: Document Types MANDT
VBCO7 FKART VBCO7 FKART TVFK Billing: Document Types FKART
VBCO7 KUNNR VBCO7 MANDT KNA1 General Data in Customer Master MANDT
VBCO7 KUNNR VBCO7 KUNNR KNA1 General Data in Customer Master KUNNR
VBCO7 LLAND VBCO7 MANDT T005 Countries MANDT
VBCO7 LLAND VBCO7 LLAND T005 Countries LAND1
VBCO7 MANDT VBCO7 MANDT T000 Clients MANDT
VBCO7 SPART VBCO7 SPART TSPA Organizational Unit: Sales Divisions SPART
VBCO7 SPART VBCO7 MANDT TSPA Organizational Unit: Sales Divisions MANDT
VBCO7 VBELN VBCO7 VBELN VBUK Sales Document: Header Status and Administrative Data VBELN
VBCO7 VBELN VBCO7 MANDT VBUK Sales Document: Header Status and Administrative Data MANDT
VBCO7 VBELN_BIS VBCO7 MANDT VBUK Sales Document: Header Status and Administrative Data MANDT
VBCO7 VBELN_BIS VBCO7 VBELN_BIS VBUK Sales Document: Header Status and Administrative Data VBELN
VBCO7 VKORG VBCO7 MANDT TVKO Organizational Unit: Sales Organizations MANDT
VBCO7 VKORG VBCO7 VKORG TVKO Organizational Unit: Sales Organizations VKORG
VBCO7 VSTEL VBCO7 MANDT TVST Organizational Unit: Shipping Points MANDT
VBCO7 VSTEL VBCO7 VSTEL TVST Organizational Unit: Shipping Points VSTEL
VBCO7 VTWEG VBCO7 MANDT TVTW Organizational Unit: Distribution Channels MANDT
VBCO7 VTWEG VBCO7 VTWEG TVTW Organizational Unit: Distribution Channels VTWEG