SAP table VBCO7 (Sales.Doc.Access Methods: Key Fields: Billing Index)

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
FKTYP Billing Category CHAR 1 0 FKTYP
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
S CRM Billing Document
U Billing request
W POS billing document
X Billing using general interface
VKORG Sales Organization CHAR 4 0 TVKO VKORG
FKDAT Billing date from which billing is to be carried out DATS 8 0 FKDAT_VON
FKDAT_BIS Date up to which billing is to be carried out DATS 8 0 FKDAT_BIS
KUNNR Sold-to Party CHAR 10 0 KNA1 KUNAG
FKART Billing Type CHAR 4 0 TVFK FKART
LLAND Destination Country/Region CHAR 3 0 T005 LLAND
VBELN From document CHAR 10 0 VBELN_AB
VBELN_BIS To sales and distribution document CHAR 10 0 VBELN_BIS
VTWEG Distribution Channel CHAR 2 0 TVTW VTWEG
SPART Division CHAR 2 0 TSPA SPART
VBTYP SD Document Category CHAR 4 0 VBTYPL
# Revenue Recognition (Temporary)
$ (AFS)
& Warehouse Document
* Pick Order
+ Journal Entry (Temporary)
, Shipment Document
- Journal Entry (Temporary)
. Service Notification
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
: Service Order
A Inquiry
a Shipment Costs
b CRM Opportunity
B Quotation
BOS Service Entry Sheet
C Order
c Unverified Delivery
CEM ETM Shipping Document
CMMA Customer Management Master Agreement
CSCO Customer Management Service Confirmation
CSCT Customer Management Service Contract
CSVO Customer Management Service Order
D Item Proposal
d Trading Contract
e Allocation Table
E Scheduling Agreement
EBDR Billing Document Request
F Scheduling Agreement with External Service Agent
f001 Period-End Invoice
f002 Period-End Credit Memo
f003 Period-End Invoice (Intercompany Billing)
f004 Period-End Credit Memo (Intercompany Billing)
G Contract
g Rough Goods Receipt (only IS-Retail)
GBRQ Grants Management Billing Request
h Cancel Goods Issue
H Returns
i Goods Receipt
I Order Without Charge
J Delivery
j JIT Call
K Credit Memo Request
k Settlement Management Document
L Debit Memo Request
M Invoice
N Invoice Cancellation
n Reserved
O Credit Memo
o Reserved
P Debit Memo
p Goods Movement (Documentation)
PBD Preliminary Billing Document
PBDR Billing Document Request for Prof. Serv.
PBRQ Project Billing Request
q Reserved
Q WMS Transfer Order
R Goods Movement
r TD Transport (Only IS-Oil)
S Credit Memo Cancellation
s Load Confirmation, Reposting (Only IS-Oil)
SBRQ Subscription Billing Request
SOLO Solution Order
t Gain / Loss (Only IS-Oil)
T Returns Delivery for Order
TMFO Freight Order
TMFU Freight Unit
U Pro Forma Invoice
u Reentry into Storage (Only IS-Oil)
v Data Collation (Only IS-Oil)
V Purchase Order
W Independent Reqts Plan
w Reservation (Only IS-Oil)
X Handling Unit
x Load Confirmation, Goods Receipt (Only IS-Oil)
Y Rebate Agreement
^ Reserved
| Reserved
~ Revenue Cancellation (Temporary)
ยง Revenue Recognition/New View (Temporary)
NAME_DAZU Is the name of the sold-to party to be read as well? CHAR 1 0 NAME_DAZU
ALLEF Invoice lists CHAR 1 0 ALLEF
ALLEL Delivery-Related Billing Documents CHAR 1 0 ALLEL
ALLEA Order-Related Billing Documents CHAR 1 0 ALLEA
ALLEB Rebate-Related Billing Documents CHAR 1 0 ALLEB
ALLEI Intercompany billing CHAR 1 0 ALLEI
ALLEX Select billing document requests for billing CHAR 1 0 ALLEX
NO_FAKSK No selection of sales documents with billing block CHAR 1 0 NO_FAKSK
SORTKRI Sort Criterion CHAR 20 0 SORTKRI
VSTEL Shipping Point / Receiving Point CHAR 4 0 TVST VSTEL
PDSTK Documents with POD Status CHAR 1 0 ALPOD
VKBUR Sales office CHAR 4 0 TVBUR VKBUR
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
CRBYME Selects Data Records Created by Me CHAR 1 0 CRBYME

VBCO7 foreign key relationships

Table Field Check Table Check Field
0 VBCO7 FKART TVFK Billing: Document Types MANDT
0 VBCO7 FKART TVFK Billing: Document Types FKART
1 VBCO7 KUNNR KNA1 General Data in Customer Master MANDT
1 VBCO7 KUNNR KNA1 General Data in Customer Master KUNNR
0 VBCO7 LLAND T005 Countries MANDT
0 VBCO7 LLAND T005 Countries LAND1
1 VBCO7 MANDT T000 Clients MANDT
0 VBCO7 SPART TSPA Organizational Unit: Sales Divisions MANDT
0 VBCO7 SPART TSPA Organizational Unit: Sales Divisions SPART
1 VBCO7 VKBUR TVBUR Organizational Unit: Sales Offices MANDT
0 VBCO7 VKORG TVKO Organizational Unit: Sales Organizations MANDT
0 VBCO7 VKORG TVKO Organizational Unit: Sales Organizations VKORG
1 VBCO7 VSTEL TVST Organizational Unit: Shipping Points MANDT
1 VBCO7 VSTEL TVST Organizational Unit: Shipping Points VSTEL
0 VBCO7 VTWEG TVTW Organizational Unit: Distribution Channels MANDT
0 VBCO7 VTWEG TVTW Organizational Unit: Distribution Channels VTWEG